Pretty printing (syntax highlighting)

By default, phpMyAdmin parses and highlights the various elements of any MySQL statement it processes. This is controlled by $cfg['SQP']['fmtType'], which is set to'html' by default. This mode uses a specific color for each different element (a reserved word, a variable, a comment, and so on) as described in the $cfg['SQP']['fmtColor'] array located in the theme-specific layout.inc.php file.

Setting fmtType to'text' would remove all color formatting, inserting line breaks at logical points inside a MySQL statement. Finally, setting fmtType to'none' removes every kind of formatting, leaving our syntax intact.

Get Mastering phpMyAdmin 3.4 for Effective MySQL Management now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.