Advertisement
Guest User

Untitled

a guest
Feb 18th, 2016
73
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.37 KB | None | 0 0
  1. <html>
  2. <head>
  3.  
  4. </head>
  5. <body>
  6.  
  7. <?php
  8. $fnameinput= $_POST['fname'];
  9. $lnameinput= $_POST['lname'];
  10. $emailinput= $_POST['email'];
  11. $postalinput= $_POST['postal'];
  12. $attendinginput= (isset($_POST['attending'])) ? 1 : 0;
  13. $requirementsinput= $_POST['requirements'];
  14. $messageinput= $_POST['message'];
  15. $kidsinput= $_POST['kids'];
  16. $servername = "localhost";
  17. $username = "root";
  18. $password = "Exper1ence";
  19. $dbname = "RSVP";
  20.  
  21. // Create connection
  22. $conn = new mysqli($servername, $username, $password, $dbname);
  23. // Check connection
  24. if ($conn->connect_error) {
  25. die("Connection failed: " . $conn->connect_error);
  26. }
  27.  
  28. $sql = "INSERT INTO `responses`(`fname`, `lname`, `email`,`postal`, `attending`, `requirements`,`message`,`kids`) VALUES ($fnameinput,$lnameinput,$emailinput,$postalinput,$attendinginput,$requirementsinput,$messageinput,$kidsinput)";
  29.  
  30. if ($conn->query($sql) === TRUE) {
  31. if ($attendinginput == "1") {
  32. echo "Thank you for sending through your RSVP.<br/>";
  33. echo "We look forward to seeing you on our special day!";
  34. }
  35. else {
  36. echo "Thank you for sending through your RSVP.<br/>";
  37. echo "We are sad you cannot make it to our special day, you will be missed!";
  38. }
  39.  
  40. } else {
  41. echo "Oops something bad happened!: " . $conn->error;
  42. echo "Please Email jamesandruth2016@gmail.com or try again later.";
  43. }
  44. $conn->close();
  45.  
  46. ?>
  47.  
  48. </body>
  49. </html>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement