Mysql.class.php file See http://www.jb51.net/article/25496.htm
Copy Code code as follows:
<?php
Include MySQL operations class
Include_once ' Mysql.class.php ';
Local MySQL Data
$mysql _local_data = Array (' db_host ' => ' localhost '),
' Db_user ' => ' root ',
' Db_pass ' => ' root ',
' Db_name ' => ' test ');
Remote MySQL Data
$mysql _remote_data = Array (' db_host ' => ' 61.183.41.178 '),
' Db_user ' => ' XXX ',
' Db_pass ' => ' XXX ',
' Db_name ' => ' XXX ');
Public data
$TB _prefix = ' php95_ ';
$db _charset = ' UTF-8 ';
Successful local connection instantiate local MySQL class, otherwise connect remote database and instantiate MySQL class
if (@mysql_connect ($mysql _local_data[db_host], $mysql _local_data[db_user], $mysql _local_data[db_pass]))
$db = new Mysql ($db _host, $mysql _local_data[db_user], $mysql _local_data[db_pass], $mysql _local_data[db_name], $db _ CharSet, $conn);
Else
$db = new Mysql ($mysql _remote_data[db_host], $mysql _remote_data[db_user], $mysql _remote_data[db_pass], $mysql _remote _data[db_name], $db _charset, $conn);
$db->show_tables (); Test: Displays all table names under the current database
?>