<!-- Search Bar -->
<div class="aside-search-bar">
    <input class="form-control" type="text" placeholder="جستجو...">
    <button><i class="fa fa-search"></i></button>
</div>
<!-- Search Bar -->

<!-- Aside Widget -->
<div class="aside-widget">
    <h3><span>دسته بندی</span></h3>
    <div class="top-categories">
        <ul>
            <?php
            $category2 = $connect -> prepare("select * from `tbl_news_cat` where `delete_flag` = 0 order by `id` desc");
            $category2 -> execute();
            if($category2 -> rowCount() > 0) {
                while ($categoryRow2 = $category2->fetch(PDO::FETCH_ASSOC)){
                    echo '<li><a href="news.php?cat='.$categoryRow2['id'].'">'.$categoryRow2['title'].'</a></li>';
                }
            }
            ?>
        </ul>
    </div>
</div>
<!-- Aside Widget -->

<!-- Aside Widget -->
<div class="aside-widget">
    <h3><span>اخبار پربازدید</span></h3>
    <div class="top-categories">
        <ul>
            <?php
            $newsRelated = $connect -> prepare("select * from `tbl_news` where `delete_flag` = 0 order by rand() limit 5");
            $newsRelated -> execute();
            if($newsRelated -> rowCount() > 0) {
                while ($newsRelatedRows = $newsRelated -> fetch(PDO::FETCH_ASSOC)){
                    ?>
                    <li>
                        <h5><a href="news-detail.php?id=<?php echo $newsRelatedRows['id']; ?>"><?php echo $newsRelatedRows['title']; ?></a></h5>
                    </li>
                    <?php
                }
            }
            ?>
        </ul>
    </div>
</div>
<!-- Aside Widget -->