The Check
All / Uncheck All option permits us to easily check or uncheck all boxes.
??? ??? ??? ??? ???
Changing Table Structures
[ 100 ]
TEXT
We will now explore how to use the TEXT field type and the relevant configuration
values to adjust for the best possible phpMyAdmin behavior.
First we add to the book table a TEXT field called description:
There are three parameters that control the layout of the text area that will be
displayed in Insert or Edit mode for the TEXT fields. First, the number of columns
and rows for each field is defined by:
$cfg['TextareaCols'] = 40;
$cfg['TextareaRows'] = 7;
This gives (by default) the following space to work on a TEXT field:
The settings impose only a visual limit on the text area, and a vertical scroll bar is
created by the browser if necessary.
Chapter 6
[ 101 ]
Although MEDIUMTEXT, TEXT, and LONGTEXT columns can
accommodate more than 32K of data, some browsers cannot always
edit them with the mechanism offered by HTML: a text area. In fact,
experimentation has convinced the phpMyAdmin development team to
have the product display a warning message, if the contents are larger
than 32K, telling users that it might not be editable.
The last parameter has an impact for LONGTEXT fields. Setting $cfg['LongtextDo
ubleTextarea'] to TRUE doubles the available editing space.
Pages:
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114