3v4l.org

run code in 300+ PHP versions simultaneously
<?php $arr = [5, "David"]; $query = "SELECT * FROM users WHERE user_id = ? AND user_name = ?"; function logger($query, $arr) { foreach($arr as $a) { $query = is_numeric($a) ? preg_replace("/(?<=\s)\?(?=\s|$)/", $a, $query, 1) : preg_replace("/(?<=\s)\?(?=\s|$)/", "'$a'", $query, 1); } return $query; } echo logger($query, $arr);
Output for 7.1.25 - 7.1.28, 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.33, 8.2.0 - 8.2.29, 8.3.0 - 8.3.26, 8.4.1 - 8.4.13
SELECT * FROM users WHERE user_id = 5 AND user_name = 'David'
preferences:
130.6 ms | 407 KiB | 5 Q