PHPize Online / SQLize Online  /  SQLtest Online

A A A
Share      Blog   Popular
Copy Format Clear
CREATE TABLE somewhere ( id INT AUTO_INCREMENT, name VARCHAR(100), PRIMARY KEY (id) ); INSERT INTO somewhere(id, name) VALUES (1, 'Chad'), (4, 'Ned'), (5, 'Dave'), (14, 'Newt'), (18, 'Bill'), (21, 'Norton'), (25, 'Alan'), (34, 'Jan'), (56, 'Hercules');
Copy Clear
Copy Format Clear
<?php // $mysqli is already declared as a working database connection by this sandbox $ids = [1, 5, 14, 18, 21, 25, 34, 56]; $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 "<div>{$row['name']}</div>\n"; }
Show:  
Copy Clear