database.inc
3.22 KB
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
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
<?php
class DBUtil {
public $dbhost = '';
public $dbname = '';
public $dbuname = '';
public $dbpassword = '';
public $dbconnection = '';
public $error = '';
public function __construct() {
}
/** Connect to a MySQL database
*
* @param string $dhost host
* @param string $duname database username
* @param string $dpassword database password
* @access public
* @return boolean
*/
public function DBUtil($dhost = 'localhost', $duname, $dpassword, $dbname = '') {
$this->dbhost = $dhost;
$this->dbuname = $duname;
$this->dbpassword = $dpassword;
$this->dbconnection = @mysql_connect($dhost, $duname, $dpassword);
if($dbname != '') {
$this->setDb($dbname);
$this->useBD($dbname);
}
if($this->dbconnection)
return $this->dbconnection;
else {
$this->error = @mysql_error();
return false;
}
}
/**
* Choose a database to use
*
* @param string $dbname name of the database
* @access public
* @return boolean
*/
public function useBD($dbname) {
if($dbname != '') {
$this->setDb($dbname);
}
if(@mysql_select_db($this->dbname))
return true;
else {
$this->error = @mysql_error();
return false;
}
}
public function setDb($dbname) {
$this->dbname = $dbname;
}
/**
* Query the database.
*
* @param $query the sql query.
* @access public
* @return The result of the query.
*/
public function query($query)
{
$result = @mysql_query($query);
if($result) {
return $result;
} else {
$this->error = @mysql_error();
return false;
}
}
/**
* Do the same as query.
*
* @param $query the sql query.
* @access public
* @return boolean
*/
public function execute($query) {
$result = @mysql_query($query);
if($result) {
return true;
} else {
$this->error = @mysql_error();
return false;
}
}
/** Convenience method for mysql_fetch_object().
* @param $result The resource returned by query().
* @access public
* @return An object representing a data row.
*/
public function fetchNextObject($result = NULL) {
if ($result == NULL || mysql_num_rows($result) < 1)
return NULL;
else
return mysql_fetch_object($result);
}
/** Convenience method for mysql_fetch_assoc().
* @param $result The resource returned by query().
* @access public
* @return array Returns an associative array of strings.
*/
public function fetchAssoc($result = NULL) {
$r = array();
if ($result == NULL || mysql_num_rows($result) < 1)
return NULL;
else {
while ($row = mysql_fetch_assoc($result)) {
$r[] = $row;
}
return $r;
}
}
/**
* Close the connection with the database server.
*
* @param none.
* @access public
* @return void.
*/
public function close() {
@mysql_close();
}
/**
* Get database errors.
*
* @param none.
* @access public
* @return string.
*/
public function getErrors() {
return $this->error;
}
}
?>