ikan Uploader :
Directory : /home/u956822991/domains/kalamasserylocalnews.com/public_html/
Upload File : |
| Current File : /home/u956822991/domains/kalamasserylocalnews.com/public_html/news(1).php |
<?php
error_reporting(0);
include('includes/config.php');
date_default_timezone_set('Asia/Kolkata'); // change according to the timezone
$date = date("d-m-Y");
?>
<!DOCTYPE html>
<html>
<head>
<title>News-Kalamassery Local News</title>
<!-- metas -->
<meta charset="utf-8">
<meta name="author" content="http://themeforest.net/user/CreativeWS/portfolio">
<meta name="keywords" content="">
<meta name="description" content="">
<meta name="viewport" content="width=device-width, initial-scale=1.0, minimum-scale=1.0">
<link rel="shortcut icon" href="img/favicon.png">
<!--/ metas -->
<!-- styles -->
<link rel="stylesheet" href="css/animate.css">
<link rel="stylesheet" href="css/font-awesome.css">
<link rel="stylesheet" href="css/jquery.fancybox.css">
<link rel="stylesheet" href="css/jquery.owl.carousel.css">
<link rel="stylesheet" href="js/layerslider/css/layerslider.css">
<link rel="stylesheet" href="js/layerslider/css/layerslider1.css">
<link rel="stylesheet" href="css/main.css">
<link rel="stylesheet" href="tuner/css/main.css">
<link rel="stylesheet" href="tuner/css/colorpicker.css">
<!--/ styles -->
<!-- modernizr -->
<script src="js/modernizr.js"></script>
<!--/modernizr -->
<!-- Google tag (gtag.js) -->
<script async src="https://www.googletagmanager.com/gtag/js?id=G-ELEB7ZPDKB"></script>
<script>
window.dataLayer = window.dataLayer || [];
function gtag() {
dataLayer.push(arguments);
}
gtag('js', new Date());
gtag('config', 'G-ELEB7ZPDKB');
</script>
<style>
.btn-text-left {
text-align: left;
}
.btn-text-right {
text-align: right;
}
</style>
<style>
.button {
border: none;
color: white;
padding: 0px 27px;
text-align: center;
text-decoration: none;
display: inline-block;
font-size: 16px;
margin: 4px 35px;
cursor: pointer;
}
.button1 {
background-color: #B3361B;
}
</style>
<style>
.whats-app {
position: fixed;
width: 50px;
height: 50px;
bottom: 10px;
background-color: #25d366;
color: #FFF;
border-radius: 30px;
text-align: center;
font-size: 20px;
box-shadow: 3px 4px 3px #999;
left: 35px;
z-index: 100;
}
.my-float {
margin-top: 10px;
}
</style>
<style>
/* CSS for the fixed position slideshow */
.slideshow-wrap {
position: fixed;
top: 40px;
left: 16px;
right: 16px;
z-index: 1000; /* Adjust the z-index as needed */
}
.slideshow {
height: 50px;
}
.ls-slide {
transition: none !important;
}
/* Content area below the slideshow */
.content-below-slideshow {
margin-top: 100px; /* Adjust this margin to match the slideshow height */
padding-top: 20px; /* Add padding to separate content from the slideshow */
}
/* Style for the active page number */
.pagination a.active,
.pagination span.current-page {
background-color: #B3361B; /* Change to your desired highlight color */
color: white; /* Change to your desired text color */
padding: 5px 10px;
border-radius: 5px;
}
.pagination span.current-page {
font-weight: bold; /* Optionally, make the current page number bold */
}
</style>
</head>
<body>
<div class="page">
<!-- page header top -->
<?php include('header.php'); ?>
<script async src="https://pagead2.googlesyndication.com/pagead/js/adsbygoogle.js?client=ca-pub-1903888166252177" crossorigin="anonymous"></script>
<!--/ page header top -->
<!-- page content -->
<!--<div class="page-content">-->
<div class="grid-row">
<div class="grid-col grid-col-8">
<?php include('smallslider.php'); ?>
<!-- blog -->
<!-- item 1 -->
<div class="content-below-slideshow">
<?php
// Step 1: Define the number of articles per page and the current page number
$articlesPerPage = 15;
$page = isset($_GET['page']) ? $_GET['page'] : 1; // Get the current page number from the URL
// Calculate the offset for the SQL query
$offset = ($page - 1) * $articlesPerPage;
// Step 2: Modify your database query
$ret = mysqli_query($con, "SELECT * FROM contentnews WHERE timestamp >= NOW() - INTERVAL 5 DAY ORDER BY id DESC LIMIT $articlesPerPage OFFSET $offset");
$num = mysqli_num_rows($ret);
// Step 4: Count the total number of articles
$totalArticles = mysqli_query($con, "SELECT COUNT(*) FROM contentnews");
$totalArticlesCount = mysqli_fetch_row($totalArticles)[0];
// Calculate the total number of pages
$totalPages = ceil($totalArticlesCount / $articlesPerPage);
if ($num > 0) {
while ($row = mysqli_fetch_array($ret)) {
// Step 2: Display the articles
// Convert the database date to the desired format
$postingDate = strtotime($row['postingDate']);
$formattedDate = date('l, F j, Y', $postingDate);
?>
<div class="item item-fashion item-photography item-travel isotope-item">
<div class="clearfix">
<!--<a href="news-details.php?pid=<?php echo htmlentities($row['id']); ?>">-->
<div class="picture">
<img src="admin/newscontent/<?php echo htmlentities($row['postingDate']); ?>/<?php echo htmlentities($row['image1']); ?>" alt="">
</div>
<!--</a>-->
<b>
<!--<p>-->
<!-- <i class="fa fa-calendar"> </i><?php echo $formattedDate; ?> -->
<!-- <i class="fa fa-user"><a href="index.php"> Reporter</a></i>-->
<!--</p>-->
</b>
<br>
<h1 style="font-size: 18px; color: blue !important;"><b><a href="news-details.php?pid=<?php echo htmlentities($row['id']); ?>"><?php echo html_entity_decode($row['headlines']); ?></a></b></h1>
</div>
</div>
<!--<p style="text-align: center; margin: 10px 0;"><a href="news-detail.php?pid=<?php echo htmlentities($row['id']); ?>" style="display: inline-block; padding: 10px 20px; background-color: black; color: white; text-decoration: none; border-radius: 5px;">Read news</a></p>-->
<br>
<?php
}
}
?>
</div>
<!--/item 1 -->
<!-- author-info -->
<script async src="https://pagead2.googlesyndication.com/pagead/js/adsbygoogle.js?client=ca-pub-1903888166252177" crossorigin="anonymous"></script>
<!-- slideshow -->
<!--/ slideshow -->
<br><br><br>
<!--/author-info -->
<script async src="https://pagead2.googlesyndication.com/pagead/js/adsbygoogle.js?client=ca-pub-1903888166252177" crossorigin="anonymous"></script>
</div>
<!--/blog -->
</div>
</div>
</div>
</div>
<!--</div>-->
<!--/ page content -->
<?php include('footer.php'); ?>
<a href="" id="scroll-top" class="scroll-top"><i class="fa fa-angle-up"></i></a>
<!-- open or close menu -->
<div id="open_or_close_menu"></div>
</div>
<!-- scripts -->
<!--[if lt IE 9]><script src="js/html5shiv.js"></script><![endif]-->
<script src="js/jquery.min.js"></script>
<script src="js/jquery-ui.min.js"></script>
<script src="js/jquery.migrate.min.js"></script>
<script src="js/jquery.isotope.min.js"></script>
<script src="js/jquery.form.min.js"></script>
<script src="js/jquery.validate.min.js"></script>
<script src="js/jquery.tweet.js"></script>
<script src="js/jquery.countdown.min.js"></script>
<script src="js/jquery.fancybox.pack.js"></script>
<script src="js/jquery.fancybox-media.js"></script>
<script src="js/jquery.ui.core.min.js"></script>
<script src="js/jquery.ui.widget.min.js"></script>
<script src="js/jquery.ui.mouse.min.js"></script>
<script src="js/jquery.ui.slider.min.js"></script>
<script src="js/jquery.owl.carousel.min.js"></script>
<script src="js/layerslider/js/greensock.js"></script>
<script src="js/layerslider/js/layerslider.transitions.js"></script>
<script src="js/layerslider/js/layerslider.kreaturamedia.jquery.js"></script>
<script src="js/retina.min.js"></script>
<script src="js/wow.min.js"></script>
<script src="js/main.js"></script>
<!--/ scripts -->
<!-- tuner -->
<script src="tuner/js/main.js"></script>
<script src="tuner/js/colorpicker.js"></script>
<script type="text/javascript">
var today = new Date();
var dd = today.getDate();
var mm = today.getMonth() + 1; //January is 0!
var yyyy = today.getFullYear();
if (dd < 10) {
dd = '0' + dd;
}
if (mm < 10) {
mm = '0' + mm;
}
today = yyyy + '-' + mm + '-' + dd;
document.getElementById("datepicker").setAttribute("max", today);
</script>
</body>
</html>
........