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; }