<?php
    $article = mysqli_query($connection, "SELECT * FROM `articles` WHERE  `id` = " . (int)$_GET['id']);
    if (mysqli_num_rows($article) <= 0) {
        ?>
        <div id="content">
            <div class="container">
                <div class="row">
                    <section class="content__left col-md-8">
                        <div class="block">
                            <a></a>
                            <h3>Статья не найдена</h3>
                            <div class="block__content">
                                <div class="full-text">
                                    Запрашиваемая Вами статья не существует.
                                </div>
                            </div>
                        </div>

                    </section>
                    <section class="content__right col-md-4">
                        <?php
                        include 'includes/sidebar.php';
                        ?>
                    </section>
                </div>
            </div>
        </div>
        <?php
    } else {
        $art = mysqli_fetch_assoc($article);
        mysqli_query($connection, "UPDATE `articles` SET `views` = `views` + 1 WHERE `id` = " . (int)$art['id'])
        ?>
        <div id="content">
            <div class="container">
                <div class="row">
                    <section class="content__left col-md-8">
                        <div class="block">
                            <a>Просмотров: <?php echo $art['views']; ?></a>
                            <h3><?php echo $art['title']; ?></h3>
                            <div class="block__content">
                                <img src="media/img_articles/<?php echo $art['image'] ?>" alt="Article image"
                                     style="max-width: 100%;">
                                <div class="full-text">
                                    <?php echo $art['text']; ?>
                                </div>
                            </div>
                        </div>

                        <div class="block">
                            <a href="#comment-add-form">Добавить свой</a>
                            <h3>Комментарии</h3>
                            <div class="block__content">
                                <div class="articles articles__vertical">
                                    <?php
                                    $query = "SELECT * FROM `comments` WHERE `article_id` = " . (int)$art['id'] . " ORDER BY `pubdate` DESC";
                                    $comments = mysqli_query($connection, $query);
                                    if (mysqli_num_rows($comments) <= 0) {
                                        echo "Нет комментариев";
                                    } else {
                                        while ($comment = mysqli_fetch_assoc($comments)) {
                                            ?>
                                            <article class="article">
                                                <div class="article__image"
                                                     style="background-image: url(https://gravatar.com/avatar/<?php echo md5($comment['email']) ?>)"></div>
                                                <div class="article__info">
                                                    <a href="/article.php?id=<?php echo $comment['id']; ?>"><?php echo $comment['nickname']; ?></a>
                                                    <div class="article__info__meta"></div>
                                                    <div class="article__info__preview">
                                                        <?php echo $comment['text']; ?>
                                                    </div>
                                                </div>
                                            </article>
                                            <?php
                                        }
                                    }
                                    ?>