c1a1o1
版主
  
一品带刀护卫
UID 68669
精华
0
积分 8926
帖子 2347
金钱 8926 喜悦币
威望 0
人脉 0
阅读权限 100
注册 2006-2-17
状态 离线
|
[广告]: q
m
发个sql类支持4.1以后的
<?php
CLASS MYSQL
{
var $QueryS = 0;
var $Conn;
var $Prefix = "qinggan_";
Function MYSQL($dbSet)
{
$this->Prefix = $dbSet["prefix"];
$this->Connect($dbSet);
}
Function Connect($dbSet)
{
if($dbSet["conn"] == 1)
{
$this->Conn = mysql_pconnect($dbSet["host"],$dbSet["user"],$dbSet["pass"]) OR die(mysql_error());
}
else
{
$this->Conn = mysql_connect($dbSet["host"],$dbSet["user"],$dbSet["pass"]) OR die(mysql_error());
}
//-----检查版本
if(mysql_get_server_info()>"4.1") mysql_query("SET NAMES 'gbk'");
if(mysql_get_server_info()>"5.0.1") mysql_query("SET sql_mode=''");
mysql_select_db($dbSet["data"]) or die(mysql_error());
}
Function Close()
{
Return @mysql_close();
}
Function Query($sql)
{
$sql = ($this->Prefix == "qinggan_" ? $sql : str_replace("qinggan_",$this->Prefix,$sql));
$query = mysql_query($sql,$this->Conn);
$this->QueryS++;
if($query) Return $query;
Return False;
}
Function FetchArray($query)
{
if(empty($query)) Return False;
$array = mysql_fetch_array($query);
Return $array;
}
Function FetchQuery($sql)
{
$query = $this->Query($sql);
$rows = $this->FetchArray($query);
Return $rows;
}
Function FetchRow($query)
{
$rows = mysql_fetch_row($query);
RETURN $rows;
}
Function InsertID()
{
$id = mysql_insert_id();
Return $id;
}
Function NumRows($query)
{
$rows = mysql_num_rows($query);
Return $rows;
}
Function AffectedRows()
{
$rows = mysql_affected_rows();
Return $rows;
}
Function MysqlResult($query,$row=0)
{
$rows = mysql_result($query,$row);
Return $rows;
}
}
?>
| 
生日礼物送什么www.feichanglipin.cn
生日礼物 补肾 |
|
