With larger tables,
we could see a more complete set of navigation buttons. To simulate this, let's use the
Show dialog to change the default number of rows from 30 to 1; we then click Show.
We can see that the navigation bar adapts itself:
Chapter 4
[ 79 ]
This time, there are buttons labeled <<, <, >, and >> for easy access to the first page,
previous page, next page, and last page of the results. The buttons only appear 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 because the default setting of
$cfg['NavigationBarIconic'] is TRUE. A FALSE here would produce a different
set of labels:
There is also a Page number drop-down menu, to go directly to one of the pages
located near the current page. Since there can be hundreds or thousands of pages, this
menu is kept small with only a few page numbers before and after the current page.
By design, phpMyAdmin always tries to give quick results, and one way to achieve
this result is by adding a LIMIT clause in SELECT. If there is already a LIMIT clause
in the original query, phpMyAdmin will respect it. The default limit is 30 rows, set in
$cfg['MaxRows']. With multiple users on the server, this helps keeping the server
load to a minimum.
Another button is available on the navigation bar, but must be activated by setting
$cfg['ShowAll'] to TRUE.
Pages:
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98