id/database.php
2024-03-02 12:41:57 +00:00

27 lines
471 B
PHP

<?php
// Functions for interacting with the database. Requires PDO is initialised at $pdo.
function db_execute($sql, $variables=[]) {
global $pdo;
$stmt = $pdo->prepare($sql);
$stmt->execute($variables);
return $stmt->fetch();
}
function db_execute_all($sql, $variables=[]) {
global $pdo;
$stmt = $pdo->prepare($sql);
$stmt->execute($variables);
return $stmt->fetchAll();
}
function db_query($sql) {
global $pdo;
return $pdo->query($sql);
}