Data is not static; it often changes. This chapter focuses on editing and deleting data and its supporting structures: tables and databases.
When we browse a table or view results from a search on any single-table query, small icons appear on the left or right of each table row:
The row can be edited with the pencil-shaped icon and deleted with the X-shaped icon. The exact form and location of these controls are governed by:
$cfg['PropertiesIconic'] = TRUE; $cfg['ModifyDeleteAtLeft'] = TRUE; $cfg['ModifyDeleteAtRight'] = FALSE;
We can decide whether to display them on the left, the right, or both sides. The $cfg['PropertiesIconic']
parameter can have the values TRUE, FALSE
, or 'both'. TRUE
displays icons as seen in the previous image, FALSE
displays Edit and Delete (or their translated equivalent) as links, and 'both'
displays the icon and the text.
The small checkbox beside each row is explained in the Multi-Row Edit and the Deleting Many Rows sections...