<?php

class mysql {

var $host = "";
var $user = "";
var $pass = "";
var $database = "";
var $persistency = false;
var $serverid = "";
var $error = array();

function mysql($host, $user, $pass, $database, $persistency = false) {

$this->host = $host;
$this->user = $user;
$this->pass = $pass;
$this->database = $database;
$this->persistency = $persistency;

if($this->persistency) {

$this->serverid = @mysql_pconnect($this->host, $this->user, $this->pass);

}
else {

$this->serverid = @mysql_connect($this->host, $this->user, $this->pass);

}

if(!($this->serverid)) {

$this->error["error"] = true;
$this->error["msg"] = "Es konnte keine Verbindung zum Datenbank-Server hergestellt werden.";
return false;

}
else {

if($this->database == "") {

$this->error["error"] = true;
$this->error["msg"] = "Es wurde keine Datenbank angegeben";
return false;

}
else {

$list = mysql_list_dbs($this->serverid);

$db_exists = false;

while($db = mysql_fetch_object($list)) {

if($db->Database == $this->database) {

$db_exists = true;

}

}

if($db_exists == false) {

if(!(mysql_create_db($this->database, $this->serverid))) {

$this->error["error"] = true;
$this->error["msg"] = "Datenbank konnte nicht angelegt werden.";
return false;

}
else {

if(!(mysql_select_db($this->database, $this->serverid))) {

$this->error["error"] = true;
$this->error["msg"] = "Datenbank konnte nicht ausgewählt werden.";
return false;

}

}

}
else {

if(!(mysql_select_db($this->database, $this->serverid))) {

$this->error["error"] = true;
$this->error["msg"] = "Datenbank konnte nicht ausgewählt werden.";
return false;

}

}

}

}

}

function shut() {

if(!($this->serverid)) {

$this->error["error"] = true;
$this->error["msg"] = "Verbindung konnte nicht getrennt werden, da keine besteht.";
return false;

}
else {

@mysql_close($this->serverid);
return true;

}

}

}

?>