Gecko [ www.vortexaion.com ]

Name	Size	Permission	Date
adodb-access.inc.php	2.13 KB	-rw-rw-rw-	2012-09-03 08:18
adodb-ado.inc.php	15.98 KB	-rw-rw-rw-	2012-09-03 08:18
adodb-ado5.inc.php	17.08 KB	-rw-rw-rw-	2012-09-03 08:18
adodb-ado_access.inc.php	1.39 KB	-rw-rw-rw-	2012-09-03 08:18
adodb-ado_mssql.inc.php	4.35 KB	-rw-rw-rw-	2012-09-03 08:18
adodb-ads.inc.php	23.41 KB	-rw-rw-rw-	2009-06-26 13:27
adodb-borland_ibase.inc.php	2.19 KB	-rw-rw-rw-	2012-09-03 08:18
adodb-csv.inc.php	4.75 KB	-rw-rw-rw-	2012-09-03 08:18
adodb-db2.inc.php	21.59 KB	-rw-rw-rw-	2012-09-03 08:18
adodb-db2oci.inc.php	4.58 KB	-rw-rw-rw-	2012-09-03 08:18
adodb-db2ora.inc.php	1.62 KB	-rw-rw-rw-	2012-09-03 08:18
adodb-fbsql.inc.php	6.37 KB	-rw-rw-rw-	2012-09-03 08:18
adodb-firebird.inc.php	1.88 KB	-rw-rw-rw-	2012-09-03 08:18
adodb-ibase.inc.php	24.76 KB	-rw-rw-rw-	2012-09-03 08:18
adodb-informix.inc.php	980 B	-rw-rw-rw-	2012-09-03 08:18
adodb-informix72.inc.php	14.44 KB	-rw-rw-rw-	2012-09-03 08:18
adodb-ldap.inc.php	12.11 KB	-rw-rw-rw-	2012-09-03 08:18
adodb-mssql.inc.php	33.8 KB	-rw-rw-rw-	2012-09-03 08:18
adodb-mssql_n.inc.php	7.14 KB	-rw-rw-rw-	2012-01-19 07:44
adodb-mssqlnative.inc.php	30.08 KB	-rw-rw-rw-	2012-09-03 08:18
adodb-mssqlpo.inc.php	1.49 KB	-rw-rw-rw-	2012-09-03 08:18
adodb-mysql.inc.php	22.8 KB	-rw-rw-rw-	2012-09-03 08:18
adodb-mysqli.inc.php	32.66 KB	-rw-rw-rw-	2012-09-03 08:18
adodb-mysqlpo.inc.php	3.14 KB	-rw-rw-rw-	2012-09-03 08:18
adodb-mysqlt.inc.php	3.72 KB	-rw-rw-rw-	2012-09-03 08:18
adodb-netezza.inc.php	5.03 KB	-rw-rw-rw-	2012-09-03 08:18
adodb-oci8.inc.php	46.43 KB	-rw-rw-rw-	2012-09-03 08:18
adodb-oci805.inc.php	1.54 KB	-rw-rw-rw-	2012-09-03 08:18
adodb-oci8po.inc.php	5.53 KB	-rw-rw-rw-	2012-09-03 08:18
adodb-odbc.inc.php	19.33 KB	-rw-rw-rw-	2012-09-03 08:18
adodb-odbc_db2.inc.php	9.13 KB	-rw-rw-rw-	2012-09-03 08:18
adodb-odbc_mssql.inc.php	10.52 KB	-rw-rw-rw-	2012-09-03 08:18
adodb-odbc_oracle.inc.php	3.12 KB	-rw-rw-rw-	2012-09-03 08:18
adodb-odbtp.inc.php	23.29 KB	-rw-rw-rw-	2012-09-03 08:18
adodb-odbtp_unicode.inc.php	1.1 KB	-rw-rw-rw-	2012-09-03 08:18
adodb-oracle.inc.php	9.2 KB	-rw-rw-rw-	2012-09-03 08:18
adodb-pdo.inc.php	14.73 KB	-rw-rw-rw-	2012-09-03 08:18
adodb-pdo_mssql.inc.php	1.41 KB	-rw-rw-rw-	2012-09-03 08:18
adodb-pdo_mysql.inc.php	5 KB	-rw-rw-rw-	2012-09-03 08:18
adodb-pdo_oci.inc.php	2.6 KB	-rw-rw-rw-	2012-09-03 08:18
adodb-pdo_pgsql.inc.php	8.26 KB	-rw-rw-rw-	2012-09-03 08:18
adodb-pdo_sqlite.inc.php	5.78 KB	-rw-rw-rw-	2012-09-03 08:18
adodb-postgres.inc.php	515 B	-rw-rw-rw-	2012-09-03 08:18
adodb-postgres64.inc.php	31.51 KB	-rw-rw-rw-	2012-09-03 08:18
adodb-postgres7.inc.php	11 KB	-rw-rw-rw-	2012-09-03 08:18
adodb-postgres8.inc.php	348 B	-rw-rw-rw-	2012-09-03 08:18
adodb-postgres9.inc.php	1.59 KB	-rw-rw-rw-	2012-09-03 08:18
adodb-proxy.inc.php	805 B	-rw-rw-rw-	2012-09-03 08:18
adodb-sapdb.inc.php	4.98 KB	-rw-rw-rw-	2012-09-03 08:18
adodb-sqlanywhere.inc.php	4.13 KB	-rw-rw-rw-	2012-09-03 08:18
adodb-sqlite.inc.php	10.27 KB	-rw-rw-rw-	2012-09-03 08:18
adodb-sqlite3.inc.php	12 KB	-rw-rw-rw-	2012-09-03 08:18
adodb-sqlitepo.inc.php	1.82 KB	-rw-rw-rw-	2012-09-03 08:18
adodb-sybase.inc.php	12.71 KB	-rw-rw-rw-	2012-09-03 08:18
adodb-sybase_ase.inc.php	3.18 KB	-rw-rw-rw-	2012-09-03 08:18
adodb-vfp.inc.php	2.42 KB	-rw-rw-rw-	2012-09-03 08:18

