diff options
Diffstat (limited to 'tests/fetch.phpt')
| -rw-r--r-- | tests/fetch.phpt | 76 |
1 files changed, 76 insertions, 0 deletions
diff --git a/tests/fetch.phpt b/tests/fetch.phpt new file mode 100644 index 0000000000..5206324940 --- /dev/null +++ b/tests/fetch.phpt @@ -0,0 +1,76 @@ +--TEST-- +ocifetch() & ociresult() +--SKIPIF-- +<?php if (!extension_loaded('oci8')) die("skip no oci8 extension"); ?> +--FILE-- +<?php + +require(dirname(__FILE__)."/connect.inc"); + +// Initialize + +$stmtarray = array( + "drop table fetch_tab", + "create table fetch_tab (id number, value number)", + "insert into fetch_tab (id, value) values (1,1)", + "insert into fetch_tab (id, value) values (1,1)", + "insert into fetch_tab (id, value) values (1,1)", +); + +foreach ($stmtarray as $stmt) { + $s = oci_parse($c, $stmt); + $r = @oci_execute($s); + if (!$r) { + $m = oci_error($s); + if (!in_array($m['code'], array( // ignore expected errors + 942 // table or view does not exist + ))) { + echo $stmt . PHP_EOL . $m['message'] . PHP_EOL; + } + } +} + +foreach ($stmtarray as $stmt) { + $s = oci_parse($c, $stmt); + oci_execute($s); +} + +// Run Test + +if (!($s = oci_parse($c, "select * from fetch_tab"))) { + die("oci_parse(select) failed!\n"); +} + +if (!oci_execute($s)) { + die("oci_execute(select) failed!\n"); +} + +while(ocifetch($s)) { + $row = ociresult($s, 1); + $row1 = ociresult($s, 2); + var_dump($row); + var_dump($row1); +} + +// Cleanup + +$stmtarray = array( + "drop table fetch_tab" +); + +foreach ($stmtarray as $stmt) { + $s = oci_parse($c, $stmt); + oci_execute($s); +} + + +echo "Done\n"; +?> +--EXPECTF-- +%unicode|string%(1) "1" +%unicode|string%(1) "1" +%unicode|string%(1) "1" +%unicode|string%(1) "1" +%unicode|string%(1) "1" +%unicode|string%(1) "1" +Done |