| Server IP : 66.29.137.217 / Your IP : 3.15.198.191 Web Server : LiteSpeed System : Linux premium294.web-hosting.com 4.18.0-513.11.1.lve.el8.x86_64 #1 SMP Thu Jan 18 16:21:02 UTC 2024 x86_64 User : gltevjme ( 1095) PHP Version : 7.0.33 Disable Function : NONE MySQL : OFF | cURL : ON | WGET : ON | Perl : ON | Python : ON | Sudo : OFF | Pkexec : OFF Directory : /home/gltevjme/greatlifehub.ng/fir/ |
Upload File : |
<!-- Sidebar Container Start -->
<div class="sidebar">
<div class="widget widget-search">
<form action="<?php echo BASE_URL.URL_SEARCH; ?>" method="post">
<input type="text" name="search_string" placeholder="<?php echo SEARCH; ?>">
<button type="submit"><i class="fa fa-search"></i></button>
</form>
</div>
<div class="widget">
<?php
$statement = $pdo->prepare("SELECT * FROM tbl_settings WHERE id=1");
$statement->execute();
$result = $statement->fetchAll(PDO::FETCH_ASSOC);
foreach ($result as $row) {
$total_recent_news_sidebar = $row['total_recent_news_sidebar'];
$total_popular_news_sidebar = $row['total_popular_news_sidebar'];
}
?>
<h4><?php echo CATEGORIES; ?></h4>
<ul>
<?php
$statement = $pdo->prepare("SELECT * FROM tbl_category ORDER BY category_name ASC");
$statement->execute();
$result = $statement->fetchAll(PDO::FETCH_ASSOC);
foreach ($result as $row) {
?>
<li><a href="<?php echo BASE_URL.URL_CATEGORY.$row['category_slug']; ?>"><?php echo $row['category_name']; ?></a></li>
<?php
}
?>
</ul>
</div>
<div class="widget">
<h4><?php echo LATEST_NEWS; ?></h4>
<ul>
<?php
$i=0;
$statement = $pdo->prepare("SELECT * FROM tbl_news ORDER BY news_id DESC");
$statement->execute();
$result = $statement->fetchAll(PDO::FETCH_ASSOC);
foreach ($result as $row) {
$i++;
if($i>$total_recent_news_sidebar) {break;}
?>
<li><a href="<?php echo BASE_URL.URL_NEWS.$row['news_slug']; ?>"><?php echo $row['news_title']; ?></a></li>
<?php
}
?>
</ul>
</div>
<div class="widget">
<h4><?php echo POPULAR_NEWS; ?></h4>
<ul>
<?php
$i=0;
$statement = $pdo->prepare("SELECT * FROM tbl_news ORDER BY total_view DESC");
$statement->execute();
$result = $statement->fetchAll(PDO::FETCH_ASSOC);
foreach ($result as $row) {
$i++;
if($i>$total_popular_news_sidebar) {break;}
?>
<li><a href="<?php echo BASE_URL.URL_NEWS.$row['news_slug']; ?>"><?php echo $row['news_title']; ?></a></li>
<?php
}
?>
</ul>
</div>
</div>
<!-- Sidebar Container End -->