xref: /PHP-7.0/ext/oci8/tests/fetch.phpt (revision bfc3c223)
1--TEST--
2ocifetch() & ociresult()
3--SKIPIF--
4<?php if (!extension_loaded('oci8')) die("skip no oci8 extension"); ?>
5--FILE--
6<?php
7
8require(dirname(__FILE__)."/connect.inc");
9
10// Initialize
11
12$stmtarray = array(
13    "drop table fetch_tab",
14    "create table fetch_tab (id number, value number)",
15    "insert into fetch_tab (id, value) values (1,1)",
16    "insert into fetch_tab (id, value) values (1,1)",
17    "insert into fetch_tab (id, value) values (1,1)",
18);
19
20oci8_test_sql_execute($c, $stmtarray);
21
22// Run Test
23
24if (!($s = oci_parse($c, "select * from fetch_tab"))) {
25	die("oci_parse(select) failed!\n");
26}
27
28if (!oci_execute($s)) {
29	die("oci_execute(select) failed!\n");
30}
31
32while(ocifetch($s)) {
33		$row = ociresult($s, 1);
34		$row1 = ociresult($s, 2);
35		var_dump($row);
36		var_dump($row1);
37}
38
39// Cleanup
40
41$stmtarray = array(
42    "drop table fetch_tab"
43);
44
45oci8_test_sql_execute($c, $stmtarray);
46
47echo "Done\n";
48?>
49--EXPECTF--
50string(1) "1"
51string(1) "1"
52string(1) "1"
53string(1) "1"
54string(1) "1"
55string(1) "1"
56Done
57