class sql
{
//::::: variables :::::
var $connection;
var $query;
var $result;
//::::: edit here the value : 1 = show errors on the site; 0 = show errors only in the source-code :::::
var $show_errors = 1;
var $host = "localhost";
var $user = "root";
var $passwd = "";
var $db = "dart";
//::::: Konstructor :::::
function sql()
{
$this->connect($this->host, $this->user, $this>passwd, $this->db);
}
//::::: Connect :::::
function connect()
{
@$this->connection = mysql_connect($this->host, $this->user, $this->passwd);
if ($this->connection)
{
$this->sel_db($this->db);
}
else
{
$this->make_error(2, "Kann nicht zur Datenbank verbinden!", mysql_errno(), mysql_error());
}
}
//::::: Select database :::::
function sel_db($db)
{
if (@!mysql_select_db($this->db, $this->connection))
{
$this->make_error(2, "Kann die Datenbank nicht auswählen! ".$this->db, mysql_errno($this->connection), mysql_error($this->connection));
}
}
//::::: query :::::
function query($str, $get = 0)
{
if(@!$this->query = mysql_query($str, $this->connection))
{
$this->make_error(2, "Kann die Abfrage nicht starten: ".$str, mysql_errno($this->connection), mysql_error($this->connection));
}
else
{
if($get == 1)
{
return $this->query;
}
}
}
//::::: fetch array :::::
function fetch_array($query = 0)
{
if ($query == 0)
{
if (@$this->result = mysql_fetch_array($this->query))
{
return $this->result;
}
}
else
{
if (@$this->result = mysql_fetch_array($query))
{
return $this->result;
}
}
}
//::::: fetch object :::::
function fetch_obj($query = 0)
{
if ($query == 0)
{
if (@$this->result = mysql_fetch_object($this->query))
{
return $this->result;
}
}
else
{
if (@$this->result = mysql_fetch_object($query))
{
return $this->result;
}
}
}
//::::: fetch assoc :::::
function fetch_assoc($query = 0)
{
if ($query == 0)
{
if (@$this->result = mysql_fetch_assoc($this->query))
{
return $this->result;
}
}
else
{
if (@$this->result = mysql_fetch_assoc($query))
{
return $this->result;
}
}
}
//::::: num_rows ::::::
function num_rows($query = 0)
{
if ($query == 0)
{
if (@$this->result = mysql_num_rows($this->query))
{
return $this->result;
}
}
else
{
if (@$this->result = mysql_num_rows($query))
{
return $this->result;
}
}
}
//::::: Error function :::::
function make_error($mode, $desc, $errno, $error)
{
/*::::: error modes :
1 = Light Error
2 = Critical Error
:::::*/
switch($mode)
{
case 1:
$mod = "Leichter Fehler :"; break;
case 2:
$mod = "Kritischer Fehler :"; break;
default:
$mod = "Fehler :"; break;
}
if ($this->show_errors == 1)
{
$err_msg = "<span style=\"color: #FF0000; font-weight: bold; font-size: 14pt;\">".$mod."</span><br />";
$err_msg .= "Beschreibung: <b>".$desc."</b><br />";
$err_msg .= "MySQL error nummer: <b>".$errno."</b><br />";
$err_msg .= "MySQL error Beschreibung: <b>".$error."</b><br />";
$err_msg .= "Zeit: <b>".date("d.m.y :: H:i:s")."</b<br />";
$err_msg .= "<b>Bitte wenden Sie sich an den Administrator!<br /><a href=\"mailto: marcus.wolf@impuls-systems.de\">.:Administrator:.</a></b><br />";
die ($err_msg);
}
elseif ($this->show_errors == 0)
{
$err_msg = $mod."\n";
$err_msg .= "Description: ".$desc."\n";
$err_msg .= "MySQL error nummer: ".$errno."\n";
$err_msg .= "MySQL error description: ".$error."\n";
$err_msg .= "Time: ".date("d.m.y :: H:i:s")."\n";
$err_msg .= "Please contact the Administrator! :: Bitte wenden Sie sich an den Administrator! admin@sintima.de \n";
die ("<!--".$err_msg."//-->");
}
}
}
