Posted: Sun Jun 17, 2007 12:40 pm
here's my entire code
Code: Select all
function mysql($sql){
// highlighting the code
$sql = str_replace("\n", '<br />', $sql);
//Quotes
$sql = preg_replace("/(['\"`])(.+?)(['\"`])/", "<span class='quote'>\\1\\2\\3</span>", $sql);
$sql = preg_replace('/`(.+?)`/i', "<span class='quote'>`\\1`</span>", $sql);
//Equal Sign
$sql = preg_replace("/(=)(?!['\"][^>]*>)/", "<span class='operator'>\\1</span>", $sql);
//Keywords
$sql = preg_replace("/((CREATE|ALTER|DROP)\s+(VIEW|TABLE|DATABASE|SCHEMA)\s+(\w)*[^<>])/i","<span class='keyword'>\\1</span>", $sql);
$sql = preg_replace("/(SELECT|UPDATE|INSERT)/i", "<span class='keyword'>\\1</span>", $sql);
$sql = preg_replace("/(MAX|AVG|SUM|COUNT|MIN|FROM|INTO)/i", "<span class='keyword'>\\1</span>", $sql);
//edited out very long keyword highlighting
//Condition
$sql = preg_replace('/(LIKE|NOT LIKE|REGEXP)/i', "<span class='condition'>\\1</span>", $sql);
//Operator
$sql = str_replace(";", "<span class='operator'>;</span>", $sql);
$sql = preg_replace("/[0-9]{50}/", "<span class='number'>\\1</span>", $sql);
//Numbers
$sql = preg_replace("/(\d{1,10})/", "<span class='number'>\\1</span>", $sql);
// Comments
$sql = preg_replace("'(\/\*.*)(\w*)(.*\*/)'", "<span class='comment'>\\1\\2\\3</span>", $sql);
$sql = preg_replace("'((//|#)((\w|\s|\d)*)*)'i", "<span class='comment'>\\1</span>", $sql);
// $sql = preg_replace("/()/i", "<span class=''>\\1</span>", $sql);
// output the Code
echo $this->output($sql, "grey");
}