Gecko [ edgpens.lpkmn.gov.my ]

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

Code Editor : adodb-sqlite3.inc.php

<?php
/*
V5.18 3 Sep 2012  (c) 2000-2012 John Lim (jlim#natsoft.com). 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
  
  SQLite info: http://www.hwaci.com/sw/sqlite/
    
  Install Instructions:
  ====================
  1. Place this in adodb/drivers
  2. Rename the file, remove the .txt prefix.
*/

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

// class ADODB_sqlite extends ADOConnection { **change
class ADODB_sqlite3 extends ADOConnection {
	//var $databaseType = "sqlite"; **change
	var $databaseType = "sqlite3";
	var $replaceQuote = "''"; // string to use to replace quotes
	var $concat_operator='||';
	var $_errorNo = 0;
	var $hasLimit = true;	
	var $hasInsertID = true; 		/// supports autoincrement ID?
	var $hasAffectedRows = true; 	/// supports affected rows for update/delete?
	var $metaTablesSQL = "SELECT name FROM sqlite_master WHERE type='table' ORDER BY name";
	var $sysDate = "adodb_date('Y-m-d')";
	var $sysTimeStamp = "adodb_date('Y-m-d H:i:s')";
	var $fmtTimeStamp = "'Y-m-d H:i:s'";
	
	//function ADODB_sqlite3() **change
	function ADODB_sqlite3() 
	{
	}
	
/*
  function __get($name) 
  {
  	switch($name) {
	case 'sysDate': return "'".date($this->fmtDate)."'";
	case 'sysTimeStamp' : return "'".date($this->sysTimeStamp)."'";
	}
  }*/
	
	function ServerInfo()
	{
		$arr['version'] = $this->_connectionID->version(); //**tochange
		$arr['description'] = 'SQLite 3'; //**tochange
		//$arr['encoding'] = sqlite_libencoding();//**tochange
		return $arr;
	}
	
	function BeginTrans()
	{	  
		 if ($this->transOff) return true; 
		 $ret = $this->Execute("BEGIN TRANSACTION");
		 $this->transCnt += 1;
		 return true;
	}
	
	function CommitTrans($ok=true) 
	{ 
		if ($this->transOff) return true; 
		if (!$ok) return $this->RollbackTrans();
		$ret = $this->Execute("COMMIT");
		if ($this->transCnt>0)$this->transCnt -= 1;
		return !empty($ret);
	}
	
	function RollbackTrans()
	{
		if ($this->transOff) return true; 
		$ret = $this->Execute("ROLLBACK");
		if ($this->transCnt>0)$this->transCnt -= 1;
		return !empty($ret);
	}
	
	// mark newnham
	function MetaColumns($table, $normalize=true) 
	{
	  global $ADODB_FETCH_MODE;
	  $false = false;
	  $save = $ADODB_FETCH_MODE;
	  $ADODB_FETCH_MODE = ADODB_FETCH_ASSOC;
	  if ($this->fetchMode !== false) $savem = $this->SetFetchMode(false);
	  $rs = $this->Execute("PRAGMA table_info('$table')");
	  if (isset($savem)) $this->SetFetchMode($savem);
	  if (!$rs) {
	    $ADODB_FETCH_MODE = $save; 
	    return $false;
	  }
	  $arr = array();
	  while ($r = $rs->FetchRow()) {
	  
	    $type = explode('(',$r['type']);
	    $size = '';
	    if (sizeof($type)==2)
	    $size = trim($type[1],')');
	    $fn = strtoupper($r['name']);
	    $fld = new ADOFieldObject;
	    $fld->name = $r['name'];
	    $fld->type = $type[0];
	    $fld->max_length = $size;
	    $fld->not_null = $r['notnull'];
	    $fld->default_value = $r['dflt_value'];
	    $fld->scale = 0;
		if (isset($r['pk']) && $r['pk']) $fld->primary_key=1;
	    if ($save == ADODB_FETCH_NUM) $arr[] = $fld;	
	    else $arr[strtoupper($fld->name)] = $fld;
	  }
	  $rs->Close();
	  $ADODB_FETCH_MODE = $save;
	  return $arr;
	}
	
	function _init($parentDriver)
	{
	
		$parentDriver->hasTransactions = false;
		$parentDriver->hasInsertID = true;
	}

// returns true or false
	function _connect($argHostname, $argUsername, $argPassword, $argDatabasename) //**tochange: all the function need to be changed, just hacks for the moment
	{
		if (empty($argHostname) && $argDatabasename) $argHostname = $argDatabasename; 
		$this->_connectionID = new SQLite3($argDatabasename); 
		$this->_createFunctions();
		
		return true; // hack
		/*
		if (!function_exists('sqlite_open')) return null;
		if (empty($argHostname) && $argDatabasename) $argHostname = $argDatabasename;
		
		$this->_connectionID = sqlite_open($argHostname);
		if ($this->_connectionID === false) return false;
		$this->_createFunctions();
		return true;
		*/
	}
	
	// returns true or false
	function _pconnect($argHostname, $argUsername, $argPassword, $argDatabasename) //**tochange
	{
		if (!function_exists('sqlite_open')) return null;
		if (empty($argHostname) && $argDatabasename) $argHostname = $argDatabasename;
		
		$this->_connectionID = sqlite_popen($argHostname);
		if ($this->_connectionID === false) return false;
		$this->_createFunctions();
		return true;
	}

// returns query ID if successful, otherwise false
	function _query($sql,$inputarr=false)
	{
		//$rez = sqlite_query($sql,$this->_connectionID);//**change
		$rez = $this->_connectionID->query($sql);
		if (!$rez) {
			//$this->_errorNo = sqlite3_last_error($this->_connectionID);**change
			$this->_connectionID->lastErrorCode();
		}
		
		return $rez;
	}
	
	function SelectLimit($sql,$nrows=-1,$offset=-1,$inputarr=false,$secs2cache=0) 
	{
		$offsetStr = ($offset >= 0) ? " OFFSET $offset" : '';
		$limitStr  = ($nrows >= 0)  ? " LIMIT $nrows" : ($offset >= 0 ? ' LIMIT 999999999' : '');
	  	if ($secs2cache)
	   		$rs = $this->CacheExecute($secs2cache,$sql."$limitStr$offsetStr",$inputarr);
	  	else
	   		$rs = $this->Execute($sql."$limitStr$offsetStr",$inputarr);
			
		return $rs;
	}
	
	/*
		This algorithm is not very efficient, but works even if table locking
		is not available.
		
		Will return false if unable to generate an ID after $MAXLOOPS attempts.
	*/
	var $_genSeqSQL = "create table %s (id integer)";
	
