Book Image

Mastering phpMyAdmin 2.11 for Effective MySQL Management

Book Image

Mastering phpMyAdmin 2.11 for Effective MySQL Management

Overview of this book

Table of Contents (25 chapters)
Mastering phpMyAdmin 2.11 for Effective MySQL Management
Credits
About the Author
About the Reviewers
Preface

Chapter 5. 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...