Вот собственно новая редакция рега:
<?
$some_string = "
SET @idins = REPLACE(CONVERT(nvarchar(50), @myid), '-rrr'','dfj'njd' ) SET @userid = (SELECT ID FROM dbo.USERS WHERE (UserName = 'yuk'ko'))
";
$string = preg_replace("/(?<=[\(=,]|<>)\s*('.*?')(?=\s*[,\\x29]|\s+where|\s*$|\s+and|\s+or)/sie","my_func('\\0')",$some_string);
echo nl2br($string);
function my_func($string)
{
$start = strpos($string,"'");
$end = strrpos($string, "'");
$begin = substr($string, 0, $start+1);
$finish = substr($string, $end);
$middle = substr($string, $start+1,$end-$start-1);
$string = $begin.str_replace("'","''", $middle).$finish;
return($string);
}
?>
|
Вариант для распечатки
