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 = ["XS", "S"]; $placeHolders = implode(",", array_fill(0, count($searchArray), "?")); // '?,?' $sql_types = str_repeat("s", count($searchArray)); //types 'ss' $query = "SELECT * FROM `lm_items` WHERE `size` IN (" . $placeHolders . ")"; $stmt = $db->prepare($query); $stmt->bind_param($sql_types, ...$searchArray); // bind array at once $stmt->execute(); $result = $stmt->get_result(); $load_result = $result->fetch_all(); print_r($load_result);
Show:  
Copy Clear