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
|
<?php
if (!function_exists("mysql_connect")){
/* warning: fatal error "cannot redeclare" if a function was disabled in php.ini with disable_functions:
disable_functions =mysql_connect,mysql_pconnect,mysql_select_db,mysql_ping,mysql_query,mysql_fetch_assoc,mysql_num_rows,mysql_fetch_array,mysql_error,mysql_insert_id,mysql_close,mysql_real_escape_string,mysql_data_seek,mysql_result
*/
define("MYSQL_ASSOC", MYSQLI_ASSOC);
define("MYSQL_NUM", MYSQLI_NUM);
define("MYSQL_BOTH", MYSQLI_BOTH);
function mysql_fetch_array($result, $result_type = MYSQL_BOTH){
$row = mysqli_fetch_array($result, $result_type);
return is_null($row) ? false : $row;
}
function mysql_fetch_assoc($result){
$row = mysqli_fetch_assoc($result);
return is_null($row) ? false : $row;
}
function mysql_fetch_row($result) {
$row = mysqli_fetch_row($result);
return is_null($row) ? false : $row;
}
function mysql_fetch_object($result) {
$row = mysqli_fetch_object($result);
return is_null($row) ? false : $row;
}
function mysql_connect($host, $username, $password, $new_link = FALSE, $client_flags = 0){
global $global_link_identifier;
$global_link_identifier = mysqli_connect($host, $username, $password);
return $global_link_identifier;
}
function mysql_pconnect($host, $username, $password, $client_flags = 0){
global $global_link_identifier;
$global_link_identifier = mysqli_connect("p:".$host, $username, $password);
return $global_link_identifier;
}
function mysql_select_db($dbname, $link_identifier = null){
global $global_link_identifier;
if($link_identifier == null) {
$link_identifier = $global_link_identifier;
}
return mysqli_select_db($link_identifier, $dbname);
}
function mysql_ping($link_identifier = null){
global $global_link_identifier;
if($link_identifier == null) {
$link_identifier = $global_link_identifier;
}
return mysqli_ping($link_identifier);
}
function mysql_query($stmt, $link_identifier = null){
global $global_link_identifier;
if($link_identifier == null) {
$link_identifier = $global_link_identifier;
}
return mysqli_query($link_identifier, $stmt);
}
function mysql_num_rows($result){
return mysqli_num_rows($result);
}
function mysql_affected_rows($link_identifier = NULL){
// TODO: check, if working when called without argument: mysql_affected_rows()
global $global_link_identifier;
if($link_identifier == null) {
$link_identifier = $global_link_identifier;
}
return mysqli_affected_rows($link_identifier);
}
function mysql_list_tables($dbname, $link_identifier = null){
global $global_link_identifier;
if($link_identifier == null) {
$link_identifier = $global_link_identifier;
}
$sql = "SHOW TABLES FROM $dbname";
$result = mysql_query($sql, $link_identifier);
return $result;
}
function mysql_error($link_identifier = null){
global $global_link_identifier;
if($link_identifier == null) {
$link_identifier = $global_link_identifier;
}
return mysqli_error($link_identifier);
}
function mysql_errno($link_identifier = null){
global $global_link_identifier;
if($link_identifier == null) {
$link_identifier = $global_link_identifier;
}
return mysqli_errno($link_identifier);
}
function mysql_insert_id($link_identifier = NULL){
global $global_link_identifier;
if($link_identifier == null) {
$link_identifier = $global_link_identifier;
}
return mysqli_insert_id($link_identifier);
}
function mysql_close($link_identifier = NULL){
return true;
}
function mysql_real_escape_string($unescaped_string, $link_identifier = null){
global $global_link_identifier;
if($link_identifier == null) {
$link_identifier = $global_link_identifier;
}
return mysqli_real_escape_string($link_identifier, $unescaped_string);
}
function mysql_data_seek($result, $row_number){
return mysqli_data_seek($result, $row_number);
}
function mysql_result($result, $row=0, $col=0){
$numrows = mysqli_num_rows($result);
if($numrows && $row <= ($numrows-1) && $row >= 0){
mysqli_data_seek($result, $row);
$resultrow = (is_numeric($col)) ? mysqli_fetch_row($result) : mysqli_fetch_assoc($result);
if (isset($resultrow[$col])){
return $resultrow[$col];
}
}
return false;
}
function mysql_escape_string($s, $link_identifier = null){
global $global_link_identifier;
if($link_identifier == null) {
$link_identifier = $global_link_identifier;
}
return mysqli_real_escape_string($link_identifier, $s);
}
function mysql_field_name($result, $i) {
return mysqli_fetch_field_direct($result, $i);
}
function mysql_free_result($result) {
return mysqli_free_result($result);
}
function mysql_get_server_info($link_identifier = null){
global $global_link_identifier;
if($link_identifier == null) {
$link_identifier = $global_link_identifier;
}
return mysqli_get_server_info($link_identifier);
}
function mysql_set_charset($csname, $link_identifier = null){
global $global_link_identifier;
if($link_identifier == null) {
$link_identifier = $global_link_identifier;
}
return mysqli_set_charset($link_identifier, $csname);
}
}
|