Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?
- if( isset($_POST["submit"]) )
- {
- $filter = array("submit");
- // INSERT
- $keys = "";
- $values = "";
- foreach($_POST as $key => $value)
- if(!in_array($key, $filter))
- $keys .= "$key, ";
- $values .= "'$value', ";
- $insert_query = "INSERT INTO person ( ". substr($keys, 0, -2) ." ) VALUES ( ". substr($values, 0, -2) ." )";
- // !INSERT
- // UPDATE
- $update_query = "UPDATE person SET ";
- foreach($_POST as $key => $value)
- if(!in_array($key, $filter))
- $update_query .= $key . " = '$value', ";
- $update_query = substr($update_query, 0, -2 ) ." WHERE id = '0'";
- // !UPDATE
- echo "Insert query: " . $insert_query . "<br />";
- echo "Update query: " . $update_query . "<br /><br />";
- }
- ?>
- <html>
- <body>
- <form action="" method="post">
- First name: <input type="text" name="firstname" /> <br />
- Last name: <input type="text" name="lastname" /> <br />
- Zipcode: <input type="text" name="zipcode" /> <br />
- <input type="submit" name="submit" value="Do it!" />
- </form>
- </body>
- </html>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement