diff options
Diffstat (limited to 'ext/mysqli/tests/048.phpt')
-rw-r--r-- | ext/mysqli/tests/048.phpt | 79 |
1 files changed, 79 insertions, 0 deletions
diff --git a/ext/mysqli/tests/048.phpt b/ext/mysqli/tests/048.phpt new file mode 100644 index 0000000..afc0923 --- /dev/null +++ b/ext/mysqli/tests/048.phpt @@ -0,0 +1,79 @@ +--TEST-- +mysqli bind_result (OO-Style) +--SKIPIF-- +<?php +require_once('skipif.inc'); +require_once('skipifconnectfailure.inc'); +?> +--FILE-- +<?php + require_once("connect.inc"); + + /*** test mysqli_connect 127.0.0.1 ***/ + $mysql = my_mysqli_connect($host, $user, $passwd, $db, $port, $socket); + + $mysql->select_db($db); + $mysql->query("DROP TABLE IF EXISTS test_fetch_null"); + + $mysql->query("CREATE TABLE test_fetch_null(col1 tinyint, col2 smallint, + col3 int, col4 bigint, + col5 float, col6 double, + col7 date, col8 time, + col9 varbinary(10), + col10 varchar(50), + col11 char(20)) ENGINE=" . $engine); + + $mysql->query("INSERT INTO test_fetch_null(col1,col10, col11) VALUES(1,'foo1', 1000),(2,'foo2', 88),(3,'foo3', 389789)"); + + $stmt = $mysql->prepare("SELECT col1, col2, col3, col4, col5, col6, col7, col8, col9, col10, col11 from test_fetch_null"); + $stmt->bind_result($c1, $c2, $c3, $c4, $c5, $c6, $c7, $c8, $c9, $c10, $c11); + $stmt->execute(); + + $stmt->fetch(); + + $test = array($c1,$c2,$c3,$c4,$c5,$c6,$c7,$c8,$c9,$c10,$c11); + + var_dump($test); + + $stmt->close(); + $mysql->query("DROP TABLE IF EXISTS test_fetch_null"); + $mysql->close(); + print "done!"; +?> +--CLEAN-- +<?php +require_once("connect.inc"); +if (!$link = my_mysqli_connect($host, $user, $passwd, $db, $port, $socket)) + printf("[c001] [%d] %s\n", mysqli_connect_errno(), mysqli_connect_error()); + +if (!mysqli_query($link, "DROP TABLE IF EXISTS test_fetch_null")) + printf("[c002] Cannot drop table, [%d] %s\n", mysqli_errno($link), mysqli_error($link)); + +mysqli_close($link); +?> +--EXPECTF-- +array(11) { + [0]=> + int(1) + [1]=> + NULL + [2]=> + NULL + [3]=> + NULL + [4]=> + NULL + [5]=> + NULL + [6]=> + NULL + [7]=> + NULL + [8]=> + NULL + [9]=> + %unicode|string%(4) "foo1" + [10]=> + %unicode|string%(4) "1000" +} +done!
\ No newline at end of file |