Let's see an example. In the Search page for the book table, we select the
fields that we want in the results, and enter the search values as shown in the
following screenshot:
After clicking Go, we see that the results page has a bookmark dialog. We have
to enter only a label for this bookmark and click Bookmark this SQL-query to
save this query as a bookmark. Bookmarks are saved in the table defined by
$cfg['Servers'][$i]['bookmarktable'].
Chapter 14
[ 221 ]
This bookmark dialog can be seen on any page that contains results. As a test, we
could just click Browse for a table to get results, and then store this query as a
bookmark. However, it does not make much sense to store (in a bookmark) a query
that can easily be made with one click.
Storing a Bookmark before Sending
a Query
Sometimes, we may want to store a bookmark even if a query does not find any
results. This may be the case if the matching data is not yet present or if the query
is not a SELECT statement. To achieve this, we have the Bookmark this SQL-query
dialog available in the SQL tab of Database view, Table view, and the query window.
We now go to the SQL sub-page of the book table, enter a query, and directly put
the books in French bookmark label in the Bookmark this SQL query field. If this
bookmark label was previously used, a new bookmark with the same name will be
created, unless we select the Replace existing bookmark of same name checkbox.
Pages:
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208