PHPize Online / SQLize Online  /  SQLtest Online

<?php // $mysqli is already declared as a working database connection by this sandbox $table1Ids = [1, 3, 5, 3]; $table2Ids = [2, 6, 2]; $uniqueIds1 = array_unique($table1Ids); $uniqueIds2 = array_unique($table2Ids); $count1 = count($uniqueIds1); $count2 = count($uniqueIds2); $placeholders1 = implode(',', array_fill(0, $count1, '?')); $placeholders2 = implode(',', array_fill(0, $count2, '?')); $stmt = $mysqli->prepare("SELECT * FROM `pivot` $sql WHERE table_1_id NOT IN ($placeholders1) AND table_2_id NOT IN ($placeholders2)"); $stmt->bind_param(str_repeat('i', $count1 + $count2), ...$uniqueIds1, ...$uniqueIds2); $stmt->execute(); $result = $stmt->get_result(); echo json_encode($result->fetch_all(), JSON_PRETTY_PRINT);