When the MySQL column name is not appropriate for display as the title of the column in the displayed table, alternate text can be specified. To display the word "Subject" instead of the name "Topic" for the example column from previous chapter, add the following option to the script:
When creating MySQL tables for use with phpMyEdit, consider using the underscore character in certain field names. For example, a MySQL column named "last_name" will be displayed as "Last name" in tables created using phpMyEdit (underscore characters are replaced with a space).
Sometimes a short title can't be explicit enough, so it is neccessary to provide the user a large description on a given field when he is manipulating with field data. For this purpose was $opts['fdd']['col_name']['help'] option created. Content of this option will appear in the third column of record display pages.
This option is optional. If there is no ['help'] option for all columns, the third "help" column will be omitted.
Per field, you can define field CSS class names postfix. This is especially useful in order to highlight one column in a table.
Example 4-4. Field CSS customization
$opts['fdd']['col_name']['css'] = array( 'postfix' => 'ColName' ); |
More information about CSS handling can be found in the CSS classes policy section.
Specify field input type as text box, numeric comparsion text box, drop-down selection, or multiple selection. The same input type will be used also for table filtering.
Example 4-5. Filter selections
$opts['fdd']['col_name']['select'] = 'T'; // text box $opts['fdd']['col_name']['select'] = 'N'; // numeric $opts['fdd']['col_name']['select'] = 'D'; // drop down $opts['fdd']['col_name']['select'] = 'M'; // multiple selection |
An optional parameter to control whether a field is displayed in the add, change, copy, delete, view, list, or filter views.
| A | -- add |
| C | -- change |
| P | -- copy |
| V | -- view |
| D | -- delete |
| L | -- table list |
| F | -- table filter |
Additional column-specific options that apply to certain views or modes (add, change, delete, list) are:
| R | -- indicates a field is read only |
| W | -- indicates a field is a password field |
| H | -- indicates a field is to be hidden and marked as hidden |