Advertisement
Guest User

Untitled

a guest
Sep 23rd, 2017
66
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 1.07 KB | None | 0 0
  1. <?
  2.     if( isset($_POST["submit"]) )
  3.     {
  4.         $filter     = array("submit");
  5.        
  6.         // INSERT
  7.         $keys       = "";
  8.         $values     = "";
  9.        
  10.         foreach($_POST as $key => $value)
  11.             if(!in_array($key, $filter))
  12.                 $keys       .= "$key, ";
  13.                 $values     .= "'$value', ";
  14.        
  15.         $insert_query   = "INSERT INTO person ( ". substr($keys, 0, -2) ." ) VALUES ( ". substr($values, 0, -2) ." )";
  16.         // !INSERT
  17.        
  18.        
  19.         // UPDATE
  20.         $update_query   = "UPDATE person SET ";
  21.                            
  22.         foreach($_POST as $key => $value)
  23.             if(!in_array($key, $filter))
  24.                 $update_query   .= $key . " = '$value', ";
  25.        
  26.         $update_query   = substr($update_query, 0, -2 ) ." WHERE id = '0'";
  27.         // !UPDATE
  28.        
  29.         echo "Insert query: " . $insert_query . "<br />";
  30.         echo "Update query: " . $update_query . "<br /><br />";
  31.     }
  32. ?>
  33. <html>
  34.     <body>
  35.         <form action="" method="post">
  36.             First name: <input type="text" name="firstname" /> <br />
  37.             Last name: <input type="text" name="lastname" /> <br />
  38.             Zipcode: <input type="text" name="zipcode" /> <br />
  39.             <input type="submit" name="submit" value="Do it!" />
  40.         </form>
  41.     </body>
  42. </html>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement