<?php
/**
	Datenbankklasse
	Autor: Sebastian Lenz (lenzy)
	Homepage: http://www.lenzy.de/
	Version: 1
	Benötigte Konstanten: DB_HOST, DB_USER, DB_PASSWORD, DB_DATABASE
*/
class db
{
	var $db;
	
	function db()
	{
		$this->db_connect();
	}
	
	function db_connect()
	{
		$this->db = new mysqli(DB_HOST, DB_USER, DB_PASSWORD, DB_DATABASE);
		if($this->db->connect_error)
		{
			die("Database Error (" . $this->db->connect_errno . ") " . $this->db->connect_error . " Please contact the siteadmin.");
		}
		if(!$this->db->set_charset("utf8"))//setting DB-Connection to utf8
		{
			printf("Error loading character set utf8: %s\n", $this->db->error);
		}
	}
	
	function db_close()
	{
		$this->db->close();
	}
	
	function db_query($query, $query_type = "selection")
	{
		if($query_type == "selection")
		{
			if($result = $this->db->query($query))
			{
				/* fetch associative array */
				$return = array();
				while($row = $result->fetch_assoc())
				{
					$return[] = $row;
				}
				/* free result set */
				$result->close();
				return $return;
			}
			else
			{
				die("Query Error! " . $this->db->error);
			}
		}
		if($query_type = "manipulation")
		{
			if($result = $this->db->query($query))//manipulating database
			{
				return true;
			}
			else
			{
				return false;
			}
		}
	}
	
	function db_num_rows($query)
	{
		if($result = $this->db->query($query)->num_rows)
		{
			return $result;
		}
	}
	
	function sql_safe_str($str)
	{
		if(get_magic_quotes_gpc() == 1)
		{
			$str = stripslashes($str);
		}
		return (NULL === $str ? 'NULL' : mysql_escape_string ($str));
	}
	
	function sql_safe_int($int)
	{
		return (NULL === $int ? "NULL" : intVal ($int));
	}
}
?>