CYap_ODBC.php

Go to the documentation of this file.

<?PHP
/*
 * +-------------------------------------------------------------------------+
 * | Yap, Version 2.5.0                                                      |
 * +-------------------------------------------------------------------------+
 * | Copyright (c) 2003-2013 Andrioli Darvin                                 |
 * | Email         <darvin (inside) andrioli (dot) com>                      |
 * | Web           http://www.andrioli.com/en/yap.html                       |
 * | Download      http://www.phpclasses.org/browse.html/package/1391.html   |
 * |                                                                         |
 * +-------------------------------------------------------------------------+
 * | This library is free software; you can redistribute it and/or modify    |
 * | it under the terms of the GNU Lesser General Public License as          |
 * | published by the Free Software Foundation; either version 2 of the      |
 * | License, or (at your option) any later version.                         |
 * |                                                                         |
 * | This library is distributed in the hope that it will be useful, but     |
 * | WITHOUT ANY WARRANTY; without even the implied warranty of              |
 * | MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU        |
 * | Lesser General Public License for more details.                         |
 * |                                                                         |
 * | You should have received a copy of the GNU Lesser General Public        |
 * | License along with this library; if not, write to the Free Software     |
 * | Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA 02111-1307 USA |
 * +-------------------------------------------------------------------------+
 */
