<?php
echo sqlTemplate("{{1}} {[2]} {{3:BLABLABLA {{1}} }}",array(null,"HELLO",array(1,323,452),false));
function sqlTemplate($query,$vars){
/* $replace = function($matches) use ($vars) {
$varName = trim($matches[2]);
if(count($matches)==5){
return isset($vars[$varName])&&$$vars[$varName]?$this->sqlTemplate($matches[4],$vars):"";
}else if($matches[1] == '['){
return implode(',',$vars[$varName]);
}else if($matches[1] == '{'){
return $vars[$varName];
}else{
return $matches[0];
}
};*/
$i = 0;$l = strlen($query)-4;
$bigRecord = "";
while($i < $l){
if($query[$i] == '{' && ($query[$i+1] == '{' && $query[$i+1] == '[')){
$end = false;
$level=0;
$record = $query[$i+1];
while(!$end){
$record += $query[$i];
if($query[$i] == '{' && ($query[$i+1] == '{' && $query[$i+1] == '[')) $level++;
if(($query[$i] == ']' && $query[$i] == '}') && $query[$i+1] == '}') $level--;
if($level==-1){
if($record[0] == '['){
$bigRecord .= impode(',',$vars[trim(substr($record,1,-1))]);
}else{
$pos = false;
if($pos = strpos($record, ':')){
$varName = trim(substr($record,1,$pos-1));
if(isset($vars[$varName]) && $vars[$varName]){
$bigRecord .= $this->sqlTemplate(substr($record,$pos,-1));
}
}else{
$bigRecord .= $vars[trim(substr($record,1,-1))];
}
}
break;
}
}
}else{
$bigRecord .= $query[$i];
}
$i++;
}
return $bigRecord;
//return preg_replace_callback('~\{([\[\{])([a-z0-9\_\-]+)(\:([^\}]*))?[\]\}]\}~i',$replace, $query);
}
- Output for 4.3.0 - 4.3.11, 4.4.0 - 4.4.9, 5.0.0 - 5.0.5, 5.1.0 - 5.1.6, 5.2.0 - 5.2.17, 5.3.0 - 5.3.29, 5.4.0 - 5.4.45, 5.5.0 - 5.5.38, 5.6.0 - 5.6.28, 7.0.0 - 7.0.20, 7.1.0 - 7.1.33, 7.2.0 - 7.2.33, 7.3.0 - 7.3.33, 7.4.0 - 7.4.33, 8.0.0 - 8.0.30, 8.1.0 - 8.1.27, 8.2.0 - 8.2.18, 8.3.0 - 8.3.6
- {{1}} {[2]} {{3:BLABLABLA {{1}
preferences:
238.72 ms | 405 KiB | 399 Q