Gecko [ nrupathungauniversityblr.ac.in ]

Name	Size	Permission
adodb-access.inc.php	2.18 KB	-rwxr-xr-x
adodb-ado.inc.php	15.94 KB	-rwxr-xr-x
adodb-ado5.inc.php	17 KB	-rwxr-xr-x
adodb-ado_access.inc.php	1.39 KB	-rwxr-xr-x
adodb-ado_mssql.inc.php	4.29 KB	-rwxr-xr-x
adodb-ads.inc.php	23.2 KB	-rwxr-xr-x
adodb-borland_ibase.inc.php	2.18 KB	-rwxr-xr-x
adodb-csv.inc.php	4.82 KB	-rwxr-xr-x
adodb-db2.inc.php	21.53 KB	-rwxr-xr-x
adodb-db2oci.inc.php	4.57 KB	-rwxr-xr-x
adodb-db2ora.inc.php	1.94 KB	-rwxr-xr-x
adodb-fbsql.inc.php	6.36 KB	-rwxr-xr-x
adodb-firebird.inc.php	1.88 KB	-rwxr-xr-x
adodb-ibase.inc.php	24 KB	-rwxr-xr-x
adodb-informix.inc.php	1.03 KB	-rwxr-xr-x
adodb-informix72.inc.php	14.57 KB	-rwxr-xr-x
adodb-ldap.inc.php	10.86 KB	-rwxr-xr-x
adodb-mssql.inc.php	33.59 KB	-rwxr-xr-x
adodb-mssql_n.inc.php	9.79 KB	-rwxr-xr-x
adodb-mssqlnative.inc.php	35.12 KB	-rwxr-xr-x
adodb-mssqlpo.inc.php	1.52 KB	-rwxr-xr-x
adodb-mysql.inc.php	21.99 KB	-rwxr-xr-x
adodb-mysqli.inc.php	32.43 KB	-rwxr-xr-x
adodb-mysqlpo.inc.php	3.1 KB	-rwxr-xr-x
adodb-mysqlt.inc.php	3.47 KB	-rwxr-xr-x
adodb-netezza.inc.php	4.71 KB	-rwxr-xr-x
adodb-oci8.inc.php	45.94 KB	-rwxr-xr-x
adodb-oci805.inc.php	1.55 KB	-rwxr-xr-x
adodb-oci8po.inc.php	5.92 KB	-rwxr-xr-x
adodb-oci8quercus.inc.php	2.39 KB	-rwxr-xr-x
adodb-odbc.inc.php	18.94 KB	-rwxr-xr-x
adodb-odbc_db2.inc.php	9.16 KB	-rwxr-xr-x
adodb-odbc_mssql.inc.php	10.49 KB	-rwxr-xr-x
adodb-odbc_oracle.inc.php	3.15 KB	-rwxr-xr-x
adodb-odbtp.inc.php	23.26 KB	-rwxr-xr-x
adodb-odbtp_unicode.inc.php	1.14 KB	-rwxr-xr-x
adodb-oracle.inc.php	9.26 KB	-rwxr-xr-x
adodb-pdo.inc.php	16.68 KB	-rwxr-xr-x
adodb-pdo_mssql.inc.php	1.5 KB	-rwxr-xr-x
adodb-pdo_mysql.inc.php	6.76 KB	-rwxr-xr-x
adodb-pdo_oci.inc.php	2.67 KB	-rwxr-xr-x
adodb-pdo_pgsql.inc.php	8.29 KB	-rwxr-xr-x
adodb-pdo_sqlite.inc.php	5.84 KB	-rwxr-xr-x
adodb-pdo_sqlsrv.inc.php	1013 B	-rwxr-xr-x
adodb-postgres.inc.php	611 B	-rwxr-xr-x
adodb-postgres64.inc.php	31.46 KB	-rwxr-xr-x
adodb-postgres7.inc.php	10.34 KB	-rwxr-xr-x
adodb-postgres8.inc.php	1.42 KB	-rwxr-xr-x
adodb-postgres9.inc.php	821 B	-rwxr-xr-x
adodb-proxy.inc.php	884 B	-rwxr-xr-x
adodb-sapdb.inc.php	5.1 KB	-rwxr-xr-x
adodb-sqlanywhere.inc.php	4.13 KB	-rwxr-xr-x
adodb-sqlite.inc.php	10.4 KB	-rwxr-xr-x
adodb-sqlite3.inc.php	10.07 KB	-rwxr-xr-x
adodb-sqlitepo.inc.php	1.82 KB	-rwxr-xr-x
adodb-sybase.inc.php	12.15 KB	-rwxr-xr-x
adodb-sybase_ase.inc.php	3.24 KB	-rwxr-xr-x
adodb-vfp.inc.php	2.45 KB	-rwxr-xr-x

Code Editor : adodb-sapdb.inc.php

