| Server IP : 162.0.232.25 / Your IP : 3.143.237.203 Web Server : LiteSpeed System : Linux premium276.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 : kwacuqig ( 988) PHP Version : 8.2.26 Disable Function : NONE MySQL : OFF | cURL : ON | WGET : ON | Perl : ON | Python : ON | Sudo : OFF | Pkexec : OFF Directory : /home/kwacuqig/bm1holdings-ltd.com/ |
Upload File : |
<?php
include './header.php';
include './assets/php/connect.php';
include './assets/php/filterFile.php';
if (isset($_GET['pageno'])) {
$pageno = $_GET['pageno'];
} else {
$pageno = 1;
}
$no_of_records_per_page = 8;
$offset = (($pageno - 1) * $no_of_records_per_page);
$total_pages_sql = "SELECT COUNT(*) FROM `clients`";
$result = mysqli_query($conn, $total_pages_sql);
$total_rows = mysqli_fetch_array($result)[0];
$total_pages = ceil($total_rows / $no_of_records_per_page);
?>
<div class="breadcrumbs mb-3">
<div class="container">
<div class="row">
<div class="col-12">
<div class="bread-inner">
<ul class="bread-list">
<li><a href="home">Home<i class="ti-arrow-right"></i></a></li>
<li class="active"><a href="clients">Clients</a></li>
</ul>
</div>
</div>
</div>
</div>
</div>
<div class="product-area most-popular related-product section">
<div class="container">
<div class="row">
<div class="col-12">
<div class="row">
<?php
$query = "SELECT * FROM `clients` ORDER BY `cid` DESC LIMIT $offset, $no_of_records_per_page";
$run = mysqli_query($conn, $query) or die(mysqli_error($conn));
while ($row = mysqli_fetch_array($run)) {
?>
<div class="col-lg-3 col-md-4 col-sm-6 col-12 mb-4" data-aos="flip-right" data-aos-duration="600" data-aos-delay="50">
<div class="single-product">
<div class="product-img">
<a href="#">
<img class="product-img" src="assets/clients/<?php echo $row['image']; ?>" alt="<?php echo $row['name']; ?>">
</a>
</div>
<div class="product-content">
<h5><a href="#"><?php echo $row['name']; ?></a></h5>
<div class="d-flex justify-content-between">
<a href="#"><i class="fa fa-map-marker-alt"></i> <?php echo $row['location']; ?></a>
<a href="#" data-bs-toggle="modal" data-bs-target="#info-<?php echo $row['cid']; ?>"><i class="fa fa-info-circle"></i></a>
</div>
</div>
</div>
</div>
<!-- The Modal -->
<div class="modal fade" id="info-<?php echo $row['cid']; ?>">
<div class="modal-dialog modal-lg modal-dialog-centered">
<div class="modal-content">
<!-- Modal Header -->
<div class="modal-header">
<h4 class="modal-title"><?php echo $row['name']; ?></h4>
<button type="button" class="btn-close" data-bs-dismiss="modal"></button>
</div>
<!-- Modal body -->
<div class="modal-body">
<p class="text"><?php echo $row['biography']; ?></p>
</div>
</div>
</div>
</div>
<?php
}
?>
</div>
</div>
</div>
</div>
</div>
<div class="container section">
<div class="row">
<div class="col-12">
<div class="pagination center mt-2">
<ul class="pagination-list">
<li><a href="<?php if ($pageno <= 1) {
echo '#';
} else {
echo "?pageno=" . ($pageno - 1);
} ?>"><i class="ti-arrow-left"></i></a></li>
<?php
for ($i = 1; $i <= 3; $i++) {
echo "<li><a href=\"?pageno=$i\">$i</a></li>";
}
?>
<li><a href="<?php if ($pageno >= $total_pages) {
echo '#';
} else {
echo "?pageno=" . ($pageno + 1);
} ?>"><i class="ti-arrow-right"></i></a></li>
</ul>
</div>
</div>
</div>
</div>
<?php
include './footer.php';
include './scripts.php';
?>
<script>
document.querySelector("title").innerText = "BM 1 HOLDINGS LTD - CLIENTS";
document.querySelectorAll(".menu-area ul li")[3].classList.add("active");
document.querySelectorAll(".slicknav_nav li a")[3].style.color = "blue";
</script>