Option controls the number of records displayed on the screen. Change the argument for $opts['inc'] in order to specify the maximum number of rows to display at one time. The default is 15 rows. To display all found records, specify a value of -1 (negative 1).
Example 3-4. Displayed records
$opts['inc'] = 20; // list 20 records per page $opts['inc'] = -1; // list all found records |
This option affects the display of <SELECT MULTIPLE> boxes. If the MySQL column type is "set", the number of lines displayed on multiple selection filters is specified as:
Setting $opts['multiple'] to a large number may adversely affect the appearance of your form. Four (4) is the default.
There are some special page elements, that may be turned on or off by changing $opts['display'] array.
Setting the query or sort values to true will display the current query or sort order near the top of the table. To display the execution time of the query below the table, change the time value from false to true. Setting sort to true is very helpful in understanding how cumulative sorting takes place.
To display all these page elements use:
Example 3-6. Special page elements
$opts['display'] = array( 'query' => true, 'sort' => true, 'time' => true ); |
If graphic links are selected with navigation (for example by setting $opts['navigation'] to 'GD') then $opts['url'] can be used to specify the folder containing images. The default image location is normally one folder (or directory level) below the location of the phpMyEdit.class.php file.
Other URLs for another elements may be added into this array in future.
Since version 4.0, phpMyEdit automatically starts its execution. You can turn this feature off by setting:
If variable $opts['execute'] is not defined, its value is considered as 1.