Advertisement
Guest User

Untitled

a guest
Mar 20th, 2017
210
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.85 KB | None | 0 0
  1. 1. Maak 3 PHP files.
  2. 2. Benoem ze index.php, addAdress.php en connection.php
  3.  
  4.  
  5.  
  6. Index.php:
  7. <?php
  8.  
  9. require 'connection.php';
  10. $conn = Connect();
  11. $voornaam = $conn->real_escape_string($_POST['voornaam']);
  12. $tussenvoegsel = $conn->real_escape_string($_POST['tussenvoegsel']);
  13. $achternaam = $conn->real_escape_string($_POST['achternaam']);
  14. $email = $conn->real_escape_string($_POST['email']);
  15. $query = "INSERT into users (Voornaam,Tussenvoegsel,Achternaam,Email)
  16. VALUES('" . $voornaam . "','" . $tussenvoegsel . "','" . $achternaam . "','" . $email . "')";
  17. $success = $conn->query($query);
  18.  
  19. if (!$success) {
  20. die("Couldn't enter data: ".$conn->error);
  21.  
  22. }
  23.  
  24. echo "Thank You For Contacting Us <br>";
  25.  
  26. $conn->close();
  27.  
  28. ?>
  29. -----------------------------------------------------------------------------------------------------------------------------
  30. addAddres.php:
  31.  
  32. <!DOCTYPE html>
  33. <html>
  34. <head>
  35. <title> Simple PHP contact form with MySQL and Form Validation </title>
  36. </head>
  37. <body>
  38. <h3> Contact US</h3>
  39. <form action="index.php" method="post">
  40. Voornaam:<br>
  41. <input type="text" name="voornaam" required><br>
  42.  
  43. Tussenvoegsel:
  44. <input type="text" name="tussenvoegsel"><br>
  45.  
  46. Achternaam:<br>
  47. <input type="text" name="achternaam" required><br>
  48.  
  49. E-Mail:<br>
  50. <input type="email" name="email" required><br>
  51. <input type="submit" value="Submit"><br>
  52. </form>
  53. </body>
  54. </html>
  55. -----------------------------------------------------------------------------------------------------------------------------
  56. connection.php:
  57. <?php
  58.  
  59. function Connect()
  60. {
  61. $dbhost = "localhost";
  62. $dbuser = "root";
  63. $dbpass = "password";
  64. $dbname = ""; (DIT VERANDEREN)
  65.  
  66. // Create connection
  67. $conn = new mysqli($dbhost, $dbuser, $dbpass, $dbname) or die($conn->connect_error);
  68.  
  69. return $conn;
  70. }
  71.  
  72. ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement