File: mysqli_debug_control_string.phpt

package info (click to toggle)
php8.4 8.4.11-1
  • links: PTS, VCS
  • area: main
  • in suites: forky, sid, trixie
  • size: 208,108 kB
  • sloc: ansic: 1,060,628; php: 35,345; sh: 11,866; cpp: 7,201; pascal: 4,913; javascript: 3,091; asm: 2,810; yacc: 2,411; makefile: 689; xml: 446; python: 301; awk: 148
file content (130 lines) | stat: -rw-r--r-- 4,564 bytes parent folder | download
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
--TEST--
mysqli_debug() - invalid debug control strings
--EXTENSIONS--
mysqli
--SKIPIF--
<?php
require_once 'skipifconnectfailure.inc';

if (!function_exists('mysqli_debug'))
    die("skip: mysqli_debug() not available");

if (!defined('MYSQLI_DEBUG_TRACE_ENABLED'))
    die("skip: can't say for sure if mysqli_debug works");

if (defined('MYSQLI_DEBUG_TRACE_ENABLED') && !MYSQLI_DEBUG_TRACE_ENABLED)
    die("skip: debug functionality not enabled");
?>
--FILE--
<?php
    require_once 'connect.inc';
    require_once 'table.inc';

    function try_control_string($link, $control_string, $trace_file, $offset) {

        if (true !== ($tmp = mysqli_debug($control_string))) {
            printf("[%03d][control string '%s'] Expecting boolean/true, got %s/%s.\n",
                $offset + 1,
                $control_string,
                gettype($tmp),
                $tmp);
            return false;
        }

        if (false === mysqli_query($link, 'SELECT * FROM test')) {
            printf("[%03d][control string '%s'] [%d] %s.\n",
                $offset + 2,
                $control_string,
                mysqli_errno($link),
                mysqli_error($link));
            return false;
        }

        clearstatcache();
        if (!file_exists($trace_file)) {
            printf("[%03d][control string '%s'] Trace file has not been written.\n",
                $offset + 3,
                $control_string,
                gettype($tmp),
                $tmp);
            return false;
        }

        unlink($trace_file);
    }

    $trace_file = sprintf('%s%s%s', sys_get_temp_dir(), DIRECTORY_SEPARATOR, 'mysqli_debug_phpt.trace');
    try_control_string($link, 't:,,:o,' . $trace_file, $trace_file, 10);
    try_control_string($link, ':' . chr(0) . 'A,' . $trace_file, $trace_file, 20);
    try_control_string($link, 't:o,' . $trace_file . ':abc', $trace_file, 30);
    try_control_string($link, 't:o,' . $trace_file . ':ABC,123:b', $trace_file, 40);
    try_control_string($link, 't:ABC,123:b;:o,' . $trace_file, $trace_file, 50);
    try_control_string($link, 't:A;BC,123:b;:o,' . $trace_file, $trace_file, 60);
    try_control_string($link, 't:p:o,' . $trace_file, $trace_file, 70);
    try_control_string($link, 't:p,1,,2:o,' . $trace_file, $trace_file, 80);
    try_control_string($link, 't:z,1,,2:o,' . $trace_file, $trace_file, 90);#

    mysqli_close($link);
    print "done";
    print "libmysql/DBUG package prints some debug info here."
?>
--EXPECTF--
Warning: mysqli_debug(): Unrecognized format ',' in %s on line %d

Warning: mysqli_debug(): Consecutive semicolons at position 0 in %s on line %d
[023][control string '%s'] Trace file has not been written.

Warning: mysqli_debug(): Colon expected, 'b' found in %s on line %d

Warning: mysqli_debug(): Colon expected, 'c' found in %s on line %d

Warning: mysqli_debug(): Colon expected, 'B' found in %s on line %d

Warning: mysqli_debug(): Colon expected, 'C' found in %s on line %d

Warning: mysqli_debug(): Colon expected, ',' found in %s on line %d

Warning: mysqli_debug(): Colon expected, '1' found in %s on line %d

Warning: mysqli_debug(): Colon expected, '2' found in %s on line %d

Warning: mysqli_debug(): Colon expected, '3' found in %s on line %d

Warning: mysqli_debug(): Unrecognized format 'b' in %s on line %d

Warning: mysqli_debug(): Colon expected, 'B' found in %s on line %d

Warning: mysqli_debug(): Colon expected, 'C' found in %s on line %d

Warning: mysqli_debug(): Colon expected, ',' found in %s on line %d

Warning: mysqli_debug(): Colon expected, '1' found in %s on line %d

Warning: mysqli_debug(): Colon expected, '2' found in %s on line %d

Warning: mysqli_debug(): Colon expected, '3' found in %s on line %d

Warning: mysqli_debug(): Unrecognized format 'b' in %s on line %d

Warning: mysqli_debug(): Colon expected, ';' found in %s on line %d

Warning: mysqli_debug(): Colon expected, ';' found in %s on line %d

Warning: mysqli_debug(): Colon expected, 'B' found in %s on line %d

Warning: mysqli_debug(): Colon expected, 'C' found in %s on line %d

Warning: mysqli_debug(): Colon expected, ',' found in %s on line %d

Warning: mysqli_debug(): Colon expected, '1' found in %s on line %d

Warning: mysqli_debug(): Colon expected, '2' found in %s on line %d

Warning: mysqli_debug(): Colon expected, '3' found in %s on line %d

Warning: mysqli_debug(): Unrecognized format 'b' in %s on line %d

Warning: mysqli_debug(): Colon expected, ';' found in %s on line %d

Warning: mysqli_debug(): Unrecognized format 'z' in %s on line %d
done%s