A basic example to fetch results oci_fetch_array : Oracle : Databases PHP Source Code

PHP Source Code » Databases » Oracle »


A basic example to fetch results oci_fetch_array

In an associative array there is no table prefix for the column name. If you join tables where the same column name occurs with different meanings in both tables, use a column alias in the query. Otherwise only one of the similarly named columns will be returned by PHP:
Note: Numbers and dates are fetched as strings and the Oracle globalization settings may affect their formatting. Refer to the chapter Globalization for more information.
Some of the fetch functions do not return NULL data by default. This can be tricky when using numerically indexed arrays. The result array can appear to have fewer columns than selected, and you can’t always tell which column was NULL. Either use associative arrays so the column names are directly associated with their values, or specify the OCI_RETURN_NULLS flag:
$res = oci_fetch_array($s, OCI_NUM+OCI_RETURN_NULLS);
$s oci_parse($c"select region_name,
           regions.region_id as myreg,
            from countries
            inner join regions
            on countries.region_id = regions.region_id"
while (
$res oci_fetch_array($s)) {
$res["REGION_NAME"] . " " $res["MYREG"] . " - " .
$res["COUNTRY_NAME"] . " " $res["REGION_ID"] . " " .
The query column alias MYREG is used as the index to the result array. The script output is:
Americas 2 - Argentina 2
Asia 3 - Australia 3
Europe 1 - Belgium 1
Americas 2 - Brazil 2
Americas 2 - Canada 2

HTML code for linking to this page:

Follow Navioo On Twitter

PHP Source Code

 Navioo Databases
» Oracle