| Server IP : 162.0.232.25 / Your IP : 3.137.177.204 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/nkhwaziaeros.com/ |
Upload File : |
<?php
include "./inc/connect.php";
if(isset($_GET['pageno']))
{
$pageno=$_GET['pageno'];
}
else
{
$pageno=1;
}
$no_of_records_per_page=12;
$offset=($pageno-1) * $no_of_records_per_page;
$total_pages_sql="SELECT COUNT(*) FROM `gallery`";
$result=mysqli_query($conn,$total_pages_sql);
$total_rows=mysqli_fetch_array($result)[0];
$total_pages=ceil($total_rows / $no_of_records_per_page);
?>
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="utf-8">
<meta name="viewport" content="width=device-width, initial-scale=1.0">
<meta name="description" content="">
<meta name="author" content="">
<link rel="icon" href="./icons/nkhwaziaeros.ico">
<title>NKHWAZI AEROS - Gallery</title>
<link rel="stylesheet" type="text/css" href="./css/bootstrap.min.css" >
<link href="./css/main.css" rel="stylesheet" type="text/css">
<link rel="stylesheet" href="./css/animate.css" type="text/css">
<!-- Font awesome JS -->
<script type="text/javascript" src="./js/all.min.js"></script>
<!-- Ajax Features -->
<script type="text/javascript" src="./js/ajax.js"></script>
<!-- Sweet Alert -->
<script type="text/javascript" src="./js/sweetalert.min.js"></script>
<!-- Open Graph tags -->
<meta property="og:site_name" content="NkhwaziAeros"/>
<meta property="og:title" content="Gallery"/>
<meta property="og:description" content="Providing captivating footage from all angles!"/>
<meta property="og:type" content="website"/>
<meta property="og:image" content="https://www.nkhwaziaeros.com/img/dji-phantom-4.jpg"/>
<meta property="og:locale" content="en_US"/>
<meta name="twitter:card" content="summary"/>
<meta name="twitter:site" content="@AerosNkhwazi"/>
<meta name="twitter:title" content="NkhwaziAeros"/>
<meta name="twitter:description" content="Mapping, drone photography and videos"/>
<meta name="twitter:image" content="https://www.nkhwaziaeros.com/img/dji-phantom-4.jpg"/>
<meta name="twitter:image:alt" content="NkhwaziAeros"/>
</head>
<body>
<!-- Email Us -->
<i class="fa fa-envelope message" data-toggle="modal" data-target="#message"></i>
<!-- Email Modal -->
<?php include './email.php';?>
<!-- Header -->
<div class="cover-overflow">
<section class="row img-cover">
<nav class="navbar navbar-expand-md navbar-dark fixed-top">
<a class="navbar-brand">
<img src="./img/aeros1.png" alt="NkhwaziAeros">
</a>
<button class="navbar-toggler" type="button" data-toggle="collapse" data-target="#navbarsExampleDefault" aria-controls="navbarsExampleDefault" aria-expanded="false" aria-label="Toggle navigation">
<span class="navbar-toggler-icon"></span>
</button>
<!-- Nav Bar -->
<div class="collapse navbar-collapse" id="navbarsExampleDefault">
<ul class="navbar-nav mr-auto">
<li class="nav-item">
<a class="nav-link" href="home" tabindex="-1" aria-disabled="true">HOME</a>
</li>
<li class="nav-item active">
<a class="nav-link" href="gallery">GALLERY<span class="sr-only">(current)</span></a>
</li>
<li class="nav-item">
<a class="nav-link" href="videos" tabindex="-1" aria-disabled="true">VIDEOS</a>
</li>
<li class="nav-item">
<a class="nav-link" href="services" tabindex="-1" aria-disabled="true">SERVICES</a>
</li>
<li class="nav-item">
<a class="nav-link" href="projects" tabindex="-1" aria-disabled="true">PROJECTS</a>
</li>
<li class="nav-item">
<a class="nav-link" href="team" tabindex="-1" aria-disabled="true">TEAM</a>
</li>
<li class="nav-item">
<a class="nav-link" href="contact">CONTACT</a>
</li>
</ul>
</div>
</nav>
<!-- Background Image -->
<div class="container-fluid">
<div class="color-overlay-img"></div>
<div class="img-content">
<h3 class="my-3">NKHWAZI GALLERY</h3>
<div class="underline"></div>
<h4 class="lead">Check It Out</h4>
</div>
</div>
</section>
</div>
<section>
<!-- Carousel -->
<div class="container-fluid cover-overflow mt-2">
<!-- Carousel -->
<div class="row">
<div class="col-12 carousel-gutter wow fadeInUp" data-wow-duration="0.7s" data-wow-delay="0.6s">
<div id="ctrl" class="carousel slide" data-ride="carousel" data-interval="2000">
<div class="carousel-inner">
<?php
$sql2="SELECT * FROM `gallery` ORDER BY `gid` DESC LIMIT $offset, $no_of_records_per_page";
if($run2=mysqli_query($conn,$sql2))
{
while($row=mysqli_fetch_array($run2))
{
$id=$row['gid'];
$image=$row['image'];
$description=$row['description'];
?>
<div class="carousel-item">
<img src="./img_gallery/<?php echo $image;?>" alt="<?php echo $id;?>" class="carousel-img">
<div class="carousel-caption">
<p><?php echo strtoupper($description);?></p>
</div>
</div>
<?php
}
}
else
{
die(mysqli_error($conn));
}
?>
</div>
<a class="carousel-control-prev" href="#ctrl" data-slide="prev">
<span class="carousel-control-prev-icon"></span>
</a>
<a class="carousel-control-next" href="#ctrl" data-slide="next">
<span class="carousel-control-next-icon"></span>
</a>
</div>
</div>
</div>
</div>
<!-- Image Gallery -->
<div class="container-fluid">
<div class="row">
<?php
$sql3="SELECT * FROM `gallery` ORDER BY `gid` DESC LIMIT $offset, $no_of_records_per_page";
if($run3=mysqli_query($conn,$sql3))
{
while($row=mysqli_fetch_array($run3))
{
$id=$row['gid'];
$image=$row['image'];
$description=$row['description'];
?>
<div class="col-6 col-lg-3 col-md-4 col-sm-6 my-2 gallery wow fadeInUp" data-wow-duration="0.7s" data-wow-delay="0.6s">
<img src="./img_gallery/<?php echo $image;?>" alt="<?php echo $description;?>" class="img img-gallery" id="img-<?php echo $id;?>" onclick="zoom('<?php echo $id;?>')" />
</div>
<!-- The Modal -->
<div id="modal-<?php echo $id;?>" class="modal-gallery" onclick="this.style.display='none'">
<span class="close" id="close-<?php echo $id;?>">×</span>
<img class="modal-content-gallery" id="img-modal-<?php echo $id;?>" />
<div class="caption" id="caption-<?php echo $id;?>"></div>
</div>
<?php
}
}
else
{
die(mysqli_error($conn));
}
?>
</div>
</div>
</section>
<!-- Pagination -->
<div class="cover-overflow">
<div class="row">
<div class="col">
<ul class="pagination justify-content-center">
<li class="page-item"><a class="page-link" href="<?php if($pageno<=1){echo '#';} else {echo "?pageno=".($pageno-1);} ?>">Prev</a></li>
<?php
for($x=1;$x<=2;$x++)
{
echo "<li class=\"page-item\"><a class=\"page-link\" href=\"?pageno=$x\">$x</a></li>";
}
?>
<li class="page-item"><a class="page-link" href="<?php if($pageno==$total_pages){echo '#';} else {echo "?pageno=".($pageno+1);} ?>">Next</a></li>
</ul>
</div>
</div>
</div>
<!-- Footer -->
<?php include './footer.php';?>
<!-- Bootstrap core JavaScript
================================================== -->
<!-- Placed at the end of the document so the pages load faster -->
<script type="text/javascript" src="./js/jquery-3.3.1.min.js"></script>
<script type="text/javascript" src="./js/bootstrap.min.js"></script>
<script type="text/javascript" src="js/jquerySmoothScroll.js"></script>
<script src="./js/changeBg.js"></script>
<script type="text/javascript" src="./js/email.js"></script>
<script type="text/javascript" src="./js/zoomImg.js"></script>
<script type="text/javascript" src="./js/wow.min.js"></script>
<script src="./js/changeBg.js"></script>
<script type="text/javascript">
new WOW().init();
</script>
<script>
document.querySelectorAll(".carousel-item")[0].classList.add("active");
</script>
</body>
</html>