Databases Reference
In-Depth Information
Now we are ready to create the table by clicking on
Save
. If all goes well, the next
screen conirms that the table has been created; we are now in the
Structure
page of
the current database.
Of the various links shown for the
book
table, some are not active, because it would
not make sense to browse or search a table if there are no rows in it.
Inserting data manually
Now that we have a table, let us put some data in it manually. Before we do that,
here are some useful references on data manipulation within this topic:
•
Chapter
5
explains how to change data and structure, including how to use
the
Function
selector
•
Chapter
7
explains how to import data from existing iles
•
Chapter
9
explains how to copy data from other tables
•
Chapter
10
explains the relational system (in our case, we will want to link to
the
author
table)
For now, click on the
Insert
link, which will lead us to the data-entry (or edit) panel.
This screen has room to enter information for two rows, that is, two topics in our
example. This is because the default value of
$cfg['InsertRows']
is
2
. In the lower
part of the screen, the dialog
Continue
insertion
with
2
rows
can be used if the
default number of rows does not suit our needs. By default, the
Ignore
checkbox is
ticked, which means that the second group of input ields will be ignored. As soon
as we enter some information in one ield of this group and exit the ield, the
Ignore
box is automatically unchecked if JavaScript is enabled in the browser.
We can enter the following sample information for two topics:
• ISBN: 1-234567-89-0, title: A hundred years of cinema (volume 1), 600 pages,
author ID: 1
• ISBN: 1-234567-22-0, title: Future souvenirs, 200 pages, author ID: 2
Search WWH ::
Custom Search