本文实例讲述了PHP封装的连接MysqL类及用法。分享给大家供大家参考，具体如下：
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)从结果集中取得一行作为关联数组 没有则返回false
while($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程序设计有所帮助。