class CYap_odbc extends CYapDB {
var $UseLimit;
var $LimitToEnd;
var $LimitStart;
var $LimitEnd;
var $LastRow;
var $SaveUser;
var $SavePasswd;

function CYap_odbc()
{
CYapDB::CYapDB();
$this->UseLimit=false;
$this->LimitStart=0;
$this->LastRow=array();
$this->CurrentRow=array();
}
function OpenDb($DBSystem,$DBUser="",$DBPasswd="")
{
if($this->Db_Open)
   {
   $this->txtError='Database already open';
   return(false);
   }
$this->SaveUser=$DBUser;
$this->SavePasswd=$DBPasswd;
return(true);
}
function SelectDb($DBname)
{
if($this->Db_Open)
   {
   $this->txtError='Database already open';
   return(false);
   }
if(($this->DbConn=odbc_connect($DBname,$this->SaveUser,$this->SavePasswd))===FALSE)
  {
  // Errore di select del db
  $this->txtError="Error during connection to the server ".$DBSystem;
  return(false);
  }
$this->Db_Open=true;
return(true);
}
function DbExecSql($sql)
{
$this->UseLimit=FALSE;
$this->LimitStart=0;
if(!$this->Db_Open)
   {
   $this->txtError='No database open';
   return(false);
   }
if(($this->DbResult=odbc_exec($this->DbConn,$sql))===false)
  {
  // Errore di select del db
  $this->txtError="Error into sql statement. Sql string: ".$sql.".Err:". odbc_errormsg() . ": " . mysql_error();
  return(false);
  }
$this->CurrentRow[$this->DbResult]=1;
$this->LastQuery[$this->DbResult]=$sql;
return($this->DbResult);
}

function QueryLimit($select,$start=0,$many=-1)
{
// If I got an error, exit. The error text is set by DbExecSql
// and the caller should know what to do.
if(($res=$this->DbExecSql($select))===FALSE)
   return($res);
$this->UseLimit=TRUE;
// yap start limi is zero based, the odbc start from 1
$this->LimitStart=$start+1;
if($many!=-1)
   {
   $this->LimitToEnd=$many;
   }
else
   $this->LimitToEnd=999999;  // I hope that no one perform a select that returns 1000000 rows!
$this->LimitEnd=$this->LimitToEnd;
$this->CurrentRow[$res]=$this->LimitStart;
return($res);
}
function DbGetNumRow($result)
{
$nRows=odbc_num_rows($result);
if($nRows==-1)
   {
   // ODBC without numrows support. Try to guess it
   $nRows=$this->CalculateNumRows($result);
   }
if($this->UseLimit)
  {
  $newRows=$nRows-$this->LimitStart;
  $nRows=($newRows>$this->LimitEnd)?$this->LimitEnd:$newRows;
  }
return($nRows);
}


function CalculateNumRows($result)
{
$min=1;
$max=60000;  // no more then 60000 rows are returned
if(odbc_fetch_into($result,$tmp,$max))
   return($max);
if(!odbc_fetch_into($result,$tmp,$min))
   return(0);   // No row
$fine=false;
$gap=($min-$max)/2;
$corrente=$max;
while(!(abs($gap)<1))
     {
     $corrente+=floor($gap);
     if(!odbc_fetch_into($result,$tmp,$corrente))
       {
       $gap=($min-$corrente)/2;
       $max=$corrente;
       }
     else
       {
       $min=$corrente;
       $gap=($max-$min)/2;
       }
     }
odbc_fetch_into($result,$tmp,1);
return($min);
}
function DbGetNumFields($result)
{
$tmp=odbc_fetch_array($result,1);
return(count($tmp));
}
function DbFetchField($result,$FieldNo)
{
$meta=new DbMeta();
$meta->name=odbc_field_name($result,$FieldNo+1);
$type=odbc_field_type($result,$FieldNo+1);
$meta->max_length=odbc_field_len($result,$FieldNo+1);
switch($type)
    {
    case 'LONGBINARY': // Ole object
                    $meta->type='IGNORE';  // Ignore this field
                    $meta->numeric=0;
                    break;
    case 'DATETIME':  // Date format
    case 'LONGCHAR':  // memo fields
    case 'CHAR' :
    case 'VARCHAR' :
                    $meta->type=$type;
                    $meta->numeric=0;
                    break;
    case 'BIT':     // Boolean
                    $meta->type='BOOL';
                    $meta->numeric=0;
                    break;
    case 'BYTE' :
                    $meta->type='BIT';
                    $meta->numeric=0;
                    break;
    case 'CURRENCY' :
                    $meta->type='DOUBLE';
                    $meta->numeric=1;
                    break;
    case 'SMALLINT' :
    case 'INTEGER' :
    case 'DOUBLE' :
                    $meta->type=$type;
                    $meta->numeric=1;
                    break;
    }
$meta->table='';
return($meta);
}
function DbFieldFlags($result,$FieldNo)
{
$type=odbc_field_type($result,$FieldNo+1);
if($type=='COUNTER')
  $txt='auto_increment';
else
  $txt='';
return($txt);
}


function DbFreeResult($result)
{
if(!($es=odbc_free_result($result)))
   $this->txtError=odbc_errormsg();
$this->LastRow[$result]=array();
return($es);
}
function DbGetValue($result)
{
if(!$this->Db_Open)
   {
   $this->txtError='No database open';
   return(false);
   }
if($this->UseLimit&&!$this->LimitToEnd)
   return(FALSE);
if($this->UseLimit)
   $this->LimitToEnd--;
$this->LastRow[$result]=odbc_fetch_array($result,$this->CurrentRow[$result]);
$this->CurrentRow[$result]++;
return($this->LastRow[$result]);
}
function Db_Close()
{
if(!$this->Db_Open)
   {
   $this->txtError='No database open';
   return(false);
   }
odbc_close($this->DbConn);
$this->Db_Open=false;
return(true);
}


function DbaddSql($row,$fieldsType,$KeyField)
{
$Count=0;
$fName='';
$fValue='';
foreach($row as $Key => $Value)
   {
   // I Can't update the row key
   if($Key!=$KeyField)
     {
     if($Count)
       {
       $fName.=', ';
       $fValue.=', ';
       }
     $fName.='['.$Key.']';
     $apice=$fieldsType[$Key]['apice'];
     $fValue.=$apice.$this->DBEscape($Value).$apice;
     $Count++;
     }
   }
$OutText='('.$fName.') VALUES ('.$fValue.') ';
return($OutText);
}

function DbmodifySql($row,$fieldsType)
{
$OutText=' set ';
$c=0;
foreach($row as $Key => $Value)
   {
   if($c) $OutText.=', ';
   $apice=$fieldsType[$Key]['apice'];
   $OutText.='['.$Key.'] = '.$apice.$this->DBEscape($Value).$apice.' ';
   $c++;
   }
return($OutText);
}
function DbRegexCond($FieldName,$pattern)
{
return($FieldName.' like \'%'.$pattern.'%\'');
}

function DbEscape($value)
{
$quote=(bool)ini_get('magic_quotes_gpc');
if(!$quote)
   $ret=str_replace("'","''",$value);
else
   $ret=str_replace("\\","'",$value);
return($ret);
}
function DbBetweenCond($FieldName,$ValueFrom,$ValueTo,$ValueType)
{
if($ValueType=='DB_NUMBER')
  return($FieldName.' >= '.$ValueFrom.' and '.$FieldName.' <= '.$ValueTo);
else
  return($FieldName.' >= \''.$ValueFrom.'\' and '.$FieldName.' <= \''.$ValueTo.'\'');
}
}
?>