Advertisement
Guest User

Untitled

a guest
Mar 16th, 2017
86
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 2.15 KB | None | 0 0
  1. <?php
  2. if(isset($_POST['btnToevoegen']))
  3. {
  4.  
  5. $Titel = $_POST['txtTitel'];
  6. $Datum = $_POST['Datum'];
  7. $Midden = $_POST['txtTekst'];
  8.  
  9. $query = "INSERT INTO nieuws(Titel, Datum, Midden)";
  10. $query .= "VALUES('$Titel', '$Datum', '$Midden')";
  11. $res = mysqli_query($con,$query);
  12. if ($res) {
  13. $errTyp = "Gelukt";
  14. $errMSG = "Succesvol opgeslagen, u gaat over 5 seconden naar het 'Home' venster.";
  15. unset($Titel);
  16. unset($Datum);
  17. unset($Midden);
  18.  
  19. } else {
  20. $errTyp = "Waarschuwing";
  21. $errMSG = "Er ging iets fout, probeer het een andere keer later.";
  22. }echo $errMSG;
  23. header("refresh:5; url=Home.php");
  24. }
  25. ?>
  26. <?php
  27. ob_start();
  28. session_start();
  29. if( isset($_SESSION['user'])!="" ){
  30.  
  31. }
  32. include_once 'dbconnectNieuws.php';
  33. ?>
  34. <form method="Post">
  35. Titel: <input type="text" name= "txtTitel"/>
  36. <br>Datum: <input type="date" name= "Datum"/>
  37. <br>Tekst: <textarea rows="12" cols="80" name="txtTekst"></textarea>
  38. <br><input style="float: none; width: 100%; margin-top: 4px; margin-bottom: 10px;"type="submit" name= "btnToevoegen" value="Toevoegen"/>
  39. </form>
  40.  
  41. <?php
  42. $servername = "localhost";
  43. $username = "root";
  44. $password = "";
  45. $dbname = "nieuws";
  46.  
  47. $dbconnection = mysqli_connect($servername, $username, $password, $dbname);
  48.  
  49. $query = "SELECT * FROM nieuws";
  50. $result = mysqli_query($dbconnection, $query);
  51. if(!$result)
  52. {
  53. echo mysqli_query();
  54. }else
  55. {
  56. while($row = mysqli_fetch_array($result))
  57. {
  58. echo $row["Titel"] . "<br>" . $row["Datum"] . "<br>" . $row["Midden"]. "~~~~~~~~~~~" . "<br>";
  59. }
  60. }
  61.  
  62. ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement