Gecko [ v3.cesa.co.za ]

Name	Size	Permission	Date
adodb-access.inc.php	2.15 KB	-rw-r--r--	2023-01-22 09:53
adodb-ado.inc.php	16.24 KB	-rw-r--r--	2023-01-22 09:53
adodb-ado5.inc.php	17.33 KB	-rw-r--r--	2023-01-22 09:53
adodb-ado_access.inc.php	1.48 KB	-rw-r--r--	2023-01-22 09:53
adodb-ado_mssql.inc.php	4.02 KB	-rw-r--r--	2023-01-22 09:53
adodb-ads.inc.php	19.39 KB	-rw-r--r--	2023-01-22 09:53
adodb-borland_ibase.inc.php	2.43 KB	-rw-r--r--	2023-01-22 09:53
adodb-csv.inc.php	5.09 KB	-rw-r--r--	2023-01-22 09:53
adodb-db2.inc.php	44.36 KB	-rw-r--r--	2023-01-22 09:53
adodb-db2oci.inc.php	4.31 KB	-rw-r--r--	2023-01-22 09:53
adodb-db2ora.inc.php	2.23 KB	-rw-r--r--	2023-01-22 09:53
adodb-fbsql.inc.php	6.84 KB	-rw-r--r--	2023-01-22 09:53
adodb-firebird.inc.php	33.07 KB	-rw-r--r--	2023-01-22 09:53
adodb-ibase.inc.php	22.51 KB	-rw-r--r--	2023-01-22 09:53
adodb-informix.inc.php	1.21 KB	-rw-r--r--	2023-01-22 09:53
adodb-informix72.inc.php	14.9 KB	-rw-r--r--	2023-01-22 09:53
adodb-ldap.inc.php	10.93 KB	-rw-r--r--	2023-01-22 09:53
adodb-mssql.inc.php	30.66 KB	-rw-r--r--	2023-01-22 09:53
adodb-mssql_n.inc.php	7.75 KB	-rw-r--r--	2023-01-22 09:53
adodb-mssqlnative.inc.php	34.74 KB	-rw-r--r--	2023-01-22 09:53
adodb-mssqlpo.inc.php	1.41 KB	-rw-r--r--	2023-01-22 09:53
adodb-mysqli.inc.php	50.3 KB	-rw-r--r--	2023-01-22 09:53
adodb-netezza.inc.php	5.12 KB	-rw-r--r--	2023-01-22 09:53
adodb-oci8.inc.php	47.83 KB	-rw-r--r--	2023-01-22 09:53
adodb-oci805.inc.php	1.79 KB	-rw-r--r--	2023-01-22 09:53
adodb-oci8po.inc.php	7.12 KB	-rw-r--r--	2023-01-22 09:53
adodb-oci8quercus.inc.php	2.3 KB	-rw-r--r--	2023-01-22 09:53
adodb-odbc.inc.php	18.56 KB	-rw-r--r--	2023-01-22 09:53
adodb-odbc_db2.inc.php	6.87 KB	-rw-r--r--	2023-01-22 09:53
adodb-odbc_mssql.inc.php	12.34 KB	-rw-r--r--	2023-01-22 09:53
adodb-odbc_mssql2012.inc.php	1.08 KB	-rw-r--r--	2023-01-22 09:53
adodb-odbc_oracle.inc.php	3.34 KB	-rw-r--r--	2023-01-22 09:53
adodb-odbtp.inc.php	23.2 KB	-rw-r--r--	2023-01-22 09:53
adodb-odbtp_unicode.inc.php	1.42 KB	-rw-r--r--	2023-01-22 09:53
adodb-oracle.inc.php	9.39 KB	-rw-r--r--	2023-01-22 09:53
adodb-pdo.inc.php	20.79 KB	-rw-r--r--	2023-01-22 09:53
adodb-pdo_dblib.inc.php	5.8 KB	-rw-r--r--	2023-01-22 09:53
adodb-pdo_firebird.inc.php	10.76 KB	-rw-r--r--	2023-01-22 09:53
adodb-pdo_mssql.inc.php	1.84 KB	-rw-r--r--	2023-01-22 09:53
adodb-pdo_mysql.inc.php	9.84 KB	-rw-r--r--	2023-01-22 09:53
adodb-pdo_oci.inc.php	3.41 KB	-rw-r--r--	2023-01-22 09:53
adodb-pdo_pgsql.inc.php	10.2 KB	-rw-r--r--	2023-01-22 09:53
adodb-pdo_sqlite.inc.php	6.33 KB	-rw-r--r--	2023-01-22 09:53
adodb-pdo_sqlsrv.inc.php	4.5 KB	-rw-r--r--	2023-01-22 09:53
adodb-postgres.inc.php	1008 B	-rw-r--r--	2023-01-22 09:53
adodb-postgres64.inc.php	32.3 KB	-rw-r--r--	2023-01-22 09:53
adodb-postgres7.inc.php	9.27 KB	-rw-r--r--	2023-01-22 09:53
adodb-postgres8.inc.php	2.1 KB	-rw-r--r--	2023-01-22 09:53
adodb-postgres9.inc.php	1.13 KB	-rw-r--r--	2023-01-22 09:53
adodb-proxy.inc.php	1.12 KB	-rw-r--r--	2023-01-22 09:53
adodb-sapdb.inc.php	5 KB	-rw-r--r--	2023-01-22 09:53
adodb-sqlanywhere.inc.php	3.43 KB	-rw-r--r--	2023-01-22 09:53
adodb-sqlite.inc.php	11.83 KB	-rw-r--r--	2023-01-22 09:53
adodb-sqlite3.inc.php	18.66 KB	-rw-r--r--	2023-01-22 09:53
adodb-sqlitepo.inc.php	2.05 KB	-rw-r--r--	2023-01-22 09:53
adodb-sybase.inc.php	12.27 KB	-rw-r--r--	2023-01-22 09:53
adodb-sybase_ase.inc.php	3.5 KB	-rw-r--r--	2023-01-22 09:53
adodb-text.inc.php	8.14 KB	-rw-r--r--	2023-01-22 09:53
adodb-vfp.inc.php	2.6 KB	-rw-r--r--	2023-01-22 09:53

