Databases Reference
In-Depth Information
Changing Data
Data is not static; it often changes. This chapter focuses on editing and deleting data
and its supporting structures: tables and databases.
Edit Mode
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 later in this chapter.
Clicking on the Edit icon or link brings the following panel, which is similar to the
data entry panel (except for the lower part):
Search WWH ::




Custom Search