Annotation of embedaddon/php/ext/oci8/tests/fetch_object_1.phpt, revision 1.1.1.1
1.1 misho 1: --TEST--
2: oci_fetch_object()
3: --SKIPIF--
4: <?php
5: $target_dbs = array('oracledb' => true, 'timesten' => false); // test runs on these DBs
6: require(dirname(__FILE__).'/skipif.inc');
7: ?>
8: --FILE--
9: <?php
10:
11: require(dirname(__FILE__).'/connect.inc');
12:
13: // Initialization
14:
15: $stmtarray = array(
16: "drop table fetch_object_tab",
17: "create table fetch_object_tab (\"caseSensitive\" number, secondcol varchar2(20), anothercol char(15))",
18: "insert into fetch_object_tab values (123, '1st row col2 string', '1 more text')",
19: "insert into fetch_object_tab values (456, '2nd row col2 string', '2 more text')",
20: "insert into fetch_object_tab values (789, '3rd row col2 string', '3 more text')",
21: );
22:
23: oci8_test_sql_execute($c, $stmtarray);
24:
25: // Run Test
26:
27: echo "Test 1\n";
28:
29: if (!($s = oci_parse($c, 'select * from fetch_object_tab'))) {
30: die("oci_parse(select) failed!\n");
31: }
32:
33: if (!oci_execute($s)) {
34: die("oci_execute(select) failed!\n");
35: }
36:
37: while ($row = oci_fetch_object($s)) {
38: var_dump($row);
39: }
40:
41: echo "Test 2\n";
42:
43: if (!($s = oci_parse($c, 'select * from fetch_object_tab'))) {
44: die("oci_parse(select) failed!\n");
45: }
46:
47: if (!oci_execute($s)) {
48: die("oci_execute(select) failed!\n");
49: }
50:
51: while ($row = oci_fetch_object($s)) {
52: echo $row->caseSensitive . "\n";
53: echo $row->SECONDCOL . "\n";
54: echo $row->ANOTHERCOL . "\n";
55: }
56:
57: echo "Test 3\n";
58:
59: if (!($s = oci_parse($c, 'select * from fetch_object_tab where rownum < 2 order by "caseSensitive"'))) {
60: die("oci_parse(select) failed!\n");
61: }
62:
63: if (!oci_execute($s)) {
64: die("oci_execute(select) failed!\n");
65: }
66:
67: $row = oci_fetch_object($s);
68: echo $row->caseSensitive . "\n";
69: echo $row->CASESENSITIVE . "\n";
70:
71: // Clean up
72:
73: $stmtarray = array(
74: "drop table fetch_object_tab"
75: );
76:
77: oci8_test_sql_execute($c, $stmtarray);
78:
79: ?>
80: ===DONE===
81: <?php exit(0); ?>
82: --EXPECTF--
83: Test 1
84: object(stdClass)#%d (3) {
85: ["caseSensitive"]=>
86: string(3) "123"
87: ["SECONDCOL"]=>
88: string(19) "1st row col2 string"
89: ["ANOTHERCOL"]=>
90: string(15) "1 more text "
91: }
92: object(stdClass)#%d (3) {
93: ["caseSensitive"]=>
94: string(3) "456"
95: ["SECONDCOL"]=>
96: string(19) "2nd row col2 string"
97: ["ANOTHERCOL"]=>
98: string(15) "2 more text "
99: }
100: object(stdClass)#%d (3) {
101: ["caseSensitive"]=>
102: string(3) "789"
103: ["SECONDCOL"]=>
104: string(19) "3rd row col2 string"
105: ["ANOTHERCOL"]=>
106: string(15) "3 more text "
107: }
108: Test 2
109: 123
110: 1st row col2 string
111: 1 more text
112: 456
113: 2nd row col2 string
114: 2 more text
115: 789
116: 3rd row col2 string
117: 3 more text
118: Test 3
119: 123
120:
121: Notice: Undefined property: stdClass::$CASESENSITIVE in %sfetch_object_1.php on line %d
122:
123: ===DONE===
FreeBSD-CVSweb <freebsd-cvsweb@FreeBSD.org>