| Server IP : 68.65.120.201 / Your IP : 216.73.216.73 Web Server : LiteSpeed System : Linux server179.web-hosting.com 4.18.0-513.18.1.lve.el8.x86_64 #1 SMP Thu Feb 22 12:55:50 UTC 2024 x86_64 User : taxhyuvu ( 2294) PHP Version : 8.1.32 Disable Function : NONE MySQL : OFF | cURL : ON | WGET : ON | Perl : ON | Python : ON | Sudo : OFF | Pkexec : OFF Directory : /home/taxhyuvu/public_html/ |
Upload File : |
<?php
include_once('head.php');
include_once('admin/db.php');
$limit = 10;
if(isset($_GET['page'])){
$page = $_GET['page'];
}
else{
$page = 1;
}
$offset = ($page -1)*$limit;
$sel="SELECT * FROM `news` ORDER BY `id` desc LIMIT $offset, $limit";
$data=mysqli_query($con,$sel);
$Paseee="SELECT COUNT(*) FROM `news`";
$asasss = mysqli_query($con,$Paseee);
$total_rows = mysqli_fetch_array($asasss)[0];
$total_page = ceil ($total_rows / $limit);
// $sel="SELECT * FROM `news` ORDER BY `id` Desc ";
// $data=mysqli_query($con,$sel);
?>
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="UTF-8">
<meta http-equiv="X-UA-Compatible" content="IE=edge">
<meta name="viewport" content="width=device-width, initial-scale=1.0">
<title>LATEST NEWS</title>
<style>
.NEWWOR:HOVER{box-shadow: 0 -5px 15px 0 rgb(29 150 159 / 33%);transition:0.5s;}
.NEWWOR{transition:0.5s;border: 2px solid #1d969d57;border-radius: 10px; padding: 15px 1px;
margin-bottom:20px; }
.NEWWOR img{opacity: 80%;transition:0.5s;}
.NEWWOR img:hover{opacity: 100%;transition:0.5s;}
.NEWWOR a:hover {
color: #5e5d5b !important; transition:0.5s;
}
.NEWWOR a{ color: #603f3f;
transition: 0.5s;
font-family: math;
font-size: 18px;}
.NEWWOR h1{ color: #177d85;
font-family: math;
font-size: 25px;}
.NEWWOR p,span{color: #5e5d5b;};
.section-title {
text-align: center;
}
.section-title h2 {
font-size: 50px;
font-weight: 900;
text-transform: uppercase;
margin-top: 1.5%;
position: relative;
color: #4f5457;
font-family: math;
}
.pagination {
font-weight: 600;
display: flex;
padding-left: 0;
list-style: none;
font-size: 18px;
font-family: math;
}
.pagination a {
color: #007799;
border: 1px solid #379ab5;
}
.pagination a:hover {
color: black!important;
border: 1px solid #379ab5;
}
.page-link:focus {
z-index: 3;
color: black !important;
background-color: #e9ecef !important;
outline: 0 !important;
box-shadow: none !important;
}
.page-item.active .page-link {
z-index: 3;
color: #fff;
background-color: #469ab3;
border-color: #379ab5;
}
</style>
</head>
<body>
<div class="row">
<div class="section-title">
<center> <h2 style="padding:40px 0px;text-align: center;"> Latest News</h2></center>
</div>
<div class="col-md-2">
</div>
<div class="col-xxl-8 col-xl-8 col-lg-8 col-md-8 col-sm-8">
<?php foreach ($data as $v ) { ?>
<a class='red' href="news_detaill?id=<?php echo $v['id']?>">
<div class="row NEWWOR">
<div class="col-md-9">
<h1><?php echo $v['heading']?></h1>
<?php
$ddd=$v['eemail'];
$pagal="SELECT * FROM `adminsignup` WHERE `Email_Address` ='$ddd'";
$dddd= mysqli_query($con,$pagal);
$db=mysqli_fetch_assoc($dddd);
?>
<span><I class="fa fa-calendar"></I> <?php echo $v['pdate']?> </span>
<span style="text-align:justify;"> <?php $desc=$v['text']; $StrCut=substr($desc,0,300); $desc =substr($StrCut,0,strrpos($StrCut,' '))."<a style='color: #007881;font-weight: 600;' class='red' href='news_detaill?id=$v[id]'> Read More...</a>";echo $desc; ?></span>
</div>
<div class="col-md-3">
<img style=" width: 100%; height: 200px;" src="admin/<?php echo $v['img']?>" alt="">
</div>
</div>
</a>
<?php }?>
</div>
<div class="col-md-2">
</div>
<div class="col-12 text-center" style=" margin-top: 0%; margin-bottom: 0%;">
<ul class="pagination justify-content-center">
<li class="page-item "><a class="page-link" href="?page=1">Previous</a></li>
<li class="page-item "><a class="page-link" href="<?php if($page <= 1) {echo "#";}else{echo "?page=".$page -1;}?>"><</a></li>
<?php
for($x = 1; $x <= $total_page; $x++){echo " <li class='page-item'><a class='page-link' href='?page=$x'>$x</a></li>";
}?>
<li class="page-item"><a class="page-link" href="<?php if($page == $total_page) {echo "#";}else{echo "?page=".$page +1;}?>">></a></li>
<li class="page-item"><a class="page-link" href="?page=<?php echo $total_page;?>" style="width: 150%;">Next</a></li>
</ul>
</div>
</div>
<script>
/* Demo purposes only */
document.querySelectorAll(".projcard-description").forEach(function(box) {
$clamp(box, {
clamp: 6
});
});
</script>
</body>
</html>
<?php
include_once('footer.php');
?>