2
oci_fetch_all() - all combinations of flags
4
<?php if (!extension_loaded('oci8')) die("skip no oci8 extension"); ?>
8
require dirname(__FILE__)."/connect.inc";
9
require dirname(__FILE__).'/create_table.inc';
11
$insert_sql = "INSERT INTO ".$schema."".$table_name." (id, value) VALUES (:idbv,:vbv)";
13
$s = oci_parse($c, $insert_sql);
14
oci_bind_by_name($s, ":idbv", $idbv, SQLT_INT);
15
oci_bind_by_name($s, ":vbv", $vbv, SQLT_INT);
17
for ($i = 1; $i <= 4; $i++) {
20
oci_execute($s, OCI_DEFAULT);
25
$select_sql = "SELECT ID, VALUE FROM ".$schema."".$table_name." order by id";
27
$s = oci_parse($c, $select_sql);
31
var_dump(oci_fetch_all($s, $all, 0, -1));
36
var_dump(oci_fetch_all($s, $all, 0, -1, OCI_ASSOC));
39
echo "OCI_FETCHSTATEMENT_BY_COLUMN\n";
41
var_dump(oci_fetch_all($s, $all, 0, -1, OCI_FETCHSTATEMENT_BY_COLUMN));
44
echo "OCI_FETCHSTATEMENT_BY_COLUMN|OCI_ASSOC\n";
46
var_dump(oci_fetch_all($s, $all, 0, -1, OCI_FETCHSTATEMENT_BY_COLUMN|OCI_ASSOC));
49
echo "OCI_FETCHSTATEMENT_BY_COLUMN|OCI_NUM\n";
51
var_dump(oci_fetch_all($s, $all, 0, -1, OCI_FETCHSTATEMENT_BY_COLUMN|OCI_NUM));
54
echo "OCI_FETCHSTATEMENT_BY_COLUMN|OCI_NUM|OCI_ASSOC\n";
56
var_dump(oci_fetch_all($s, $all, 0, -1, OCI_FETCHSTATEMENT_BY_COLUMN|OCI_NUM|OCI_ASSOC));
59
echo "OCI_FETCHSTATEMENT_BY_ROW\n";
61
var_dump(oci_fetch_all($s, $all, 0, -1, OCI_FETCHSTATEMENT_BY_ROW));
64
echo "OCI_FETCHSTATEMENT_BY_ROW|OCI_ASSOC\n";
66
var_dump(oci_fetch_all($s, $all, 0, -1, OCI_FETCHSTATEMENT_BY_ROW|OCI_ASSOC));
69
echo "OCI_FETCHSTATEMENT_BY_ROW|OCI_FETCHSTATEMENT_BY_COLUMN\n";
71
var_dump(oci_fetch_all($s, $all, 0, -1, OCI_FETCHSTATEMENT_BY_ROW|OCI_FETCHSTATEMENT_BY_COLUMN));
74
echo "OCI_FETCHSTATEMENT_BY_ROW|OCI_FETCHSTATEMENT_BY_COLUMN|OCI_ASSOC\n";
76
var_dump(oci_fetch_all($s, $all, 0, -1, OCI_FETCHSTATEMENT_BY_ROW|OCI_FETCHSTATEMENT_BY_COLUMN|OCI_ASSOC));
79
echo "OCI_FETCHSTATEMENT_BY_ROW|OCI_FETCHSTATEMENT_BY_COLUMN|OCI_NUM\n";
81
var_dump(oci_fetch_all($s, $all, 0, -1, OCI_FETCHSTATEMENT_BY_ROW|OCI_FETCHSTATEMENT_BY_COLUMN|OCI_NUM));
84
echo "OCI_FETCHSTATEMENT_BY_ROW|OCI_FETCHSTATEMENT_BY_COLUMN|OCI_NUM|OCI_ASSOC\n";
86
var_dump(oci_fetch_all($s, $all, 0, -1, OCI_FETCHSTATEMENT_BY_ROW|OCI_FETCHSTATEMENT_BY_COLUMN|OCI_NUM|OCI_ASSOC));
89
echo "OCI_FETCHSTATEMENT_BY_ROW|OCI_NUM\n";
91
var_dump(oci_fetch_all($s, $all, 0, -1, OCI_FETCHSTATEMENT_BY_ROW|OCI_NUM));
94
echo "OCI_FETCHSTATEMENT_BY_ROW|OCI_NUM|OCI_ASSOC\n";
96
var_dump(oci_fetch_all($s, $all, 0, -1, OCI_FETCHSTATEMENT_BY_ROW|OCI_NUM|OCI_ASSOC));
101
var_dump(oci_fetch_all($s, $all, 0, -1, OCI_NUM));
104
echo "OCI_NUM|OCI_ASSOC\n";
106
var_dump(oci_fetch_all($s, $all, 0, -1, OCI_NUM|OCI_ASSOC));
108
require dirname(__FILE__).'/drop_table.inc';
165
OCI_FETCHSTATEMENT_BY_COLUMN
191
OCI_FETCHSTATEMENT_BY_COLUMN|OCI_ASSOC
217
OCI_FETCHSTATEMENT_BY_COLUMN|OCI_NUM
243
OCI_FETCHSTATEMENT_BY_COLUMN|OCI_NUM|OCI_ASSOC
269
OCI_FETCHSTATEMENT_BY_ROW
301
OCI_FETCHSTATEMENT_BY_ROW|OCI_ASSOC
333
OCI_FETCHSTATEMENT_BY_ROW|OCI_FETCHSTATEMENT_BY_COLUMN
365
OCI_FETCHSTATEMENT_BY_ROW|OCI_FETCHSTATEMENT_BY_COLUMN|OCI_ASSOC
397
OCI_FETCHSTATEMENT_BY_ROW|OCI_FETCHSTATEMENT_BY_COLUMN|OCI_NUM
429
OCI_FETCHSTATEMENT_BY_ROW|OCI_FETCHSTATEMENT_BY_COLUMN|OCI_NUM|OCI_ASSOC
461
OCI_FETCHSTATEMENT_BY_ROW|OCI_NUM
493
OCI_FETCHSTATEMENT_BY_ROW|OCI_NUM|OCI_ASSOC