21,886
社区成员
发帖
与我相关
我的任务
分享
private function escapeReserved($query)
{
$search = array ("/({)(\w+)(})/e",
"/({L#)([0-9]+)(})/e",
"/(\:)(uid|session|file|access|mode|comment|desc|size|start|end)/e",
)
$replace = array ("'\"\\1'.strtoupper('\\2').'\\3\"'",
"'\"\\1'.strtoupper('\\2').'\\3\"'",
"'\\1'.'db_'.'\\2'.'\\3'",)
return preg_replace($search, $replace, $query);
}
$s = '{Test}{L#123456}:uid';
echo escapeReserved($s);// "{TEST}""{L#123456}":db_uid
echo '<br>';
echo test($s);//"{TEST}""{L#123456}":db_uid
function escapeReserved($query){
$search = array ("/({)(\w+)(})/e",
"/({L#)([0-9]+)(})/e",
"/(\:)(uid|session|file|access|mode|comment|desc|size|start|end)/e");
$replace = array ("'\"\\1'.strtoupper('\\2').'\\3\"'",
"'\"\\1'.strtoupper('\\2').'\\3\"'",
"'\\1'.'db_'.'\\2'.'\\3'");
return preg_replace($search, $replace, $query);
}
function test($query){
$search = array ("/({)(\w+)(})/",
"/({L#)([0-9]+)(})/",
"/(\:)(uid|session|file|access|mode|comment|desc|size|start|end)/");
return preg_replace_callback($search, function($m) {
if(isset($m[3])){
return '"'.$m[1].strtoupper($m[2]).$m[3].'"';
}else{
return "$m[1]db_$m[2]";
}
}, $query);
}