PHPize Online / SQLize Online  /  SQLtest Online

<?php $mysqli->query("create table table_name (col1 varchar(1), col2 int)"); $mysqli->query("insert into table_name values ('a',1),('b',2),('c',3)"); $data = ['a',1,'b',2]; $bind_param_types = 'sisi'; $kweerie = $mysqli->query("SELECT * FROM table_name"); while ($object = mysqli_fetch_assoc(kweerie)) { echo '<pre>' , print_r($object) , '</pre>'; } exit(); $stmt = $mysqli->prepare("DELETE FROM table_name WHERE (col1, col2) IN ((?, ?),(?, ?))"); $stmt->bind_param($bind_param_types, ...$data); $stmt->execute(); echo $mysqli->affected_rows;