PHPize Online / SQLize Online  /  SQLtest Online

A A A
Share      Blog   Popular
Copy Format Clear
CREATE TABLE my_table ( id INT AUTO_INCREMENT, city VARCHAR(50), name VARCHAR(100), PRIMARY KEY (id) ); INSERT INTO my_table(city, name) VALUES ('Albuquerque','Al'), ('Knoxville','Ned'), ('Nashville','Natalie'), ('New Orleans','Newt'), ('Nashville','Nathan'), ('Knoxville','Norton'), ('Biloxi','Bill');
Copy Clear
Copy Format Clear
<?php // $mysqli is already declared as a working database connection by this sandbox $cities = ['Nashville', 'Knoxville']; $count = count($cities); $sql = "SELECT name FROM my_table"; if ($count) { $stmt = $mysqli->prepare("$sql WHERE city IN (" . implode(',', array_fill(0, $count, '?')) . ")"); $stmt->bind_param(str_repeat('s', $count), ...$cities); $stmt->execute(); $result = $stmt->get_result(); } else { $result = $mysqli->query($sql); // a prepared statement is unnecessary due to no incoming parameters } foreach ($result as $row) { echo "<div>{$row['name']}</div>\n"; }
Show:  
Copy Clear