	function GenID($seq='adodbseq',$start=1)
	{	
		// if you have to modify the parameter below, your database is overloaded,
		// or you need to implement generation of id's yourself!
		$MAXLOOPS = 100;
		//$this->debug=1;
		while (--$MAXLOOPS>=0) {
			@($num = $this->GetOne("select id from $seq"));
			if ($num === false) {
				$this->Execute(sprintf($this->_genSeqSQL ,$seq));	
				$start -= 1;
				$num = '0';
				$ok = $this->Execute("insert into $seq values($start)");
				if (!$ok) return false;
			} 
			$this->Execute("update $seq set id=id+1 where id=$num");
			
			if ($this->affected_rows() > 0) {
				$num += 1;
				$this->genID = $num;
				return $num;
			}
		}
		if ($fn = $this->raiseErrorFn) {
			$fn($this->databaseType,'GENID',-32000,"Unable to generate unique id after $MAXLOOPS attempts",$seq,$num);
		}
		return false;
	}

function MetaIndexes($table, $primary = FALSE, $owner=false, $owner = false)
	{
		$false = false;
		// save old fetch mode
        global $ADODB_FETCH_MODE;
        $save = $ADODB_FETCH_MODE;
        $ADODB_FETCH_MODE = ADODB_FETCH_NUM;
        if ($this->fetchMode !== FALSE) {
               $savem = $this->SetFetchMode(FALSE);
        }
		$SQL=sprintf("SELECT name,sql FROM sqlite_master WHERE type='index' AND tbl_name='%s'", strtolower($table));
        $rs = $this->Execute($SQL);
        if (!is_object($rs)) {
			if (isset($savem)) 
				$this->SetFetchMode($savem);
			$ADODB_FETCH_MODE = $save;
            return $false;
        }

$indexes = array ();
		while ($row = $rs->FetchRow()) {
			if ($primary && preg_match("/primary/i",$row[1]) == 0) continue;
            if (!isset($indexes[$row[0]])) {

$indexes[$row[0]] = array(
				   'unique' => preg_match("/unique/i",$row[1]),
				   'columns' => array());
			}
			/**
			  * There must be a more elegant way of doing this,
			  * the index elements appear in the SQL statement
			  * in cols[1] between parentheses
			  * e.g CREATE UNIQUE INDEX ware_0 ON warehouse (org,warehouse)
			  */
			$cols = explode("(",$row[1]);
			$cols = explode(")",$cols[1]);
			array_pop($cols);
			$indexes[$row[0]]['columns'] = $cols;
		}
		if (isset($savem)) { 
            $this->SetFetchMode($savem);
			$ADODB_FETCH_MODE = $save;
		}
        return $indexes;
	}

}

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

//class ADORecordset_sqlite extends ADORecordSet {**change
class ADORecordset_sqlite3 extends ADORecordSet {

//var $databaseType = "sqlite";**change
	var $databaseType = "sqlite3";
	var $bind = false;

//function ADORecordset_sqlite($queryID,$mode=false)**change
	function ADORecordset_sqlite3($queryID,$mode=false)
	{
		
		if ($mode === false) { 
			global $ADODB_FETCH_MODE;
			$mode = $ADODB_FETCH_MODE;
		}
		switch($mode) {
		//case ADODB_FETCH_NUM: $this->fetchMode = SQLITE_NUM; break;**change
		case ADODB_FETCH_NUM: $this->fetchMode = SQLITE3_NUM; break;
		//case ADODB_FETCH_ASSOC: $this->fetchMode = SQLITE_ASSOC; break;**change
		case ADODB_FETCH_ASSOC: $this->fetchMode = SQLITE3_ASSOC; break;
		//default: $this->fetchMode = SQLITE_BOTH; break;**change
		default: $this->fetchMode = SQLITE3_BOTH; break;
		}
		$this->adodbFetchMode = $mode;
		
		$this->_queryID = $queryID;
	
		$this->_inited = true;
		$this->fields = array();
		if ($queryID) {
			$this->_currentRow = 0;
			$this->EOF = !$this->_fetch();
			@$this->_initrs();
		} else {
			$this->_numOfRows = 0;
			$this->_numOfFields = 0;
			$this->EOF = true;
		}
		
		return $this->_queryID;
	}

function FetchField($fieldOffset = -1)
	{
		$fld = new ADOFieldObject;
		//$fld->name = sqlite3_field_name($this->_queryID, $fieldOffset);**change
		$fld->name->columnName($this->_queryID, $fieldOffset);
		$fld->type = 'VARCHAR';
		$fld->max_length = -1;
		return $fld;
	}
	
   function _initrs()
   {
		//$this->_numOfRows = @sqlite_num_rows($this->_queryID); **tochange but sqlite3 doesn't implement this!
		$this->_numOfRows = 1;
		//$this->_numOfFields = @sqlite3_num_fields($this->_queryID);**change
		$this->_numOfFields = $this->_queryID->numColumns();
		
   }

function _fetch($ignore_fields=false) 
	{
		//$this->fields = @sqlite3_fetch_array($this->_queryID,$this->fetchMode);**change
		$this->fields = $this->_queryID->fetchArray($this->fetchMode);
		return !empty($this->fields);
	}
	
	function _close() 
	{
	}

}
?>

${this.title}

Code Editor : adodb-sqlite3.inc.php