PHPize Online / SQLize Online  /  SQLtest Online

A A A
Share      Blog   Popular
Copy Format Clear
CREATE TABLE lm_items ( name varchar(64), size varchar(4) ); INSERT INTO lm_items VALUES ('XtraSmall', 'XS'),('Small', 'S'),('Medium', 'M') ;
Copy Clear
Copy Format Clear
<?php $db = &$mysqli; $searchArray = array("XS", "S"); $placeHolders = array_fill(0, count($searchArray), '?'); $stmt = $db->prepare("SELECT * FROM `lm_items` WHERE `size` IN (" . implode(',', $placeHolders) . ")"); $types = str_repeat('s', count($searchArray)); //types $stmt->bind_param($types, ...$searchArray); // bind array at once $result = $stmt->execute(); $load_result = $result->fetchAll(); print_r($load_result);
Show:  
Copy Clear