3v4l.org

run code in 500+ PHP versions simultaneously
<?php $where = [["id", ">", 3], ["firstname", "=", "John"]]; $wherequery = ' where'; foreach($where as $w){ $wherequery .= ' ' . $w[0] . ' ' . $w[1] . ' :' . $w[0]; $params[$w[0]] = $w[2]; } echo "SELECT columns FROM table " . $wherequery;
Output for 7.4.0 - 7.4.33, 8.0.1 - 8.0.30, 8.1.0 - 8.1.34, 8.2.0 - 8.2.30, 8.3.0 - 8.3.30, 8.4.1 - 8.4.21, 8.5.0 - 8.5.7
SELECT columns FROM table where id > :id firstname = :firstname
preferences:
73.1 ms | 1261 KiB | 4 Q