mysqli.php
View Options

	<?php

	/**
	* Keruald, core libraries for Pluton and Xen engines.
	* (c) 2010, 2014, Sébastien Santoro aka Dereckson, some rights reserved
	* Released under BSD license
	*
	* MySQLi layer and helper class
	*/

	if (!defined('SQL_LAYER')) {
	define('SQL_LAYER', 'MySQL');

	/**
	* SQL layer and helper class: MySQLi
	*
	* @package Keruald
	* @subpackage Keruald
	* @copyright Copyright (c) 2010, Sébastien Santoro aka Dereckson
	* @license Released under BSD license
	* @version 0.1
	*/
	class sql_db {
	/*
	* @var int the connection identifier
	*/
	private $db;

	/**
	* Singleton instance
	*
	* @var sql_db
	*/
	private static $instance = null;

	/**
	* Initializes a new instance of the database abstraction class, for MySQLi engine
	*/
	function __construct($host = 'localhost', $username = '', $password = '', $database = '') {
	//Connects to MySQL server
	$this->db = new mysqli($host, $username, $password) or $this->sql_die();

	//Selects database
	if ($database != '') {
	$this->db->select_db($database);
	}

	$db->set_charset('utf8');
	}

	static function load() {
	if (self::$instance === null) {
	self::makeSingletonInstance();
	}

	return self::$instance;
	}

	private static function makeSingletonInstance() {
	global $Config;

	self::$instance = new sql_db(
	$Config['sql']['host'], $Config['sql']['username'],
	$Config['sql']['password'], $Config['sql']['database']
	);

	unset($Config['sql']);
	}

	/**
	* Outputs a can't connect to the SQL server message and exits.
	* It's called on connect failure
	*/
	private function sql_die () {
	//You can custom here code when you can't connect to SQL server
	//e.g. in a demo or appliance context, include('start.html'); exit;
	die ("Can't connect to SQL server.");
	}

	/**
	* Sends a unique query to the database
	*
	* @return mixed if the query is successful, a mysqli_result instance ; otherwise, false
	*/
	function sql_query ($query) {
	return $this->db->query($query);
	}

	/**
	* Fetches a row of result into an associative array
	*
	* @return array an associative array with columns names as keys and row values as values
	*/
	function sql_fetchrow ($result) {
	return $result->fetch_array();
	}

	/**
	* Gets last SQL error information
	*
	* @return array an array with two keys, code and message, containing error information
	*/
	function sql_error () {
	return [
	'code' => $this->db->errno,
	'message' => $this->db->error
	];
	}

	/**
	* Gets the number of rows affected or returned by a query
	*
	* @return int the number of rows affected (delete/insert/update) or the number of rows in query result
	*/
	function sql_numrows ($result) {
	return $result->num_rows;
	}

	/**
	* Gets the primary key value of the last query (works only in INSERT context)
	*
	* @return int the primary key value
	*/
	function sql_nextid () {
	return $this->db->insert_id;
	}

	/**
	* Express query method, returns an immediate and unique result
	*
	* @param string $query the query to execute
	* @param string $error_message the error message
	* @param boolean $return_as_string return result as string, and not as an array
	* @return mixed the row or the scalar result
	*/
	function sql_query_express ($query = '', $error_message = "Impossible d'exécuter cette requête.", $return_as_string = true) {
	if ($query === '' \|\| $query === false \|\| $query === null) {
	//No query, no value
	return '';
	} elseif (!$result = $this->sql_query($query)) {
	//An error have occured
	message_die(SQL_ERROR, $error_message, '', '', '', $query);
	} else {
	//Fetches row
	$row = $this->sql_fetchrow($result);

	//If $return_as_string is true, returns first query item (scalar mode) ; otherwise, returns row
	return $return_as_string ? $row[0] : $row;
	}
	}

	/*
	* Escapes a SQL expression
	* @param string expression The expression to escape
	* @return string The escaped expression
	*/
	function sql_escape ($expression) {
	return $this->db->real_escape_string($expression);
	}

	/**
	* Sets charset
	*/
	function set_charset ($encoding) {
	$this->db->set_charset($encoding);
	}
	}
	}

File Metadata

Mime Type: text/x-php
Expires: Sat, Oct 11, 20:03 (8 h, 17 m)
Storage Engine: blob
Storage Format: Raw Data
Storage Handle: 3061044
Default Alt Text: mysqli.php (5 KB)

mysqli.php
No OneTemporary
Actions

mysqli.php
View Options

File Metadata

Event Timeline

mysqli.phpNo OneTemporaryActions

mysqli.phpView Options

File Metadata

Event Timeline

mysqli.php
No OneTemporary
Actions

mysqli.php
View Options