Advertisement
Guest User

Untitled

a guest
Mar 21st, 2017
97
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.88 KB | None | 0 0
  1. <html>
  2. <head>
  3. </head>
  4. <body>
  5. <div>
  6. <h2> </h2>
  7. <hr/>
  8. <form method="post">
  9. <label>Voornaam :</label>
  10. <input type="text" name="voornaam" id="voornaam" required="required" placeholder="Voornaam"/><br /><br />
  11. <label>Tussenvoegsel :</label>
  12. <input type="text" name="tussenvoegsel" id="tussenvoegsel" placeholder="Tussenvoegsel"/><br/><br />
  13. <label>Achternaam :</label>
  14. <input type="text" name="achternaam" id="achternaam" required="required" placeholder="Achternaam"/><br/><br />
  15. <label>Email :</label>
  16. <input type="email" name="email" id="email" required="required" placeholder="Email"/><br/><br />
  17. <input type="submit" value=" Submit " name="submit"/><br />
  18. </form>
  19. </div>
  20.  
  21. <?php
  22. if(isset($_POST["submit"])){
  23. $hostname='localhost';
  24. $username='root';
  25. $password=null;
  26.  
  27. try {
  28. $dbh = new PDO("mysql:host=$hostname;dbname=toets1",$username,$password);
  29.  
  30. $dbh->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION); // <== add this line
  31. $sql = "INSERT INTO waardes (voornaam, tussenvoegsel, achternaam, email)
  32. VALUES (:voornaam,:tussenvoegsel,:achternaam,:email)";
  33. $insert = $dbh->prepare($sql);
  34. $insert->bindParam(":voornaam", $_POST["voornaam"] );
  35. $insert->bindParam(":tussenvoegsel", $_POST["tussenvoegsel"] );
  36. $insert->bindParam(":achternaam", $_POST["achternaam"] );
  37. $insert->bindParam(":email", $_POST["email"] );
  38. if ($insert->execute()) {
  39. echo "<script type= 'text/javascript'>alert('Inserted Successfully');</script>";
  40. }
  41. else{
  42. echo "<script type= 'text/javascript'>alert('not successfully Inserted.');</script>";
  43. }
  44.  
  45. $dbh = null;
  46. }
  47. catch(PDOException $e)
  48. {
  49. echo $e->getMessage();
  50. }
  51.  
  52. }
  53. ?>
  54. </body>
  55. </html>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement