PHPize Online / SQLize Online  /  SQLtest Online

<?php // $mysqli is already declared as a working database connection by this sandbox $ids = [1, 5, 18, 25]; $count = count($ids); $sql = 'SELECT name FROM somewhere'; $orderBy = 'ORDER BY name'; if ($count) { $placeholders = implode(',', array_fill(0, $count, '?')); $stmt = $mysqli->prepare("$sql WHERE id IN ($placeholders) $orderBy"); $stmt->bind_param(str_repeat('i', $count), ...$ids); $stmt->execute(); $result = $stmt->get_result(); } else { $result = $mysqli->query("$sql $orderBy"); // a prepared statement is unnecessary } foreach ($result as $row) { echo "{$row['name']}\n"; }