本文实例讲述了php封装的连接Mysql类及用法。分享给大家供大家参考，具体如下：
|
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
|
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程序设计有所帮助。