Rename

<?php
/**
 * Portable version of Oracle oci8 driver
 *
 * This file is part of ADOdb, a Database Abstraction Layer library for PHP.
 *
 * 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>
 *
 * @package ADOdb
 * @link https://adodb.org Project's web site and documentation
 * @link https://github.com/ADOdb/ADOdb Source code and issue tracker
 *
 * The ADOdb Library is dual-licensed, released under both the BSD 3-Clause
 * and the GNU Lesser General Public Licence (LGPL) v2.1 or, at your option,
 * any later version. This means you can use it in proprietary products.
 * See the LICENSE.md file distributed with this source code for details.
 * @license BSD-3-Clause
 * @license LGPL-2.1-or-later
 *
 * @copyright 2000-2013 John Lim
 * @copyright 2014 Damien Regad, Mark Newnham and the ADOdb community
 */

// 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 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);
	}

/**
	 * The optimizations performed by ADODB_oci8::SelectLimit() are not
	 * compatible with the oci8po driver, so we rely on the slower method
	 * from the base class.
	 * We can't properly handle prepared statements either due to preprocessing
	 * of query parameters, so we treat them as regular SQL statements.
	 */
	function SelectLimit($sql, $nrows=-1, $offset=-1, $inputarr=false, $secs2cache=0)
	{
		if(is_array($sql)) {
//			$sql = $sql[0];
		}
		return ADOConnection::SelectLimit($sql, $nrows, $offset, $inputarr, $secs2cache);
	}

// 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 {
				$sql = $this->extractBinds($sql,$inputarr);
			}
		}
		return ADODB_oci8::_query($sql,$inputarr);
	}

/**
	* Replaces compatibility bind markers with oracle ones and returns a
	* valid sql statement
	*
	* This replaces a regexp based section of code that has been subject
	* to numerous tweaks, as more extreme test cases have appeared. This
	* is now done this like this to help maintainability and avoid the
	* need to rely on regexp experienced maintainers
	*
	* @param	string		$sql		The sql statement
	* @param	string[]	$inputarr	The bind array
	*
	* @return	string	The modified statement
	*/
	private function extractBinds($sql,$inputarr)
	{
		$inString  = false;
		$escaped   = 0;
		$sqlLength = strlen($sql) - 1;
		$newSql    = '';
		$bindCount = 0;

/*
		* inputarr is the passed in bind list, which is associative, but
		* we only want the keys here
		*/
		$inputKeys = array_keys($inputarr);

for ($i=0;$i<=$sqlLength;$i++)
		{
			/*
			* find the next character of the string
			*/
			$c = $sql[$i];

if ($c == "'" && !$inString && $escaped==0)
				/*
				* Found the start of a string inside the statement
				*/
				$inString = true;
			elseif ($c == "\\" && $escaped==0)
				/*
				* The next character will be escaped
				*/
				$escaped = 1;
			elseif ($c == "'" && $inString && $escaped==0)
				/*
				* We found the end of the string
				*/
				$inString = false;

if ($escaped == 2)
				$escaped = 0;

if ($escaped==0 && !$inString && $c == '?')
				/*
				* We found a bind symbol, replace it with the oracle equivalent
				*/
				$newSql .= ':' . $inputKeys[$bindCount++];
			else
				/*
				* Add the current character the pile
				*/
				$newSql .= $c;

if ($escaped == 1)
				/*
				* We have just found an escape character, make sure we ignore the
				* next one that comes along, it might be a ' character
				*/
				$escaped = 2;
		}

return $newSql;

}
}

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

class ADORecordset_oci8po extends ADORecordset_oci8 {

var $databaseType = 'oci8po';

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 = oci_field_name($this->_queryID, $fieldOffset);
		if (ADODB_ASSOC_CASE == ADODB_ASSOC_CASE_LOWER) {
			$fld->name = strtolower($fld->name);
		}
		$fld->type = oci_field_type($this->_queryID, $fieldOffset);
		$fld->max_length = oci_field_size($this->_queryID, $fieldOffset);
		if ($fld->type == 'NUMBER') {
			$sc = oci_field_scale($this->_queryID, $fieldOffset);
			if ($sc == 0) {
				$fld->type = 'INT';
			}
		}
		return $fld;
	}

// 10% speedup to move MoveNext to child class
	function MoveNext()
	{
		$ret = @oci_fetch_array($this->_queryID,$this->fetchMode);
		if($ret !== false) {
		global $ADODB_ANSI_PADDING_OFF;
			$this->fields = $ret;
			$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;
	}

return $results;
	}

function _fetch()
	{
		global $ADODB_ANSI_PADDING_OFF;

$ret = @oci_fetch_array($this->_queryID,$this->fetchMode);
		if ($ret) {
			$this->fields = $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 !== false;
	}

}