tangra logo
   
[ class tree: tangra_lib ] [ index: tangra_lib ] [ all elements ]
 

Class: SQL_Highlighter

Source Location: /misc/sql_highlighter.class.php

Class SQL_Highlighter

Class Overview

Class for color highlighting SQL statements

Provided by dzver <dzver@abv.bg>

Located in /misc/sql_highlighter.class.php [line 17]



		
		
		
		

Properties

Methods

[ Top ]
Property Summary
mixed   $colors  
mixed   $words  

[ Top ]
Method Summary
SQL_Highlighter   __construct()  
void   highlight()  

[ Top ]
Properties
mixed   $colors = array('chars' => 'grey', 'keywords' => 'blue', 'joins' => 'gray', 'functions' => 'violet', 'constants' => 'red') [line 22]
API Tags:
Access:  protected


[ Top ]
mixed   $words = array (
'keywords' =>
array('SELECT', 'UPDATE', 'INSERT', 'DELETE', 'REPLACE', 'INTO', 'CREATE', 'ALTER', 'TABLE', 'DROP', 'TRUNCATE', 'FROM',
'ADD', 'CHANGE', 'COLUMN', 'KEY',
'WHERE', 'ON', 'CASE', 'WHEN', 'THEN', 'END', 'ELSE', 'AS',
'USING', 'USE', 'INDEX', 'CONSTRAINT', 'REFERENCES', 'DUPLICATE',
'LIMIT', 'OFFSET', 'SET', 'SHOW', 'STATUS',
'BETWEEN', 'AND', 'IS', 'NOT', 'OR', 'XOR', 'INTERVAL', 'TOP',
'GROUP BY', 'ORDER BY', 'DESC', 'ASC', 'COLLATE', 'NAMES', 'UTF8', 'DISTINCT', 'DATABASE',
'CALC_FOUND_ROWS', 'SQL_NO_CACHE', 'MATCH', 'AGAINST', 'LIKE', 'REGEXP', 'RLIKE',
'PRIMARY', 'AUTO_INCREMENT', 'DEFAULT', 'IDENTITY', 'VALUES', 'PROCEDURE', 'FUNCTION',
'TRAN', 'TRANSACTION', 'COMMIT', 'ROLLBACK', 'SAVEPOINT', 'TRIGGER', 'CASCADE',
'DECLARE', 'CURSOR', 'FOR', 'DEALLOCATE'
),'joins'=>array('JOIN','INNER','OUTER','FULL','NATURAL','LEFT','RIGHT'),'chars'=>'/([\\.,\\(\\)<>:=`]+)/i','functions'=>array('MIN','MAX','SUM','COUNT','AVG','CAST','COALESCE','CHAR_LENGTH','LENGTH','SUBSTRING','DAY','MONTH','YEAR','DATE_FORMAT','CRC32','CURDATE','SYSDATE','NOW','GETDATE','FROM_UNIXTIME','FROM_DAYS','TO_DAYS','HOUR','IFNULL','ISNULL','NVL','NVL2','INET_ATON','INET_NTOA','INSTR','FOUND_ROWS','LAST_INSERT_ID','LCASE','LOWER','UCASE','UPPER','LPAD','RPAD','RTRIM','LTRIM','MD5','MINUTE','ROUND','SECOND','SHA1','STDDEV','STR_TO_DATE','WEEK'),'constants'=>'/(\'[^\']*\'|[0-9]+)/i')
[line 26]
API Tags:
Access:  protected


[ Top ]
Methods
Constructor __construct  [line 58]

  SQL_Highlighter __construct( [ $colors = 0]  )

Parameters:
   $colors: 


[ Top ]
highlight  [line 62]

  void highlight( $sql  )

Parameters:
   $sql: 

API Tags:
Access:  public


[ Top ]