<?php // 配置數據庫 define('DB_HOST', '127.0.0.1'); //服務器地址 define('DB_USER', 'root'); //用戶名 define('DB_PASS', ''); //密碼 define('DB_DATABASENAME', 'fenxiao'); //數據庫 class Dbmysql { /* *變量 **/ private $tablename=""; //表名 private $fieldname="*"; private $conn; private $where; private $sql; function __construct($tablename) { //生成一個連接 $this->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=3 ? ?public?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?"<br>"; ? ?$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']=> ? */ ? ?>
? 版權聲明
文章版權歸作者所有，未經允許請勿轉載。
THE END
