<?php
echo sqlTemplate("{{o}} {[a]} {{u:BLABLABLA {{a}} }}",array("o"=>"HELLO","a"=>array(1,323,452),"u"=>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] == '[')){
$i+=2;
$end = false;
$level=0;
$record = $query[$i+1];
while($i < $l){
$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, ':') !== false){
$varName = trim(substr($record,1,$pos-1));
if(isset($vars[$varName]) && $vars[$varName]){
$bigRecord .= $sqlTemplate(substr($record,$pos,-1));
}
}else{
die($record);
$bigRecord .= $vars[trim(substr($record,1))];
}
}
break;
}
$i++;
}
}else{
$bigRecord .= $query[$i];
}
$i++;
}
return $bigRecord;
//return preg_replace_callback('~\{([\[\{])([a-z0-9\_\-]+)(\:([^\}]*))?[\]\}]\}~i',$replace, $query);
}
preferences:
46.82 ms | 402 KiB | 5 Q