andrey Sun Jan 1 16:52:05 2006 UTC
Modified files: (Branch: PHP_5_1)
/php-src/ext/mysqli/tests 004.phpt
Log:
fetch more than one row at once
http://cvs.php.net/viewcvs.cgi/php-src/ext/mysqli/tests/004.phpt?r1=1.4&r2=1.4.2.1&diff_format=u
Index: php-src/ext/mysqli/tests/004.phpt
diff -u php-src/ext/mysqli/tests/004.phpt:1.4
php-src/ext/mysqli/tests/004.phpt:1.4.2.1
--- php-src/ext/mysqli/tests/004.phpt:1.4 Sat Dec 4 08:50:33 2004
+++ php-src/ext/mysqli/tests/004.phpt Sun Jan 1 16:52:05 2006
@@ -14,16 +14,21 @@
mysqli_query($link,"DROP TABLE IF EXISTS test_bind_fetch");
mysqli_query($link,"CREATE TABLE test_bind_fetch(c1 char(10), c2
text)");
- mysqli_query($link, "INSERT INTO test_bind_fetch VALUES ('1234567890',
'this is a test')");
+ mysqli_query($link, "INSERT INTO test_bind_fetch VALUES ('1234567890',
'this is a test0')");
+ mysqli_query($link, "INSERT INTO test_bind_fetch VALUES ('1234567891',
'this is a test1')");
+ mysqli_query($link, "INSERT INTO test_bind_fetch VALUES ('1234567892',
'this is a test2')");
+ mysqli_query($link, "INSERT INTO test_bind_fetch VALUES ('1234567893',
'this is a test3')");
- $stmt = mysqli_prepare($link, "SELECT * FROM test_bind_fetch");
+ $stmt = mysqli_prepare($link, "SELECT * FROM test_bind_fetch ORDER BY
c1");
mysqli_bind_result($stmt, $c1, $c2);
mysqli_execute($stmt);
- mysqli_fetch($stmt);
+ $i=4;
+ while ($i--) {
+ mysqli_fetch($stmt);
+ $test = array($c1,$c2);
+ var_dump($test);
+ }
- $test = array($c1,$c2);
-
- var_dump($test);
mysqli_stmt_close($stmt);
mysqli_close($link);
@@ -33,5 +38,23 @@
[0]=>
string(10) "1234567890"
[1]=>
- string(14) "this is a test"
+ string(15) "this is a test0"
+}
+array(2) {
+ [0]=>
+ string(10) "1234567891"
+ [1]=>
+ string(15) "this is a test1"
+}
+array(2) {
+ [0]=>
+ string(10) "1234567892"
+ [1]=>
+ string(15) "this is a test2"
+}
+array(2) {
+ [0]=>
+ string(10) "1234567893"
+ [1]=>
+ string(15) "this is a test3"
}
--
PHP CVS Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
