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-sqlanywhere.inc.php

<?php
/* 
version 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. 
Set tabs to 4 for best viewing.

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

21.02.2002 - Wade Johnson wade@wadejohnson.de
			   Extended ODBC class for Sybase SQLAnywhere.
   1) Added support to retrieve the last row insert ID on tables with
	  primary key column using autoincrement function.

2) Added blob support.  Usage:
		 a) create blob variable on db server:

$dbconn->create_blobvar($blobVarName);

b) load blob var from file.  $filename must be complete path

$dbcon->load_blobvar_from_file($blobVarName, $filename);

c) Use the $blobVarName in SQL insert or update statement in the values
	  clause:

$recordSet = $dbconn->Execute('INSERT INTO tabname (idcol, blobcol) '
		.
	   'VALUES (\'test\', ' . $blobVarName . ')');

instead of loading blob from a file, you can also load from 
	  an unformatted (raw) blob variable:
	  $dbcon->load_blobvar_from_var($blobVarName, $varName);

d) drop blob variable on db server to free up resources:
	  $dbconn->drop_blobvar($blobVarName);

Sybase_SQLAnywhere 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_SYBASE_SQLANYWHERE')){

define('ADODB_SYBASE_SQLANYWHERE',1);

class ADODB_sqlanywhere extends ADODB_odbc {
  	var $databaseType = "sqlanywhere";	
	var $hasInsertID = true;
	
	function ADODB_sqlanywhere()
	{
		$this->ADODB_odbc();
	}

function _insertid() {
  	   return $this->GetOne('select @@identity');
	 }

function create_blobvar($blobVarName) {
   $this->Execute("create variable $blobVarName long binary");
   return;
  }

function drop_blobvar($blobVarName) {
   $this->Execute("drop variable $blobVarName");
   return;
  }

function load_blobvar_from_file($blobVarName, $filename) {
   $chunk_size = 1000;

$fd = fopen ($filename, "rb");

$integer_chunks = (integer)filesize($filename) / $chunk_size;
   $modulus = filesize($filename) % $chunk_size;
   if ($modulus != 0){
	$integer_chunks += 1;
   }

for($loop=1;$loop<=$integer_chunks;$loop++){
	$contents = fread ($fd, $chunk_size);
	$contents = bin2hex($contents);

$hexstring = '';

for($loop2=0;$loop2<strlen($contents);$loop2+=2){
	 $hexstring .= '\x' . substr($contents,$loop2,2);
	 }

$hexstring = $this->qstr($hexstring);

$this->Execute("set $blobVarName = $blobVarName || " . $hexstring);
   }

fclose ($fd);
   return;
  }

function load_blobvar_from_var($blobVarName, &$varName) {
   $chunk_size = 1000;

$integer_chunks = (integer)strlen($varName) / $chunk_size;
   $modulus = strlen($varName) % $chunk_size;
   if ($modulus != 0){
	$integer_chunks += 1;
   }

for($loop=1;$loop<=$integer_chunks;$loop++){
	$contents = substr ($varName, (($loop - 1) * $chunk_size), $chunk_size);
	$contents = bin2hex($contents);

$hexstring = '';

for($loop2=0;$loop2<strlen($contents);$loop2+=2){
	 $hexstring .= '\x' . substr($contents,$loop2,2);
	 }

$hexstring = $this->qstr($hexstring);

$this->Execute("set $blobVarName = $blobVarName || " . $hexstring);
   }

return;
  }

/*
  Insert a null into the blob field of the table first.
  Then use UpdateBlob to store the blob.

Usage:

$conn->Execute('INSERT INTO blobtable (id, blobcol) VALUES (1, null)');
  $conn->UpdateBlob('blobtable','blobcol',$blob,'id=1');
 */
  function UpdateBlob($table,$column,&$val,$where,$blobtype='BLOB')
  {
   $blobVarName = 'hold_blob';
   $this->create_blobvar($blobVarName);
   $this->load_blobvar_from_var($blobVarName, $val);
   $this->Execute("UPDATE $table SET $column=$blobVarName WHERE $where");
   $this->drop_blobvar($blobVarName);
   return true;
  }
 }; //class

class  ADORecordSet_sqlanywhere extends ADORecordSet_odbc {

var $databaseType = "sqlanywhere";

function ADORecordSet_sqlanywhere($id,$mode=false)
 {
  $this->ADORecordSet_odbc($id,$mode);
 }

}; //class

} //define
?>

${this.title}

Code Editor : adodb-sqlanywhere.inc.php