Databases Reference
In-Depth Information
The bar enables us to navigate from page to page, displaying an arbitrary number of
rows, starting at some point in the results. As we entered browse mode by clicking
Browse
, the underlying query that generated the results includes the whole table.
However, this is not always the case.
We are currently using a table containing a small number of rows. With larger tables,
we could see a more complete set of navigation buttons. To simulate this, let us
use the
Show
dialog to change the default number of rows from
30
to
1
; we then
click on
Show
. We can see that the navigation bar adapts itself as shown in the
following screenshot:
This time, there are buttons labeled
<<
,
<
,
>
, and
>>
for easy access to the first page,
previous page, next page, and the last page of the results respectively. The buttons
appear only when necessary; for example, the
first
page
button is not displayed if
we already are on the first page. These symbols are displayed in this manner as the
default setting of
$cfg['NavigationBarIconic']
is
TRUE
. A
FALSE
here would
produce buttons such as
Next
and
End
, whereas a value of
'both'
would display
>
Next
and
>>
End
.
Note that the
$cfg['NavigationBarIconic']
directive controls
only the behavior of these navigation buttons; other buttons and links
such as
Edit
are controlled by other configuration directives.
There is also a
Page
number
drop-down menu, to go directly to one of the pages
located near the current page. As there can be hundreds or thousands of pages, this
menu is kept small and contains the commonly requested pages: a few page numbers
before and after the current page, a few pages at the beginning and at the end plus a
sample of page numbers based on a computed interval.
By design, phpMyAdmin always tries to give quick results, and one way to achieve
this result is to add a
LIMIT
clause in
SELECT
. If a
LIMIT
clause is already there in
the original query, phpMyAdmin will respect it. The default limit is 30 rows, set in
$cfg['MaxRows'].
If there are many users on the server, limiting the number of
rows returned helps keeping the server load to a minimum.
Search WWH ::
Custom Search