database.inc
2 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
<?php
class DBUtil {
public $dbhost = '';
public $dbname = '';
public $dbuname = '';
public $dbpassword = '';
public $dbconnection = '';
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
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
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 {
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 {
return false;
}
}
/**
* Close the connection with the database server.
*
* @param none.
* @access public
* @return void.
*/
public function close() {
mysql_close();
}
}
?>