Databases Reference
In-Depth Information
It may be interesting to visually mark some rows when we have many columns
in the table and must constantly scroll left and right to read data. Another usage
is to highlight the importance of some rows for personal comparison of data,
or when showing data to people. Highlighting is done by clicking on the row.
Clicking again removes the mark on the row. The chosen color is defined by
$cfg['BrowseMarkerColor']
(see
themes/<themename>/layout.inc.php
). This
feature must be enabled by setting
$cfg['BrowseMarkerEnable']
to
TRUE
, this time
in
config.inc.php
. This sets the feature for all the themes. We can mark more than
one row. Marking the row also activates the checkbox for this row.
Marking a column is done by clicking on the column header, but not on the column
name itself.
Limiting the length of each column
In the previous examples, we always saw the full contents of each column,
as each column had the number of characters within the limit defined by
$cfg['LimitChars']
. This is a limit enforced on all non-numeric columns. If this
limit was low (say
10
), the display would be as follows:
This would help us see more columns at the same time (at the expense of seeing less
of each column).
Display options
In order to see the full texts, we will now make use of the
Options
slider, which
reveals some display options. All these options will be explained in the chapters that
cover the corresponding notions. The option that concerns us at the moment is the
Partial
Texts/Full
Texts
pair; we can choose
Full
Texts
to see all of the text that was
truncated. Even if we elect not to change the
$cfg['LimitChars']
parameter, there
will be a time when asking for full texts will be useful (when we work with
TEXT
column type—more on this in
Chapter
5
).
Search WWH ::
Custom Search