CYap_Mysql.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_mysql extends CYapDB {

function CYap_mysql()
{
CYapDB::CYapDB();
}
function OpenDb($DBSystem,$DBUser="",$DBPasswd="")
{
if($this->Db_Open)
   {
   $this->txtError='Database already open';
   return(false);
   }
if(($this->DbConn=mysql_connect($DBSystem,$DBUser,$DBPasswd))===FALSE)
  {
  // Errore di select del db
  $this->txtError="Error during connection to the server ".$DBSystem;
  return(false);
  }
$this->Db_Open=true;
return(true);
}
function SelectDb($DBname)
{
if(!$this->Db_Open)
   {
   $this->txtError='No database open';
   return(false);
   }
if(!mysql_select_db($DBname,$this->DbConn))
  {
  // Errore di select del db
  $this->txtError="I cannot select the db ".$DBname;
  return(false);
  }
return(true);
}
function DbExecSql($sql)
{
if(!$this->Db_Open)
   {
   $this->txtError='No database open';
   return(false);
   }
if(($this->DbResult=mysql_query($sql))===FALSE)
  {
  // Errore di select del db
  $this->txtError="Error into sql statement. Sql string: ".$sql.".Err:". mysql_errno() . ": " . mysql_error();
  return(false);
  }
return($this->DbResult);
}
function QueryLimit($select,$start=0,$many=-1)
{
$sql=$select. " limit ".$start;
if($many!=-1)
   $sql.=",".$many;
return($this->DbExecSql($sql));
}
function DbGetNumRow($result)
{
return(mysql_num_rows($result));
}
function DbGetNumFields($result)
{
return(mysql_num_fields($result));
}
function DbFetchField($result,$FieldNo)
{
return(mysql_fetch_field($result));
}
function DbFieldFlags($result,$FieldNo)
{
return(mysql_field_flags($result,$FieldNo));
}
function DbFreeResult($result)
{
if(!($es=mysql_free_result($result)))
   $this->txtError=mysql_error();
return($es);
}
function DbGetValue($result)
{
if(!$this->Db_Open)
   {
   $this->txtError='No database open';
   return(false);
   }
return(mysql_fetch_array($result,MYSQL_ASSOC));
}
function Db_Close()
{
if(!$this->Db_Open)
   {
   $this->txtError='No database open';
   return(false);
   }
mysql_close($this->DbConn);
$this->Db_Open=false;
return(true);
}
function DbEscape($value)
{
$quote=(bool)ini_get('magic_quotes_gpc');
if(!$quote)
   $ret=mysql_real_escape_string($value);
else
   $ret=$value;
return($ret);
}
function DbRegexCond($FieldName,$pattern)
{
return($FieldName.' regexp \''.$pattern.'\'');
}
function DbBetweenCond($FieldName,$ValueFrom,$ValueTo,$ValueType)
{
if($ValueType=='DB_NUMBER')
  return($FieldName.' between '.$ValueFrom.' and '.$ValueTo);
else
  return($FieldName.' between \''.$ValueFrom.'\' and \''.$ValueTo.'\'');
}
}
 ?>