The code for automatically adding data to php lazy functions is as follows:
/** @ Automatically add a data function * @ $ table name * @ $ arr field Library array ("title", array ("content", int )) * @ array (field, type) * @ type description html -- allow html unhtml-do not allow html int -- int type float -- float type * // The function autoInsert ($ table, $ arr = array (), $ method = 'post') {$ SQL = "insert ". DB_TBLPRE. "$ table set"; $ var = ""; print_r ($ arr); if (empty ($ arr) $ arr = $ _ POST? $ _ POST: $ _ GET; if (empty ($ arr) return false; $ ct = count ($ arr)-1; foreach ($ arr as $ k => $ v) {$ vtype = "unhtml"; if (is_array ($ v) {$ vtype = @ $ v [1]; $ v = $ v [0];} if ($ method = 'post') {$ _ post [$ v] = isset ($ _ POST [$ v])? Trim ($ _ POST [$ v]): ""; if (is_int ($ _ POST [$ v]) {$ _ POST [$ v] = intval ($ _ POST [$ v]);} elseif (is_float ($ _ POST [$ v]) {$ _ POST [$ v] = floatval ($ _ POST [$ v]);} elseif (is_string ($ _ POST [$ v]) {// equal to 1: save html. html if ($ vtype = "unhtml") is not saved by default ") {$ _ POST [$ v] = htmlspecialchars ($ _ POST [$ v]);} elseif ($ vtype = "int ") {$ _ POST [$ v] = @ intval ($ _ POST [$ v]);} elseif ($ vtype = 'float ') {$ _ POST [$ v] = @ floatval ($ _ POST [$ v]) ;}}$ var. = "$ v = '$ _ POST [$ v] '". ($ k <$ ct? ",": "");} Else {$ _ GET [$ v] = isset ($ _ GET [$ v])? Trim ($ _ GET [$ v]): ""; if (is_int ($ _ GET [$ v]) {$ _ GET [$ v] = intval ($ _ GET [$ v]);} elseif (is_float ($ _ GET [$ v]) {$ _ GET [$ v] = floatval ($ _ GET [$ v]);} elseif (is_string ($ _ GET [$ v]) {// equal to 1: save html. html if ($ vtype = 'unhtml ') is not saved by default ') {$ _ GET [$ v] = htmlspecialchars ($ _ GET [$ v]);} elseif ($ vtype = 'int ') {$ _ GET [$ v] = intval ($ _ GET [$ v]);} elseif ($ vtype = 'float ') {$ _ GET [$ v] = floatval ($ _ GET [$ v]) ;}}$ var. = "$ v = '$ _ GET [$ v]'". ($ k <$ c T? ",": "") ;}}$ SQL. = $ var; $ this-> query ($ SQL); return $ this-> insert_id ();} /** @ automatically update the data function * @ $ table name * @ $ arr field Library array ("title", array ("content", int )) * @ array (field, type) * @ type description html -- allow html unhtml-do not allow html int -- int type float -- float type ** $ where condition array type is the same as $ arr * $ method form submission method * /function autoUpdate ($ table, $ arr = array (), $ where = array (), $ method = 'post') {$ SQL = "update ". DB_TBLPRE. "$ table set"; $ var = $ w = ""; I F (empty ($ arr) $ arr =$ _ POST? $ _ POST: $ _ GET; if (empty ($ arr) return false; $ ct = count ($ arr)-1; foreach ($ arr as $ k => $ v) {$ vtype = "unhtml"; if (is_array ($ v) {$ vtype = @ $ v [1]; $ v = $ v [0];} if ($ method = 'post') {$ _ post [$ v] = isset ($ _ POST [$ v])? Trim ($ _ POST [$ v]): ""; if (is_int ($ _ POST [$ v]) {$ _ POST [$ v] = intval ($ _ POST [$ v]);} elseif (is_float ($ _ POST [$ v]) {$ _ POST [$ v] = floatval ($ _ POST [$ v]);} elseif (is_string ($ _ POST [$ v]) {// equal to 1: save html. html if ($ vtype = "unhtml") is not saved by default ") {$ _ POST [$ v] = htmlspecialchars ($ _ POST [$ v]);} elseif ($ vtype = "int ") {$ _ POST [$ v] = @ intval ($ _ POST [$ v]);} elseif ($ vtype = 'float ') {$ _ POST [$ v] = @ floatval ($ _ POST [$ v]) ;}}$ var. = "$ v = '$ _ POST [$ v] '". ($ k <$ ct? ",": "");} Else {$ _ GET [$ v] = isset ($ _ GET [$ v])? Trim ($ _ GET [$ v]): ""; if (is_int ($ _ GET [$ v]) {$ _ GET [$ v] = intval ($ _ GET [$ v]);} elseif (is_float ($ _ GET [$ v]) {$ _ GET [$ v] = floatval ($ _ GET [$ v]);} elseif (is_string ($ _ GET [$ v]) {// equal to 1: save html. html if ($ vtype = 'unhtml ') is not saved by default ') {$ _ GET [$ v] = htmlspecialchars ($ _ GET [$ v]);} elseif ($ vtype = 'int ') {$ _ GET [$ v] = intval ($ _ GET [$ v]);} elseif ($ vtype = 'float ') {$ _ GET [$ v] = floatval ($ _ GET [$ v]) ;}}$ var. = "$ v = '$ _ GET [$ v]'". ($ k <$ c T? ",": "") ;}}$ SQL. = $ var; // Parse where $ ct = count ($ where)-1; if (! Empty ($ where) $ w = "where"; foreach ($ where as $ k => $ v) {$ vtype = "unhtml "; if (is_array ($ v) {$ vtype = @ $ v [1]; $ v = $ v [0];} if ($ method = 'post ') {$ _ POST [$ v] = isset ($ _ POST [$ v])? Trim ($ _ POST [$ v]): ""; if (is_int ($ _ POST [$ v]) {$ _ POST [$ v] = intval ($ _ POST [$ v]);} elseif (is_float ($ _ POST [$ v]) {$ _ POST [$ v] = floatval ($ _ POST [$ v]);} elseif (is_string ($ _ POST [$ v]) {// equal to 1: save html. html if ($ vtype = "unhtml") is not saved by default ") {$ _ POST [$ v] = htmlspecialchars ($ _ POST [$ v]);} elseif ($ vtype = "int ") {$ _ POST [$ v] = @ intval ($ _ POST [$ v]);} elseif ($ vtype = 'float ') {$ _ POST [$ v] = @ floatval ($ _ POST [$ v]);} $ w. = "$ v = '$ _ PO ST [$ v] '". ($ k <$ ct? "And": "");} else {$ _ GET [$ v] = isset ($ _ GET [$ v])? Trim ($ _ GET [$ v]): ""; if (is_int ($ _ GET [$ v]) {$ _ GET [$ v] = intval ($ _ GET [$ v]);} elseif (is_float ($ _ GET [$ v]) {$ _ GET [$ v] = floatval ($ _ GET [$ v]);} elseif (is_string ($ _ GET [$ v]) {// equal to 1: save html. html if ($ vtype = 'unhtml ') is not saved by default ') {$ _ GET [$ v] = htmlspecialchars ($ _ GET [$ v]);} elseif ($ vtype = 'int ') {$ _ GET [$ v] = intval ($ _ GET [$ v]);} elseif ($ vtype = 'float ') {$ _ GET [$ v] = floatval ($ _ GET [$ v]) ;}}$ w. = "$ v = '$ _ GET [$ v]'". ($ k <$ ct? "And": "") ;}}$ SQL. = $ w; $ this-> query ($ SQL );}