Annotation of embedaddon/php/ext/mysqli/tests/mysqli_stmt_get_result_types.phpt, revision 1.1.1.1
1.1 misho 1: --TEST--
2: mysqli_stmt_get_result - data types
3: --SKIPIF--
4: <?php
5: require_once('skipif.inc');
6: require_once('skipifemb.inc');
7: require_once('skipifconnectfailure.inc');
8:
9: if (!function_exists('mysqli_stmt_get_result'))
10: die("skip mysqli_stmt_get_result() not available");
11: ?>
12: --FILE--
13: <?php
14: require('connect.inc');
15: if (!$link = my_mysqli_connect($host, $user, $passwd, $db, $port, $socket))
16: printf("[001] [%d] %s\n", mysqli_connect_errno(), mysqli_connect_error());
17:
18: $hint_str_or_unicode = (version_compare(PHP_VERSION, '5.9.9', '>') == 1) ? 'unicode' : 'string';
19:
20: function func_mysqli_stmt_get_result($link, $engine, $bind_type, $sql_type, $bind_value, $offset, $type_hint = null) {
21:
22: if (!mysqli_query($link, "DROP TABLE IF EXISTS test")) {
23: printf("[%04d] [%d] %s\n", $offset, mysqli_errno($link), mysqli_error($link));
24: return false;
25: }
26:
27: if (!mysqli_query($link, sprintf("CREATE TABLE test(id INT, label %s, PRIMARY KEY(id)) ENGINE = %s", $sql_type, $engine))) {
28: // don't bail - column type might not be supported by the server, ignore this
29: return false;
30: }
31:
32: if (!$stmt = mysqli_stmt_init($link)) {
33: printf("[%04d] [%d] %s\n", $offset + 1, mysqli_errno($link), mysqli_error($link));
34: return false;
35: }
36:
37: if (!mysqli_stmt_prepare($stmt, "INSERT INTO test(id, label) VALUES (?, ?)")) {
38: printf("[%04d] [%d] %s\n", $offset + 2, mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt));
39: return false;
40: }
41:
42: $id = null;
43: if (!mysqli_stmt_bind_param($stmt, "i" . $bind_type, $id, $bind_value)) {
44: printf("[%04d] [%d] %s\n", $offset + 3, mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt));
45: mysqli_stmt_close($stmt);
46: return false;
47: }
48:
49: for ($id = 1; $id < 4; $id++) {
50: if (!mysqli_stmt_execute($stmt)) {
51: printf("[%04d] [%d] %s\n", $offset + 3 + $id, mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt));
52: mysqli_stmt_close($stmt);
53: return false;
54: }
55: }
56: mysqli_stmt_close($stmt);
57:
58: $stmt = mysqli_stmt_init($link);
59:
60: if (!mysqli_stmt_prepare($stmt, "SELECT id, label FROM test")) {
61: printf("[%04d] [%d] %s\n", $offset + 7, mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt));
62: mysqli_stmt_close($stmt);
63: return false;
64: }
65:
66: if (!mysqli_stmt_execute($stmt)) {
67: printf("[%04d] [%d] %s\n", $offset + 8, mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt));
68: mysqli_stmt_close($stmt);
69: return false;
70: }
71:
72: $result = mysqli_stmt_result_metadata($stmt);
73:
74: if (!$res = mysqli_stmt_get_result($stmt)) {
75: printf("[%04d] [%d] %s\n", $offset + 9, mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt));
76: mysqli_stmt_close($stmt);
77: return false;
78: }
79: $num = 0;
80: $fields = mysqli_fetch_fields($result);
81:
82: while ($row = mysqli_fetch_assoc($res)) {
83: $bind_res = &$row['label'];
84: if (!gettype($bind_res) == 'unicode') {
85: if ($bind_res !== $bind_value && (!$type_hint || ($type_hint !== gettype($bind_res)))) {
86: printf("[%04d] [%d] Expecting %s/'%s' [type hint = %s], got %s/'%s'\n",
87: $offset + 10, $num,
88: gettype($bind_value), $bind_value, $type_hint,
89: gettype($bind_res), $bind_res);
90: mysqli_free_result($res);
91: mysqli_stmt_close($stmt);
92: return false;
93: }
94: }
95: $num++;
96: }
97:
98: if ($num != 3) {
99: printf("[%04d] [%d] %s, expecting 3 results, got only %d results\n",
100: $offset + 11, mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt), $num);
101: mysqli_free_result($res);
102: mysqli_stmt_close($stmt);
103: return false;
104: }
105:
106: mysqli_free_result($res);
107: mysqli_stmt_close($stmt);
108: return true;
109: }
110:
111:
112: function func_mysqli_stmt_bind_make_string($len) {
113:
114: $ret = '';
115: for ($i = 0; $i < $len; $i++)
116: $ret .= chr(mt_rand(65, 90));
117:
118: return $ret;
119: }
120:
121: func_mysqli_stmt_get_result($link, $engine, "i", "TINYINT", -11, 20);
122: func_mysqli_stmt_get_result($link, $engine, "i", "TINYINT", NULL, 40);
123: func_mysqli_stmt_get_result($link, $engine, "i", "TINYINT UNSIGNED", 1, 60);
124: func_mysqli_stmt_get_result($link, $engine, "i", "TINYINT UNSIGNED", NULL, 80);
125:
126: func_mysqli_stmt_get_result($link, $engine, "i", "BOOL", 1, 100);
127: func_mysqli_stmt_get_result($link, $engine, "i", "BOOL", NULL, 120);
128: func_mysqli_stmt_get_result($link, $engine, "i", "BOOLEAN", 0, 140);
129: func_mysqli_stmt_get_result($link, $engine, "i", "BOOLEAN", NULL, 160);
130:
131: func_mysqli_stmt_get_result($link, $engine, "i", "SMALLINT", -32768, 180);
132: func_mysqli_stmt_get_result($link, $engine, "i", "SMALLINT", 32767, 200);
133: func_mysqli_stmt_get_result($link, $engine, "i", "SMALLINT", NULL, 220);
134: func_mysqli_stmt_get_result($link, $engine, "i", "SMALLINT UNSIGNED", 65535, 240);
135: func_mysqli_stmt_get_result($link, $engine, "i", "SMALLINT UNSIGNED", NULL, 260);
136:
137: func_mysqli_stmt_get_result($link, $engine, "d", "MEDIUMINT", -8388608, 280, "integer");
138: func_mysqli_stmt_get_result($link, $engine, "d", "MEDIUMINT", 8388607, 300, "integer");
139: func_mysqli_stmt_get_result($link, $engine, "d", "MEDIUMINT", NULL, 320);
140: func_mysqli_stmt_get_result($link, $engine, "d", "MEDIUMINT UNSIGNED", 16777215, 340, "integer");
141: func_mysqli_stmt_get_result($link, $engine, "d", "MEDIUMINT UNSIGNED", NULL, 360);
142:
143: func_mysqli_stmt_get_result($link, $engine, "i", "INTEGER", (defined("PHP_INT_MAX")) ? max(-1 * PHP_INT_MAX + 1, -2147483648) : 1, 380);
144: func_mysqli_stmt_get_result($link, $engine, "i", "INTEGER", -2147483647, 400, "integer");
145: func_mysqli_stmt_get_result($link, $engine, "i", "INTEGER", (defined("PHP_INT_MAX")) ? min(2147483647, PHP_INT_MAX) : 1, 420);
146: func_mysqli_stmt_get_result($link, $engine, "i", "INTEGER", NULL, 440);
147: func_mysqli_stmt_get_result($link, $engine, "i", "INTEGER UNSIGNED", (defined("PHP_INT_MAX")) ? min(4294967295, 2147483647) : 1, 460);
148: func_mysqli_stmt_get_result($link, $engine, "i", "INTEGER UNSIGNED", 4294967295, 480, (defined("PHP_INT_MAX") && (4294967295 > PHP_INT_MAX)) ? "string" : null);
149: func_mysqli_stmt_get_result($link, $engine, "i", "INTEGER UNSIGNED", NULL, 500);
150:
151: /* test is broken too: we bind "integer" but value is a float
152: func_mysqli_stmt_get_result($link, $engine, "i", "BIGINT", -9223372036854775808, 520);
153: func_mysqli_stmt_get_result($link, $engine, "i", "BIGINT UNSIGNED", 18446744073709551615, 560);
154: */
155: func_mysqli_stmt_get_result($link, $engine, "i", "BIGINT", NULL, 540);
156: func_mysqli_stmt_get_result($link, $engine, "i", "BIGINT UNSIGNED", NULL, 580);
157: func_mysqli_stmt_get_result($link, $engine, "i", "BIGINT", -1, 1780);
158: func_mysqli_stmt_get_result($link, $engine, "i", "BIGINT UNSIGNED", 1, 1800);
159: func_mysqli_stmt_get_result($link, $engine, "i", "BIGINT", -1 * PHP_INT_MAX + 1, 1820);
160: func_mysqli_stmt_get_result($link, $engine, "i", "BIGINT UNSIGNED", PHP_INT_MAX, 1840);
161: func_mysqli_stmt_get_result($link, $engine, "s", "BIGINT UNSIGNED", "18446744073709551615", 1860);
162: func_mysqli_stmt_get_result($link, $engine, "s", "BIGINT", "-9223372036854775808", 1880);
163:
164: func_mysqli_stmt_get_result($link, $engine, "d", "FLOAT", -9223372036854775808 - 1.1, 600);
165: func_mysqli_stmt_get_result($link, $engine, "d", "FLOAT", NULL, 620);
166: func_mysqli_stmt_get_result($link, $engine, "d", "FLOAT UNSIGNED", 18446744073709551615 + 1.1, 640);
167: func_mysqli_stmt_get_result($link, $engine, "d", "FLOAT UNSIGNED ", NULL, 660);
168:
169: // Yes, we need the temporary variable. The PHP casting will fouls us otherwise.
170: $tmp = strval('-99999999.99');
171: func_mysqli_stmt_get_result($link, $engine, "d", "DOUBLE(10,2)", $tmp, 680, "string");
172: func_mysqli_stmt_get_result($link, $engine, "d", "DOUBLE(10,2)", NULL, 700);
173: $tmp = strval('99999999.99');
174: func_mysqli_stmt_get_result($link, $engine, "d", "DOUBLE(10,2) UNSIGNED", $tmp , 720, "string");
175: func_mysqli_stmt_get_result($link, $engine, "d", "DOUBLE(10,2) UNSIGNED", NULL, 740);
176: $tmp = strval('-99999999.99');
177: func_mysqli_stmt_get_result($link, $engine, "d", "DECIMAL(10,2)", $tmp, 760, "string");
178: func_mysqli_stmt_get_result($link, $engine, "d", "DECIMAL(10,2)", NULL, 780);
179: $tmp = strval('99999999.99');
180: func_mysqli_stmt_get_result($link, $engine, "d", "DECIMAL(10,2)", $tmp, 800, "string");
181: func_mysqli_stmt_get_result($link, $engine, "d", "DECIMAL(10,2)", NULL, 820);
182:
183: // don't care about date() strict TZ warnings...
184: func_mysqli_stmt_get_result($link, $engine, "s", "DATE", @date('Y-m-d'), 840);
185: func_mysqli_stmt_get_result($link, $engine, "s", "DATE NOT NULL", @date('Y-m-d'), 860);
186: func_mysqli_stmt_get_result($link, $engine, "s", "DATE", NULL, 880);
187:
188: func_mysqli_stmt_get_result($link, $engine, "s", "DATETIME", @date('Y-m-d H:i:s'), 900);
189: func_mysqli_stmt_get_result($link, $engine, "s", "DATETIME NOT NULL", @date('Y-m-d H:i:s'), 920);
190: func_mysqli_stmt_get_result($link, $engine, "s", "DATETIME", NULL, 940);
191:
192: func_mysqli_stmt_get_result($link, $engine, "s", "TIMESTAMP", @date('Y-m-d H:i:s'), 960);
193:
194: func_mysqli_stmt_get_result($link, $engine, "s", "TIME", @date('H:i:s'), 980);
195: func_mysqli_stmt_get_result($link, $engine, "s", "TIME NOT NULL", @date('H:i:s'), 1000);
196: func_mysqli_stmt_get_result($link, $engine, "s", "TIME", NULL, 1020);
197:
198: $tmp = intval(@date('Y'));
199: func_mysqli_stmt_get_result($link, $engine, "s", "YEAR", $tmp, 1040, "integer");
200: func_mysqli_stmt_get_result($link, $engine, "s", "YEAR NOT NULL", $tmp, 1060, "integer");
201: func_mysqli_stmt_get_result($link, $engine, "s", "YEAR", NULL, 1080);
202:
203: $string255 = func_mysqli_stmt_bind_make_string(255);
204: func_mysqli_stmt_get_result($link, $engine, "s", "CHAR(1)", "a", 1110, $hint_str_or_unicode);
205: func_mysqli_stmt_get_result($link, $engine, "s", "CHAR(255)", $string255, 1120, $hint_str_or_unicode);
206: func_mysqli_stmt_get_result($link, $engine, "s", "CHAR(1) NOT NULL", "a", 1140, $hint_str_or_unicode);
207: func_mysqli_stmt_get_result($link, $engine, "s", "CHAR(1)", NULL, 1160);
208:
209: $string65k = func_mysqli_stmt_bind_make_string(65535);
210: func_mysqli_stmt_get_result($link, $engine, "s", "VARCHAR(1)", "a", 1180, $hint_str_or_unicode);
211: func_mysqli_stmt_get_result($link, $engine, "s", "VARCHAR(255)", $string255, 1200, $hint_str_or_unicode);
212: func_mysqli_stmt_get_result($link, $engine, "s", "VARCHAR(65635)", $string65k, 1220, $hint_str_or_unicode);
213: func_mysqli_stmt_get_result($link, $engine, "s", "VARCHAR(1) NOT NULL", "a", 1240, $hint_str_or_unicode);
214: func_mysqli_stmt_get_result($link, $engine, "s", "VARCHAR(1)", NULL, 1260);
215:
216: func_mysqli_stmt_get_result($link, $engine, "s", "BINARY(1)", "a", 1280);
217: func_mysqli_stmt_get_result($link, $engine, "s", "BINARY(1)", chr(0), 1300);
218: func_mysqli_stmt_get_result($link, $engine, "s", "BINARY(1) NOT NULL", "b", 1320);
219: func_mysqli_stmt_get_result($link, $engine, "s", "BINARY(1)", NULL, 1340);
220:
221: func_mysqli_stmt_get_result($link, $engine, "s", "VARBINARY(1)", "a", 1360);
222: func_mysqli_stmt_get_result($link, $engine, "s", "VARBINARY(1)", chr(0), 1380);
223: func_mysqli_stmt_get_result($link, $engine, "s", "VARBINARY(1) NOT NULL", "b", 1400);
224: func_mysqli_stmt_get_result($link, $engine, "s", "VARBINARY(1)", NULL, 1420);
225:
226: func_mysqli_stmt_get_result($link, $engine, "s", "TINYBLOB", "a", 1440);
227: func_mysqli_stmt_get_result($link, $engine, "s", "TINYBLOB", chr(0), 1460);
228: func_mysqli_stmt_get_result($link, $engine, "s", "TINYBLOB NOT NULL", "b", 1480);
229: func_mysqli_stmt_get_result($link, $engine, "s", "TINYBLOB", NULL, 1500);
230:
231: func_mysqli_stmt_get_result($link, $engine, "s", "TINYTEXT", "a", 1520, $hint_str_or_unicode);
232: func_mysqli_stmt_get_result($link, $engine, "s", "TINYTEXT NOT NULL", "a", 1540, $hint_str_or_unicode);
233: func_mysqli_stmt_get_result($link, $engine, "s", "TINYTEXT", NULL, 1560, $hint_str_or_unicode);
234:
235: // Note: you cannot insert any blob values this way. But you can check the API at least partly this way
236: // Extra BLOB tests are in mysqli_stmt_send_long()
237: func_mysqli_stmt_get_result($link, $engine, "b", "BLOB", b"", 1580);
238: func_mysqli_stmt_get_result($link, $engine, "b", "TEXT", "", 1600, $hint_str_or_unicode);
239: func_mysqli_stmt_get_result($link, $engine, "b", "MEDIUMBLOB", b"", 1620);
240: func_mysqli_stmt_get_result($link, $engine, "b", "MEDIUMTEXT", "", 1640, $hint_str_or_unicode);
241:
242: /* Is this one related? http://bugs.php.net/bug.php?id=35759 */
243: func_mysqli_stmt_get_result($link, $engine, "b", "LONGBLOB", "", 1660);
244: func_mysqli_stmt_get_result($link, $engine, "b", "LONGTEXT", "", 1680, $hint_str_or_unicode);
245:
246: func_mysqli_stmt_get_result($link, $engine, "s", "ENUM('a', 'b')", "a", 1700, $hint_str_or_unicode);
247: func_mysqli_stmt_get_result($link, $engine, "s", "ENUM('a', 'b')", NULL, 1720, $hint_str_or_unicode);
248: func_mysqli_stmt_get_result($link, $engine, "s", "SET('a', 'b')", "a", 1740, $hint_str_or_unicode);
249: func_mysqli_stmt_get_result($link, $engine, "s", "SET('a', 'b')", NULL, 1760, $hint_str_or_unicode);
250:
251: mysqli_close($link);
252: print "done!";
253: ?>
254: --CLEAN--
255: <?php
256: require_once("clean_table.inc");
257: ?>
258: --EXPECTF--
259: done!
FreeBSD-CVSweb <freebsd-cvsweb@FreeBSD.org>