<?php
// SET THESE VALUES TO MATCH YOUR DATA CONNECTION
private $db_host = "localhost"; // server name
private $db_user = "root"; // user name
private $db_pass = ""; // password
private $db_dbname = "moymir"; // database name
private $db_charset = "cp1251"; // optional character set (i.e. utf8)
private $db_pcon = false; // use persistent connection?
// class-internal variables - do not change
private $error_desc = ""; // mysql error string
private $error_number = 0; // mysql error number
private $mysql_link = 0; // mysql link resource
private $sql = ""; // mysql query
private $result; // mysql query result
/**
* Determines if an error throws an exception
*
* @var boolean Set to true to throw error exceptions
*/
public $ThrowExceptions = false;
/**
* Constructor: Opens the connection to the database
*
* @param boolean $connect (Optional) Auto-connect when object is created
* @param string $database (Optional) Database name
* @param string $server (Optional) Host address
* @param string $username (Optional) User name
* @param string $password (Optional) Password
* @param string $charset (Optional) Character set
*/
function __construct($pcon=false, $server="", $username="", $password="", $database="", $charset="") {
if ($pcon) $this->db_pcon = true;
if (strlen($server) > 0) $this->db_host = $server; if (strlen($username) > 0) $this->db_user = $username; if (strlen($password) > 0) $this->db_pass = $password; if (strlen($database) > 0) $this->db_dbname = $database; if (strlen($charset) > 0) $this->db_charset = $charset;
//
if (strlen($this->db_host) > 0 && strlen($this->db_user) > 0) {
$this->Open();
}
}
/**
* Connect to specified MySQL server
*
* @return boolean Returns TRUE on success or FALSE on error
*/
private function Open()
{
$this->ResetError();
// Open persistent or normal connection
if ($this->db_pcon) {
$this->mysql_link = @mysql_pconnect($this->db_host, $this->db_user, $this->db_pass); } else {
$this->mysql_link = @mysql_connect ($this->db_host, $this->db_user, $this->db_pass); }
// Connect to mysql server failed?
if (! $this->IsConnected()) {
$this->SetError();
return false;
}
else // Connected to mysql server
{
//
// Select a database (if specified)
if (strlen($this->db_dbname) > 0) { if (strlen($this->db_charset) == 0) { if (! $this->SelectDatabase($this->db_dbname)) {
return false;
} else {
return true;
}
} else {
if (! $this->SelectDatabase($this->db_dbname, $this->db_charset)) {
return false;
} else {
return true;
}
}
} else {
return true;
}
}
}
/**
* Executes the given SQL query and returns the result
*
* @param string $sql The query string
* @return (boolean, string, object, array with objects) result
*/
public function Query($sql, $debug = false) {
$this->ResetError();
$this->sql = $sql;
$this->result = @mysql_query($this->sql, $this->mysql_link); // show debug info
if($debug) self::ShowDebugInfo("sql=".$this->sql);
// start the analysis
if (TRUE === $this->result) { // simply result
$return = TRUE; // successfully (for example: INSERT INTO ...)
}
else if (FALSE === $this->result)
{
$this->SetError();
if($debug)
{
self::ShowDebugInfo("error=".$this->error_desc);
self::ShowDebugInfo("number=".$this->error_number);
}
$return = FALSE; // error occured (for example: syntax error)
}
else // complex result
{
case 0:
$return = NULL; // return NULL rows
break;
case 1: // return one row ...
else
{
$return = $row[0];
}
break;
default:
}
}
return $return;
}
/**
* Determines if a valid connection to the database exists
*
* @return boolean TRUE idf connectect or FALSE if not connected
*/
public function IsConnected() {
if (gettype($this->mysql_link) == "resource") { return true;
} else {
return false;
}
}
/**
* Selects a different database and character set
*
* @param string $database Database name
* @param string $charset (Optional) Character set (i.e. utf8)
* @return boolean Returns TRUE on success or FALSE on error
*/
public function SelectDatabase($database, $charset = "") {
$return_value = true;
if (! $charset) $charset = $this->db_charset;
$this->ResetError();
$this->SetError();
$return_value = false;
} else {
if (! (mysql_query("SET CHARACTER SET '{$charset}'", $this->mysql_link))) { $this->SetError();
$return_value = false;
}
}
}
return $return_value;
}
/**
* Clears the internal variables from any error information
*
*/
private function ResetError() {
$this->error_desc = '';
$this->error_number = 0;
}
/**
* Show debug info
*/
static function ShowDebugInfo($string=""){
print "<br>--- ".$string." ---<br>\r\n";
}
/**
* Sets the local variables with the last error information
*
* @param string $errorMessage The error description
* @param integer $errorNumber The error number
*/
private function SetError($errorMessage = '', $errorNumber = 0) {
try {
// get/set error message
if (strlen($errorMessage) > 0) { $this->error_desc = $errorMessage;
} else {
if ($this->IsConnected()) {
} else {
}
}
// get/set error number
if ($errorNumber <> 0) {
$this->error_number = $errorNumber;
} else {
if ($this->IsConnected()) {
} else {
}
}
} catch(Exception $e) {
$this->error_desc = $e->getMessage();
$this->error_number = -999;
}
if ($this->ThrowExceptions) {
throw new Exception($this->error_desc);
}
}
/**
* Destructor: Closes the connection to the database
*
*/
public function __destruct() {
$this->Close();
}
/**
* Close current MySQL connection
*
* @return object Returns TRUE on success or FALSE on error
*/
public function Close() {
$this->ResetError();
$success = $this->Release();
if ($success) {
if (! $success) {
$this->SetError();
} else {
unset($this->mysql_link); }
}
return $success;
}
/**
* Frees memory used by the query results and returns the function result
*
* @return boolean Returns TRUE on success or FALSE on failure
*/
public function Release() {
$this->ResetError();
if (! $this->result) {
$success = true;
} else {
if (! $success) $this->SetError();
}
return $success;
}
}// end
?>
Главная
Помощь
Поиск
Пользователи
Форумы портала PHP.SU » PHP » Программирование на PHP (Модераторы: valenok, OrmaJever, Саныч)
Описание: Трабла с выводом + цикл
