Insert/Update/Delete functions

PHP Example :

<?php //////////////////////////////////////////////////////////// // Function Name: db_insert() // Accepts: varchar table // Returns: Success or mysql_error() // // Author: Andrew Deering // Date: 12/09/04 // // Purpose: // // This function takes all of the posted form elements // and inserts them into $table. /////////////////////////////////////////////////////////// function db_insert($table){ //$query = "INSERT INTO <table>( $query = "INSERT INTO ".$table." ("; //$query = "INSERT INTO <table>($fldnm1, $fldnm2, ... $fldnmN //$fldnmN = $fieldnameN //EXPLANATION// $trigger = 0; foreach($_POST as $field => $value){ if($trigger > 0) $query = $query . ", "; $query = $query . $field; $trigger++; } //$query = "INSERT INTO <table>(fldnm1, fldnm2, ... fldnmN) VALUES(trim(' $query = $query . ") VALUES (trim('"; //$query = "INSERT INTO <table>(fldnm1, fldnm2, ... fldnmN) VALUES(trim('value1'), trim('value2'), trim('valueN') $trigger = 0; foreach($_POST as $field => $value){ if($trigger > 0) $query = $query . ", trim('"; $query = $query . $value."')"; $trigger++; } //$query = "INSERT INTO <table>(fldnm1, fldnm2, ... fldnmN) VALUES(trim('value1'), trim('value2'), trim('valueN')); $query = $query . ");"; //IF query runs, return. Else, tell me why //echo $query."<br><br>"; if($result = mysql_query($query)) return(0); else echo(mysql_error()); } //END db_insert //////////////////////////////////////////////////////////// // Function Name: db_update() // Accepts: varchar table, varchar pk, varchar pkval // Returns: Success or mysql_error() // // Author: Andrew Deering // Date: 12/10/04 // // Purpose: // // This function takes all of the posted form elements // and updates $table WHERE $pk = $pkval with new values. /////////////////////////////////////////////////////////// function db_update($table, $pk, $pkval){ //$query = "UPDATE <table> SET $query = "UPDATE ".$table." SET "; //$query = "UPDATE <table> SET $fldnm1 = fldnm1, $fldnm2 = fldnm2, ... $fldnmN = fldnmN //$fldnmN = $fieldnameN //EXPLANATION// $trigger = 0; foreach($_POST as $field => $value){ echo $field." = ".$value."<br><br>"; if($trigger > 0) $query = $query . ", "; $query = $query . $field." = trim('$value')"; $trigger++; } //$query = "UPDATE <table> SET $fldnm1 = fldnm1, $fldnm2 = fldnm2, ... $fldnmN = fldnmN WHERE $pk = $pkval $query = $query . " WHERE ".$pk." = ".$pkval; //IF query runs, return. else, tell me why echo $query."<br><br>"; if($result = mysql_query($query)) return(0); else echo(mysql_error()); } //END db_update //////////////////////////////////////////////////////////// // Function Name: db_delete() // Accepts: varchar table, varchar pk, varchar pkval // Returns: Success or mysql_error() // // Author: Andrew Deering // Date: 12/10/04 // // Purpose: // // This function deletes FROM $table WHERE $pk = $pkval. /////////////////////////////////////////////////////////// function db_delete($table, $pk, $pkval){ $query = "DELETE FROM ".$table." WHERE ".$pk." = ".$pkval; //IF query runs, return. else, tell me why //echo $query."<br><br>"; if($result = mysql_query($query)) return(0); else echo(mysql_error()); } //END db_delete ?>