PHP simple database operation instance [Support addition, deletion, modification, query, and chain operations], add, delete, and chain operations
This example describes the PHP simple database operation class. We will share this with you for your reference. The details are as follows:
Databases are essential for project development. However, it is often a headache for the complexity of Database SQL statements. Provides a database operation class (Model) for your use. Supports addition, deletion, modification, and query, and chain operations. The Code contains less than 100 lines, which is very small and convenient and suitable for quick deployment and use of small projects.
/*** @ Authot: summer *** @ E-mail: wenghang1228@me.com *** @ Data: 2015-02-06 *** @ Project: database operation class Model *** @ Version: 1.0 ** @ Copyright All: summer wind ---- record summer pursuit of technology and life love ** @ URL: http://www.xtwind.com **/class Model {public $ field; public $ tabname; public $ where; public $ order; public $ limit; // constructor, link to database, assign function _ construct ($ tabname) {mysql_connect (HOST, USER, PASSWORD); mysql_select_db (DBNAME); mysql_query ("set names utf8"); $ this-> tabname = $ tabname;} // function field ($ field) {$ this-> $ field = $ field; return $ this;} // combine the where condition function where ($ where) {$ this-> where = "where ". $ where; return $ this;} // function order ($ order) of the combined order sorting condition {$ this-> order = "order ". $ order; return $ this;} // function limit ($ limit) {$ this-> limit = "limit ". $ limit; return $ this;} // combine and execute the select statement function select ($ all = "") {if ($ all) {$ SQL = "select {$ all} from {$ this-> tabname} order by id ";} else {$ SQL = "select {$ this-> filed} from {$ this-> tabname} {$ this-> where} {$ this-> order} {$ this-> limit }";} $ rst = mysql_query ($ SQL); while ($ row = mysql_fetch_assoc ($ rst) {$ rows [] = $ row;} return $ rows ;} // combine and execute the insert statement function insert ($ post) {// database insert operation, receiving array foreach ($ post as $ key => $ value) {$ keys [] = $ key; $ vals [] = "'". $ valu. "'" ;}$ keyStr = join (",", $ keys); $ valStr = join (",", $ vals ); $ SQL = "insert into {$ this-> tabname} ($ keystr) values ()"; if (mysql_query ($ SQL) {return mysql_insert_id ();} else {return false ;}// combine and execute the delect statement function delect () {$ SQL = "delect from {$ this-> tabname} {$ this-> where}"; if (mysql_query ($ SQL) {return mysql_affected_rows ();} else {return false ;}// combine and execute the updata statement function update ($ post) {foreach ($ psot as $ key => $ value) {$ sets [] = "{$ key} = '{$ val}'" ;}$ setStr = join (",", $ sets ); $ SQL = "update {$ this-> tabname} set {$ setStr} {$ this-> where}"; if (mysql_query ($ SQL )) {return mysql_affected_rows () ;}else {return false ;}// function find () {if ($ this-> order) {$ SQL = "select * from {$ this-> tabname} {$ this-> order} limit 1 ";} else {$ SQL = "select * from {$ this-> tabname} order by id limit 1" ;}$ rst = mysql_query ($ SQL ); while ($ row = mysql_fetch_assoc ($ rst) {$ rows [] = $ row;} return $ rows;} // obtain the total number of rows function total () {$ SQL = "select count (*) from {$ this-> tabname}"; $ rst = mysql_query ($ SQL); if ($ rst) {$ row = mysql_fetch_row ($ rst); return $ row [0];} else {return false ;}}// Model Class Object factory function M ($ tabname) {return new Model ($ tabname);} define ("HOST", "localhost"); define ("USER", "root"); define ("PASSWORD ", "123456"); define ("DBNAME", "test") $ user = new Model ("user"); $ user-> field ("id, name ") -> where ("id = 3")-> order ("id desc")-> limit ("3")-> select ();
Click here for the complete instance codeDownload from this site.