<?php
$query = "UPDATE `benefits` SET `ins_id`=:ins_id, `order`=:order WHERE `ben_id`=:ben_id";
$querydata = array(':ins_id' => 1001, ':order' => 1, ':ben_id' => 4004);
echo "$query\n";
foreach($querydata AS $key=>$val)
{
echo preg_replace('/(.+?)('.$key.')(.*)/','$1' . $val . '$3', $query) . "\n";
//echo $query;
}
- Output for 5.4.0 - 5.4.45, 5.5.0 - 5.5.38, 5.6.0 - 5.6.40, 7.0.0 - 7.0.33, 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.7
- UPDATE `benefits` SET `ins_id`=:ins_id, `order`=:order WHERE `ben_id`=:ben_id
001, `order`=:order WHERE `ben_id`=:ben_id
WHERE `ben_id`=:ben_id
004
preferences:
250.96 ms | 404 KiB | 377 Q