db_host = "localhost";
$this->db_user = "dmo2_5admin";
$this->db_passwort = "dmo2_5_Passwort_ist_viel_zu_sicher_als_dass_es_jemand_errät.Ich_könnte_es_in_den_source_scrheiben_und_es_brächte_nix";
$this->db = "dmo2_5";
$this->connect($this->db_host,$this->db_user,$this->db_passwort);
if (!mysql_select_db($this->db, $this->connid))
{
echo "Fehler beim Auswählen der DB...";
echo mysql_error();
}
}
#
# MySQL Methoden
#
function connect($host,$user,$passwort)
{
if(!$this->connid = mysql_connect($host, $user, $passwort))
{
echo "Fehler beim Verbinden...";
echo mysql_errno().": ".mysql_error();
}
return $this->connid;
}
function DM_mysql_query($query, $file = null, $line = null)
{
$GLOBALS['last_sql_query'] = $query;
$query_result = mysql_query($query, $this->connid);
//print_r($query);
if (!$query_result && $file != null)
{
die($this->DM_mysql_error($file, $line));
}
$this->count_querys();
if(mysql_error())
{
echo mysql_errno().": ".mysql_error();
echo "
".$query;
}
return $query_result;
}
function DM_mysql_array($query, $file = null, $line = null)
{
$GLOBALS['last_sql_query'] = $query;
$query_result = $this->DM_mysql_query($query, $this->connid);
$counter = 0;
while($q_arr = @mysql_fetch_array($query_result))
{
$query_array[$counter]=$q_arr;
$counter++;
}
$this->count_querys();
@reset($query_array);
if($query_array[1]!=NULL)
{
return $query_array;
}
else
{
}
return $query_array;
}
function DM_mysql_num_rows($query, $file = null, $line = null)
{
$GLOBALS['last_sql_query'] = $query;
$query_result = $this->DM_mysql_query($query, $this->connid);
$num = mysql_num_rows($query_result);
$this->count_querys();
//print_r($num);
return $num;
}
function count_querys($inc = true)
{
static $querys = 0;
if ($inc==true)
{
$querys++;
}
return $querys;
}
function DM_mysql_error($file = null, $line = null, $log = true)
{
$re = "Mysql Fehler" . ($file != "" ? " in " . $file . "(" . $line . ")" : "") . ":" . ($GLOBALS['last_sql_query'] ? "\n- Query: " . $GLOBALS['last_sql_query'] . "
\n" : "") . "- Fehlermeldung: " . mysql_errno() . " - " . mysql_error() . "
\n