/
database.php
46 lines (39 loc) · 1.02 KB
/
database.php
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
<?php
require_once 'db_cred.php';
function db_queryAll($sql, $conn, $word_list = []) {
try {
// run query and store the results
$cmd = $conn->prepare($sql);
$cmd -> execute($word_list);
$games = $cmd->fetchAll();
return $games;
} catch (Exception $e) {
// mail('code.rom7.6@gmail.com', 'PDO Error', $e);
// header("Location: error.php");
echo $e;
exit;
}
}
function db_queryOne($sql, $conn) {
try {
// run query and store the results
$cmd = $conn->prepare($sql);
$cmd -> execute();
$games = $cmd->fetch();
return $games;
} catch (Exception $e) {
header("Location: error.php");
}
}
function db_connect() {
$conn = new PDO('mysql:host=' . DB_SERVER . ';dbname=' . DB_USER, DB_NAME, DB_PASS);
$conn -> setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
return $conn;
}
function db_disconnect($conn) {
if (isset($conn)) {
// disconnect
$conn = null;
}
}
?>