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); $bindString = str_repeat('s', count($ids)); $sql = 'SELECT name FROM somewhere WHERE id IN ($placeholders)'; $stmt=mysqli_stmt_init($conn); mysqli_stmt_prepare($stmt, $sql); mysqli_stmt_bind_param($stmt, $bindString, ...$placeholders); mysqli_stmt_execute($stmt); $empRecords=mysqli_stmt_get_result($stmt); $result=mysqli_num_rows($empRecords); if ($result > 0) { while ($row = mysqli_fetch_assoc($empRecords)) { $number=$row['a_number']; } echo $number; } else { }