De class:


<?php

class MySQL {
	
	var $query_count = 0;
	var $last_query = '';
	
	function connect($host, $username, $password = '', $dbname) {
		
		mysql_connect($host,$username,$password) or die('Er ging iets fout bij het connecten naar de database:<br /><b>'.mysql_error().'</b>');
		mysql_select_db($dbname) or die('Er ging iets fout bij het selecteren van de database:<br /><b>'.mysql_error().'</b>');
	}
	
	function query($query) {
		
		$this->last_query = $query;
		
		$query = mysql_query($query) or die('Er ging iets fout bij het uitvoeren van query '. ($this->query_count + 1) .':<br /><br /><b>'.mysql_error().'</b><br />Query:<br /><br />'.$this->last_query);
		
		$this->query_count++;
		
		return $query;
	}
	
	function fetch($query, $type = 'assoc') {
		
		if ($type == 'array') {
	
			$query = mysql_fetch_array($query);
		}

		elseif ($type == 'assoc') {

			$query = mysql_fetch_assoc($query);
		}
		
		else {

			$query = mysql_fetch_object($query);
		}

		return $query;
	}
	
	function num_rows($query) {
		
		$query = mysql_num_rows($query);
		
		return $query;
	}

	function close() {

		mysql_close();
	}
	
}

?>