<?php class opmysql{ private $host = 'localhost'; //服务器地址 private $name = 'root'; //登录账号 private $pwd = ''; //登录密码 private $dBase = ''; //数据库名称 private $conn = ''; //数据库链接资源 private $result = ''; //结果集 private $msg = ''; //返回结果 private $fields; //返回字段 private $fieldsNum = 0; //返回字段数 private $rowsNum = 0; //返回结果数 private $rowsRst = ''; //返回单条记录的字段数组 private $filesArray = array(); //返回字段数组 private $rowsArray = array(); //返回结果数组 //初始化类 function __construct($host='',$name='',$pwd='',$dBase=''){ if($host != '') $this->host = $host; if($name != '') $this->name = $name; if($pwd != '') $this->pwd = $pwd; if($dBase != '') $this->dBase = $dBase; $this->init_conn(); } //链接数据库 function init_conn(){ $this->conn=@mysql_connect($this->host,$this->name,$this->pwd); @mysql_select_db($this->dBase,$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); } |