Psalm
Get started
Documentation
Paid support
Plugins
Blog
GitHub
<?php /** * @return list<array{id: int, name: string}> */ function getUsers(mysqli $db, string $role): array { return query($db, "SELECT id, name FROM users WHERE role = ?", [$role]); } /** * @param list $params * @return list<array<array-key, float|int|null|string>> */ function query(mysqli $db, string $sql, array $params = []): array { $stmt = $db->prepare($sql); $stmt->execute($params); return $stmt->get_result()->fetch_all(MYSQLI_ASSOC); }
Snippet created on April 21 2022 at 15:54 UTC
Settings
Get link