17         printf("[001] Expecting NULL, got %s/%s\n", gettype($tmp), $tmp);
20         printf("[002] Expecting NULL, got %s/%s\n", gettype($tmp), $tmp);
26         printf("[002a] [%d] %s\n", mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt));
29         printf("[002b] Expecting NULL, got %s/%s\n", gettype($tmp), $tmp);
39         printf("[003] Expecting false, got %s/%s\n", gettype($tmp), $tmp);
42         printf("[004] [%d] %s\n", mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt));
45         printf("[005] Expecting boolean/false, got %s/%s\n", gettype($tmp), $tmp);
48         printf("[006] Expecting boolean/true, got %s/%s\n", gettype($tmp), $tmp);
51         printf("[007] Expecting boolean/false, got %s/%s\n", gettype($tmp), $tmp);
54         printf("[008] [%d] %s\n", mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt));
66             printf("[%04d] [%d] %s\n", $offset, mysqli_errno($link), mysqli_error($link));
70 …ysqli_query($link, sprintf("CREATE TABLE test(id INT, label %s, PRIMARY KEY(id)) ENGINE = %s", $sq…
76             printf("[%04d] [%d] %s\n", $offset + 1, mysqli_errno($link), mysqli_error($link));
81 …       printf("[%04d] [%d] %s\n", $offset + 2, mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt));
87 …       printf("[%04d] [%d] %s\n", $offset + 3, mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt));
94 … printf("[%04d] [%d] %s\n", $offset + 3 + $id, mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt));
104 …       printf("[%04d] [%d] %s\n", $offset + 7, mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt));
110 …       printf("[%04d] [%d] %s\n", $offset + 8, mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt));
119 …       printf("[%04d] [%d] %s\n", $offset + 9, mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt));
129                     printf("[%04d] [%d] Expecting %s/'%s' [type hint = %s], got %s/'%s'\n",
141             printf("[%04d] [%d] %s, expecting 3 results, got only %d results\n",
201 …func_mysqli_stmt_bind_result($link, $engine, "s", "BIGINT UNSIGNED", "18446744073709551615", 1860);
202     func_mysqli_stmt_bind_result($link, $engine, "s", "BIGINT", "-9223372036854775808", 1880);
224     func_mysqli_stmt_bind_result($link, $engine, "s", "DATE", @date('Y-m-d'), 840);
225     func_mysqli_stmt_bind_result($link, $engine, "s", "DATE NOT NULL", @date('Y-m-d'), 860);
226     func_mysqli_stmt_bind_result($link, $engine, "s", "DATE", NULL, 880);
228     func_mysqli_stmt_bind_result($link, $engine, "s", "DATETIME", @date('Y-m-d H:i:s'), 900);
229 … func_mysqli_stmt_bind_result($link, $engine, "s", "DATETIME NOT NULL", @date('Y-m-d H:i:s'), 920);
230     func_mysqli_stmt_bind_result($link, $engine, "s", "DATETIME", NULL, 940);
232     func_mysqli_stmt_bind_result($link, $engine, "s", "TIMESTAMP", @date('Y-m-d H:i:s'), 960);
234     func_mysqli_stmt_bind_result($link, $engine, "s", "TIME", @date('H:i:s'), 980);
235     func_mysqli_stmt_bind_result($link, $engine, "s", "TIME NOT NULL", @date('H:i:s'), 1000);
236     func_mysqli_stmt_bind_result($link, $engine, "s", "TIME", NULL, 1020);
239     func_mysqli_stmt_bind_result($link, $engine, "s", "YEAR", $tmp, 1040, "integer");
240     func_mysqli_stmt_bind_result($link, $engine, "s", "YEAR NOT NULL", $tmp, 1060, "integer");
241     func_mysqli_stmt_bind_result($link, $engine, "s", "YEAR", NULL, 1080);
244     func_mysqli_stmt_bind_result($link, $engine, "s", "CHAR(1)", "a", 1110, 'string');
245     func_mysqli_stmt_bind_result($link, $engine, "s", "CHAR(255)", $string255, 1120, 'string');
246     func_mysqli_stmt_bind_result($link, $engine, "s", "CHAR(1) NOT NULL", "a", 1140, 'string');
247     func_mysqli_stmt_bind_result($link, $engine, "s", "CHAR(1)", NULL, 1160);
250     func_mysqli_stmt_bind_result($link, $engine, "s", "VARCHAR(1)", "a", 1180, 'string');
251     func_mysqli_stmt_bind_result($link, $engine, "s", "VARCHAR(255)", $string255, 1200, 'string');
252     func_mysqli_stmt_bind_result($link, $engine, "s", "VARCHAR(65635)", $string65k, 1220, 'string');
253     func_mysqli_stmt_bind_result($link, $engine, "s", "VARCHAR(1) NOT NULL", "a", 1240, 'string');
254     func_mysqli_stmt_bind_result($link, $engine, "s", "VARCHAR(1)", NULL, 1260);
256     func_mysqli_stmt_bind_result($link, $engine, "s", "BINARY(1)", "a", 1280);
257     func_mysqli_stmt_bind_result($link, $engine, "s", "BINARY(1)", chr(0), 1300);
258     func_mysqli_stmt_bind_result($link, $engine, "s", "BINARY(1) NOT NULL", "b", 1320);
259     func_mysqli_stmt_bind_result($link, $engine, "s", "BINARY(1)", NULL, 1340);
261     func_mysqli_stmt_bind_result($link, $engine, "s", "VARBINARY(1)", "a", 1360);
262     func_mysqli_stmt_bind_result($link, $engine, "s", "VARBINARY(1)", chr(0), 1380);
263     func_mysqli_stmt_bind_result($link, $engine, "s", "VARBINARY(1) NOT NULL", "b", 1400);
264     func_mysqli_stmt_bind_result($link, $engine, "s", "VARBINARY(1)", NULL, 1420);
266     func_mysqli_stmt_bind_result($link, $engine, "s", "TINYBLOB", "a", 1440);
267     func_mysqli_stmt_bind_result($link, $engine, "s", "TINYBLOB", chr(0), 1460);
268     func_mysqli_stmt_bind_result($link, $engine, "s", "TINYBLOB NOT NULL", "b", 1480);
269     func_mysqli_stmt_bind_result($link, $engine, "s", "TINYBLOB", NULL, 1500);
271     func_mysqli_stmt_bind_result($link, $engine, "s", "TINYTEXT", "a", 1520, 'string');
272     func_mysqli_stmt_bind_result($link, $engine, "s", "TINYTEXT NOT NULL", "a", 1540, 'string');
273     func_mysqli_stmt_bind_result($link, $engine, "s", "TINYTEXT", NULL, 1560, 'string');
290     func_mysqli_stmt_bind_result($link, $engine, "s", "ENUM('a', 'b')", "a", 1700, 'string');
291     func_mysqli_stmt_bind_result($link, $engine, "s", "ENUM('a', 'b')", NULL, 1720, 'string');
292     func_mysqli_stmt_bind_result($link, $engine, "s", "SET('a', 'b')", "a", 1740, 'string');
293     func_mysqli_stmt_bind_result($link, $engine, "s", "SET('a', 'b')", NULL, 1760, 'string');
296 …    func_mysqli_stmt_bind_result($link, $engine, "s", "TIME", "13:31:34.123456", 1770, "13:31:34");
298     /* Check that the function alias exists. It's a deprecated function,
301         printf("[3000] Expecting NULL, got %s/%s\n", gettype($tmp), $tmp);
305         printf("[3001] [%d] %s\n", mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt));
321 Warning: mysqli_stmt_bind_result() expects at least 2 parameters, 1 given in %s on line %d
324  in %s on line %d
326 …t(): Number of bind variables doesn't match number of fields in prepared statement in %s on line %d
328 …t(): Number of bind variables doesn't match number of fields in prepared statement in %s on line %d
330 %s(1) "a"

Last Index update Sat May 04 14:03:19 UTC 2024

Dedicated to & Maintained by Room-11