<?php
$template = "select emp.* from employee emp" .
" join departments dep on emp.id_department = dep.id" .
" @{where}" .
" @{order}" .
" limit :limit offset :offset";
echo $template;
$pattern = '/[^\\$]\\@\\{(\\w+)\\}/';
preg_match_all($pattern, $template, $matches);
var_dump($matches);
- 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.30, 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.28, 8.2.0 - 8.2.18, 8.3.0 - 8.3.6
- select emp.* from employee emp join departments dep on emp.id_department = dep.id @{where} @{order} limit :limit offset :offsetarray(2) {
[0]=>
array(2) {
[0]=>
string(9) " @{where}"
[1]=>
string(9) " @{order}"
}
[1]=>
array(2) {
[0]=>
string(5) "where"
[1]=>
string(5) "order"
}
}
preferences:
236.45 ms | 406 KiB | 399 Q