php封装的连接Mysql类及用法分析
本文实例讲述了php封装的连接Mysql类及用法。分享给大家供大家参考,具体如下:
classmysql{ 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(); } //连接数据库 privatefunctiondb_connect(){ $this->conn=mysql_connect($this->db_host,$this->db_user,$this->db_pwd)ordie("CouldnotConnectMySqlServer"); } privatefunctionselectdb(){ mysql_select_db($this->db_name)ordie("unabletoselectdbname") } privatefunctionquery(){ return$this->result=mysql_query($this->querysql); } privatefunctionget_result($sql){ $this->querysql=$sql; $this->query(); if($this->get_num()>0){ //mysql_fetch_assoc()和mysql_fetch_array(,MYSQL_ASSOC)从结果集中取得一行作为关联数组没有则返回false while($this->rows=mysql_fetch_array($this->result)){ //赋值数组赋值resultarray[]=将影响的行数赋值给数组 $this->resultarray[]=$this->rows } return$this->resultarray; } } //$result返回值为bool类型false为没有数据 privatefunctionget_num(){ return$this->num=mysql_num_rows($this->result); } } $m=newmysql("testuser","localhost","root","root"); $arreresult=$m->get_result("select*fromuserinfo");
希望本文所述对大家php程序设计有所帮助。