Book Image

Mastering phpMyAdmin 2.11 for Effective MySQL Management

Book Image

Mastering phpMyAdmin 2.11 for Effective MySQL Management

Overview of this book

Table of Contents (25 chapters)
Mastering phpMyAdmin 2.11 for Effective MySQL Management
Credits
About the Author
About the Reviewers
Preface

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. The default values are:

$cfg['SQP']['fmtColor'] = array(
'comment' => '#808000',
'comment_mysql' => '',
'comment_ansi' => '',
'comment_c' => '',
'digit' => '',
'digit_hex' => 'teal',
'digit_integer' => 'teal',
'digit_float' => 'aqua',
'punct' => 'fuchsia',
'alpha' => '',
'alpha_columnType' => '#FF9900',
'alpha_columnAttrib' => '#0000FF',
'alpha_reservedWord' => '#990099',
'alpha_functionName' => '#FF0000',
'alpha_identifier' => 'black',
'alpha_variable' => '#800000',
'quote' => '#008000',
'quote_double' =&gt...