PHP encapsulates a DB database MySQL class

Configuration database Define (' Db_host ', ' 127.0.0.1 '); Server address Define (' Db_user ', ' root '); User name Define (' Db_pass ', '); Password Define (' Db_databasename ', ' Fenxiao '); Database Class Dbmysql { /* * Variable **/ Private $tablename = ""; Table name Private $fieldname = "*"; Private $conn; Private $where; Private $sql; function __construct ($tablename) { Generate a connection $this->conn = mysql_connect (Db_host, Db_user, Db_pass) or Die ("Connect Failed". Mysql_error ()); Select Database mysql_select_db (Db_databasename, $this->conn); Set the encoding format mysql_query ("SET NAMES UTF8"); Var_dump ($conn); $this->tablename= $tablename; } Setting Up SQL statements Private Function SetSQL ($sql) { $this->sql= $sql; } Set conditional statements Public function where ($where) { $this->where= "where". $where; return $this; } by specified field Public function field ($keyword) { $this->fieldname= $keyword; return $this; } Set up a connection query table Public Function table ($table 1, $table 2, $field, $bool) { $this->tablename= "$table 1 left joins $table 2 on $table 1. $field $bool$table2. $field"; Print_r ($this->tablename); return $this; } Set up multiple table queries Public Function addtable ($table 1, $table 2, $field, $bool) { $this->tablename.= "left JOIN $table 2 on $table 1. $field $bool$table2. $field"; Print_r ($this->tablename); return $this; } Set up a connection query table # #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; } Query all databases output as an array Public Function Select () { /** * Query all the data in the database **/ $arr =array (); Execute SQL statement $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; } Search for specified field data Public Function Find () { Execute SQL statement $result = mysql_query ("select". $this->fieldname. "from". $this->tablename. $this->where, $this->conn); $result = Mysql_fetch_assoc ($result); return $result; } Adding data to the database 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; } Modify the contents of a database 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: Returns the fields of the single column [0]=> "111" * Mysql_fetch_field: Gets field information. [0]=> [' Name ']=> object * Mysql_fetch_array returns array data. [0]=> "Asasds" [' Name ']=> */ ?> Copy Code

Loaded, PHP, MySQL

