Creating and Browsing Tables - Mastering phpMyAdmin 3.4 for Effective MySQL Management - page 78

The following points describe the function of each link:
• The Profiling checkbox is covered in the Profiling queries section of
this chapter.
• The Inline link permits to put the query inside a text area without reloading
the page; then the query may be edited and the new query may be executed.
• 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 (refer
to Chapter 11 for more details).
• Explain SQL is displayed if $cfg['SQLQuery']['Explain'] is set to TRUE .
We will see in Chapter 5 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 (as shown in the
following screenshot), 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 or processes might
be modifying the same tables. This link is shown if $cfg['SQLQuery']
['Refresh'] is set to TRUE .
Navigation bar
The Navigation bar is displayed at the top of results and also at the bottom. Column
headers can be repeated at certain intervals among results depending on the value
entered in repeat headers after field.