unhighlighted instead of'color:green'
> =
here is the code i am parsing=
Code: Select all
$sql = preg_replace('/(=)/', "<div style='color:green'> \\1 </div>", $sql);Moderator: General Moderators
unhighlighted instead of'color:green'
> =
here is the code i am parsing=
Code: Select all
$sql = preg_replace('/(=)/', "<div style='color:green'> \\1 </div>", $sql);Code: Select all
echo preg_replace('/(=)/', '<span style="background-color: green; color: white;">\\1</span>', "hi = bye when me = gone");Code: Select all
<?php
function mysql($sql){
// highlighting the code
echo "<style>div
{
display: inline;
}
\n
code { padding-top: 2px; padding-right: 2px; padding-bottom: 2px; padding-left: 2px }
</style>\n\n";
$sql = str_replace("\n", '<br />', $sql);
$sql = preg_replace('/(=)/i', "<span style='color: green'> \\1 </span>", $sql);
// $sql = preg_replace("/(*)/", "<div style='color:brown'> \\1 </div>", $sql);
$sql = preg_replace("/'(.+?)'/i", "<div style='color:red'> '\\1' </div>", $sql);
$sql = preg_replace('/^(CREATE|ALTER|DROP)\s+(VIEW|TABLE|DATABASE|SCHEMA)\s+/i', "<div style='color:blue'>$1 $2 </div>", $sql);
$sql = preg_replace('/.(SELECT|UPDATE)\s+/i', "<div style='color:blue'>\\1 </div>", $sql);
$sql = preg_replace('/.(MAX|AVG|SUM|COUNT|MIN|FROM|INTO)\s+/i', "<div style='color:green'> \\1 </div>", $sql);
$sql = preg_replace('/`(.+?)`/i', "<div style='color:red'> `\\1` </div>", $sql);
$sql = preg_replace('/(ASC|DESC|ORDER BY|LIMIT|LEFT|JOIN|WHERE|MODIFY|CHANGE|DISTINCT)/i', "<div style='color:green'> \\1 </div>", $sql);
$sql = preg_replace('/(LIKE|NOT LIKE|REGEXP)/i', "<div style='color:orange'> \\1 </div>", $sql);
$sql = preg_replace('/"(.+?)"/i', "<div style='color:red'> \"\\1\" </div>", $sql);
$sql = preg_replace('/(INT|VARCHAR|TINYINT|BIGINT|BINARY|BIT|BLOB|BOOL|BOOLEAN|CHAR|CHARACTER'.
'|DATE|DATETIME|DEC|DECIMAL|DOUBLE|ENUM|FLOAT|FLOAT4|FLOAT8|INT1|INT2|INT3|INT4|'.
'INT8|INTEGER|LONGBLOB|LONGTEXT|MEDIUMBLOB|MEDIUMTEXT|MEDIUMINT|MIDDLEINT|NCHAR|'.
'NUMERIC|REAL|SERIAL|SET|SMALLINT|TEXT|TIME|TIMESTAMP|TINYBLOB|TINYTEXT|'.
'VARBINARY|YEAR|PRIMARY|AUTO INCREMENT)/i', "<div style='color:darkred'> \\1 </div>", $sql);
$sql = preg_replace('/;/i', "<b><div style='color: green;'> ;</div></b>", $sql);
$sql = preg_replace('/[0-9]{6}/i', "<div style='color: red;'> \\1 </div>", $sql);
// $sql = preg_replace('/()/i', "<div style='color:'> \\1 </div>", $sql);
//$sql = stripslashes($sql);
}
?>Code: Select all
$sql = preg_replace('/(=)/i', "<span style='color: green'> \\1 </span>", $sql);Code: Select all
$sql = str_replace('=', "<span style='color: green'>=</span>", $sql);Code: Select all
$sql = preg_replace("/'(.+?)'/i", "<div style='color:red'> '\\1' </div>", $sql);Code: Select all
$sql = str_replace("\n", '<br />', $sql);
$sql = preg_replace("/'(.+?)'/i", "<div style='color:red'> '\\1' </div>", $sql);
$sql = preg_replace('/"(.+?)"/i', "<div style='color:red'> \"\\1\" </div>", $sql);
$sql = preg_replace('/`(.+?)`/i', "<div style='color:red'> `\\1` </div>", $sql);
$sql = str_replace('/=/', "<span style='color: green'>=</span>", $sql);
// $sql = preg_replace("/(*)/", "<div style='color:brown'> \\1 </div>", $sql);
$sql = preg_replace('/^(CREATE|ALTER|DROP)\s+(VIEW|TABLE|DATABASE|SCHEMA)\s+/i', "<div style='color:blue'>$1 $2 </div>", $sql);
$sql = preg_replace('/.(SELECT|UPDATE)\s+/i', "<div style='color:blue'>\\1 </div>", $sql);
$sql = preg_replace('/.(MAX|AVG|SUM|COUNT|MIN|FROM|INTO)\s+/i', "<div style='color:green'> \\1 </div>", $sql);
$sql = preg_replace('/(ASC|DESC|ORDER BY|LIMIT|LEFT|JOIN|WHERE|MODIFY|CHANGE|DISTINCT)/i', "<div style='color:green'> \\1 </div>", $sql);
$sql = preg_replace('/(LIKE|NOT LIKE|REGEXP)/i', "<div style='color:orange'> \\1 </div>", $sql);
$sql = preg_replace('/(INT|VARCHAR|TINYINT|BIGINT|BINARY|BIT|BLOB|BOOL|BOOLEAN|CHAR|CHARACTER'.
'|DATE|DATETIME|DEC|DECIMAL|DOUBLE|ENUM|FLOAT|FLOAT4|FLOAT8|INT1|INT2|INT3|INT4|INT8|INTEGER|'.
'LONGBLOB|LONGTEXT|MEDIUMBLOB|MEDIUMTEXT|MEDIUMINT|MIDDLEINT|NCHAR|NUMERIC|REAL|SERIAL|SET|'.
'SMALLINT|TEXT|TIME|TIMESTAMP|TINYBLOB|TINYTEXT|VARBINARY|YEAR|PRIMARY|AUTO INCREMENT)/i', "<div style='color:darkred'> \\1 </div>", $sql);
$sql = preg_replace('/;/i', "<b><div style='color: green;'> ;</div></b>", $sql);
$sql = preg_replace('/[0-9]{6}/i', "<div style='color: red;'> \\1 </div>", $sql);Kind of cocky to assume that if people aren't replying to you that they must be copying your code. I think it's safe to say that, being a forum of developers, we tend to write our code ourselves. And, so you know, most of us don't dwell on one post for too long, so when you have a long snippet of code (I'll admit), we don't always read the whole thing. It's not plain English, you know. :-pziggy3000 wrote:i have noticed that people help me more when i dont post my whole code, because users just wait and see how i solve my problem, and then copy without learning...(most of them)