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; } /****************************************类结束***************************/ }?>