Rename

<?php
/*
V5.18 3 Sep 2012  (c) 2000-2012 John Lim. All rights reserved.
  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 ADODB_oci8po()
	{
		$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 {
				$sqlarr = explode('?',$sql);
				$sql = $sqlarr[0];
				foreach($inputarr as $k => $v) {
					$sql .=  ":$k" . $sqlarr[++$i];
				}
			}
		}
		return ADODB_oci8::_query($sql,$inputarr);
	}
}

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

class ADORecordset_oci8po extends ADORecordset_oci8 {

var $databaseType = 'oci8po';
	
	function ADORecordset_oci8po($queryID,$mode=false)
	{
		$this->ADORecordset_oci8($queryID,$mode);
	}

// 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++;
			
			if ($this->fetchMode & OCI_ASSOC) $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;
		}
		if ($this->fetchMode & OCI_ASSOC) $this->_updatefields();
		$results = array();
		$cnt = 0;
		while (!$this->EOF && $nrows != $cnt) {
			$results[$cnt++] = $this->fields;
			$this->MoveNext();
		}
		
		return $results;
	}

// Create associative array
	function _updatefields()
	{
		if (ADODB_ASSOC_CASE == 2) return; // native
	
		$arr = array();
		$lowercase = (ADODB_ASSOC_CASE == 0);
		
		foreach($this->fields as $k => $v) {
			if (is_integer($k)) $arr[$k] = $v;
			else {
				if ($lowercase)
					$arr[strtolower($k)] = $v;
				else
					$arr[strtoupper($k)] = $v;
			}
		}
		$this->fields = $arr;
	}
	
	function _fetch() 
	{
		$ret = @OCIfetchinto($this->_queryID,$this->fields,$this->fetchMode);
		if ($ret) {
		global $ADODB_ANSI_PADDING_OFF;
	
				if ($this->fetchMode & OCI_ASSOC) $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;
	}
	
}