dodawanieWpisow/wyswielanie

<!--
dodawanie
-->

    <form method="post">
                    <aside class="form-group col-12">
                        <h4 class="text-center">Podaj tytuł wpisu:</h4>
                        <input type="text" class="form-control col-12 col-lg-5 mx-auto"   placeholder="Podaj tytuł wpisu" name="tytul" required>
                    </aside>
                    <aside class="form-group justify-content-center">
                        <h4 class="text-center">Podaj treść wpisu:</h4>
                        <textarea class=" col-12 col-lg-6 offset-lg-3" name="tresc" id="exampleFormControlTextarea1">Treść wpisu(max 1000 znaków)...</textarea>
                    </aside>
                        <button class="btn btn-primary ml-lg-5 col-12 col-lg-5" type="submit">Dodaj wpis</button>
                        <input class="btn btn-primary ml-lg-5 mt-2 mt-lg-0 col-12 col-lg-5" type="reset" value="Wyczyść">
                </form>

if(isset($_POST["tytul"])&&isset($_POST["tresc"]))
                {
                    $tytul=$_POST["tytul"];
                    $tresc=nl2br($_POST["tresc"]);

                    $query = "INSERT INTO `wpisy` (`Data`, `Tytul`, `Tresc`) VALUES (?, ?, ?)";
                    $statement = $connection->prepare($query);
                    $statement->bind_param("sss", $data, $tytul, $tresc);
                    $data = date("d-m-Y H:i:s");
                    $tytul = $connection->real_escape_string($tytul);
                    $tresc = $connection->real_escape_string($tresc);
                    $statement->execute();
                    $statement->close();
                }

<!--wyswietlanie-->

$zapytanie="SELECT * FROM wpisy ORDER BY Id DESC";
                $rezultat=mysqli_query($connection, $zapytanie);
                while($bufor=mysqli_fetch_assoc($rezultat))
                {
                    echo '<article class="col-10 mt-2 mb-1 mx-auto" style=" border:1px solid black; border-radius:20px;"><aside class="col-12 text-right"> Dodano: '.$bufor['Data'].'</aside><br>';
                    if(isset($_SESSION["sessionid"])) echo '<aside class="col-12 text-left"><b>Id: '.$bufor['Id'].'</b></aside>';
                    echo '<h3 class="col-12 text-left ml-md-5"><br>'.$bufor["Tytul"].'</h3>';
                        echo '<aside class="col-12 text-center">'.$bufor['Tresc'].'</aside></article>';
                }