In this chapter, we will cover a powerful phpMyAdmin feature—its ability to transform a column's contents during a table browse, based on specific rules called transformations. Normally, browsing a table shows only the original data that resides in it. However, MIME-based transformations permit the alteration of the display format.
Note that this kind of transformation does not have the same effect as a permanent data change, such as one made via the UPDATE
statement. The transformed data is not written back to the MySQL server; it is just sent to the browser for display purposes.
Normally, the exact contents of each row are displayed, except that:
$cfg['LimitChars']
, and depending on whether we have chosen to see Full Texts or notWe will use the term cell to indicate a specific column of a specific row. The cell containing the cover photograph for the "Future souvenirs" book (a BLOB column) is currently displayed as cryptic data such as ‰PNG IHDR or as a message stating the BLOB column's size. It would be interesting to see a thumbnail (shown in the following screenshot) of the picture directly in phpMyAdmin and possibly the full-size picture itself. This will be made possible with proper transformation.
3.145.78.136