PHP使用类对mysql的使用进行封装

来源：互联网发布：淘宝卖爱奇艺会员编辑：程序博客网时间：2024/06/06 07:05

先前有过文章介绍了PHP中通过普通方法对mysql进行封装使用，回顾可以点击链接查看： PHP中MySQL的连接封装。今天介绍使用类的方法对MySQL进行封装。

具体代码如下：

<?phpheader("content-type:text/html;charset=utf8");//Mysql数据库连接class Mysql{   public $db_host;    public $db_user;   public $db_pass;   public $db_charset;   public $db_name;      public function __construct($db_host,$db_user,$db_pass,$db_charset,$db_name){    $this->db_host=$db_host;      $this->db_user=$db_user;     $this->db_pass=$db_pass;     $this->db_charset=$db_charset;     $this->db_name=$db_name;     $this->connect();   }      public function connect(){   @mysql_connect($this->db_host,$this->db_user,$this->db_pass);   mysql_set_charset($this->db_charset);   mysql_select_db($this->db_name);   }   public function getAll($sql){     $res =mysql_query($sql);     $rows=[];     while($row=mysql_fetch_assoc($res)){     $rows[]=$row;     }     return $rows;   }   public function __destruct(){     mysql_close();   }   }$mysql=new Mysql('127.0.0.1','root','root','utf8','cms');$arr=$mysql->getAll("select *from cms_user");var_dump($arr);?>

阅读全文

0 0