This chapter covers
single-table and whole database searches. Chapter 13 is a complement to this chapter
and presents multi-table query by example.
Single-Table Searches
This section describes the Search sub-page where single-table search is available.
Daily Usage of phpMyAdmin
The main use for the tool for some users is with the Search mode, for finding and
updating data. For this, the phpMyAdmin team has made it possible to define which
sub-page is the starting page in Table view, with the $cfg['DefaultTabTable']
parameter. Setting it to 'tbl_select.php' defines the default sub-page to search.
With this mode, application developers can look for data in ways not expected by the
interface they are building, adjusting and sometimes repairing data.
Searching Data
[ 152 ]
Entering the Search Sub-Page
The Search sub-page can be accessed by clicking the Search link in the Table view.
This has been done here for the book table:
Chapter 9
[ 153 ]
Selection of Display Fields
The first panel facilitates a selection of the fields to be displayed in the results:
All fields are selected by default, but we can control-click other fields to make the
necessary selections. Mac users would use command-click to select / unselect
the fields.
Here are the fields of interest to us in this example:
We can also specify the number of rows per page in the textbox just next to the field
selection.
Pages:
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156