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_uidecho '<br>';echo test($s);//"{TEST}""{L#123456}":db_uidfunction 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);}