xref: /PHP-7.4/ext/oci8/tests/fetch_into.phpt (revision 26dfce7f)
1--TEST--
2ocifetchinto()
3--SKIPIF--
4<?php if (!extension_loaded('oci8')) die("skip no oci8 extension"); ?>
5--FILE--
6<?php
7
8require(__DIR__."/connect.inc");
9
10// Initialize
11
12$stmtarray = array(
13    "drop table fetch_into_tab",
14    "create table fetch_into_tab (id number, value number)",
15    "insert into fetch_into_tab (id, value) values (1,1)",
16    "insert into fetch_into_tab (id, value) values (1,1)",
17    "insert into fetch_into_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_into_tab"))) {
25	die("oci_parse(select) failed!\n");
26}
27
28/* ocifetchinto */
29if (!oci_execute($s)) {
30	die("oci_execute(select) failed!\n");
31}
32var_dump(ocifetchinto($s, $all));
33var_dump($all);
34
35/* ocifetchinto */
36if (!oci_execute($s)) {
37	die("oci_execute(select) failed!\n");
38}
39var_dump(ocifetchinto($s, $all, OCI_NUM+OCI_ASSOC+OCI_RETURN_NULLS+OCI_RETURN_LOBS));
40var_dump($all);
41
42// Cleanup
43
44$stmtarray = array(
45    "drop table fetch_into_tab"
46);
47
48oci8_test_sql_execute($c, $stmtarray);
49
50echo "Done\n";
51?>
52--EXPECT--
53int(2)
54array(2) {
55  [0]=>
56  string(1) "1"
57  [1]=>
58  string(1) "1"
59}
60int(2)
61array(4) {
62  [0]=>
63  string(1) "1"
64  ["ID"]=>
65  string(1) "1"
66  [1]=>
67  string(1) "1"
68  ["VALUE"]=>
69  string(1) "1"
70}
71Done
72