Annotation of embedaddon/php/ext/oci8/tests/fetch_into1.phpt, revision 1.1.1.1
1.1 misho 1: --TEST--
2: various ocifetchinto() tests
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: require dirname(__FILE__).'/create_table.inc';
13:
14: $insert_sql = "INSERT INTO ".$schema."".$table_name." (id, value, string) VALUES (1, 1, NULL)";
15:
16: if (!($s = oci_parse($c, $insert_sql))) {
17: die("oci_parse(insert) failed!\n");
18: }
19:
20: for ($i = 0; $i<20; $i++) {
21: if (!oci_execute($s)) {
22: die("oci_execute(insert) failed!\n");
23: }
24: }
25:
26: if (!oci_commit($c)) {
27: die("oci_commit() failed!\n");
28: }
29:
30: $select_sql = "SELECT * FROM ".$schema."".$table_name."";
31:
32: if (!($s = oci_parse($c, $select_sql))) {
33: die("oci_parse(select) failed!\n");
34: }
35:
36: if (!oci_execute($s)) {
37: die("oci_execute(select) failed!\n");
38: }
39: var_dump(ocifetchinto($s, $all, OCI_NUM));
40: var_dump($all);
41: var_dump(ocifetchinto($s, $all, OCI_ASSOC));
42: var_dump($all);
43: var_dump(ocifetchinto($s, $all, OCI_RETURN_NULLS));
44: var_dump($all);
45: var_dump(ocifetchinto($s, $all, OCI_RETURN_LOBS));
46: var_dump($all);
47: var_dump(ocifetchinto($s, $all, OCI_NUM+OCI_ASSOC));
48: var_dump($all);
49: var_dump(ocifetchinto($s, $all, OCI_NUM+OCI_ASSOC+OCI_RETURN_NULLS));
50: var_dump($all);
51: var_dump(ocifetchinto($s, $all, OCI_NUM+OCI_ASSOC+OCI_RETURN_NULLS+OCI_RETURN_LOBS));
52: var_dump($all);
53: var_dump(ocifetchinto($s, $all, OCI_RETURN_NULLS+OCI_RETURN_LOBS));
54: var_dump($all);
55: var_dump(ocifetchinto($s, $all, OCI_ASSOC+OCI_RETURN_NULLS+OCI_RETURN_LOBS));
56: var_dump($all);
57: var_dump(ocifetchinto($s, $all, OCI_NUM+OCI_RETURN_NULLS+OCI_RETURN_LOBS));
58: var_dump($all);
59:
60: require dirname(__FILE__).'/drop_table.inc';
61:
62: echo "Done\n";
63: ?>
64: --EXPECT--
65: int(5)
66: array(2) {
67: [0]=>
68: string(1) "1"
69: [1]=>
70: string(1) "1"
71: }
72: int(5)
73: array(2) {
74: ["ID"]=>
75: string(1) "1"
76: ["VALUE"]=>
77: string(1) "1"
78: }
79: int(5)
80: array(5) {
81: [0]=>
82: string(1) "1"
83: [1]=>
84: string(1) "1"
85: [2]=>
86: NULL
87: [3]=>
88: NULL
89: [4]=>
90: NULL
91: }
92: int(5)
93: array(2) {
94: [0]=>
95: string(1) "1"
96: [1]=>
97: string(1) "1"
98: }
99: int(5)
100: array(4) {
101: [0]=>
102: string(1) "1"
103: ["ID"]=>
104: string(1) "1"
105: [1]=>
106: string(1) "1"
107: ["VALUE"]=>
108: string(1) "1"
109: }
110: int(5)
111: array(10) {
112: [0]=>
113: string(1) "1"
114: ["ID"]=>
115: string(1) "1"
116: [1]=>
117: string(1) "1"
118: ["VALUE"]=>
119: string(1) "1"
120: [2]=>
121: NULL
122: ["BLOB"]=>
123: NULL
124: [3]=>
125: NULL
126: ["CLOB"]=>
127: NULL
128: [4]=>
129: NULL
130: ["STRING"]=>
131: NULL
132: }
133: int(5)
134: array(10) {
135: [0]=>
136: string(1) "1"
137: ["ID"]=>
138: string(1) "1"
139: [1]=>
140: string(1) "1"
141: ["VALUE"]=>
142: string(1) "1"
143: [2]=>
144: NULL
145: ["BLOB"]=>
146: NULL
147: [3]=>
148: NULL
149: ["CLOB"]=>
150: NULL
151: [4]=>
152: NULL
153: ["STRING"]=>
154: NULL
155: }
156: int(5)
157: array(5) {
158: [0]=>
159: string(1) "1"
160: [1]=>
161: string(1) "1"
162: [2]=>
163: NULL
164: [3]=>
165: NULL
166: [4]=>
167: NULL
168: }
169: int(5)
170: array(5) {
171: ["ID"]=>
172: string(1) "1"
173: ["VALUE"]=>
174: string(1) "1"
175: ["BLOB"]=>
176: NULL
177: ["CLOB"]=>
178: NULL
179: ["STRING"]=>
180: NULL
181: }
182: int(5)
183: array(5) {
184: [0]=>
185: string(1) "1"
186: [1]=>
187: string(1) "1"
188: [2]=>
189: NULL
190: [3]=>
191: NULL
192: [4]=>
193: NULL
194: }
195: Done
FreeBSD-CVSweb <freebsd-cvsweb@FreeBSD.org>