<?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,$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']=>

*/

?>