Online PHP editor | output for VZtD2

<?php $query = "UPDATE `list` set `item`=?,`type`=? WHERE `item` != 'Are you okay?' (`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);