PHPize Online / SQLize Online  /  SQLtest Online

<?php // let's prepare some data $mysqli->query( "create table sources (id int, user_id int, url char(10), dr int, status int)" ); $mysqli->query("insert into sources values (1, 1, 'url1', 1, 1)"); $mysqli->query("insert into sources values (2, 2, 'url2', 1, 2)"); $mysqli->query("insert into sources values (3, 2, 'url2', 1, 2)"); // here you go echo json_encode(get_records($mysqli)), "\n"; echo json_encode(get_records($mysqli, [1])), "\n"; echo json_encode(get_records($mysqli, [1, 2], 2)), "\n"; function get_records($db, $status = [1, 2, 3, 4], $user_id = false) { $params = $status; $in = str_repeat("?,", count($status) - 1) . "?"; $query = "SELECT id, user_id, url, dr FROM sources WHERE status IN ($in)"; if ($user_id) { $query .= " AND user_id = ?"; $params[] = $user_id; } $stmt = prepared_query($db, $query, $params); return $stmt->get_result()->fetch_all(MYSQLI_ASSOC); } function prepared_query($mysqli, $sql, $params, $types = "") { $types = $types ?: str_repeat("s", count($params)); $stmt = $mysqli->prepare($sql); $stmt->bind_param($types, ...$params); $stmt->execute(); return $stmt; }