A class that constructs SQL statements

A class that constructs SQL statements

<无详细内容> /** * @ Package Database Class * @ Author injection (mail: injection.mail@gmail.com) * @ Version 1.0 */ @ Ini_set ('display _ errors ', 0 ); Class DataBase { Private $ mDb_host, $ mAb_user, $ mAb_pwd, $ mConn_No; Function DataBase ($ Conn_Obj ){ $ This-> connectDb ($ Conn_Obj ); } Function connectDb ($ Conn_Obj ){ $ This-> mDb_host = $ Conn_Obj-> host; $ This-> mAd_name = $ Conn_Obj-> user; $ This-> mAd_pwd = $ Conn_Obj-> pwd; $ This-> mConn_No = mysql_connect ($ this-> mDb_host, $ this-> mAd_name, $ this-> mAd_pwd ); } Function selectDb ($ Conn_Obj ){ $ This-> mDb_name = $ Conn_Obj-> dbname; Mysql_select_db ($ this-> mDb_name ); } } /** * @ Package Making Sqls Class exetends Database Class * @ Author injection (mail: injection.mail@gmail.com) * @ Version 1.0 */ Class MakeSql extends DataBase { Private $ mSql; Function MakeSql ($ type, $ arr_colum_list, $ arr_ SQL _choice ){ $ This-> MakeSqlType ($ arr_colum_list, $ arr_ SQL _choice ); } # Switch make list Function MakeSqlType ($ type, $ arr_colum_list, $ arr_ SQL _choice ){ Switch ($ type ){ Case 'insert ': Return $ this-> makeInsert ($ arr_colum_list, $ arr_ SQL _choice ); Case 'select ': Return $ this-> makeSelect ($ arr_colum_list, $ arr_ SQL _choice ); Case 'update ': Return $ this-> makeUpdate ($ arr_colum_list, $ arr_ SQL _choice ); Case 'delete ': Return $ this-> makeDelete ($ arr_colum_list, $ arr_ SQL _choice ); } } # Make insert Function makeInsert ($ arr_colum_list, $ arr_ SQL _choice ){ $ Colum_key = array_keys ($ arr_colum_list ); $ Colum_value = array_values ($ arr_colum_list ); $ This-> mSql = "insert ". $ arr_ SQL _choice ["tbl_name"]. "(". join (',', $ colum_key ). ") VALUES ('". join ("','", $ colum_value ). "')"; Return $ this-> mSql; } # Making select Function makeSelect ($ arr_colum_list = '*', $ arr_ SQL _choice ){ $ Colum_value = array_keys ($ arr_colum_list ); Foreach ($ arr_ SQL _choice as $ SQL _key => $ SQL _value ){ If (strcmp ($ SQL _key, 'tbl _ name') = 0 ){ If (strcmp ($ arr_colum_list ,'*')! = 0) $ This-> mSql = "SELECT". join (',', $ colum_value). "FROM". $ SQL _value; Else $ This-> mSql = "SELECT * FROM". $ SQL _value; } Else If (strcmp ($ SQL _value ,'')! = 0) If (strcmp ($ SQL _key, 'where') = 0 & strcmp ($ SQL _value, 'colum ') = 0 ){ Foreach ($ arr_colum_list As $ colum_key => $ colum_value) $ This-> mSql. = "$ colum_key = '$ colum_value' AND "; $ This-> mSql = rtrim ($ this-> mSql, "AND "); } Else $ This-> mSql. = "$ SQL _key". $ SQL _value; } Return $ this-> mSql; } # Making update Function makeUpdate ($ arr_colum_list, $ arr_ SQL _choice ){ $ This-> mSql = "UPDATE". $ arr_ SQL _choice ['tbl _ name']. "SET "; Foreach ($ arr_colum_list as $ colum_key => $ colum_value) $ This-> mSql. = "$ colum_key = '$ colum_value ',"; $ This-> mSql = rtrim ($ this-> mSql ,','); Foreach ($ arr_ SQL _choice as $ SQL _key => $ SQL _value ){ If (strcmp ($ SQL _value ,'')! = 0 & strcmp ($ SQL _key, 'tbl _ name ')! = 0 & strcmp ($ SQL _key, 'Order ')! = 0) $ This-> mSql. = "$ SQL _key". $ SQL _value; } Return $ this-> mSql; } # Making delete Function makeDelete ($ arr_colum_list, $ arr_ SQL _choice ){ $ This-> mSql = "delete from". $ arr_ SQL _choice ['tbl _ name']; Foreach ($ arr_ SQL _choice as $ SQL _key => $ SQL _value ){ If (strcmp ($ SQL _key, 'tbl _ name ')! = 0 & strcmp ($ SQL _value ,'')! = 0 ){ $ This-> mSql. = "$ SQL _key". $ SQL _value; } } Return $ this-> mSql; } }