/
__database.php
executable file
·62 lines (47 loc) · 1.98 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
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
<?
$database['host'] = 'ec2-184-73-194-196.compute-1.amazonaws.com';
$database['port'] = '5432';
$database['dbname'] = 'd9cg95qfnscd29';
$database['user'] = 'prqorunfzkghvr';
$database['pw'] = 'jc2hyAmXE23mp9iS2wGn7CD6zU';
$db = pg_connect("host=".$database['host']." port=".$database['port']." dbname=".$database['dbname']." user=".$database['user']." password=".$database['pw']." sslmode=require options='--client_encoding=UTF8'") or die("Didn't work" . pg_last_error());
function getSelectedItems($search, $start = 0) {
$start = intval($start);
$items = runQuery('SELECT * FROM "items" WHERE description ~* '.pg_escape_literal('([^\w\d]+|^)'.preg_quote($search).'([^\w\d]+|$)').' ORDER BY startdate ASC OFFSET '.$start);
return $items;
}
function getSpecificItem($id) {
$item = runQuery('SELECT * FROM "items" WHERE id = '.intval($id));
return $item;
}
function getAllItems($start = 0) {
$start = intval($start);
$items = runQuery('SELECT * FROM "items" ORDER BY startdate DESC OFFSET '.$start.' LIMIT 20');
return $items;
}
function addItemToDB($name, $description, $price, $picture = "", $seller = "", $status = 'For sale') {
$name = pg_escape_literal($name);
$description = pg_escape_literal($description);
$picture = pg_escape_literal($picture);
$seller = pg_escape_literal($seller);
$status = pg_escape_literal($status);
$price = floatval($price);
$query = 'INSERT INTO "items" (name,description,picture,seller,status,price) VALUES ('."$name,$description,$picture,$seller,$status,$price) RETURNING id;";
$id = runQuery($query);
runQuery('UPDATE "items" SET postlink = \'/item.php?id='.$id[0]['id'].'\' WHERE id = '.$id[0]['id']);
return $id;
}
function runQuery($query) {
global $db;
$result = pg_query($db, $query);
if (!$result) {
echo "An error occurred.\n";
exit;
}
$array = array();
while ($row = pg_fetch_array($result, null, PGSQL_ASSOC)) {
$array[] = $row;
}
return $array;
}
?>