PHP: Db (Mysql) Logger Class

php_db_logger.php

<?php

class DbLogger {

	private $table_name;
	private $db;
	private $queries;
	private $errors;
	private $result;
	private $safe;
	private $connection;

	public function __construct( $table_name, $safe = false ) {
		global $con;

		$this->db = '';
		$this->errors = '';
		$this->table_name = $table_name;
		$this->queries = array();
		$this->safe = $safe;
		$this->connection = $con;
	}

	public function OpenDB( $server, $username, $password, $database ) {
		if ( $this->safe ) {
			$this->db = $this->connection;
		} else {
			$this->db = mysql_connect( $server, $username, $password );
			mysql_select_db( $database );
		}

		if ( $this->db ) {
			$this->errors = mysql_error();
		}
	}

	public function AddEvent( $arrEvent ) {
		if ( $this->db ) {
			$sql = $this->buildQuery( $arrEvent );
			array_push( $this->queries, $sql );
		}
	}

	public function GetQueries() {
		if ( is_array( $this->queries ) ) {
			$multi_sql 	= "INSERT INTO $this->table_name ( remote_addr, request_uri, `table`, event, person, status, message, log_date ) VALUES ";
			$multi_sql .= implode( ',', $this->queries ) . ";";
			return $multi_sql;
		}
	}

	public function Execute() {
		if ( $this->db ) {
			$multi_sql = $this->GetQueries();
			$this->result = mysql_query( $multi_sql );

			if ( $this->result ) {
				$this->errors = mysql_error();
			}
		}
	}

	public function ClearQueries() {
		$this->queries = array();
	}

	public function GetErrors() {
		return $this->errors;
	}

	public function CloseDb() {
		if ( $this->db ) {
			mysql_close( $this->db );
		}
	}

	private function buildQuery( $arrEvent ) {
		$sql = "(
					'$arrEvent[remote_addr]', '$arrEvent[request_uri]', '$arrEvent[table]', '$arrEvent[event]', 
					'$arrEvent[person]', '$arrEvent[status]', '$arrEvent[message]', CURRENT_TIMESTAMP
				)";
		return $sql;
	}
}