Community Company Search Contact

mysqli.php from ECP (EliteCore Project) at Krugle

Show mysqli.php syntax highlighted

<?php
class DB extends DB_abstract {
	protected static $result;
	protected static $Thread = null; // connection pointer
	protected static $lastQuery = null;
	protected static $lastResult = null;

	public static function Connect($host, $username, $passwd, $dbname, $prefix = 'xcs', $port = '', $socket = '') {
		parent :: Connect($host, $username, $passwd, $dbname);
		self :: $prefix = $prefix;
		if ($port == '' || $socket == '')
			self :: $Thread = new mysqli($host, $username, $passwd, $dbname); // connect to server
		else
			self :: $Thread = new mysqli($host, $username, $passwd, $dbname, (int) $port, $socket); // connect to server with port and socket settings
		if (mysqli_connect_errno()) {
			exit ('<br/>Connect failed: '.mysqli_connect_error());
		}
	}
	public static function ServerVersion() {
		return self :: $Thread->server_version;
	}
	public static function ServerInfo() {
		return self :: $Thread->server_info;
	}
	public static function Test() {
		printf("<br/>Host information: %s", self :: $Thread->host_info);
		printf("<br/>Character set: %s", self :: $Thread->character_set_name());
	}
	public static function EscapeString($string) {
		return self :: $Thread->real_escape_string($string);
	}
	public static function SelectDB($dbname) {
		return self :: $Thread->select_db($dbname);
	}
	public static function MultiQuery($queries) {
		if (!self :: $result = self :: $Thread->multi_query($queries)) {
			exit ("<p>You have error in your query: ".$queries."</p>");
		}
		Debug :: add_report("SQL: ".$queries, 0);
		self :: $lastQuery = $queries;
		return self :: $result;
	}
	public static function Query($query) {
		global $Config;
		if (false === (self :: $result = self :: $Thread->query($query))) {
			exit ("<p>You have error in your query: ".$query."</p>");
		}
		Debug :: add_report("SQL: ".$query, 0);
		self :: $lastQuery = $query;
		return self :: $result;
	}
	public static function NumRows($result = null) {
		if (isset ($result))
			self :: $result = $result;
		return self :: $result->num_rows;
	}
	public static function NumFields($result = null) {
		if (isset ($result))
			self :: $result = $result;
		return self :: $result->field_count;
	}
	public static function FetchRow($result = null) {
		if (isset ($result))
			self :: $result = $result;
		return self :: $result->fetch_row();
	}
	public static function FetchObject($result = null) {
		if (isset ($result))
			self :: $result = $result;
		return self :: $result->fetch_object();
	}
	public static function FetchArray($result = null) {
		if (isset ($result))
			self :: $result = $result;
		return self :: $result->fetch_array(MYSQLI_BOTH);
	}
	public static function Error() {
		return self :: $Thread->error;
	}
	public static function Close() {
		if (self :: $isConnected)
			$retval = self :: $Thread->close();
		else
			$retval = false;
		return $retval;
	}
	public static function CloseResult($result = null) {
		if (isset ($result))
			self :: $result = $result;
		self :: $result->close();
	}
}
?>

See more files for this project here

ECP (EliteCore Project)

EliteCore Project is a PHP5.1/Javascript/AJAX/XHTML/CSS framework for creating WEB 2.0 applications and services.The basic open-source instalation can be also used as an interactive personal page or BLOG.This project uses the latest features available.

Project homepage: http://sourceforge.net/projects/elitecore
Programming language(s): JavaScript,PHP,XML
License: cpl

  mysql.php
  mysqli.php