diff options
Diffstat (limited to 'ext/mysqli/tests/011.phpt')
| -rw-r--r-- | ext/mysqli/tests/011.phpt | 53 |
1 files changed, 53 insertions, 0 deletions
diff --git a/ext/mysqli/tests/011.phpt b/ext/mysqli/tests/011.phpt new file mode 100644 index 0000000000..5735e2f1dd --- /dev/null +++ b/ext/mysqli/tests/011.phpt @@ -0,0 +1,53 @@ +--TEST-- +mysqli fetch mixed values +--FILE-- +<?php + include "connect.inc"; + + /*** test mysqli_connect 127.0.0.1 ***/ + $link = mysqli_connect("localhost", $user, $passwd); + + mysqli_select_db($link, "test"); + + mysqli_query($link,"DROP TABLE IF EXISTS test_bind_result"); + + mysqli_query($link,"CREATE TABLE test_bind_result(c1 tinyint, c2 smallint, + c3 int, c4 bigint, + c5 float, c6 double, + c7 varbinary(10), + c8 varchar(50))"); + + mysqli_query($link,"INSERT INTO test_bind_result VALUES(19,2999,3999,4999999, + 2345.6,5678.89563, + 'foobar','mysql rulez')"); + $stmt = mysqli_prepare($link, "SELECT * FROM test_bind_result"); + mysqli_bind_result($stmt, &$c1, &$c2, &$c3, &$c4, &$c5, &$c6, &$c7, &$c8); + mysqli_execute($stmt); + mysqli_fetch($stmt); + + $test = array($c1,$c2,$c3,$c4,$c5,$c6,$c7,$c8); + + var_dump($test); + + mysqli_stmt_close($stmt); + mysqli_close($link); +?> +--EXPECT-- +array(8) { + [0]=> + int(19) + [1]=> + int(2999) + [2]=> + int(3999) + [3]=> + int(4999999) + [4]=> + float(2345.6000976563) + [5]=> + float(5678.89563) + [6]=> + string(6) "foobar" + [7]=> + string(11) "mysql rulez" +} |