Online PHP editor | output for nmQE5

<?php $query = 'UPDATE `list?` set `item`=?,`type`=? WHERE ( "ty?pe?"<> \'Are yo?\' `id` = ?);'; $params = array( 'item' => '1', 'type' => 'Are you o\'k?', 'id' => '2' ); function substitute_params($query, $params) { $prep_params = str_replace(array("'","?"),array("''","\\?"),$params); $query = array_reduce($prep_params, function ($interm, $param) { return preg_replace('/^([^"\'`]*?(?:(?:`[^`]*?`[^"\'`]*?)*?(?:"[^"]*?"[^"\'`]*?)*?(?:\'[^\']*?\'[^\'"`]*?)*?)*?)(?<!\\\\)\\?/m', '${1}'.(is_numeric($param) ? $param : '\'' . $param . '\''), $interm, 1); }, $query); return "-- Not to be used as a query to database. For demonstration purposes only!\n" .str_replace("\\?", "?", $query); } echo substitute_params($query, $params); ?>