1--TEST-- 2mysqli fetch mixed values 2 3--INI-- 4precision=12 5--SKIPIF-- 6<?php 7require_once('skipif.inc'); 8require_once('skipifconnectfailure.inc'); 9?> 10--FILE-- 11<?php 12 require_once("connect.inc"); 13 14 /*** test mysqli_connect 127.0.0.1 ***/ 15 $link = my_mysqli_connect($host, $user, $passwd, $db, $port, $socket); 16 17 if (!mysqli_query($link, "DROP TABLE IF EXISTS test_bind_result")) 18 printf("[001] [%d] %s\n", mysqli_errno($link), mysqli_error($link)); 19 20 $rc = mysqli_query($link, "CREATE TABLE test_bind_result(c1 tinyint, c2 smallint, 21 c3 int, c4 bigint, 22 c5 float, c6 double, 23 c7 varbinary(10), 24 c8 varchar(10)) ENGINE=" . $engine); 25 if (!$rc) 26 printf("[002] [%d] %s\n", mysqli_errno($link), mysqli_error($link)); 27 28 if (!mysqli_query($link, "INSERT INTO test_bind_result VALUES(120,2999,3999,54, 29 2.6,58.89, 30 '206','6.7')")) 31 printf("[003] [%d] %s\n", mysqli_errno($link), mysqli_error($link)); 32 33 $stmt = mysqli_prepare($link, "SELECT * FROM test_bind_result"); 34 mysqli_stmt_bind_result($stmt, $c1, $c2, $c3, $c4, $c5, $c6, $c7, $c8); 35 mysqli_stmt_execute($stmt); 36 mysqli_stmt_fetch($stmt); 37 38 $test = array($c1,$c2,$c3,$c4,$c5,$c6,$c7,$c8); 39 40 var_dump($test); 41 42 mysqli_stmt_close($stmt); 43 mysqli_query($link, "DROP TABLE IF EXISTS test_bind_result"); 44 mysqli_close($link); 45 print "done!"; 46?> 47--CLEAN-- 48<?php 49require_once("connect.inc"); 50if (!$link = my_mysqli_connect($host, $user, $passwd, $db, $port, $socket)) 51 printf("[c001] [%d] %s\n", mysqli_connect_errno(), mysqli_connect_error()); 52 53if (!mysqli_query($link, "DROP TABLE IF EXISTS test_bind_result")) 54 printf("[c002] Cannot drop table, [%d] %s\n", mysqli_errno($link), mysqli_error($link)); 55 56mysqli_close($link); 57?> 58--EXPECTF-- 59array(8) { 60 [0]=> 61 int(120) 62 [1]=> 63 int(2999) 64 [2]=> 65 int(3999) 66 [3]=> 67 int(54) 68 [4]=> 69 float(2.6) 70 [5]=> 71 float(58.89) 72 [6]=> 73 string(3) "206" 74 [7]=> 75 %unicode|string%(3) "6.7" 76} 77done! 78
