Database Reference
In-Depth Information
Of the various tabs leading to other subpages, some are not active, because it would
not make sense to browse or search a table if there are no rows in it. However, it
would be acceptable to export a table, as we can export a table's structure even if it
contains no data.
Manual data insertion
Now that we have a table, let's 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
•
Chapter 8 explains how to import data from existing files•
•
Chapter 10 explains how to copy data from other tables
•
Chapter 11 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
Restart insertion with 2 rows
can be used if the
default number of rows does not suit our needs. But beware, any data already on
screen would be lost. By default, the
Ignore
checkbox is ticked, which means that the
second group of fields will be ignored. But as soon as we enter some information in
one field of this group and exit the field, the
Ignore
box is unchecked.
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
•
We start by entering data for the first and the second rows. The
Value
column width
obeys the maximum length for the character fields. For this example, we keep the
lower drop-down selector to its default value of
Insert as new row
. We then click on
Go
to insert the data. There is a
Go
button after each set of columns that represent a
row, and another one on the lower part of the screen. All these have the same effect
of saving the entered data.
Search WWH ::
Custom Search