Database Reference
In-Depth Information
The window seen in the screenshot contains the same Fields selector and << button
as that used in a Table view context. This distinct Query window is a feature
supported only on JavaScript-enabled browsers.
Query window options
The SQL tab is the default active tab in this window. This comes from the
configuration directive $cfg['QueryWindowDefTab'] , which contains sql by default.
If we want another tab to be the default active tab, we can replace sql with files or
history . Another value, full , shows the contents of all the three tabs at once.
In the Query window, we see a checkbox for the Do not overwrite this query
from outside the window choice. Normally, this is not checked. The changes we
make while generating queries are reflected in the Query window. This is called
synchronization . For example, choosing a different database or table from the left
or right panel would update the Query window accordingly. However, if we start
to type a query directly in this window, the checkbox will get checked in order to
protect its contents and remove synchronization. This way, the query composed here
will be locked and protected.
Session based SQL history
This feature collects all the successful SQL queries we execute, as PHP session data,
and modifies the Query window to make them available. This default type of history
is temporary, as $cfg['QueryHistoryDB'] is set to FALSE by default.
Database based SQL history (permanent)
As we installed the linked-tables infrastructure (see Chapter 11), a more
powerful history mechanism is available. This mechanism is triggered by setting
$cfg['QueryHistoryDB'] to TRUE .
After we try some queries from one of the query boxes, a history is built, visible only
from the Query window.
 
Search WWH ::




Custom Search