adodb-oci8po.inc.php

Go to the documentation of this file.

<?php
/*
@version   v5.20.3  01-Jan-2016
@copyright (c) 2000-2013 John Lim. All rights reserved.
@copyright (c) 2014      Damien Regad, Mark Newnham and the ADOdb community
  Released under both BSD license and Lesser GPL library license.
  Whenever there is any discrepancy between the two licenses,
  the BSD license will take precedence.

  Latest version is available at http://adodb.sourceforge.net

  Portable version of oci8 driver, to make it more similar to other database drivers.
  The main differences are

   1. that the OCI_ASSOC names are in lowercase instead of uppercase.
   2. bind variables are mapped using ? instead of :<bindvar>

   Should some emulation of RecordCount() be implemented?

*/

// security - hide paths
if (!defined('ADODB_DIR')) die();

include_once(ADODB_DIR.'/drivers/adodb-oci8.inc.php');

class ADODB_oci8po extends ADODB_oci8 {
    var $databaseType = 'oci8po';
    var $dataProvider = 'oci8';
    var $metaColumnsSQL = "select lower(cname),coltype,width, SCALE, PRECISION, NULLS, DEFAULTVAL from col where tname='%s' order by colno"; //changed by smondino@users.sourceforge. net
    var $metaTablesSQL = "select lower(table_name),table_type from cat where table_type in ('TABLE','VIEW')";

    function __construct()
    {
        $this->_hasOCIFetchStatement = ADODB_PHPVER >= 0x4200;
        # oci8po does not support adodb extension: adodb_movenext()
    }

    function Param($name,$type='C')
    {
        return '?';
    }

    function Prepare($sql,$cursor=false)
    {
        $sqlarr = explode('?',$sql);
        $sql = $sqlarr[0];
        for ($i = 1, $max = sizeof($sqlarr); $i < $max; $i++) {
            $sql .=  ':'.($i-1) . $sqlarr[$i];
        }
        return ADODB_oci8::Prepare($sql,$cursor);
    }

    function Execute($sql,$inputarr=false)
    {
        return ADOConnection::Execute($sql,$inputarr);
    }

    // emulate handling of parameters ? ?, replacing with :bind0 :bind1
    function _query($sql,$inputarr=false)
    {
        if (is_array($inputarr)) {
            $i = 0;
            if (is_array($sql)) {
                foreach($inputarr as $v) {
                    $arr['bind'.$i++] = $v;
                }
            } else {
                // Need to identify if the ? is inside a quoted string, and if
                // so not use it as a bind variable
                preg_match_all('/".*\??"|\'.*\?.*?\'/', $sql, $matches);
                foreach($matches[0] as $qmMatch){
                    $qmReplace = str_replace('?', '-QUESTIONMARK-', $qmMatch);
                    $sql = str_replace($qmMatch, $qmReplace, $sql);
                }

                $sqlarr = explode('?',$sql);
                $sql = $sqlarr[0];

                foreach($inputarr as $k => $v) {
                    $sql .=  ":$k" . $sqlarr[++$i];
                }

                $sql = str_replace('-QUESTIONMARK-', '?', $sql);
            }
        }
        return ADODB_oci8::_query($sql,$inputarr);
    }
}

/*--------------------------------------------------------------------------------------
         Class Name: Recordset
--------------------------------------------------------------------------------------*/

class ADORecordset_oci8po extends ADORecordset_oci8 {

    var $databaseType = 'oci8po';

    function __construct($queryID,$mode=false)
    {
        parent::__construct($queryID,$mode);
    }

    function Fields($colname)
    {
        if ($this->fetchMode & OCI_ASSOC) return $this->fields[$colname];

        if (!$this->bind) {
            $this->bind = array();
            for ($i=0; $i < $this->_numOfFields; $i++) {
                $o = $this->FetchField($i);
                $this->bind[strtoupper($o->name)] = $i;
            }
        }
         return $this->fields[$this->bind[strtoupper($colname)]];
    }

    // lowercase field names...
    function _FetchField($fieldOffset = -1)
    {
        $fld = new ADOFieldObject;
        $fieldOffset += 1;
        $fld->name = OCIcolumnname($this->_queryID, $fieldOffset);
        if (ADODB_ASSOC_CASE == ADODB_ASSOC_CASE_LOWER) {
            $fld->name = strtolower($fld->name);
        }
        $fld->type = OCIcolumntype($this->_queryID, $fieldOffset);
        $fld->max_length = OCIcolumnsize($this->_queryID, $fieldOffset);
        if ($fld->type == 'NUMBER') {
            $sc = OCIColumnScale($this->_queryID, $fieldOffset);
            if ($sc == 0) {
                $fld->type = 'INT';
            }
        }
        return $fld;
    }

    // 10% speedup to move MoveNext to child class
    function MoveNext()
    {
        if(@OCIfetchinto($this->_queryID,$this->fields,$this->fetchMode)) {
        global $ADODB_ANSI_PADDING_OFF;
            $this->_currentRow++;
            $this->_updatefields();

            if (!empty($ADODB_ANSI_PADDING_OFF)) {
                foreach($this->fields as $k => $v) {
                    if (is_string($v)) $this->fields[$k] = rtrim($v);
                }
            }
            return true;
        }
        if (!$this->EOF) {
            $this->EOF = true;
            $this->_currentRow++;
        }
        return false;
    }

    /* Optimize SelectLimit() by using OCIFetch() instead of OCIFetchInto() */
    function GetArrayLimit($nrows,$offset=-1)
    {
        if ($offset <= 0) {
            $arr = $this->GetArray($nrows);
            return $arr;
        }
        for ($i=1; $i < $offset; $i++)
            if (!@OCIFetch($this->_queryID)) {
                $arr = array();
                return $arr;
            }
        if (!@OCIfetchinto($this->_queryID,$this->fields,$this->fetchMode)) {
            $arr = array();
            return $arr;
        }
        $this->_updatefields();
        $results = array();
        $cnt = 0;
        while (!$this->EOF && $nrows != $cnt) {
            $results[$cnt++] = $this->fields;
            $this->MoveNext();
        }

        return $results;
    }

    function _fetch()
    {
        global $ADODB_ANSI_PADDING_OFF;

        $ret = @OCIfetchinto($this->_queryID,$this->fields,$this->fetchMode);
        if ($ret) {
            $this->_updatefields();

            if (!empty($ADODB_ANSI_PADDING_OFF)) {
                foreach($this->fields as $k => $v) {
                    if (is_string($v)) $this->fields[$k] = rtrim($v);
                }
            }
        }
        return $ret;
    }

}