host =$host; } if($name==''){ $this->name =$name; } if($pwd ==''){ $this->pwd =$pwd; } if($db == ''){ $this->db =$db; } $this->init_conn(); } //链接数据库 function init_conn(){ $this->conn = @mysql_connect($this->host,$this->name,$this->pwd); @mysql_select_db($this->db,$this->conn); mysql_query("set names gb2312"); } //查询结果集 function mysql_query_rst($sql){ if($this->conn==''){ $this->init_conn(); } $this->result = @mysql_query($sql,$this->conn); } //取得字段数 function getFieldsNum($sql){ $this->mysql_query_rst($sql); $this->fieldsNum = @mysql_num_fields($this->result); } //获取总行数 function getRowsNum($sql){ $this->mysql_query_rst($sql); if(mysql_errno() == 0){ return @mysql_num_rows($this->result,MYSQL_ASSOC); }else{ return ''; } } //获取单条记录数 function getRowsRst($sql){ $this->mysql_query_rst($sql); if(mysql_errno() == 0){ $this->rowsRst =mysql_fetch_array($this->result,MYSQL_ASSOC); return $this->rowsRst; }else{ return ''; } } //获取多条记录 function getRowsArray($sql){ $this->mysql_query_rst($sql); if(mysql_errno() == 0){ while($row= mysql_fetch_array($this->result,MYSQL_ASSOC){ $this->rowsArray[] =$row; } return $this->rowsArray; }else{ return ''; } } //更新、删除、插入记录 function uidRst($sql){ if($this->conn ==''){ $this->init_conn(); } @mysql_query($sql); $this->rowsNum = mysql_affected_rows(); if(mysql_errno() == 0){ return $this->rowsNum; }else{ return ''; } } //获取对应的字段数 function getFields($sql,$fields){ $this->mysql_query_rst($sql); if(mysql_errno() == 0){ if(mysql_num_fields($this->result) > 0){ $tmp = @mysql_fetch_row($this->result); $this->fieldsArray =$tmp[$fields] } return $this->fieldsArray; }else{ return ''; } } //错误信息 function msg_error(){ if(mysql_errno() != 0){ $this->msg = mysql_error(); } return $this->msg; } //释放结果集 function close_rst(){ mysql_free_result($this->result); $this->msg =''; $this->fieldsNum =0; $this->rowsNum =0; $this->fieldsArray =''; $this->rowsArray =''; } //关闭数据库 function close_conn(){ $this->close_rst(); mysql_close($this->conn); $this->conn =''; } $conne = new opmysql();}?>