Initial bookmark creation is made possible by the Bookmark this SQL-query button. This button appears only after execution of a query that generates results (when at least one row is found), so this method for creating bookmarks only stores SELECT
statements. For example, a complex query produced by the multi-table query generator (as seen in Chapter 13) could be stored as a bookmark in this way, provided it finds some results.
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']
.
This bookmark dialog can be seen on any page that contains results. As a test...