PHPize Online / SQLize Online  /  SQLtest Online

A A A
Share      Blog   Popular
Copy Format Clear
Copy Clear
Copy Format Clear
<?php var_dump(select_query_single($mysqli, "SELECT 'hello'")); var_dump(select_query_all($mysqli, "SELECT 'hello'")); var_dump(select_query_single($mysqli, "SELECT ? as hello", ['hello'])); // но на самом деле эти функции не так уж и нужны, потому что var_dump(select_query($mysqli, "SELECT 'hello'")->fetch_assoc()); var_dump(select_query($mysqli, "SELECT 'hello'")->fetch_all(MYSQLI_ASSOC)); function prepared_query(mysqli $db, string $sql, array $params, string $types = ""): mysqli_stmt { $types = $types ?: str_repeat("s", count($params)); $stmt = $db->prepare($sql); $stmt->bind_param($types, ...$params); $stmt->execute(); return $stmt; } function select_query(mysqli $db, string $sql, array $params = [], string $types = ""): mysqli_result { if (!$params) { return $db->query($sql); } return prepared_query($db, $sql, $params, $types)->get_result(); } function select_query_single(mysqli $db, string $sql, array $params = [], string $types = ""): array { return select_query($db, $sql, $params, $types)->fetch_assoc(); } function select_query_all(mysqli $db, string $sql, array $params = [], string $types = ""): array { return select_query($db, $sql, $params, $types)->fetch_all(MYSQLI_ASSOC); }
Show:  
Copy Clear