Online PHP editor | refs for KWFqF

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