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 as:
Chapter 12
[ 203 ]
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 avoids having very long
parameter names.
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 may be used on other SQL implementations.
A free external service, the Mimer SQL Validator, is offered. It validates our
query according to Core SQL-99 rules and generates a report. The Validator is
available directly from phpMyAdmin, and its home page is located at
http://developer.mimer.com/validator/index.htm.
This service stores anonymously on their server the queries it receives,
for statistical purposes. When storing the queries, it replaces database,
table, and columns 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.
Pages:
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198