PageRenderTime 25ms CodeModel.GetById 11ms RepoModel.GetById 1ms app.codeStats 0ms

/hphp/test/zend/bad/ext/mysqli/tests/mysqli_stmt_bind_result.php

https://gitlab.com/iranjith4/hhvm
PHP | 298 lines | 226 code | 58 blank | 14 comment | 34 complexity | 75bc89dbdb58d87b668501cb81bebba9 MD5 | raw file
    

  1. <?php
    2. 

  2. 	require_once("connect.inc");
    3. 

  3. 

  4. 	$hint_str_or_unicode = (version_compare(PHP_VERSION, '5.9.9', '>') == 1) ? "unicode":"string";
    5. 

  5. 

  6. 	$tmp    = NULL;
    7. 

  7. 	$link   = NULL;
    8. 

  8. 	$test_table_name = 'test_mysqli_stmt_bind_result_table_1'; require('table.inc');
    9. 

  9. 

  10. 	$stmt = mysqli_stmt_init($link);
    11. 

  11. 	if (!mysqli_stmt_prepare($stmt, "SELECT id, label FROM test_mysqli_stmt_bind_result_table_1 ORDER BY id LIMIT 1"))
    12. 

  12. 		printf("[002a] [%d] %s\n", mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt));
    13. 

  13. 	mysqli_stmt_close($stmt);
    14. 

  14. 	$stmt = mysqli_stmt_init($link);
    15. 

  15. 

  16. 	$id = null;
    17. 

  17. 	$label = null;
    18. 

  18. 	$foo = null;
    19. 

  19. 

  20. 	if (!is_null($tmp = mysqli_stmt_bind_result($stmt)))
    21. 

  21. 		printf("[003] Expecting NULL, got %s/%s\n", gettype($tmp), $tmp);
    22. 

  22. 

  23. 	if (!mysqli_stmt_prepare($stmt, "SELECT id, label FROM test_mysqli_stmt_bind_result_table_1 ORDER BY id LIMIT 1"))
    24. 

  24. 		printf("[004] [%d] %s\n", mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt));
    25. 

  25. 

  26. 	if (false !== ($tmp = mysqli_stmt_bind_result($stmt, $id)))
    27. 

  27. 		printf("[005] Expecting boolean/false, got %s/%s\n", gettype($tmp), $tmp);
    28. 

  28. 

  29. 	if (true !== ($tmp = mysqli_stmt_bind_result($stmt, $id, $label)))
    30. 

  30. 		printf("[006] Expecting boolean/true, got %s/%s\n", gettype($tmp), $tmp);
    31. 

  31. 

  32. 	if (false !== ($tmp = mysqli_stmt_bind_result($stmt, $id, $label, $foo)))
    33. 

  33. 		printf("[007] Expecting boolean/false, got %s/%s\n", gettype($tmp), $tmp);
    34. 

  34. 

  35. 	if (!mysqli_stmt_execute($stmt))
    36. 

  36. 		printf("[008] [%d] %s\n", mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt));
    37. 

  37. 

  38. 	while (mysqli_stmt_fetch($stmt)) {
    39. 

  39. 		var_dump($id);
    40. 

  40. 		var_dump($label);
    41. 

  41. 	}
    42. 

  42. 	mysqli_stmt_close($stmt);
    43. 

  43. 

  44. 

  45. 	function func_mysqli_stmt_bind_result($link, $engine, $bind_type, $sql_type, $bind_value, $offset, $type_hint = null) {
    46. 

  46. 

  47. 		if (!mysqli_query($link, "DROP TABLE IF EXISTS test_mysqli_stmt_bind_result_table_1")) {
    48. 

  48. 			printf("[%04d] [%d] %s\n", $offset, mysqli_errno($link), mysqli_error($link));
    49. 

  49. 			return false;
    50. 

  50. 		}
    51. 

  51. 

  52. 		if (!mysqli_query($link, sprintf("CREATE TABLE test_mysqli_stmt_bind_result_table_1(id INT, label %s, PRIMARY KEY(id)) ENGINE = %s", $sql_type, $engine))) {
    53. 

  53. 			// don't bail - column type might not be supported by the server, ignore this
    54. 

  54. 			return false;
    55. 

  55. 		}
    56. 

  56. 

  57. 		if (!$stmt = mysqli_stmt_init($link)) {
    58. 

  58. 			printf("[%04d] [%d] %s\n", $offset + 1, mysqli_errno($link), mysqli_error($link));
    59. 

  59. 			return false;
    60. 

  60. 		}
    61. 

  61. 

  62. 		if (!mysqli_stmt_prepare($stmt, "INSERT INTO test_mysqli_stmt_bind_result_table_1(id, label) VALUES (?, ?)")) {
    63. 

  63. 			printf("[%04d] [%d] %s\n", $offset + 2, mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt));
    64. 

  64. 			return false;
    65. 

  65. 		}
    66. 

  66. 

  67. 		$id = null;
    68. 

  68. 		if (!mysqli_stmt_bind_param($stmt, "i" . $bind_type, $id, $bind_value)) {
    69. 

  69. 			printf("[%04d] [%d] %s\n", $offset + 3, mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt));
    70. 

  70. 			mysqli_stmt_close($stmt);
    71. 

  71. 			return false;
    72. 

  72. 		}
    73. 

  73. 

  74. 		for ($id = 1; $id < 4; $id++) {
    75. 

  75. 			if (!mysqli_stmt_execute($stmt)) {
    76. 

  76. 				printf("[%04d] [%d] %s\n", $offset + 3 + $id, mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt));
    77. 

  77. 				mysqli_stmt_close($stmt);
    78. 

  78. 				return false;
    79. 

  79. 			}
    80. 

  80. 		}
    81. 

  81. 		mysqli_stmt_close($stmt);
    82. 

  82. 

  83. 		$stmt = mysqli_stmt_init($link);
    84. 

  84. 

  85. 		if (!mysqli_stmt_prepare($stmt, "SELECT id, label FROM test_mysqli_stmt_bind_result_table_1")) {
    86. 

  86. 			printf("[%04d] [%d] %s\n", $offset + 7, mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt));
    87. 

  87. 			mysqli_stmt_close($stmt);
    88. 

  88. 			return false;
    89. 

  89. 		}
    90. 

  90. 

  91. 		if (!mysqli_stmt_execute($stmt)) {
    92. 

  92. 			printf("[%04d] [%d] %s\n", $offset + 8, mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt));
    93. 

  93. 			mysqli_stmt_close($stmt);
    94. 

  94. 			return false;
    95. 

  95. 		}
    96. 

  96. 

  97. 		$result = mysqli_stmt_result_metadata($stmt);
    98. 

  98. 

  99. 		$bind_res = null;
    100. 

  100. 		if (!mysqli_stmt_bind_result($stmt, $id, $bind_res)) {
    101. 

  101. 			printf("[%04d] [%d] %s\n", $offset + 9, mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt));
    102. 

  102. 			mysqli_stmt_close($stmt);
    103. 

  103. 			return false;
    104. 

  104. 		}
    105. 

  105. 		$num = 0;
    106. 

  106. 		$fields = mysqli_fetch_fields($result);
    107. 

  107. 

  108. 		while (mysqli_stmt_fetch($stmt)) {
    109. 

  109. 			if (!gettype($bind_res)=="unicode") {
    110. 

  110. 				if ($bind_res !== $bind_value && (!$type_hint || ($type_hint !== gettype($bind_res)))) {
    111. 

  111. 					printf("[%04d] [%d] Expecting %s/'%s' [type hint = %s], got %s/'%s'\n",
    112. 

  112. 						$offset + 10, $num,
    113. 

  113. 						gettype($bind_value), $bind_value, $type_hint,
    114. 

  114. 						gettype($bind_res), $bind_res);
    115. 

  115. 						mysqli_stmt_close($stmt);
    116. 

  116. 						return false;
    117. 

  117. 				}
    118. 

  118. 			}
    119. 

  119. 			$num++;
    120. 

  120. 		}
    121. 

  121. 

  122. 		if ($num != 3) {
    123. 

  123. 			printf("[%04d] [%d] %s, expecting 3 results, got only %d results\n",
    124. 

  124. 				$offset + 11, mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt), $num);
    125. 

  125. 			mysqli_stmt_close($stmt);
    126. 

  126. 			return false;
    127. 

  127. 		}
    128. 

  128. 

  129. 		mysqli_stmt_close($stmt);
    130. 

  130. 		return true;
    131. 

  131. 	}
    132. 

  132. 

  133. 

  134. 	function func_mysqli_stmt_bind_make_string($len) {
    135. 

  135. 

  136. 		$ret = '';
    137. 

  137. 		for ($i = 0; $i < $len; $i++)
    138. 

  138. 			$ret .= chr(mt_rand(65, 90));
    139. 

  139. 

  140. 		return $ret;
    141. 

  141. 	}
    142. 

  142. 

  143. 	func_mysqli_stmt_bind_result($link, $engine, "i", "TINYINT", -11, 20);
    144. 

  144. 	func_mysqli_stmt_bind_result($link, $engine, "i", "TINYINT", NULL, 40);
    145. 

  145. 	func_mysqli_stmt_bind_result($link, $engine, "i", "TINYINT UNSIGNED", 1, 60);
    146. 

  146. 	func_mysqli_stmt_bind_result($link, $engine, "i", "TINYINT UNSIGNED", NULL, 80);
    147. 

  147. 

  148. 	func_mysqli_stmt_bind_result($link, $engine, "i", "BOOL", 1, 100);
    149. 

  149. 	func_mysqli_stmt_bind_result($link, $engine, "i", "BOOL", NULL, 120);
    150. 

  150. 	func_mysqli_stmt_bind_result($link, $engine, "i", "BOOLEAN", 0, 140);
    151. 

  151. 	func_mysqli_stmt_bind_result($link, $engine, "i", "BOOLEAN", NULL, 160);
    152. 

  152. 

  153. 	func_mysqli_stmt_bind_result($link, $engine, "i", "SMALLINT", -32768, 180);
    154. 

  154. 	func_mysqli_stmt_bind_result($link, $engine, "i", "SMALLINT", 32767, 200);
    155. 

  155. 	func_mysqli_stmt_bind_result($link, $engine, "i", "SMALLINT", NULL, 220);
    156. 

  156. 	func_mysqli_stmt_bind_result($link, $engine, "i", "SMALLINT UNSIGNED", 65535, 240);
    157. 

  157. 	func_mysqli_stmt_bind_result($link, $engine, "i", "SMALLINT UNSIGNED", NULL, 260);
    158. 

  158. 

  159. 	func_mysqli_stmt_bind_result($link, $engine, "d", "MEDIUMINT", -8388608, 280, "integer");
    160. 

  160. 	func_mysqli_stmt_bind_result($link, $engine, "d", "MEDIUMINT", 8388607, 300, "integer");
    161. 

  161. 	func_mysqli_stmt_bind_result($link, $engine, "d", "MEDIUMINT", NULL, 320);
    162. 

  162. 	func_mysqli_stmt_bind_result($link, $engine, "d", "MEDIUMINT UNSIGNED", 16777215, 340, "integer");
    163. 

  163. 	func_mysqli_stmt_bind_result($link, $engine, "d", "MEDIUMINT UNSIGNED", NULL, 360);
    164. 

  164. 

  165. 	func_mysqli_stmt_bind_result($link, $engine, "i", "INTEGER", (defined("PHP_INT_MAX")) ? max(-1 * PHP_INT_MAX + 1, -2147483648) : 1, 380);
    166. 

  166. 	func_mysqli_stmt_bind_result($link, $engine, "i", "INTEGER", -2147483647, 400, "integer");
    167. 

  167. 	func_mysqli_stmt_bind_result($link, $engine, "i", "INTEGER", (defined("PHP_INT_MAX")) ? min(2147483647, PHP_INT_MAX) : 1, 420);
    168. 

  168. 	func_mysqli_stmt_bind_result($link, $engine, "i", "INTEGER", NULL, 440);
    169. 

  169. 	func_mysqli_stmt_bind_result($link, $engine, "i", "INTEGER UNSIGNED", (defined("PHP_INT_MAX")) ? min(4294967295, 2147483647) : 1, 460);
    170. 

  170. 	func_mysqli_stmt_bind_result($link, $engine, "i", "INTEGER UNSIGNED", 4294967295, 480, (defined("PHP_INT_MAX") && (4294967295 > PHP_INT_MAX)) ? "string" : null);
    171. 

  171. 	func_mysqli_stmt_bind_result($link, $engine, "i", "INTEGER UNSIGNED", NULL, 500);
    172. 

  172. 

  173. 	/* test is broken too: we bind "integer" but value is a float
    174. 

  174. 	func_mysqli_stmt_bind_result($link, $engine, "i", "BIGINT", -9223372036854775808, 520);
    175. 

  175. 	func_mysqli_stmt_bind_result($link, $engine, "i", "BIGINT UNSIGNED", 18446744073709551615, 560);
    176. 

  176. 	*/
    177. 

  177. 	func_mysqli_stmt_bind_result($link, $engine, "i", "BIGINT", NULL, 540);
    178. 

  178. 	func_mysqli_stmt_bind_result($link, $engine, "i", "BIGINT UNSIGNED", NULL, 580);
    179. 

  179. 	func_mysqli_stmt_bind_result($link, $engine, "i", "BIGINT", -1, 1780);
    180. 

  180. 	func_mysqli_stmt_bind_result($link, $engine, "i", "BIGINT UNSIGNED", 1, 1800);
    181. 

  181. 	func_mysqli_stmt_bind_result($link, $engine, "i", "BIGINT", -1 * PHP_INT_MAX + 1, 1820);
    182. 

  182. 	func_mysqli_stmt_bind_result($link, $engine, "i", "BIGINT UNSIGNED", PHP_INT_MAX, 1840);
    183. 

  183. 	func_mysqli_stmt_bind_result($link, $engine, "s", "BIGINT UNSIGNED", "18446744073709551615", 1860);
    184. 

  184. 	func_mysqli_stmt_bind_result($link, $engine, "s", "BIGINT", "-9223372036854775808", 1880);
    185. 

  185. 

  186. 	func_mysqli_stmt_bind_result($link, $engine, "d", "FLOAT", -9223372036854775808 - 1.1, 600);
    187. 

  187. 	func_mysqli_stmt_bind_result($link, $engine, "d", "FLOAT", NULL, 620);
    188. 

  188. 	func_mysqli_stmt_bind_result($link, $engine, "d", "FLOAT UNSIGNED", 18446744073709551615 + 1.1, 640);
    189. 

  189. 	func_mysqli_stmt_bind_result($link, $engine, "d", "FLOAT UNSIGNED ", NULL, 660);
    190. 

  190. 

  191. 	// Yes, we need the temporary variable. The PHP casting will fouls us otherwise.
    192. 

  192. 	$tmp = strval('-99999999.99');
    193. 

  193. 	func_mysqli_stmt_bind_result($link, $engine, "d", "DOUBLE(10,2)", $tmp, 680, "string");
    194. 

  194. 	func_mysqli_stmt_bind_result($link, $engine, "d", "DOUBLE(10,2)", NULL, 700);
    195. 

  195. 	$tmp = strval('99999999.99');
    196. 

  196. 	func_mysqli_stmt_bind_result($link, $engine, "d", "DOUBLE(10,2) UNSIGNED", $tmp , 720, "string");
    197. 

  197. 	func_mysqli_stmt_bind_result($link, $engine, "d", "DOUBLE(10,2) UNSIGNED", NULL, 740);
    198. 

  198. 	$tmp = strval('-99999999.99');
    199. 

  199. 	func_mysqli_stmt_bind_result($link, $engine, "d", "DECIMAL(10,2)", $tmp, 760, "string");
    200. 

  200. 	func_mysqli_stmt_bind_result($link, $engine, "d", "DECIMAL(10,2)", NULL, 780);
    201. 

  201. 	$tmp = strval('99999999.99');
    202. 

  202. 	func_mysqli_stmt_bind_result($link, $engine, "d", "DECIMAL(10,2)", $tmp, 800, "string");
    203. 

  203. 	func_mysqli_stmt_bind_result($link, $engine, "d", "DECIMAL(10,2)", NULL, 820);
    204. 

  204. 

  205. 	// don't care about date() strict TZ warnings...
    206. 

  206. 	func_mysqli_stmt_bind_result($link, $engine, "s", "DATE", @date('Y-m-d'), 840);
    207. 

  207. 	func_mysqli_stmt_bind_result($link, $engine, "s", "DATE NOT NULL", @date('Y-m-d'), 860);
    208. 

  208. 	func_mysqli_stmt_bind_result($link, $engine, "s", "DATE", NULL, 880);
    209. 

  209. 

  210. 	func_mysqli_stmt_bind_result($link, $engine, "s", "DATETIME", @date('Y-m-d H:i:s'), 900);
    211. 

  211. 	func_mysqli_stmt_bind_result($link, $engine, "s", "DATETIME NOT NULL", @date('Y-m-d H:i:s'), 920);
    212. 

  212. 	func_mysqli_stmt_bind_result($link, $engine, "s", "DATETIME", NULL, 940);
    213. 

  213. 

  214. 	func_mysqli_stmt_bind_result($link, $engine, "s", "TIMESTAMP", @date('Y-m-d H:i:s'), 960);
    215. 

  215. 

  216. 	func_mysqli_stmt_bind_result($link, $engine, "s", "TIME", @date('H:i:s'), 980);
    217. 

  217. 	func_mysqli_stmt_bind_result($link, $engine, "s", "TIME NOT NULL", @date('H:i:s'), 1000);
    218. 

  218. 	func_mysqli_stmt_bind_result($link, $engine, "s", "TIME", NULL, 1020);
    219. 

  219. 

  220. 	$tmp = intval(@date('Y'));
    221. 

  221. 	func_mysqli_stmt_bind_result($link, $engine, "s", "YEAR", $tmp, 1040, "integer");
    222. 

  222. 	func_mysqli_stmt_bind_result($link, $engine, "s", "YEAR NOT NULL", $tmp, 1060, "integer");
    223. 

  223. 	func_mysqli_stmt_bind_result($link, $engine, "s", "YEAR", NULL, 1080);
    224. 

  224. 

  225. 	$string255 = func_mysqli_stmt_bind_make_string(255);
    226. 

  226. 	func_mysqli_stmt_bind_result($link, $engine, "s", "CHAR(1)", "a", 1110, $hint_str_or_unicode);
    227. 

  227. 	func_mysqli_stmt_bind_result($link, $engine, "s", "CHAR(255)", $string255, 1120, $hint_str_or_unicode);
    228. 

  228. 	func_mysqli_stmt_bind_result($link, $engine, "s", "CHAR(1) NOT NULL", "a", 1140, $hint_str_or_unicode);
    229. 

  229. 	func_mysqli_stmt_bind_result($link, $engine, "s", "CHAR(1)", NULL, 1160);
    230. 

  230. 

  231. 	$string65k = func_mysqli_stmt_bind_make_string(65535);
    232. 

  232. 	func_mysqli_stmt_bind_result($link, $engine, "s", "VARCHAR(1)", "a", 1180, $hint_str_or_unicode);
    233. 

  233. 	func_mysqli_stmt_bind_result($link, $engine, "s", "VARCHAR(255)", $string255, 1200, $hint_str_or_unicode);
    234. 

  234. 	func_mysqli_stmt_bind_result($link, $engine, "s", "VARCHAR(65635)", $string65k, 1220, $hint_str_or_unicode);
    235. 

  235. 	func_mysqli_stmt_bind_result($link, $engine, "s", "VARCHAR(1) NOT NULL", "a", 1240, $hint_str_or_unicode);
    236. 

  236. 	func_mysqli_stmt_bind_result($link, $engine, "s", "VARCHAR(1)", NULL, 1260);
    237. 

  237. 

  238. 	func_mysqli_stmt_bind_result($link, $engine, "s", "BINARY(1)", "a", 1280);
    239. 

  239. 	func_mysqli_stmt_bind_result($link, $engine, "s", "BINARY(1)", chr(0), 1300);
    240. 

  240. 	func_mysqli_stmt_bind_result($link, $engine, "s", "BINARY(1) NOT NULL", "b", 1320);
    241. 

  241. 	func_mysqli_stmt_bind_result($link, $engine, "s", "BINARY(1)", NULL, 1340);
    242. 

  242. 

  243. 	func_mysqli_stmt_bind_result($link, $engine, "s", "VARBINARY(1)", "a", 1360);
    244. 

  244. 	func_mysqli_stmt_bind_result($link, $engine, "s", "VARBINARY(1)", chr(0), 1380);
    245. 

  245. 	func_mysqli_stmt_bind_result($link, $engine, "s", "VARBINARY(1) NOT NULL", "b", 1400);
    246. 

  246. 	func_mysqli_stmt_bind_result($link, $engine, "s", "VARBINARY(1)", NULL, 1420);
    247. 

  247. 

  248. 	func_mysqli_stmt_bind_result($link, $engine, "s", "TINYBLOB", "a", 1440);
    249. 

  249. 	func_mysqli_stmt_bind_result($link, $engine, "s", "TINYBLOB", chr(0), 1460);
    250. 

  250. 	func_mysqli_stmt_bind_result($link, $engine, "s", "TINYBLOB NOT NULL", "b", 1480);
    251. 

  251. 	func_mysqli_stmt_bind_result($link, $engine, "s", "TINYBLOB", NULL, 1500);
    252. 

  252. 

  253. 	func_mysqli_stmt_bind_result($link, $engine, "s", "TINYTEXT", "a", 1520, $hint_str_or_unicode);
    254. 

  254. 	func_mysqli_stmt_bind_result($link, $engine, "s", "TINYTEXT NOT NULL", "a", 1540, $hint_str_or_unicode);
    255. 

  255. 	func_mysqli_stmt_bind_result($link, $engine, "s", "TINYTEXT", NULL, 1560, $hint_str_or_unicode);
    256. 

  256. 

  257. 	// Note: you cannot insert any blob values this way. But you can check the API at least partly this way
    258. 

  258. 	// Extra BLOB tests are in mysqli_stmt_send_long()
    259. 

  259. 	func_mysqli_stmt_bind_result($link, $engine, "b", "BLOB", b"", 1580);
    260. 

  260. 	func_mysqli_stmt_bind_result($link, $engine, "b", "TEXT", "", 1600, $hint_str_or_unicode);
    261. 

  261. 	func_mysqli_stmt_bind_result($link, $engine, "b", "MEDIUMBLOB", b"", 1620);
    262. 

  262. 	func_mysqli_stmt_bind_result($link, $engine, "b", "MEDIUMTEXT", "", 1640, $hint_str_or_unicode);
    263. 

  263. 

  264. 	/* Is this one related? http://bugs.php.net/bug.php?id=35759 */
    265. 

  265. 	if (($IS_MYSQLND) || (!$IS_MYSQLND && (ini_get('memory_limit') > 4294967296))) {
    266. 

  266. 		/* NOTE: the MySQL Client Library - not mysqlnd - will allocate
    267. 

  267. 		a hugge max_length(type) = 4GB bind buffer */
    268. 

  268. 		func_mysqli_stmt_bind_result($link, $engine, "b", "LONGBLOB", "", 1660);
    269. 

  269. 		func_mysqli_stmt_bind_result($link, $engine, "b", "LONGTEXT", "", 1680, $hint_str_or_unicode);
    270. 

  270. 	}
    271. 

  271. 

  272. 	func_mysqli_stmt_bind_result($link, $engine, "s", "ENUM('a', 'b')", "a", 1700, $hint_str_or_unicode);
    273. 

  273. 	func_mysqli_stmt_bind_result($link, $engine, "s", "ENUM('a', 'b')", NULL, 1720, $hint_str_or_unicode);
    274. 

  274. 	func_mysqli_stmt_bind_result($link, $engine, "s", "SET('a', 'b')", "a", 1740, $hint_str_or_unicode);
    275. 

  275. 	func_mysqli_stmt_bind_result($link, $engine, "s", "SET('a', 'b')", NULL, 1760, $hint_str_or_unicode);
    276. 

  276. 

  277. 	if (mysqli_get_server_version($link) >= 50600)
    278. 

  278. 		func_mysqli_stmt_bind_result($link, $engine, "s", "TIME", "13:31:34.123456", 1770, "13:31:34");
    279. 

  279. 

  280. 	/* Check that the function alias exists. It's a deprecated function,
    281. 

  281. 	but we have not announce the removal so far, therefore we need to check for it */
    282. 

  282. 	$stmt = mysqli_stmt_init($link);
    283. 

  283. 	if (!mysqli_stmt_prepare($stmt, "INSERT INTO test_mysqli_stmt_bind_result_table_1(id, label) VALUES (1000, 'z')"))
    284. 

  284. 		printf("[3001] [%d] %s\n", mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt));
    285. 

  285. 

  286. 	$id = null;
    287. 

  287. 	if (false !== @mysqli_stmt_bind_result($stmt, $id))
    288. 

  288. 		printf("[3002] Bind result should not be allowed");
    289. 

  289. 

  290. 	mysqli_stmt_close($stmt);
    291. 

  291. 

  292. 	mysqli_close($link);
    293. 

  293. 	print "done!";
    294. 

  294. ?>
    295. 

  295. <?php error_reporting(0); ?>
    296. 

  296. <?php
    297. 

  297. 	$test_table_name = 'test_mysqli_stmt_bind_result_table_1'; require_once("clean_table.inc");
    298. 

  298. ?>
    299.