komentarze

//dodawanie komentarzy
<?php
                    include("dane.php");
                    $connection = mysqli_connect($dbHost, $dbUser, $dbPassword, $dbDatabase)
                        or die('Brak połączenia z serwerem MySQL.<br />Błąd: '.mysqli_error($connection));
                    mysqli_set_charset($connection, "utf-8");

                    if(!empty($_POST["email"])&&!empty($_POST["nick"])&&!empty($_POST["komentarz"]))
                    {
                        $email=$_POST["email"];
                        $nick=$_POST["nick"];
                        $komentarz=nl2br($_POST["komentarz"]);

                        $query = "INSERT INTO `komentarze` (`data`, `email`, `nick`, `komentarz`) VALUES (?, ?, ?, ?)";
                        $statement = $connection->prepare($query);
                        $statement->bind_param("ssss", $data, $email, $nick, $komentarz);
                        $data = date("d-m-Y H:i:s");
                        $email = $connection->real_escape_string($email);
                        $nick = $connection->real_escape_string($nick);
                        $komentarz = $connection->real_escape_string($komentarz);
                        $statement->execute();
                        $statement->close();
                    }

?>

/wypisanie

<?php
                    $zapytanie="SELECT * FROM komentarze ORDER BY Id DESC";
                    $rezultat=mysqli_query($connection, $zapytanie);
                echo '<form method="post"  >';
                    while($bufor=mysqli_fetch_assoc($rezultat))
                    {
                        echo '<div style="  border:1px solid black;border-radius:5px;"><div class="col-12 text-right">Dodano: '.$bufor['data'].'</div>';
                            if(isset($_SESSION["sessionid"]))
                            {
                                echo '<input type="submit" name="usun" value="'.$bufor['Id'].'" class="btn btn-primary col-2 col-lg-2 mb-1 d-block mx-auto">';
                                echo '<div class="col-12 text-left"><b>Id='.$bufor['Id'].'</b></div>';
                                echo '<div class="col-12 text-left"><br>'.$bufor["email"].'</div>';
                            }
                        echo '<div class="col-12 text-left"><br><b>'.$bufor["nick"].'</b></div>';
                        echo '<div class="col-12 text-center style="text-align;">'.$bufor["komentarz"].'</div></div><br>';
                    }
                ?>