Databases Reference
In-Depth Information
We also have to enable the Validator itself (as other validators might be available on
future phpMyAdmin versions). This is done by setting
$cfg['SQLValidator']['us
e']
to
TRUE
.
The Validator is accessed with an anonymous Validator account by default, as
configured by the following:
$cfg['SQLValidator']['username'] = '';
$cfg['SQLValidator']['password'] = '';
If the company has provided us with an account, we can instead use that account
information here.
Validator Results
There are two kinds of reports returned by the Validator: one if the query conforms
to the standard, and another if it does not.
Standard-Conforming Queries
We will try a simple query:
select
*
from
books
. We enter this query in the query
box as usual and send it. On the results page, we now see an additional link:
Validate SQL
.:
Clicking on
Validate SQL
produces the following report:
Search WWH ::
Custom Search