Database Reference
In-Depth Information
Display options
In
Browse
mode, the
Options
link reveals a slider that contains, among other
choices, a
Hide Browser transformation
checkbox. We can use it whenever we want
to switch between seeing the real data of a cell and its transformed version.
Enabling transformations
We define
transformation
as a mechanism by which all the cells related to a column
are transformed at browse time, using the metadata defined for this column. Only
the cells visible on the results page are transformed. The transformation logic itself is
coded in PHP scripts, stored in
libraries/transformations
, and is called using a
plug-in architecture.
To enable this feature, we must set
$cfg['BrowseMIME']
to
TRUE
in
config.inc.php
.
The linked-tables infrastructure must be in place (see Chapter 11) because the metadata
necessary for the transformations is not available in the official MySQL table structure.
It is an addition made especially for phpMyAdmin.
In the documentation section on phpMyAdmin's homesite, there is a
link pointing to additional information for developers who would like
to learn the internal structure of the plug-ins in order to code their own
transformations.
The MIME column's settings
If we go to the Table view of the
Structure
page for the
book
table and click the
Change
link for the
cover_photo
, we see three additional attributes for the fields
(provided the transformations feature is enabled):
•
MIME type
•
Browser transformation
•
Transformation options
Search WWH ::
Custom Search