require('config.inc.php'); //Configurationsfile
$server = $config['database_server'];
$user = $config['database_user'];
$pass = $config['database_password'];
$dbname = $config['database_name'];
function dbConnect() {
global $server;
global $user;
global $pass;
global $dbname;
$conn = @mysql_connect($server, $user, $pass);
if (!$conn) { return FALSE; } else { return True; }
}
function dbAbfrage($sql) {
global $server;
global $user;
global $pass;
global $dbname;
$conn = @mysql_connect($server, $user, $pass);
if (!$conn) { return FALSE; }
$select = mysql_select_db($dbname,$conn);
$result = mysql_query($sql, $conn);
if ((!$result) or (empty($result))) {
mysql_errorhandler("Datenbankabfrage gescheitert", $sql);
return false;
}
$count = 0;
$data = array();
while ($row = mysql_fetch_array($result)) {
$data[$count] = $row;
$count++;
}
mysql_free_result($result);
return $data;
}
function dbModify($sql) {
global $server;
global $user;
global $pass;
global $dbname;
$conn = mysql_connect($server, $user, $pass);
$select = mysql_select_db($dbname,$conn);
$result = mysql_query($sql, $conn);
if ((!$result) or (empty($result))) {
mysql_errorhandler("Datenbankabfrage gescheitert", $sql);
return false;
}
}
function mysql_errorhandler($problem, $query = "") {
echo "Datenbankfehler:
\n";
echo "Problem: $problem
\n";
if($query != "") {
echo "Query: $query
\n";
}
echo "MySQL: ".mysql_errno()." - ".mysql_error()."
\n";
}
function dbAbfrageEmpty($sql) {
global $server;
global $user;
global $pass;
global $dbname;
$conn = mysql_connect($server, $user, $pass);
$select = mysql_select_db($dbname,$conn);
$result = mysql_query($sql, $conn);
if (mysql_num_rows($result)) {$datensatz=1;} else {$datensatz=0;}
mysql_free_result($result);
return $datensatz;
}
function dbAbfrageCount($sql) {
global $server;
global $user;
global $pass;
global $dbname;
$conn = mysql_connect($server, $user, $pass);
$select = mysql_select_db($dbname,$conn);
$result = mysql_query($sql, $conn);
$row=mysql_fetch_row($result);
$result=$row[0];
return $result;
}
function dbAbfrageAssoc($sql) {
global $server;
global $user;
global $pass;
global $dbname;
$conn = mysql_connect($server, $user, $pass);
$select = mysql_select_db($dbname,$conn);
$result = mysql_query($sql, $conn);
if ((!$result) or (empty($result))) {
mysql_errorhandler("Datenbankabfrage gescheitert", $sql);
return false;
}
$count = 1;
$data = array();
while ($row = mysql_fetch_assoc($result)) {
$data[][$count] = $row;
$count++;
}
mysql_free_result($result);
return $data;
}