1--TEST-- 2mysqli_stmt_bind_result() 3--SKIPIF-- 4<?php 5require_once('skipif.inc'); 6require_once('skipifemb.inc'); 7require_once('skipifconnectfailure.inc'); 8?> 9--FILE-- 10<?php 11 require_once("connect.inc"); 12 13 $tmp = NULL; 14 $link = NULL; 15 16 if (!is_null($tmp = @mysqli_stmt_bind_result())) 17 printf("[001] Expecting NULL, got %s/%s\n", gettype($tmp), $tmp); 18 19 if (!is_null($tmp = @mysqli_stmt_bind_result($link))) 20 printf("[002] Expecting NULL, got %s/%s\n", gettype($tmp), $tmp); 21 22 require('table.inc'); 23 24 $stmt = mysqli_stmt_init($link); 25 if (!mysqli_stmt_prepare($stmt, "SELECT id, label FROM test ORDER BY id LIMIT 1")) 26 printf("[002a] [%d] %s\n", mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt)); 27 28 if (!is_null($tmp = mysqli_stmt_bind_result($stmt))) 29 printf("[002b] Expecting NULL, got %s/%s\n", gettype($tmp), $tmp); 30 31 mysqli_stmt_close($stmt); 32 $stmt = mysqli_stmt_init($link); 33 34 $id = null; 35 $label = null; 36 $foo = null; 37 38 if (!is_null($tmp = mysqli_stmt_bind_result($stmt, $id))) 39 printf("[003] Expecting NULL, got %s/%s\n", gettype($tmp), $tmp); 40 41 if (!mysqli_stmt_prepare($stmt, "SELECT id, label FROM test ORDER BY id LIMIT 1")) 42 printf("[004] [%d] %s\n", mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt)); 43 44 if (false !== ($tmp = mysqli_stmt_bind_result($stmt, $id))) 45 printf("[005] Expecting boolean/false, got %s/%s\n", gettype($tmp), $tmp); 46 47 if (true !== ($tmp = mysqli_stmt_bind_result($stmt, $id, $label))) 48 printf("[006] Expecting boolean/true, got %s/%s\n", gettype($tmp), $tmp); 49 50 if (false !== ($tmp = mysqli_stmt_bind_result($stmt, $id, $label, $foo))) 51 printf("[007] Expecting boolean/false, got %s/%s\n", gettype($tmp), $tmp); 52 53 if (!mysqli_stmt_execute($stmt)) 54 printf("[008] [%d] %s\n", mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt)); 55 56 while (mysqli_stmt_fetch($stmt)) { 57 var_dump($id); 58 var_dump($label); 59 } 60 mysqli_stmt_close($stmt); 61 62 63 function func_mysqli_stmt_bind_result($link, $engine, $bind_type, $sql_type, $bind_value, $offset, $type_hint = null) { 64 65 if (!mysqli_query($link, "DROP TABLE IF EXISTS test")) { 66 printf("[%04d] [%d] %s\n", $offset, mysqli_errno($link), mysqli_error($link)); 67 return false; 68 } 69 70 if (!mysqli_query($link, sprintf("CREATE TABLE test(id INT, label %s, PRIMARY KEY(id)) ENGINE = %s", $sql_type, $engine))) { 71 // don't bail - column type might not be supported by the server, ignore this 72 return false; 73 } 74 75 if (!$stmt = mysqli_stmt_init($link)) { 76 printf("[%04d] [%d] %s\n", $offset + 1, mysqli_errno($link), mysqli_error($link)); 77 return false; 78 } 79 80 if (!mysqli_stmt_prepare($stmt, "INSERT INTO test(id, label) VALUES (?, ?)")) { 81 printf("[%04d] [%d] %s\n", $offset + 2, mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt)); 82 return false; 83 } 84 85 $id = null; 86 if (!mysqli_stmt_bind_param($stmt, "i" . $bind_type, $id, $bind_value)) { 87 printf("[%04d] [%d] %s\n", $offset + 3, mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt)); 88 mysqli_stmt_close($stmt); 89 return false; 90 } 91 92 for ($id = 1; $id < 4; $id++) { 93 if (!mysqli_stmt_execute($stmt)) { 94 printf("[%04d] [%d] %s\n", $offset + 3 + $id, mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt)); 95 mysqli_stmt_close($stmt); 96 return false; 97 } 98 } 99 mysqli_stmt_close($stmt); 100 101 $stmt = mysqli_stmt_init($link); 102 103 if (!mysqli_stmt_prepare($stmt, "SELECT id, label FROM test")) { 104 printf("[%04d] [%d] %s\n", $offset + 7, mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt)); 105 mysqli_stmt_close($stmt); 106 return false; 107 } 108 109 if (!mysqli_stmt_execute($stmt)) { 110 printf("[%04d] [%d] %s\n", $offset + 8, mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt)); 111 mysqli_stmt_close($stmt); 112 return false; 113 } 114 115 $result = mysqli_stmt_result_metadata($stmt); 116 117 $bind_res = null; 118 if (!mysqli_stmt_bind_result($stmt, $id, $bind_res)) { 119 printf("[%04d] [%d] %s\n", $offset + 9, mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt)); 120 mysqli_stmt_close($stmt); 121 return false; 122 } 123 $num = 0; 124 $fields = mysqli_fetch_fields($result); 125 126 while (mysqli_stmt_fetch($stmt)) { 127 if (!gettype($bind_res)=="unicode") { 128 if ($bind_res !== $bind_value && (!$type_hint || ($type_hint !== gettype($bind_res)))) { 129 printf("[%04d] [%d] Expecting %s/'%s' [type hint = %s], got %s/'%s'\n", 130 $offset + 10, $num, 131 gettype($bind_value), $bind_value, $type_hint, 132 gettype($bind_res), $bind_res); 133 mysqli_stmt_close($stmt); 134 return false; 135 } 136 } 137 $num++; 138 } 139 140 if ($num != 3) { 141 printf("[%04d] [%d] %s, expecting 3 results, got only %d results\n", 142 $offset + 11, mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt), $num); 143 mysqli_stmt_close($stmt); 144 return false; 145 } 146 147 mysqli_stmt_close($stmt); 148 return true; 149 } 150 151 152 function func_mysqli_stmt_bind_make_string($len) { 153 154 $ret = ''; 155 for ($i = 0; $i < $len; $i++) 156 $ret .= chr(mt_rand(65, 90)); 157 158 return $ret; 159 } 160 161 func_mysqli_stmt_bind_result($link, $engine, "i", "TINYINT", -11, 20); 162 func_mysqli_stmt_bind_result($link, $engine, "i", "TINYINT", NULL, 40); 163 func_mysqli_stmt_bind_result($link, $engine, "i", "TINYINT UNSIGNED", 1, 60); 164 func_mysqli_stmt_bind_result($link, $engine, "i", "TINYINT UNSIGNED", NULL, 80); 165 166 func_mysqli_stmt_bind_result($link, $engine, "i", "BOOL", 1, 100); 167 func_mysqli_stmt_bind_result($link, $engine, "i", "BOOL", NULL, 120); 168 func_mysqli_stmt_bind_result($link, $engine, "i", "BOOLEAN", 0, 140); 169 func_mysqli_stmt_bind_result($link, $engine, "i", "BOOLEAN", NULL, 160); 170 171 func_mysqli_stmt_bind_result($link, $engine, "i", "SMALLINT", -32768, 180); 172 func_mysqli_stmt_bind_result($link, $engine, "i", "SMALLINT", 32767, 200); 173 func_mysqli_stmt_bind_result($link, $engine, "i", "SMALLINT", NULL, 220); 174 func_mysqli_stmt_bind_result($link, $engine, "i", "SMALLINT UNSIGNED", 65535, 240); 175 func_mysqli_stmt_bind_result($link, $engine, "i", "SMALLINT UNSIGNED", NULL, 260); 176 177 func_mysqli_stmt_bind_result($link, $engine, "d", "MEDIUMINT", -8388608, 280, "integer"); 178 func_mysqli_stmt_bind_result($link, $engine, "d", "MEDIUMINT", 8388607, 300, "integer"); 179 func_mysqli_stmt_bind_result($link, $engine, "d", "MEDIUMINT", NULL, 320); 180 func_mysqli_stmt_bind_result($link, $engine, "d", "MEDIUMINT UNSIGNED", 16777215, 340, "integer"); 181 func_mysqli_stmt_bind_result($link, $engine, "d", "MEDIUMINT UNSIGNED", NULL, 360); 182 183 func_mysqli_stmt_bind_result($link, $engine, "i", "INTEGER", (defined("PHP_INT_MAX")) ? max(-1 * PHP_INT_MAX + 1, -2147483648) : 1, 380); 184 func_mysqli_stmt_bind_result($link, $engine, "i", "INTEGER", -2147483647, 400, "integer"); 185 func_mysqli_stmt_bind_result($link, $engine, "i", "INTEGER", (defined("PHP_INT_MAX")) ? min(2147483647, PHP_INT_MAX) : 1, 420); 186 func_mysqli_stmt_bind_result($link, $engine, "i", "INTEGER", NULL, 440); 187 func_mysqli_stmt_bind_result($link, $engine, "i", "INTEGER UNSIGNED", (defined("PHP_INT_MAX")) ? min(4294967295, 2147483647) : 1, 460); 188 func_mysqli_stmt_bind_result($link, $engine, "i", "INTEGER UNSIGNED", 4294967295, 480, (defined("PHP_INT_MAX") && (4294967295 > PHP_INT_MAX)) ? "string" : null); 189 func_mysqli_stmt_bind_result($link, $engine, "i", "INTEGER UNSIGNED", NULL, 500); 190 191 /* test is broken too: we bind "integer" but value is a float 192 func_mysqli_stmt_bind_result($link, $engine, "i", "BIGINT", -9223372036854775808, 520); 193 func_mysqli_stmt_bind_result($link, $engine, "i", "BIGINT UNSIGNED", 18446744073709551615, 560); 194 */ 195 func_mysqli_stmt_bind_result($link, $engine, "i", "BIGINT", NULL, 540); 196 func_mysqli_stmt_bind_result($link, $engine, "i", "BIGINT UNSIGNED", NULL, 580); 197 func_mysqli_stmt_bind_result($link, $engine, "i", "BIGINT", -1, 1780); 198 func_mysqli_stmt_bind_result($link, $engine, "i", "BIGINT UNSIGNED", 1, 1800); 199 func_mysqli_stmt_bind_result($link, $engine, "i", "BIGINT", -1 * PHP_INT_MAX + 1, 1820); 200 func_mysqli_stmt_bind_result($link, $engine, "i", "BIGINT UNSIGNED", PHP_INT_MAX, 1840); 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); 203 204 func_mysqli_stmt_bind_result($link, $engine, "d", "FLOAT", -9223372036854775808 - 1.1, 600); 205 func_mysqli_stmt_bind_result($link, $engine, "d", "FLOAT", NULL, 620); 206 func_mysqli_stmt_bind_result($link, $engine, "d", "FLOAT UNSIGNED", 18446744073709551615 + 1.1, 640); 207 func_mysqli_stmt_bind_result($link, $engine, "d", "FLOAT UNSIGNED ", NULL, 660); 208 209 // Yes, we need the temporary variable. The PHP casting will fouls us otherwise. 210 $tmp = strval('-99999999.99'); 211 func_mysqli_stmt_bind_result($link, $engine, "d", "DOUBLE(10,2)", $tmp, 680, "string"); 212 func_mysqli_stmt_bind_result($link, $engine, "d", "DOUBLE(10,2)", NULL, 700); 213 $tmp = strval('99999999.99'); 214 func_mysqli_stmt_bind_result($link, $engine, "d", "DOUBLE(10,2) UNSIGNED", $tmp , 720, "string"); 215 func_mysqli_stmt_bind_result($link, $engine, "d", "DOUBLE(10,2) UNSIGNED", NULL, 740); 216 $tmp = strval('-99999999.99'); 217 func_mysqli_stmt_bind_result($link, $engine, "d", "DECIMAL(10,2)", $tmp, 760, "string"); 218 func_mysqli_stmt_bind_result($link, $engine, "d", "DECIMAL(10,2)", NULL, 780); 219 $tmp = strval('99999999.99'); 220 func_mysqli_stmt_bind_result($link, $engine, "d", "DECIMAL(10,2)", $tmp, 800, "string"); 221 func_mysqli_stmt_bind_result($link, $engine, "d", "DECIMAL(10,2)", NULL, 820); 222 223 // don't care about date() strict TZ warnings... 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); 227 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); 231 232 func_mysqli_stmt_bind_result($link, $engine, "s", "TIMESTAMP", @date('Y-m-d H:i:s'), 960); 233 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); 237 238 $tmp = intval(@date('Y')); 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); 242 243 $string255 = func_mysqli_stmt_bind_make_string(255); 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); 248 249 $string65k = func_mysqli_stmt_bind_make_string(65535); 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); 255 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); 260 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); 265 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); 270 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'); 274 275 // Note: you cannot insert any blob values this way. But you can check the API at least partly this way 276 // Extra BLOB tests are in mysqli_stmt_send_long() 277 func_mysqli_stmt_bind_result($link, $engine, "b", "BLOB", "", 1580); 278 func_mysqli_stmt_bind_result($link, $engine, "b", "TEXT", "", 1600, 'string'); 279 func_mysqli_stmt_bind_result($link, $engine, "b", "MEDIUMBLOB", "", 1620); 280 func_mysqli_stmt_bind_result($link, $engine, "b", "MEDIUMTEXT", "", 1640, 'string'); 281 282 /* Is this one related? http://bugs.php.net/bug.php?id=35759 */ 283 if (($IS_MYSQLND) || (!$IS_MYSQLND && (ini_get('memory_limit') > 4294967296))) { 284 /* NOTE: the MySQL Client Library - not mysqlnd - will allocate 285 a hugge max_length(type) = 4GB bind buffer */ 286 func_mysqli_stmt_bind_result($link, $engine, "b", "LONGBLOB", "", 1660); 287 func_mysqli_stmt_bind_result($link, $engine, "b", "LONGTEXT", "", 1680, 'string'); 288 } 289 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'); 294 295 if (mysqli_get_server_version($link) >= 50600) 296 func_mysqli_stmt_bind_result($link, $engine, "s", "TIME", "13:31:34.123456", 1770, "13:31:34"); 297 298 /* Check that the function alias exists. It's a deprecated function, 299 but we have not announce the removal so far, therefore we need to check for it */ 300 if (!is_null($tmp = @mysqli_stmt_bind_result())) 301 printf("[3000] Expecting NULL, got %s/%s\n", gettype($tmp), $tmp); 302 303 $stmt = mysqli_stmt_init($link); 304 if (!mysqli_stmt_prepare($stmt, "INSERT INTO test(id, label) VALUES (1000, 'z')")) 305 printf("[3001] [%d] %s\n", mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt)); 306 307 $id = null; 308 if (false !== @mysqli_stmt_bind_result($stmt, $id)) 309 printf("[3002] Bind result should not be allowed"); 310 311 mysqli_stmt_close($stmt); 312 313 mysqli_close($link); 314 print "done!"; 315?> 316--CLEAN-- 317<?php 318 require_once("clean_table.inc"); 319?> 320--EXPECTF-- 321Warning: mysqli_stmt_bind_result() expects at least 2 parameters, 1 given in %s on line %d 322 323Warning: mysqli_stmt_bind_result(): invalid object or resource mysqli_stmt 324 in %s on line %d 325 326Warning: mysqli_stmt_bind_result(): Number of bind variables doesn't match number of fields in prepared statement in %s on line %d 327 328Warning: mysqli_stmt_bind_result(): Number of bind variables doesn't match number of fields in prepared statement in %s on line %d 329int(1) 330%s(1) "a" 331done! 332
