diff options
Diffstat (limited to 'ext/mysqli/tests/004.phpt')
| -rw-r--r-- | ext/mysqli/tests/004.phpt | 89 |
1 files changed, 89 insertions, 0 deletions
diff --git a/ext/mysqli/tests/004.phpt b/ext/mysqli/tests/004.phpt new file mode 100644 index 0000000..010d6e1 --- /dev/null +++ b/ext/mysqli/tests/004.phpt @@ -0,0 +1,89 @@ +--TEST-- +mysqli fetch char/text +--SKIPIF-- +<?php +require_once('skipif.inc'); +require_once('skipifconnectfailure.inc'); +?> +--FILE-- +<?php + include ("connect.inc"); + + /*** test mysqli_connect 127.0.0.1 ***/ + $link = my_mysqli_connect($host, $user, $passwd, $db, $port, $socket); + + mysqli_select_db($link, $db); + + if (!mysqli_query($link,"DROP TABLE IF EXISTS test_bind_fetch")) + printf("[001] [%d] %s\n", mysqli_errno($link), mysqli_error($link)); + + if (!mysqli_query($link,"CREATE TABLE test_bind_fetch(c1 char(10), c2 text) ENGINE=" . $engine)) + printf("[002] [%d] %s\n", mysqli_errno($link), mysqli_error($link)); + + if (!mysqli_query($link, "INSERT INTO test_bind_fetch VALUES ('1234567890', 'this is a test0')")) + printf("[003] [%d] %s\n", mysqli_errno($link), mysqli_error($link)); + + if (!mysqli_query($link, "INSERT INTO test_bind_fetch VALUES ('1234567891', 'this is a test1')")) + printf("[004] [%d] %s\n", mysqli_errno($link), mysqli_error($link)); + + if (!mysqli_query($link, "INSERT INTO test_bind_fetch VALUES ('1234567892', 'this is a test2')")) + printf("[005] [%d] %s\n", mysqli_errno($link), mysqli_error($link)); + + if (!mysqli_query($link, "INSERT INTO test_bind_fetch VALUES ('1234567893', 'this is a test3')")) + printf("[006] [%d] %s\n", mysqli_errno($link), mysqli_error($link)); + + if (!$stmt = mysqli_prepare($link, "SELECT * FROM test_bind_fetch ORDER BY c1")) + printf("[007] [%d] %s\n", mysqli_errno($link), mysqli_error($link)); + + $c1 = $c2 = NULL; + mysqli_stmt_bind_result($stmt, $c1, $c2); + mysqli_stmt_execute($stmt); + $i = 4; + while ($i--) { + mysqli_stmt_fetch($stmt); + $test = array($c1, $c2); + var_dump($test); + } + + mysqli_stmt_close($stmt); + mysqli_query($link, "DROP TABLE IF EXISTS test_bind_fetch"); + mysqli_close($link); + 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_bind_fetch")) + printf("[c002] Cannot drop table, [%d] %s\n", mysqli_errno($link), mysqli_error($link)); + +mysqli_close($link); +?> +--EXPECTF-- +array(2) { + [0]=> + %unicode|string%(10) "1234567890" + [1]=> + %unicode|string%(15) "this is a test0" +} +array(2) { + [0]=> + %unicode|string%(10) "1234567891" + [1]=> + %unicode|string%(15) "this is a test1" +} +array(2) { + [0]=> + %unicode|string%(10) "1234567892" + [1]=> + %unicode|string%(15) "this is a test2" +} +array(2) { + [0]=> + %unicode|string%(10) "1234567893" + [1]=> + %unicode|string%(15) "this is a test3" +} +done!
\ No newline at end of file |