Databases Reference
In-Depth Information
If we have problems with this command due to some of the modules being in a
beta state, we can execute the following command, which installs SOAP and other
dependent modules:
pear -d preferred_state=beta install -a SOAP
Making the Validator Available
Some parameters must be configured in
config.inc.php
. Setting
$cfg['SQLQuery'
]['Validate']
to
TRUE
enables the
Validate SQL
link.
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']
['use']
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
COUNT(*) FROM book
. 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
:
Search WWH ::
Custom Search