# Baue datenbank verbindung auf

$db = new db($dbhost, $dbuser, $dbpass, $db);




z.b ein Query
$result2=$db->query("SELECT * FROM ap_revenueAssurance WHERE revPacketNumber='{$packagesTrackingNumber}'");
$row2=$db->fetch_array($result2);



<?PHP
class db {

	var $sql_host = "";
	var $sql_user = "";
	var $sql_pass = "";
	var $sql_base = "";
	var $link_id = 0;
	var $sql_count = 0;

	function db($host,$user,$pass,$base) {
		$this->sql_host=$host;
		$this->sql_user=$user;
		$this->sql_pass=$pass;
		$this->sql_base=$base;
		$this->connect();
	}

	function connect() {
		$this->link_id=@mysql_connect($this->sql_host,$this->sql_user,$this->sql_pass);
		if(!$this->link_id) $this->error("False link == Error to connect the database");
		$selecting_base=@mysql_select_db($this->sql_base);
		if(!$selecting_base) $this->error("Flase base == Error to select the database");
	}

	function query($query_string) {
		$selecting_query=@mysql_query($query_string);
		$this->sql_count ++;
		if(!$selecting_query) $this->error("False query == $query_string");
		return $selecting_query;
	}

	function fetch_array($result_string) {
		$selecting_result=@mysql_fetch_array($result_string);
		return $selecting_result;
	}

	function fetch_object($result_string) {
		$selecting_result=@mysql_fetch_object($result_string);
		return $selecting_result;
	}

	function num_rows($result_string) {
		$selecting_result=@mysql_num_rows($result_string);
		return $selecting_result;
	}

	function unbuffered_query($query_string) {
		$selecting_result=mysql_unbuffered_query($query_string);
		if(!$selecting_result) $this->error("False query == $query_string");
		return $selecting_result;
	}

	function insert_id() {
		$query_id=@mysql_insert_id($this->link_id);
		return $query_id;
	}

	function escape_string($string){
		return mysql_real_escape_string($string);
	}

	function number_of_querys() {
		return $this->sql_count ;
	}

	function fetch_row($result_string) {
    $selecting_result=@mysql_fetch_row($result_string);
    return $selecting_result;
  }



	function error($error) {
		echo ("<title>Error by Base</title>");
		echo ("Error: <b>$error</b><br>\n");
		echo ("SQL-Error: ".mysql_error()."<br>\n");
		echo ("Derzeit gibt es Datenbank Probleme, bitte haben Sie etwas gedult.");
		#header('Location: install.php');
		exit();
	}


}