Database Reference
In-Depth Information
In the previous examples,
fmtType
was set to
'text'
because this mode is more
legible in a book. This mode inserts line breaks at logical points inside a MySQL
statement, but there is no color involved. With
fmtType
set to
'html'
, phpMyAdmin
would report the SQL statements with syntax highlighting. However, setting
fmtType
to
'none'
removes every kind of formatting, leaving our syntax intact.
The multi-dimensional arrays used for holding some parameters in
the configuration file reflect a programming style adopted by the
phpMyAdmin development team. This ensures that parameter names are
not very long.
The SQL Validator
Each time phpMyAdmin transmits a query, the MySQL server interprets it and
provides feedback. The syntax of the query must follow MySQL rules, which are not
the same as standard SQL. However, conforming to standard SQL ensures that our
queries are usable on other SQL implementations.
A free external service, the Mimer SQL Validator, is available to us. It validates our
query according to the Core SQL-99 rules and generates a report. The Validator is
available directly from phpMyAdmin, and its homepage is located at
http://developer.mimer.com/validator/index.htm
.
For statistical purposes, this service anonymously stores on its server, the
queries it receives. When storing the queries, it replaces database, table,
and column names with generic names. Strings and numbers that are part
of the query, are replaced with generic values so as to protect the original
information.
System requirements
This Validator is available as a SOAP service. Our PHP server must have XML,
PCRE, and PEAR support. We need some PEAR modules too. The following
command (executed on the server by the system administrator) installs the
modules we need:
pear install Net_Socket Net_URL HTTP_Request Mail_Mime Net_DIME SOAP
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
Search WWH ::
Custom Search