簡單的MySql class

引用：http://www.phpclasses.org/package/7572-PHP-Setup-MySQL-database-connections.html
<?php
////////////////////////////////////////////
//@Product Name : Connect to MySQL Class //
//@Coding By : hossam Youssef //
//@Copyright © 2010 - 2012 //
////////////////////////////////////////////

// Class
class database {
public $db_host;
public $db_user;
public $db_pass;
public $db_name;

// That to start connection with MySQL
function db_connect(){
// connect with MySQL
$connect = @mysql_connect($this->db_host,$this->db_user,$this->db_pass);
if(!$connect){
@mysql_close($connect);
die ("<h1><font color='#000000'><center>MySQL DataBase Not<font color='#FF0000'style='text-decoration:blink;'> Connected !</font></center></font></h1>");
return false;
}
return true;
}

// Here you have select database with MySQL
function db_select(){
// Select with Database
$select = @mysql_select_db($this->db_name);
if(!$select){
@mysql_close($connect);
die ("<h1><font color='#000000'><center>Not <font color='#FF0000'style='text-decoration:blink;'>Selected</font> DataBase !</center></font></h1>");
return false;
}
return true;
}

// Here you select charset UTF8 with Database
function charset_UTF8(){
// MySQL connection collation UTF8
@mysql_query("SET names 'UTF8'");
@mysql_query("SET charset 'UTF8'");
@mysql_query("SET character_set_client = UTF8");
@mysql_query("SET character_set_connection = UTF8");
@mysql_query("SET character_set_database = UTF8");
@mysql_query("SET character_set_results = UTF8");
@mysql_query("SET character_set_server = UTF8");
}

// MySQL Close connect Function
function close(){
global $connect;
@mysql_close($connect);
}
}

// start show
$db = new database();
/* The hostname of the MySQL server */
$db->db_host = "localhost";
/* The username to login to MySQL */
$db->db_user = "root";
/* The password to login to MySQL */
$db->db_pass = "123";
/* The name of the MySQL database */
$db->db_name = "tesr";

// Call class
$db->db_connect();
$db->db_select();
$db->charset_UTF8();

// Close connect
//$db->close();
?>

同場加映：人生是永遠的測試版：新創企業家改寫生涯的方程式