We
click on marc_book in the left panel, and request the creation of another table with
three fields:
???
??? ???
???
??? ??? ???
First Steps
[ 84 ]
Using the same techniques used when creating the first table, we get:
Since we have three fields or less, the display is now in vertical mode (more details
on this in Chapter 6, Vertical Mode section).
Here the field name id, which is our primary key in this new table, relates to the
author_id field from the book table. After saving the table structure, we enter some
data for authors 1 and 2. Use your imagination for this!
Summary
In this chapter, we explained how to create a database and tables, and how to enter
data manually in the tables. We also saw how to confirm the presence of data by
using the browse mode; including the SQL query links, navigation bar, sorting
options, and row marking.
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.
Pages:
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103