/
database.class.php
71 lines (64 loc) · 1.72 KB
/
database.class.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
<?php
// call database class
class Query {
// Variablen
var $_sql = "";
var $_result = 0;
var $_errno = 0;
var $_error = "";
//Konstruktor
function Query($sql)
{
// Query in der Klasse speichern
$this->_sql = trim($sql);
$this->_result = mysql_query($this->_sql);
if(!$this->_result) {
$this->_errno = mysql_errno();
$this->_error = mysql_error();
}
}
//Methoden
function error()
{
// Result-ID in einer tmp-Variablen speichern
$tmp = $this->_result;
// Variable in boolean umwandeln
$tmp = (bool)$tmp;
// Variable invertieren
$tmp = !$tmp;
// und zurückgeben
return $tmp;
}
function getError() {
if($this->error()) {
$str = "request:\n".$this->_sql."\n";
$str .= "response:\n".$this->_error."\n";
$str .= "Errorcode: ".$this->_errno;
}
else $str = "No error.";
return $str;
}
function getErrno() {
return $this->_errno;
}
function fetch() {
if($this->error()) {
echo "An Error has occurred, please check your MySQL-Query.";
$return = null;
}
else $return = mysql_fetch_assoc($this->_result);
return $return;
}
function numRows() {
if($this->error()) {
$return = -1;
}
else $return = mysql_num_rows($this->_result);
return $return;
}
function free() {
// Speicher freimachen
mysql_free_result($this->_result);
}
}
?>