For
example, we want to know how many different authors we have in our book table
and how many books each one wrote. On the line describing the field we want to
browse??”here author_id??”we click the Browse distinct values icon or link.
We have a limited test set but we can nonetheless see the results:
Chapter 4
[ 83 ]
Browse-Mode Customization
Here are more parameters that control the appearance of results. These parameters??”
except $cfg['RepeatCells']??”are located in themes/themename/layout.inc.php.
$cfg['Border']: The HTML tables used to present results have no border
by default because this parameter is set to 0; we can put a higher number (for
example 1 or 2) to add borders to the tables.
$cfg['ThBgcolor']: The tables mentioned have headers with #D3DCE3 as
the default background color.
$cfg['BgcolorOne'], $cfg['BgcolorTwo']: When displaying rows of
results, two background colors are used alternately; by default, those are
#CCCCCC and #DDDDDD.
$cfg['RepeatCells']: When many rows of data are displayed, we may lose
track of the meaning of each column; by default, at each 100th cell, column
headers are displayed.
Creating an Additional Table
In our (simple) design, we know that we need another table: the author table. The
author table will contain:
Author identification
Full name
Phone number
To create this table, we must go back to the Database view in the left panel.
Pages:
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102