diff options
| author | Andrey Hristov <andrey@php.net> | 2006-01-01 16:52:05 +0000 |
|---|---|---|
| committer | Andrey Hristov <andrey@php.net> | 2006-01-01 16:52:05 +0000 |
| commit | d03aea048f23be8f2ffb72e08ededa731e502c97 (patch) | |
| tree | b0a2b35077bb96aacaee6b22b6cb3e3bcce47a20 | |
| parent | 62b9a736bf69e6a35822fba6beb35e09edf1b00d (diff) | |
| download | php-git-d03aea048f23be8f2ffb72e08ededa731e502c97.tar.gz | |
fetch more than one row at once
| -rw-r--r-- | ext/mysqli/tests/004.phpt | 37 |
1 files changed, 30 insertions, 7 deletions
diff --git a/ext/mysqli/tests/004.phpt b/ext/mysqli/tests/004.phpt index c80c7214e3..fafc30ba0d 100644 --- a/ext/mysqli/tests/004.phpt +++ b/ext/mysqli/tests/004.phpt @@ -14,16 +14,21 @@ mysqli fetch char/text 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 @@ array(2) { [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" } |