1#@!#!123s

��JFIF�� 1#@!#!123s
: / home / nc6d095 / nisan.space / btc-now / inc /
Filename : res-aside.php
back
<aside class="col-lg-4 sidebar">
    <div class="widget">
        <h4 class="widget-title mb-3">Popular Posts</h4>
        <ul class="image-list">
            <?php
            $getItems = dbSelect("posts","*","(status='Active')","views","5");
            while($row = mysqli_fetch_array($getItems)){
                $id = $row['id'];
                $title = $row['title'];
                $subcategory = $row['category'];
                $catId = getDBVal('subcategories',$subcategory,'category');
                $subcatName = getDBVal('subcategories',$subcategory);
                $catName = getDBVal('categories',$catId);
                $image = $row['image'];
                $dAdded = date("F jS, Y", strtotime($row['dateAdded']));
                $dateAdded = strtotime($row['dateAdded']);
                $timeAgo = getTimeAgo($dateAdded);
                $emptyDU = $row['dateUpdated'];
                $status = $row['status'];
            ?>
            <li>
                <figure class="rounded"><a href=""><img src="<?= $uploadsRoot ?>images/resources/<?= $image ?>" alt="" /></a></figure>
                <div class="post-content">
                    <h6 class="mb-2"> <a class="link-dark" href=""><?= $title ?></a> </h6>
                    <ul class="post-meta">
                        <li class="post-date"><i class="bi bi-calendar"></i><span><?= $timeAgo ?></span></li>
                        <li class="post-comments"><a href="#"><i class="bi bi-chat"></i>3</a></li>
                    </ul>
                    <!-- /.post-meta -->
                </div>
            </li>
            <?php } ?>
        </ul>
        <!-- /.image-list -->
    </div>
    <!-- /.widget -->
    <div class="widget">
        <h4 class="widget-title mb-3">Categories</h4>
        <ul class="unordered-list bullet-primary text-reset">
            <?php
            $query = dbSelect('subcategories',"*","status='Active'");
            while($row = mysqli_fetch_array($query)){
                $subcatId = $row['id'];
                $subcatName = $row['name'];
                $slug = makeSlug($subcatName);
            ?>
            <li><a href="<?= $mainRoot ?>resources/<?= $slug ?>/<?= $subcatId ?>"><?= $subcatName ?> (<?= cntRows('posts',"category=$subcatId") ?>)</a></li>
            <?php } ?>
            <!--<li><a href="#">Teamwork (21)</a></li>-->
        </ul>
    </div>
    <!-- /.widget -->
</aside>