Online PHP editor | refs for BknBT

<?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\n"; foreach($querydata AS $key=>$val) { echo preg_replace('/(.+?)('.$key.')(.*)/','$1' . $val . '$3', $query) . "\n"; //echo $query; }