-
Notifications
You must be signed in to change notification settings - Fork 0
/
ImageClass.php
91 lines (72 loc) · 2.35 KB
/
ImageClass.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
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
<?php
require_once './db.php';
class Image {
var $img_id;
var $img_ref;
var $caption;
function __construct($img_ref, $caption) {
$this->img_id = $img_id;
$this->img_ref = $img_ref;
$this->caption = $caption;
}
public static function insertImage($caption, $img_ref) {
$connection = DB::connection();
$statement = $connection->prepare(
'INSERT INTO images (caption,reference) VALUES (?,?)'
);
if (!$statement) {
header("HTTP/1.0 500 Internal Server Error");
}
if (!$statement->bind_param('ss', $caption, $img_ref)) {
header("HTTP/1.0 500 Internal Server Error");
}
if (!$statement->execute()) {
header("HTTP/1.0 500 Internal Server Error");
}
}
public static function getImageID($img_ref) {
$connection = DB::connection();
$statement = $connection->prepare(
'SELECT img_id FROM images WHERE reference = ?'
);
if (!$statement) {
header("HTTP/1.0 500 Internal Server Error");
}
if (!$statement->bind_param('s', $img_ref)) {
header("HTTP/1.0 500 Internal Server Error");
}
if (!$statement->execute()) {
header("HTTP/1.0 500 Internal Server Error");
}
if (!$statement->bind_result($img_id)) {
header("HTTP/1.0 500 Internal Server Error");
}
if (!$statement->fetch()) {
header("HTTP/1.0 500 Internal Server Error");
}
return $img_id;
}
public static function findImageByID($img_id) {
$connection = DB::connection();
$statement = $connection->prepare(
'SELECT reference FROM images WHERE img_id = ?'
);
if (!$statement) {
header("HTTP/1.0 500 Internal Server Error");
}
if (!$statement->bind_param('i', $img_id)) {
header("HTTP/1.0 500 Internal Server Error");
}
if (!$statement->execute()) {
header("HTTP/1.0 500 Internal Server Error");
}
if (!$statement->bind_result($img_ref)) {
header("HTTP/1.0 500 Internal Server Error");
}
if (!$statement->fetch()) {
header("HTTP/1.0 500 Internal Server Error");
}
return $img_ref;
}
}
?>