PHP database operations

PHP database operations

/* ===================================================== ===================================== */ /* File name: BaseLogic. class. php */ /* Summary: common category of data processing .*/ Class BaseLogic extends MyDB { Protected $ tabName; // table name Protected $ fieldList; // A set of fields Protected $ messList; // ================================================ ==== // Function: add ($ postList) // Function: add // Parameter: $ postList submitted variable list // Return: the newly inserted auto-increment ID // ================================================ ==== Function add ($ postList ){ $ FieldList = ''; $ Value = ''; Foreach ($ postList as $ k => $ v ){ If (in_array ($ k, $ this-> fieldList )){ $ FieldList. = $ k .","; If (! Get_magic_quotes_gpc ()) $ Value. = "'". addslashes ($ v )."',"; Else $ Value. = "'". $ v ."',"; } } $ FieldList = rtrim ($ fieldList ,","); $ Value = rtrim ($ value ,","); $ SQL = "INSERT INTO {$ this-> tabName} (". $ fieldList. ") VALUES (". $ value .")"; Echo $ SQL; $ Result = $ this-> mysqli-> query ($ SQL ); If ($ result & $ this-> mysqli-> affected_rows> 0) Return $ this-> mysqli-> insert_id; Else Return false; } // ================================================ ==== // Function: mod ($ postList) // Function: modify table data // Parameter: $ postList submitted variable list // ================================================ ==== Function mod ($ postList ){ $ Id = $ postList ["id"]; Unset ($ postList ["id"]); $ Value = ''; Foreach ($ postList as $ k => $ v ){ If (in_array ($ k, $ this-> fieldList )){ If (! Get_magic_quotes_gpc ()) $ Value. = $ k. "= '". addslashes ($ v )."',"; Else $ Value. = $ k. "= '". $ v ."',"; } } $ Value = rtrim ($ value ,","); $ SQL = "UPDATE {$ this-> tabName} SET {$ value} WHERE id = {$ id }"; Return $ this-> mysqli-> query ($ SQL ); } // ================================================ ==== // Function: del ($ id) // Function: delete // Parameter: $ id number or ID list array // Return: 0 indicates the number of records deleted when the failure is successful. // ================================================ ==== Function del ($ id ){ If (is_array ($ id )) $ Tmp = "IN (". join (",", $ id ).")"; Else $ Tmp = "= $ id "; $ SQL = "DELETE FROM {$ this-> tabName} WHERE id". $ tmp; Return $ this-> mysqli-> query ($ SQL ); } Function get ($ id ){ $ SQL = "SELECT * FROM {$ this-> tabName} WHERE id = {$ id }"; $ Result = $ this-> mysqli-> query ($ SQL ); If ($ result & $ result-> num_rows = 1 ){ Return $ result-> fetch_assoc (); } Else { Return false; } } Function getMessList (){ $ Message = ""; If (! Empty ($ this-> messList )){ Foreach ($ this-> messList as $ value ){ $ Message. = $ value ." "; } } Return $ message; } } ?>