PHP连接MYSQL数据库通用类
发布时间：2015-05-27 19:29:43作者：知识屋
<?php
include "mysql.php";
$db = new Dirver();
$db->DBLink($dbhost='localhost', $dbuser='root', $password='password', $dbname='name', $pconnect=0);
?>
PHP连接MYSQL数据库类
mysql.php
<?php
Class Dirver{
//连接数据库
//link database
function DBLink($dbhost='localhost', $dbuser='root', $password='', $dbname='', $pconnect=0){
$this->LinkID[$this->Line] = ($pconnect == 1)? @mysql_pconnect($dbhost, $dbuser, $password) : @mysql_connect($dbhost, $dbuser, $password) or die("Connect to MySQL ($dbhost,$dbuser) failed");
//选择连接数据库
//choose to link database
@mysql_select_db($dbname, $this->LinkID[$this->Line]) or die('Cannot use database '.$dbname);
return $this->LinkID[$this->Line];
}
//查询语句
//view qurry
function query($query,$limit='') {
$this -> nums ++;
//检测如果有限制数据集则处理
//test if there is finite data,then function
if($limit>0){
$query = $query.' LIMIT '.$limit;
}
$this-> Lists[$this->Line][] = $query;
$querys = mysql_query($query,$this->LinkID[$this->Line]);
if(!$querys){
$this->DB_Error($query);
}
return $querys;
}
//返回数组资料
//back to array info
function fetch_array($query) {
return @mysql_fetch_array($query, MYSQL_ASSOC);
}
//返回数组资料
//back to array info
function result($query) {
return @mysql_result($query,$this->LinkID[$this->Line]);
}
//返回数组资料行
//back to row info
function rows($query) {
return $this->fetch_array($this->query($query));
}
//返回数组行
//back to numrows
function nums($query) {
return $this->num_rows($this->query($query));
}
//取得返回列的数目
//fetch the numbers backing out
function num_rows($query){
return @mysql_num_rows($query);
}
//返回单列的各字段
//return to every field of single row
function fetch_row($query) {
return @mysql_fetch_row($query);
}
//返回最后一次使用 INSERT 指令的 ID
//return to inserted ID used last time
function insert_id(){
return @mysql_insert_id($this->LinkID[$this->Line]);
}
//关闭当前数据库连接
//close current database link
function close(){
return @mysql_close($this->LinkID[$this->Line]);
}
//检测mysql版本
//test mysql version
function version(){
$query = @mysql_query("SELECT VERSION()",$this->LinkID[$this->Line]);
return @mysql_result($query, 0);
}
//返回友情提示信息 更多http://www.52mvc.com
//return to kindly note
function DB_Error_t($query=''){
}
function DB_Error($query=''){
global $PHP_SELF;
//出错语句提示
//error sentence
$errors = preg_replace("/'(.+?)'/is"," '<font color='#8899DF'><b>//1</b></font>' ",mysql_error());
$charset ='';
//提示语言
//language noted
$lang = Array('This SQL Error Info!', 'Error Script:', 'Present time:',
'Http Host:', 'Server Name:', 'Server Software:',
'Host IP Address:', 'Remote User Agent:', 'Current File:',
'Current Line:', 'Line.', 'The Error number:',
'The specific Error was:', 'SQL Query :', 'Not discover whateverly SQL Sentence ！');
//时间处理
//time
$nowdate = date('Y-m-d H:i A');
$errors = preg_replace("/'(.+?)'/is","'<font color='#8899DF'><b>//1</b></font>'",mysql_error());
//检测是否有语句
//test if there is any sentence.
if($query==''){
$query = $lang[14];
}
echo "<html>
<head>
<meta http-equiv='Content-Type' content='text/html; charset=$charset'>
<title>$lang[0]</title>
</head>
<body>
</body>
</html>
<table style='BORDER-COLLAPSE: collapse;font-size:9pt;' borderColor='#a8b7c6' cellSpacing='1' width='100%' border='1' cellpadding='3' align='center'>
<tr>
<td bgColor='#F9F9F9' height='38' colspan='2'>
<font size='4' face='Arial' color='#800000'>$lang[0]</font></td>
</tr>
<tr>
<td bgColor='#F9F9F9' width='165'>
<p align='right'>$lang[2]</td>
<td bgColor='#F9F9F9'>$nowdate</td>
</tr>
<tr>
<td bgColor='#F9F9F9' width='165'>
<p align='right'>$lang[3]</td>
<td bgColor='#F9F9F9'><b>".$_SERVER['HTTP_HOST']."</b></td>
</tr>
<tr>
<td bgColor='#F9F9F9' width='165'>
<p align='right'>$lang[4]</td>
<td bgColor='#F9F9F9'>".$_SERVER['SERVER_NAME']."</td>
</tr>
<tr>
<td bgColor='#F9F9F9' width='165'>
<p align='right'>$lang[5]</td>
<td bgColor='#F9F9F9'>".$_SERVER['SERVER_SOFTWARE']."</td>
</tr>
<tr>
<td bgColor='#F9F9F9' width='165'>
<p align='right'>$lang[6]</td>
<td bgColor='#F9F9F9'><font color=/"#800000/">".$_SERVER['REMOTE_ADDR']."</font></td>
</tr>
<tr>
<td bgColor='#F9F9F9' width='165'>
<p align='right'>$lang[7]</td>
<td bgColor='#F9F9F9'><font color=/"#000080/">".$_SERVER['HTTP_USER_AGENT'].";</font></td>
</tr>
<tr>
<td bgColor='#F9F9F9' width='165'>
<p align='right'>$lang[11]</td>
<td bgColor='#F9F9F9'><b>".mysql_errno()."</b></td>
</tr>
<tr>
<td bgColor='#F9F9F9' width='165'>
<p align='right'>$lang[12]</td>
<td bgColor='#F9F9F9'>$errors</td>
</tr>
<tr>
<td bgColor='#F9F9F9' width='165'>
<p align='right'>$lang[13]</td>
<td bgColor='#F9F9F9'>$query</td>
</tr>
</table>
</td>
</tr>
</table>";
exit;
}
}
?>
PHP连接MYSQL数据库类
<?php
include "mysql.php";
$db = new Dirver();
$db->DBLink($dbhost='localhost', $dbuser='root', $password='password', $dbname='name', $pconnect=0);
?>
PHP连接MYSQL数据库类
mysql.php
<?php
Class Dirver{
//连接数据库
//link database
function DBLink($dbhost='localhost', $dbuser='root', $password='', $dbname='', $pconnect=0){
$this->LinkID[$this->Line] = ($pconnect == 1)? @mysql_pconnect($dbhost, $dbuser, $password) : @mysql_connect($dbhost, $dbuser, $password) or die("Connect to MySQL ($dbhost,$dbuser) failed");
//选择连接数据库
//choose to link database
@mysql_select_db($dbname, $this->LinkID[$this->Line]) or die('Cannot use database '.$dbname);
return $this->LinkID[$this->Line];
}
//查询语句
//view qurry
function query($query,$limit='') {
$this -> nums ++;
//检测如果有限制数据集则处理
//test if there is finite data,then function
if($limit>0){
$query = $query.' LIMIT '.$limit;
}
$this-> Lists[$this->Line][] = $query;
$querys = mysql_query($query,$this->LinkID[$this->Line]);
if(!$querys){
$this->DB_Error($query);
}
return $querys;
}
//返回数组资料
//back to array info
function fetch_array($query) {
return @mysql_fetch_array($query, MYSQL_ASSOC);
}
//返回数组资料
//back to array info
function result($query) {
return @mysql_result($query,$this->LinkID[$this->Line]);
}
//返回数组资料行
//back to row info
function rows($query) {
return $this->fetch_array($this->query($query));
}
//返回数组行
//back to numrows
function nums($query) {
return $this->num_rows($this->query($query));
}
//取得返回列的数目
//fetch the numbers backing out
function num_rows($query){
return @mysql_num_rows($query);
}
//返回单列的各字段
//return to every field of single row
function fetch_row($query) {
return @mysql_fetch_row($query);
}
//返回最后一次使用 INSERT 指令的 ID
//return to inserted ID used last time
function insert_id(){
return @mysql_insert_id($this->LinkID[$this->Line]);
}
//关闭当前数据库连接
//close current database link
function close(){
return @mysql_close($this->LinkID[$this->Line]);
}
//检测mysql版本
//test mysql version
function version(){
$query = @mysql_query("SELECT VERSION()",$this->LinkID[$this->Line]);
return @mysql_result($query, 0);
}
//返回友情提示信息
//return to kindly note
function DB_Error_t($query=''){
}
function DB_Error($query=''){
global $PHP_SELF;
//出错语句提示
//error sentence
$errors = preg_replace("/'(.+?)'/is"," '<font color='#8899DF'><b>//1</b></font>' ",mysql_error());
$charset ='';
//提示语言
//language noted
$lang = Array('This SQL Error Info!', 'Error Script:', 'Present time:',
'Http Host:', 'Server Name:', 'Server Software:',
'Host IP Address:', 'Remote User Agent:', 'Current File:',
'Current Line:', 'Line.', 'The Error number:',
'The specific Error was:', 'SQL Query :', 'Not discover whateverly SQL Sentence ！');
//时间处理
//time
$nowdate = date('Y-m-d H:i A');
$errors = preg_replace("/'(.+?)'/is","'<font color='#8899DF'><b>//1</b></font>'",mysql_error());
//检测是否有语句
//test if there is any sentence.
if($query==''){
$query = $lang[14];
}
echo "<html>
<head>
<meta http-equiv='Content-Type' content='text/html; charset=$charset'>
<title>$lang[0]</title>
</head>
<body>
</body>
</html>
<table style='BORDER-COLLAPSE: collapse;font-size:9pt;' borderColor='#a8b7c6' cellSpacing='1' width='100%' border='1' cellpadding='3' align='center'>
<tr>
<td bgColor='#F9F9F9' height='38' colspan='2'>
<font size='4' face='Arial' color='#800000'>$lang[0]</font></td>
</tr>
<tr>
<td bgColor='#F9F9F9' width='165'>
<p align='right'>$lang[2]</td>
<td bgColor='#F9F9F9'>$nowdate</td>
</tr>
<tr>
<td bgColor='#F9F9F9' width='165'>
<p align='right'>$lang[3]</td>
<td bgColor='#F9F9F9'><b>".$_SERVER['HTTP_HOST']."</b></td>
</tr>
<tr>
<td bgColor='#F9F9F9' width='165'>
<p align='right'>$lang[4]</td>
<td bgColor='#F9F9F9'>".$_SERVER['SERVER_NAME']."</td>
</tr>
<tr>
<td bgColor='#F9F9F9' width='165'>
<p align='right'>$lang[5]</td>
<td bgColor='#F9F9F9'>".$_SERVER['SERVER_SOFTWARE']."</td>
</tr>
<tr>
<td bgColor='#F9F9F9' width='165'>
<p align='right'>$lang[6]</td>
<td bgColor='#F9F9F9'><font color=/"#800000/">".$_SERVER['REMOTE_ADDR']."</font></td>
</tr>
<tr>
<td bgColor='#F9F9F9' width='165'>
<p align='right'>$lang[7]</td>
<td bgColor='#F9F9F9'><font color=/"#000080/">".$_SERVER['HTTP_USER_AGENT'].";</font></td>
</tr>
<tr>
<td bgColor='#F9F9F9' width='165'>
<p align='right'>$lang[11]</td>
<td bgColor='#F9F9F9'><b>".mysql_errno()."</b></td>
</tr>
<tr>
<td bgColor='#F9F9F9' width='165'>
<p align='right'>$lang[12]</td>
<td bgColor='#F9F9F9'>$errors</td>
</tr>
<tr>
<td bgColor='#F9F9F9' width='165'>
<p align='right'>$lang[13]</td>
<td bgColor='#F9F9F9'>$query</td>
</tr>
</table>
</td>
</tr>
</table>";
exit;
}
}
?>
（免责声明：文章内容如涉及作品内容、版权和其它问题，请及时与我们联系，我们将在第一时间删除内容，文章内容仅供参考）
相关知识
-
如何对PHP文件进行加密方法 PHP实现加密的几种方式介绍
-
php生成圆角图片的方法 电脑中php怎么生成圆角图片教程
-
用PHP构建一个留言本方法步骤 php怎么实现留言板功能
-
php中三元运算符用法 php中的三元运算符使用说明
-
php文件如何怎么打开方式介绍 php文件用什么打开方法
-
PHP怎么插入数据库方法步骤 php编程怎么导入数据库教程
-
如何安装PHPstorm并配置方法教程 phpstorm安装后要进行哪些配置
-
PHP 获取远程文件大小的3种解决方法 如何用PHP获取远程大文件的大小
-
20个实用PHP实例代码 php接口开发实例代码详细介绍
-
如何架设PHP服务器方法步骤 怎么搭建php服务器简单教程
软件推荐
更多 >
-
1
-
2
php MYSQL数据操作类
-
3
PHP单元测试利器：PHPUNIT初探
-
4
php .htaccess 伪静态
-
5
PHP整合PayPal支付
-
6
PHP与ASP比较：这还值得讨论吗？
-
7
PHP与XML结合的网站编程
-
8
Warning: ftp_put() 问题的解决办法之被动模式
-
9
PHP Socket 编程
-
10
PHP性能优化总结
