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 Overview | Property Summary | Properties Detail | Method Summary | Methods Detail

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

		

			Class Overview
									| Property Summary | Properties Detail
												| Method Summary | Methods Detail
							    				

		

			

			

					

					

																									
mixed  
					$colors  
					

				
													
mixed  
					$words  
					

				
										

			

			
[ Top ]

		

	


	
	

		
Method Summary

		

			Class Overview
																		| Property Summary | Properties Detail
							    					| Method Summary | Methods Detail
		

		

			

				

											

											

																																
SQL_Highlighter  
										__construct()  
					

				
																
void  
										highlight()  
					

				
												

			

			
[ Top ]

		

	


	
	

		
Properties

		

			Class Overview
													| Property Summary | Properties Detail
															| Method Summary | Methods Detail
												

		

			



	

		
			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

		

			Class Overview
																		| Property Summary | Properties Detail
																	| Method Summary | Methods Detail
					

		

			







	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 ]