Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?php
- if(isset($_POST['btnToevoegen']))
- {
- $Titel = $_POST['txtTitel'];
- $Datum = $_POST['Datum'];
- $Midden = $_POST['txtTekst'];
- $query = "INSERT INTO nieuws(Titel, Datum, Midden)";
- $query .= "VALUES('$Titel', '$Datum', '$Midden')";
- $res = mysqli_query($con,$query);
- if ($res) {
- $errTyp = "Gelukt";
- $errMSG = "Succesvol opgeslagen, u gaat over 5 seconden naar het 'Home' venster.";
- unset($Titel);
- unset($Datum);
- unset($Midden);
- } else {
- $errTyp = "Waarschuwing";
- $errMSG = "Er ging iets fout, probeer het een andere keer later.";
- }echo $errMSG;
- header("refresh:5; url=Home.php");
- }
- ?>
- <?php
- ob_start();
- session_start();
- if( isset($_SESSION['user'])!="" ){
- }
- include_once 'dbconnectNieuws.php';
- ?>
- <form method="Post">
- Titel: <input type="text" name= "txtTitel"/>
- <br>Datum: <input type="date" name= "Datum"/>
- <br>Tekst: <textarea rows="12" cols="80" name="txtTekst"></textarea>
- <br><input style="float: none; width: 100%; margin-top: 4px; margin-bottom: 10px;"type="submit" name= "btnToevoegen" value="Toevoegen"/>
- </form>
- <?php
- $servername = "localhost";
- $username = "root";
- $password = "";
- $dbname = "nieuws";
- $dbconnection = mysqli_connect($servername, $username, $password, $dbname);
- $query = "SELECT * FROM nieuws";
- $result = mysqli_query($dbconnection, $query);
- if(!$result)
- {
- echo mysqli_query();
- }else
- {
- while($row = mysqli_fetch_array($result))
- {
- echo $row["Titel"] . "<br>" . $row["Datum"] . "<br>" . $row["Midden"]. "~~~~~~~~~~~" . "<br>";
- }
- }
- ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement