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
|
--TEST--
Bug #34810 (mysqli::init() and others use wrong $this pointer without checks)
--SKIPIF--
<?php
require_once('skipif.inc');
require_once('skipifconnectfailure.inc');
?>
--FILE--
<?php
class DbConnection {
public function connect() {
require_once("connect.inc");
/* Pass false as $connect_flags cannot be accessed via globals. */
$link = my_mysqli_connect($host, $user, $passwd, $db, $port, $socket, false);
var_dump($link);
$link = mysqli_init();
var_dump($link);
$mysql = new my_mysqli($host, $user, $passwd, $db, $port, $socket, false);
$mysql->query("DROP TABLE IF EXISTS test_warnings");
$mysql->query("CREATE TABLE test_warnings (a int not null)");
$mysql->query("SET sql_mode=''");
$mysql->query("INSERT INTO test_warnings VALUES (1),(2),(NULL)");
$warning = $mysql->get_warnings();
if (!$warning)
printf("[001] No warning!\n");
if ($warning->errno == 1048 || $warning->errno == 1253) {
/* 1048 - Column 'a' cannot be null, 1263 - Data truncated; NULL supplied to NOT NULL column 'a' at row */
if ("HY000" != $warning->sqlstate)
printf("[003] Wrong sql state code: %s\n", $warning->sqlstate);
if ("" == $warning->message)
printf("[004] Message string must not be empty\n");
} else {
printf("[002] Empty error message!\n");
var_dump($warning);
}
}
}
$db = new DbConnection();
$db->connect();
echo "Done\n";
?>
--CLEAN--
<?php
require_once("connect.inc");
if (!$link = my_mysqli_connect($host, $user, $passwd, $db, $port, $socket))
printf("[c001] [%d] %s\n", mysqli_connect_errno(), mysqli_connect_error());
if (!mysqli_query($link, "DROP TABLE IF EXISTS test_warnings"))
printf("[c002] Cannot drop table, [%d] %s\n", mysqli_errno($link), mysqli_error($link));
mysqli_close($link);
?>
--EXPECTF--
object(mysqli)#%d (%d) {
["affected_rows"]=>
int(0)
["client_info"]=>
string(%d) "%s"
["client_version"]=>
int(%d)
["connect_errno"]=>
int(0)
["connect_error"]=>
NULL
["errno"]=>
int(0)
["error"]=>
string(0) ""
["error_list"]=>
array(0) {
}
["field_count"]=>
int(0)
["host_info"]=>
string(%d) "%s"
["info"]=>
NULL
["insert_id"]=>
int(0)
["server_info"]=>
string(%d) "%s"
["server_version"]=>
int(%d)
["sqlstate"]=>
string(5) "00000"
["protocol_version"]=>
int(10)
["thread_id"]=>
int(%d)
["warning_count"]=>
int(0)
}
object(mysqli)#%d (%d) {
["client_info"]=>
string(%d) "%s"
["client_version"]=>
int(%d)
["connect_errno"]=>
int(0)
["connect_error"]=>
NULL
["errno"]=>
int(0)
["error"]=>
string(0) ""
}
Done
|
