本文实例讲述了php封装的连接mysql类及用法。分享给大家供大家参考，具体如下：
class mysql{private $db_name;private $db_host;private $db_user;private $db_pwd;private $conn;private $querysql;private $result;private $resultarray=array();private $row;//创建构造函数 数据库名 主机名 用户名 密码function __counstruct($dbname,$dbhost,$dbuser,$dbpwd){$this->db_name=$dbname;$this->db_host=$dbhost;$this->db_pwd=$dbpwd;$this->db_user=$dbuser;$this->dbconnect();$this->selectdb();}//连接数据库private function db_connect(){$this->conn=mysql_connect($this->db_host,$this->db_user,$this->db_pwd) or die(could not connect mysql server);}private function selectdb(){mysql_select_db($this->db_name) or die(unable to select dbname)}private function query(){return $this->result=mysql_query($this->querysql);}private function get_result($sql){$this->querysql=$sql;$this->query();if($this->get_num()>0){//mysql_fetch_assoc()和 mysql_fetch_array(,mysql_assoc)从结果集中取得一行作为关联数组 没有则返回falsewhile($this->rows=mysql_fetch_array($this->result)){//赋值 数组赋值 resultarray[]= 将影响的行数赋值给数组$this->resultarray[]=$this->rows}return $this->resultarray;}}//$result返回值为 bool类型 false为没有数据private function get_num(){return $this->num=mysql_num_rows($this->result);}}$m=new mysql(testuser,localhost,root,root);$arreresult=$m->get_result(select * from userinfo);
希望本文所述对大家php程序设计有所帮助。