<?
class CMYSQL
{
var $CMYSQL_IP;
var $CMYSQL_USER;
var $CMYSQL_PASS;
var $CMYSQL_DB;
var $CMYSQL_CON=false;
var $CMYSQL_ROW;
var $CMYSQL_QUID;
var $CMYSQL_QUAR = array();
var $CMYSQL_COUNTER;
var $CMYSQL_DIEOPTS;
//----------------------------------------------------------------------------------
// constructor
//----------------------------------------------------------------------------------
function CMYSQL($DB, $IP, $USER, $PASS, $dieopts = true)
{
$this->CMYSQL_IP = $IP;
$this->CMYSQL_USER = $USER;
$this->CMYSQL_PASS = $PASS;
$this->CMYSQL_DB = $DB;
$this->CMYSQL_DIEOPTS = $dieopts;
}
//----------------------------------------------------------------------------------
// connect to database
//----------------------------------------------------------------------------------
function connect()
{
$this->CMYSQL_CON = mysql_connect($this->CMYSQL_IP, $this->CMYSQL_USER, $this->CMYSQL_PASS);
if(!$this->CMYSQL_CON && $this->CMYSQL_DIEOPTS)
DIE("Connection failed");
$dbsel = mysql_select_db($this->CMYSQL_DB,$this->CMYSQL_CON);
if(!$dbsel && $this->CMYSQL_DIEOPTS)
DIE("Database ".$this->CMYSQL_DB." no selectable");
}
//----------------------------------------------------------------------------------
// diconnect from database
//----------------------------------------------------------------------------------
function disconnect()
{
if($this->CMYSQL_CON != false)
return mysql_close($this->CMYSQL_CON);
}
//----------------------------------------------------------------------------------
// change to other database
//----------------------------------------------------------------------------------
function change_db($DB)
{
$this->CMYSQL_DB = $DB;
$dbsel = mysql_select_db($this->CMYSQL_DB,$this->CMYSQL_CON);
if(!$dbsel && $this->CMYSQL_DIEOPTS)
DIE("Database ".$this->CMYSQL_DB." no selectable.");
}
//----------------------------------------------------------------------------------
// select data from database
//----------------------------------------------------------------------------------
function select($query)
{
unset($this->CMYSQL_QUAR);
$this->CMYSQL_QUID = mysql_query($query,$this->CMYSQL_CON);
if($this->CMYSQL_QUID != false)
{
for($this->CMYSQL_COUNTER=0;
$this->CMYSQL_ROW = mysql_fetch_array($this->CMYSQL_QUID, MYSQL_ASSOC);
$this->CMYSQL_COUNTER++)
{
$this->CMYSQL_QUAR[$this->CMYSQL_COUNTER] = $this->CMYSQL_ROW;
}
if($this->CMYSQL_COUNTER != 0)
return $this->CMYSQL_QUAR;
}
return false;
}
//----------------------------------------------------------------------------------
// execute updates or inserts
//----------------------------------------------------------------------------------
function no_result($query)
{
$this->CMYSQL_QUID = mysql_query($query,$this->CMYSQL_CON);
if($this->CMYSQL_QUID != false)
return true;
else
return false;
}
}
?>
