blob: 6dca348d1faa07e9d2b971fbe473e9195e24591a (
plain) (
blame)
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
|
<?php
/*
* @package AJAX_Chat
* @author Sebastian Tschan
* @copyright (c) Sebastian Tschan
* @license Modified MIT License
* @link https://blueimp.net/ajax/
*/
// Class to initialize the MySQL DataBase connection:
class AJAXChatDataBaseMySQL {
var $_connectionID;
var $_errno = 0;
var $_error = '';
var $_dbName;
function __construct(&$dbConnectionConfig) {
$this->_connectionID = $dbConnectionConfig['link'];
$this->_dbName = $dbConnectionConfig['name'];
}
// Method to connect to the DataBase server:
function connect(&$dbConnectionConfig) {
$this->_connectionID = @mysql_connect(
$dbConnectionConfig['host'],
$dbConnectionConfig['user'],
$dbConnectionConfig['pass'],
true
);
if(!$this->_connectionID) {
$this->_errno = null;
$this->_error = 'Database connection failed.';
return false;
}
return true;
}
// Method to select the DataBase:
function select($dbName) {
if(!@mysql_select_db($dbName, $this->_connectionID)) {
$this->_errno = mysql_errno($this->_connectionID);
$this->_error = mysql_error($this->_connectionID);
return false;
}
$this->_dbName = $dbName;
return true;
}
// Method to determine if an error has occured:
function error() {
return (bool)$this->_error;
}
// Method to return the error report:
function getError() {
if($this->error()) {
$str = 'Error-Report: ' .$this->_error."\n";
$str .= 'Error-Code: '.$this->_errno."\n";
} else {
$str = 'No errors.'."\n";
}
return $str;
}
// Method to return the connection identifier:
function &getConnectionID() {
return $this->_connectionID;
}
// Method to prevent SQL injections:
function makeSafe($value) {
return "'".mysql_real_escape_string($value, $this->_connectionID)."'";
}
// Method to perform SQL queries:
function sqlQuery($sql) {
return new AJAXChatMySQLQuery($sql, $this->_connectionID);
}
// Method to retrieve the current DataBase name:
function getName() {
return $this->_dbName;
}
// Method to retrieve the last inserted ID:
function getLastInsertedID() {
return mysql_insert_id($this->_connectionID);
}
}
?>
|