<?php
/*
@version   v5.20.9  21-Dec-2016
@copyright (c) 2000-2013 John Lim (jlim#natsoft.com). 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.
Set tabs to 4 for best viewing.

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

SAPDB data driver. Requires ODBC.

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

if (!defined('_ADODB_ODBC_LAYER')) {
	include(ADODB_DIR."/drivers/adodb-odbc.inc.php");
}
if (!defined('ADODB_SAPDB')){
define('ADODB_SAPDB',1);

class ADODB_SAPDB extends ADODB_odbc {
	var $databaseType = "sapdb";
	var $concat_operator = '||';
	var $sysDate = 'DATE';
	var $sysTimeStamp = 'TIMESTAMP';
	var $fmtDate = "'Y-m-d'";	/// used by DBDate() as the default date format used by the database
	var $fmtTimeStamp = "'Y-m-d H:i:s'"; /// used by DBTimeStamp as the default timestamp fmt.
	var $hasInsertId = true;
	var $_bindInputArray = true;

function __construct()
	{
		//if (strncmp(PHP_OS,'WIN',3) === 0) $this->curmode = SQL_CUR_USE_ODBC;
		parent::__construct();
	}

function ServerInfo()
	{
		$info = ADODB_odbc::ServerInfo();
		if (!$info['version'] && preg_match('/([0-9.]+)/',$info['description'],$matches)) {
			$info['version'] = $matches[1];
		}
		return $info;
	}

function MetaPrimaryKeys($table, $owner = false)
	{
		$table = $this->Quote(strtoupper($table));

return $this->GetCol("SELECT columnname FROM COLUMNS WHERE tablename=$table AND mode='KEY' ORDER BY pos");
	}

function MetaIndexes ($table, $primary = FALSE, $owner = false)
	{
		$table = $this->Quote(strtoupper($table));

$sql = "SELECT INDEXNAME,TYPE,COLUMNNAME FROM INDEXCOLUMNS ".
			" WHERE TABLENAME=$table".
			" ORDER BY INDEXNAME,COLUMNNO";

global $ADODB_FETCH_MODE;
		$save = $ADODB_FETCH_MODE;
        $ADODB_FETCH_MODE = ADODB_FETCH_NUM;
        if ($this->fetchMode !== FALSE) {
        	$savem = $this->SetFetchMode(FALSE);
        }

$rs = $this->Execute($sql);
        if (isset($savem)) {
        	$this->SetFetchMode($savem);
        }
        $ADODB_FETCH_MODE = $save;

if (!is_object($rs)) {
        	return FALSE;
        }

$indexes = array();
		while ($row = $rs->FetchRow()) {
            $indexes[$row[0]]['unique'] = $row[1] == 'UNIQUE';
            $indexes[$row[0]]['columns'][] = $row[2];
    	}
		if ($primary) {
			$indexes['SYSPRIMARYKEYINDEX'] = array(
					'unique' => True,	// by definition
					'columns' => $this->GetCol("SELECT columnname FROM COLUMNS WHERE tablename=$table AND mode='KEY' ORDER BY pos"),
				);
		}
        return $indexes;
	}

function MetaColumns ($table, $normalize = true)
	{
		global $ADODB_FETCH_MODE;
		$save = $ADODB_FETCH_MODE;
        $ADODB_FETCH_MODE = ADODB_FETCH_NUM;
        if ($this->fetchMode !== FALSE) {
        	$savem = $this->SetFetchMode(FALSE);
        }
		$table = $this->Quote(strtoupper($table));

$retarr = array();
		foreach($this->GetAll("SELECT COLUMNNAME,DATATYPE,LEN,DEC,NULLABLE,MODE,\"DEFAULT\",CASE WHEN \"DEFAULT\" IS NULL THEN 0 ELSE 1 END AS HAS_DEFAULT FROM COLUMNS WHERE tablename=$table ORDER BY pos") as $column)
		{
			$fld = new ADOFieldObject();
			$fld->name = $column[0];
			$fld->type = $column[1];
			$fld->max_length = $fld->type == 'LONG' ? 2147483647 : $column[2];
			$fld->scale = $column[3];
			$fld->not_null = $column[4] == 'NO';
			$fld->primary_key = $column[5] == 'KEY';
			if ($fld->has_default = $column[7]) {
				if ($fld->primary_key && $column[6] == 'DEFAULT SERIAL (1)') {
					$fld->auto_increment = true;
					$fld->has_default = false;
				} else {
					$fld->default_value = $column[6];
					switch($fld->type) {
						case 'VARCHAR':
						case 'CHARACTER':
						case 'LONG':
							$fld->default_value = $column[6];
							break;
						default:
							$fld->default_value = trim($column[6]);
							break;
					}
				}
			}
			$retarr[$fld->name] = $fld;
		}
        if (isset($savem)) {
        	$this->SetFetchMode($savem);
        }
        $ADODB_FETCH_MODE = $save;

return $retarr;
	}

function MetaColumnNames($table, $numIndexes = false, $useattnum = false)
	{
		$table = $this->Quote(strtoupper($table));

return $this->GetCol("SELECT columnname FROM COLUMNS WHERE tablename=$table ORDER BY pos");
	}

// unlike it seems, this depends on the db-session and works in a multiuser environment
	function _insertid($table,$column)
	{
		return empty($table) ? False : $this->GetOne("SELECT $table.CURRVAL FROM DUAL");
	}

/*
		SelectLimit implementation problems:

The following will return random 10 rows as order by performed after "WHERE rowno<10"
	 	which is not ideal...

select * from table where rowno < 10 order by 1

This means that we have to use the adoconnection base class SelectLimit when
	  	there is an "order by".

See http://listserv.sap.com/pipermail/sapdb.general/2002-January/010405.html
	 */

};

class  ADORecordSet_sapdb extends ADORecordSet_odbc {

var $databaseType = "sapdb";

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

} //define

${this.title}

Code Editor : adodb-sapdb.inc.php