当前位置:首页 > 在线留言 >

PHP连接MYSQL数据库通用类

作者:曲靖市宁江木业有限公司 来源:www.ynnjmy.com 发布时间:2017-09-06 13:10:40

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);

}

//返回友情提示信息 更多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","&nbsp;'<font color='#8899DF'><b>//1</b></font>'&nbsp;",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>

企业建站2800元起,携手武汉肥猫科技,做一个有见地的颜值派!更多优惠请戳:武汉网站建设公司 https://www.jingchucn.com/zt/wuhan_wangzhanjianshe/

  • 上一篇:ModernDriven 获得表单数据
  • 下一篇:最后一页