bugs/php/database.php

<?php
	require_once(realpath(dirname(__FILE__)).'/config.php');
	function get_sql(){
		static $sql;
		if(is_null($sql)){
			$sql = new mysqli(get('host'),get('user'),get('password'),get('database'));
			if($sql && $sql->connect_errno){
				die("Failed to connect to MySQL: ".$sql->connect_error);
			}
			if(!$sql->autocommit(true)){
				die("Failed to connect to MySQL: ".$sql->connect_error);
			}
		}
		return $sql;
	}
	function query($query,$args=Array()){
		$sql = get_sql();
		for ($i=0;$i<count($args);$i++){
			if(is_string($args[$i])){
				$args[$i] = get_sql()->real_escape_string($args[$i]);
			}elseif(!is_numeric($args[$i])){
				return false;
			}
		}
		return get_sql()->query(vsprintf($query,$args));
	}
	function fetch_all($result,$type=MYSQLI_NUM){
		if(method_exists('mysqli_result', 'fetch_all')){
			$res = $result->fetch_all($type);
		}else{
			for($res = array(); $tmp = $result->fetch_array($type);){
				$res[] = $tmp;
			}
		}
		return $res;
	}
?>