Database Reference
In-Depth Information
SQL query links
In the
Browse
results, the first part displayed is the query itself, along with a
few links. The displayed links may vary depending on our actions and some
configuration parameters.
The
Profiling
checkbox will be covered in Chapter 17.
The
Edit
link appears if
$cfg['SQLQuery']['Edit']
is set to
TRUE
. Its purpose is
to open the
Query
window
, so that you can edit this query (see Chapter 12 for
more details).
Explain SQL
is displayed if
$cfg['SQLQuery']['Explain']
is set to
TRUE
. We will
see in Chapter 6, what this link can be used for.
The
Create PHP Code
link can be clicked to reformat the query to the syntax
expected in a PHP script. It can then be copied and pasted directly at the place where
we need the query in the PHP script we are working on. Note that after a click, this
link changes to
Without PHP Code
, which would bring back the normal query
display. This link is available if
$cfg['SQLQuery']['ShowAsPHP']
is set to
TRUE
.
Refresh
is used to execute the same query again. The results might change, as a
MySQL server is a multi-user server, and other users might be modifying the same
tables. This link is shown if
$cfg['SQLQuery']['Refresh']
is set to
TRUE
.
All these four parameters have a default value of
TRUE
in
config.inc.php
.
Search WWH ::
Custom Search