class db{
var $linkid;
var $sqlid;
var $record;
private $host;
private $mysqldb;
private $password;
private $username;
function __construct()
{
require 'conn.php';
$this->host = $db_host;
$this->username = $db_user;
$this->password = $db_pwd;
$this->mysqldb = $db_database;
if(!$this->linkid)
@$this->linkid = mysqli_connect($this->host, $this->username, $this->password) or die("连接服务器失败.");
@mysqli_select_db($this->mysqldb,$this->linkid) or die("无法打开数据库");
mysqli_query("set names UTF-8");
return $this->linkid;}
function query($sql)
{if($this->sqlid=mysqli_query($sql,$this->linkid)) return $this->sqlid;
else {
$this->err_report($sql,mysqli_error);
return false;}
}
function nr($sql_id="")
{if(!$sql_id) $sql_id=$this->sqlid;
return mysqli_num_rows($sql_id);}
function nf($sql_id="")
{if(!$sql_id) $sql_id=$this->sqlid;
return mysqli_num_fields($sql_id);}
function nextrecord($sql_id="")
{if(!$sql_id) $sql_id=$this->sqlid;
if($this->record=mysqli_fetch_array($sql_id)) return $this->record;
else return false;
}
function f($name)
{
if($this->record[$name]) return $this->record[$name];
else return false;
}
function close() {mysqli_close($this->linkid);}
function lock($tblname,$op="WRITE")
{if(mysqli_query("lock tables ".$tblname." ".$op)) return true; else return false;}
function unlock()
{if(mysqli_query("unlock tables")) return true; else return false;}
function ar() {
return @mysqli_affected_rows($this->linkid);
}
function i_id() {
return mysqli_insert_id();
}
function err_report($sql,$err)
{
echo "Mysql查询错误
";
echo "查询语句:".$sql."
";
echo "错误信息:".$err;
}
/****************************************类结束***************************/
}?>