自己用PHP封裝了一個DB資料庫 mysql 的類

conn = mysql_connect(DB_HOST, DB_USER, DB_PASS) or die("connect failed" . mysql_error());  //選擇資料庫mysql_select_db(DB_DATABASENAME, $this->conn); //設定編碼格式mysql_query("SET NAMES utf8");//var_dump($conn);$this->tablename=$tablename;}//設定sql語句private function setsql($sql){$this->sql=$sql;}//設定條件陳述式public function where($where){$this->where=" where ".$where;return $this;}//按指定欄位public function field($keyword){$this->fieldname=$keyword;return $this;}//設定串連查詢表public function table($table1,$table2,$field,$bool){$this->tablename="$table1 LEFT JOIN $table2 ON $table1.$field$bool$table2.$field";//print_r($this->tablename);return $this;}//設定多表查詢public function addtable($table1,$table2,$field,$bool){$this->tablename.=" LEFT JOIN $table2 ON $table1.$field$bool$table2.$field";//print_r($this->tablename);return $this;}//設定串連查詢表##SELECT * FROM 【wx_order LEFT JOIN wx_shopcar ON wx_shopcar.oid=wx_order.oid and wx_order.uid=wx_shopcar.uid LEFT JOIN wx_goods ON wx_shopcar.gid=wx_goods.gid】 WHERE wx_order.oid=1 and wx_order.uid=3public function settable($sql){$this->tablename=$sql;//print_r($this->tablename);return $this;}//查詢所有資料庫 以數組形式輸出public function select(){  /*** 查詢資料庫中所有的資料**/$arr=array();//執行sql語句$result = mysql_query("select ".$this->fieldname." from ".$this->tablename.$this->where, $this->conn); while ($row = mysql_fetch_assoc($result)) {array_push($arr, $row);}return $arr; }//搜尋指定欄位資料public function find(){//執行sql語句$result = mysql_query("select ".$this->fieldname." from ".$this->tablename.$this->where, $this->conn); $result = mysql_fetch_assoc($result);return $result;}//增加資料到資料庫public function add($data){$keysql='';$valuesql='';foreach ($data as $key => $value) {$keysql.=",`$key`";$valuesql.=",'$value'";}$keysql=substr($keysql, 1);$valuesql=substr($valuesql, 1);$result=mysql_query("insert into `".$this->tablename."` ($keysql) VALUES($valuesql)");$id=mysql_insert_id();//print_r("insert into `".$this->tablename."` ($keysql) VALUES($valuesql)");return $id;}//修改資料庫的內容public function save($data){$keysql='';$valuesql='';foreach ($data as $key => $value) {$keysql.=",`$key`='$value'";}$keysql=substr($keysql, 1);//print_r($keysql);//echo "
";$result=mysql_query("UPDATE `".$this->tablename."` SET ".$keysql.$this->where);//print_r("UPDATE `".$this->tablename."` SET ".$keysql.$this->where);return $result;}##刪除資料public function delete(){$result=mysql_query("DELETE FROM $this->tablename $this->where");//print_r("DELETE FROM $this->tablename $this->where");return $result;}}/*** mysql_fetch_row: 返回單列的各欄位 [0]=>"111"* mysql_fetch_field: 取得欄位資訊。[0]=>   ['name']=>   object* mysql_fetch_array    返回數組資料。 [0]=>"asasds"   ['name']=>*/?>

來自： http://my.oschina.net/Peron/blog/552601

