3v4l.org

run code in 300+ PHP versions simultaneously
<?php $courses = array('Eng', 'Deu', 'Bio', 'Chemi'); $placeholders = rtrim(str_repeat('?, ', count($courses)), ', '); $query = "select * from table WHERE class = 'EFG' AND course in ({$placeholders})"; echo $query; /* $stmt = $pdo->prepare($query); $stmt->execute($courses); */
Output for 5.6.0 - 5.6.40, 7.0.0 - 7.0.33, 7.1.0 - 7.1.33, 7.2.0 - 7.2.34, 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.25, 8.4.1 - 8.4.12
select * from table WHERE class = 'EFG' AND course in (?, ?, ?, ?)

preferences:
135.68 ms | 408 KiB | 5 Q