本文實例為大家分享了php封裝一個簡單的數據庫操作類，供大家參考，具體內容如下

一、代碼

<?php   class ConnDB{     private $local;     private $username;     private $pwd;     private $db;     private $connID;     private $code;     public function __construct($local,$username,$pwd,$connID,$code,$db){       $this->local=$local;       $this->username=$username;       $this->pwd=$pwd;       $this->connID=$connID;       $this->code=$code;       $this->db=$db;       $this->connect();     }     public function connect(){       if($this->connID=="pconn"){         $this->connID=mysql_pconnect($this->local,$this->username,$this->pwd)or die("Connect MySQL False");       }else{         $this->connID=mysql_connect($this->local,$this->username,$this->pwd)or die("Connect MySQL False");              }       mysql_select_db($this->db,$this->connID) or die("Connect DB False");       mysql_query("SET NAMES $this->code");       return $this->connID;                 //返回數據庫連接對象            }   } class AdminDB{ function executeSQL ($sql, $connID){   $sqlType = strtolower(substr(trim($sql), 0, 6));  //提取SQL語句的類型   $rs = mysql_query($sql,$connID);        //執行SQL語句    if ($sqlType == 'select') {           //如果是select查詢     $arrayData = mysql_fetch_array($rs);       //返回查詢記錄集     if (count($arrayData) == 0 || $rs == false) { //如果沒查詢到或發生錯誤       return false;             //返回false     } else {                 //否則         return $arrayData;          //返回記錄集     }   } elseif ($sqlType == 'insert' || $sqlType == 'update' || $sqlType == 'delete') { //如果執行插入、更新或刪除語句     return $rs;            //返回語句執行狀態，即成功返回true，失敗返回false   } else {     return false;           //如果不是上述查詢，則返回false   } } } $connobj=new ConnDB("localhost","root","root","conn","utf8","db_database20");  //實例化數據庫連接類 $conn=$connobj->connect();    //返回連接標識 $admindb=new AdminDB();           //數據庫操作類實例化 $res=$admindb->executeSQL ("select * from tb_demo01",$conn); //調用數據庫操作類中方法執行查詢語句 if($res){          //如果返回結果為真，則輸出數據   print_r($res);     //輸出一個數組。 } ?>

 二、運行結果

Array(  [0] => 1  [id] => 1  [1] => php新書上市  [title] => php新書上市  [2] => php新書上市啦，希望大家給出寶貴意見  [content] => php新書上市啦，希望大家給出寶貴意見  [3] => 2010-10-23  [date] => 2010-10-23)

以上就是本文的全部內容，希望對大家的學習有所幫助，也希望大家多多支持錯新站長站。