Gecko [ nrupathungauniversityblr.ac.in ]

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

Code Editor : adodb-pdo_mysql.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 8.

class ADODB_pdo_mysql extends ADODB_pdo {

var $metaTablesSQL = "SELECT
			TABLE_NAME,
			CASE WHEN TABLE_TYPE = 'VIEW' THEN 'V' ELSE 'T' END
		FROM INFORMATION_SCHEMA.TABLES
		WHERE TABLE_SCHEMA=";
	var $metaColumnsSQL = "SHOW COLUMNS FROM `%s`";
	var $sysDate = 'CURDATE()';
	var $sysTimeStamp = 'NOW()';
	var $hasGenID = true;
	var $_genIDSQL = "update %s set id=LAST_INSERT_ID(id+1);";
	var $_dropSeqSQL = "drop table %s";
	var $fmtTimeStamp = "'Y-m-d, H:i:s'";
	var $nameQuote = '`';

function _init($parentDriver)
	{
		$parentDriver->hasTransactions = false;
		#$parentDriver->_bindInputArray = false;
		$parentDriver->hasInsertID = true;
		$parentDriver->_connectionID->setAttribute(PDO::MYSQL_ATTR_USE_BUFFERED_QUERY, true);
	}

// dayFraction is a day in floating point
	function OffsetDate($dayFraction, $date=false)
	{
		if (!$date) {
			$date = $this->sysDate;
		}

$fraction = $dayFraction * 24 * 3600;
		return $date . ' + INTERVAL ' .	$fraction . ' SECOND';
//		return "from_unixtime(unix_timestamp($date)+$fraction)";
	}

function Concat()
	{
		$s = '';
		$arr = func_get_args();

// suggestion by andrew005#mnogo.ru
		$s = implode(',', $arr);
		if (strlen($s) > 0) {
			return "CONCAT($s)";
		}
		return '';
	}

function ServerInfo()
	{
		$arr['description'] = ADOConnection::GetOne('select version()');
		$arr['version'] = ADOConnection::_findvers($arr['description']);
		return $arr;
	}

function MetaTables($ttype=false, $showSchema=false, $mask=false)
	{
		$save = $this->metaTablesSQL;
		if ($showSchema && is_string($showSchema)) {
			$this->metaTablesSQL .= $this->qstr($showSchema);
		} else {
			$this->metaTablesSQL .= 'schema()';
		}

if ($mask) {
			$mask = $this->qstr($mask);
			$this->metaTablesSQL .= " like $mask";
		}
		$ret = ADOConnection::MetaTables($ttype, $showSchema);

$this->metaTablesSQL = $save;
		return $ret;
	}

function MetaColumns($table, $normalize=true)
	{
		$this->_findschema($table, $schema);
		if ($schema) {
			$dbName = $this->database;
			$this->SelectDB($schema);
		}
		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(sprintf($this->metaColumnsSQL, $table));

if ($schema) {
			$this->SelectDB($dbName);
		}

if (isset($savem)) {
			$this->SetFetchMode($savem);
		}
		$ADODB_FETCH_MODE = $save;
		if (!is_object($rs)) {
			$false = false;
			return $false;
		}

$retarr = array();
		while (!$rs->EOF){
			$fld = new ADOFieldObject();
			$fld->name = $rs->fields[0];
			$type = $rs->fields[1];

// split type into type(length):
			$fld->scale = null;
			if (preg_match('/^(.+)$(\d+),(\d+)/', $type, $query_array)) {
				$fld->type = $query_array[1];
				$fld->max_length = is_numeric($query_array[2]) ? $query_array[2] : -1;
				$fld->scale = is_numeric($query_array[3]) ? $query_array[3] : -1;
			} elseif (preg_match('/^(.+)\((\d+)/', $type, $query_array)) {
				$fld->type = $query_array[1];
				$fld->max_length = is_numeric($query_array[2]) ? $query_array[2] : -1;
			} elseif (preg_match('/^(enum)\((.*)$$/i', $type, $query_array)) {
				$fld->type = $query_array[1];
				$arr = explode(',', $query_array[2]);
				$fld->enums = $arr;
				$zlen = max(array_map('strlen', $arr)) - 2; // PHP >= 4.0.6
				$fld->max_length = ($zlen > 0) ? $zlen : 1;
			} else {
				$fld->type = $type;
				$fld->max_length = -1;
			}
			$fld->not_null = ($rs->fields[2] != 'YES');
			$fld->primary_key = ($rs->fields[3] == 'PRI');
			$fld->auto_increment = (strpos($rs->fields[5], 'auto_increment') !== false);
			$fld->binary = (strpos($type, 'blob') !== false);
			$fld->unsigned = (strpos($type, 'unsigned') !== false);

if (!$fld->binary) {
				$d = $rs->fields[4];
				if ($d != '' && $d != 'NULL') {
					$fld->has_default = true;
					$fld->default_value = $d;
				} else {
					$fld->has_default = false;
				}
			}

if ($save == ADODB_FETCH_NUM) {
				$retarr[] = $fld;
			} else {
				$retarr[strtoupper($fld->name)] = $fld;
			}
			$rs->MoveNext();
		}

$rs->Close();
		return $retarr;
	}

// returns true or false
	function SelectDB($dbName)
	{
		$this->database = $dbName;
		$this->databaseName = $dbName; # obsolete, retained for compat with older adodb versions
		$try = $this->Execute('use ' . $dbName);
		return ($try !== false);
	}

// parameters use PostgreSQL convention, not MySQL
	function SelectLimit($sql, $nrows=-1, $offset=-1, $inputarr=false, $secs=0)
	{
		$offsetStr =($offset>=0) ? "$offset," : '';
		// jason judge, see http://phplens.com/lens/lensforum/msgs.php?id=9220
		if ($nrows < 0) {
			$nrows = '18446744073709551615';
		}

if ($secs) {
			$rs = $this->CacheExecute($secs, $sql . " LIMIT $offsetStr$nrows", $inputarr);
		} else {
			$rs = $this->Execute($sql . " LIMIT $offsetStr$nrows", $inputarr);
		}
		return $rs;
	}

function SQLDate($fmt, $col=false)
	{
		if (!$col) {
			$col = $this->sysTimeStamp;
		}
		$s = 'DATE_FORMAT(' . $col . ",'";
		$concat = false;
		$len = strlen($fmt);
		for ($i=0; $i < $len; $i++) {
			$ch = $fmt[$i];
			switch($ch) {

default:
					if ($ch == '\\') {
						$i++;
						$ch = substr($fmt, $i, 1);
					}
					// FALL THROUGH
				case '-':
				case '/':
					$s .= $ch;
					break;

case 'Y':
				case 'y':
					$s .= '%Y';
					break;

case 'M':
					$s .= '%b';
					break;

case 'm':
					$s .= '%m';
					break;

case 'D':
				case 'd':
					$s .= '%d';
					break;

case 'Q':
				case 'q':
					$s .= "'),Quarter($col)";

if ($len > $i+1) {
						$s .= ",DATE_FORMAT($col,'";
					} else {
						$s .= ",('";
					}
					$concat = true;
					break;

case 'H':
					$s .= '%H';
					break;

case 'h':
					$s .= '%I';
					break;

case 'i':
					$s .= '%i';
					break;

case 's':
					$s .= '%s';
					break;

case 'a':
				case 'A':
					$s .= '%p';
					break;

case 'w':
					$s .= '%w';
					break;

case 'W':
					$s .= '%U';
					break;

case 'l':
					$s .= '%W';
					break;
			}
		}
		$s .= "')";
		if ($concat) {
			$s = "CONCAT($s)";
		}
		return $s;
	}
}

${this.title}

Code Editor : adodb-pdo_mysql.inc.php