Function that takes your mysqli connection object and a query string and returns a mysql result object

gistfile1.txt

// Performs a database query using PHP's MYSQLI class
// Returns a result object if successful
// Else dies and displays the SQL error and the query string that failed

function db_query($mysqli, $sql) {

	$result = $mysqli->query($sql);
	
	if (!$result) {
		$message = "SQL error: ".$mysqli->errno." ".$mysqli->error.'<br>';
		$message.= "Failed query: ".$sql;
		die($message);
		
	} else {
		return $result;
		
	}
}