One Hat Cyber Team

Edit File: blog.php

<!DOCTYPE html>




<html lang="en">

<head>
    <meta charset="utf-8" />
    <title>Blog Categories</title>
    <meta content="width=device-width, initial-scale=1.0" name="viewport" />
    <meta name="description" content="Horoscope" />
    <meta name="keywords" content="Horoscope" />
    <meta name="author" content="" />
    <meta name="MobileOptimized" content="320" />
    
    <link rel="stylesheet" type="text/css" href="css/animate.css" />
    <link rel="stylesheet" type="text/css" href="css/bootstrap.css" />
    <link rel="stylesheet" type="text/css" href="css/font-awesome.css" />
    <link rel="stylesheet" type="text/css" href="css/fonts.css" />
    <link rel="stylesheet" type="text/css" href="css/flaticon.css" />
    <link rel="stylesheet" type="text/css" href="css/owl.carousel.css" />
    <link rel="stylesheet" type="text/css" href="css/owl.theme.default.css" />
    <link rel="stylesheet" type="text/css" href="css/magnific-popup.css" />
    <link rel="stylesheet" type="text/css" href="css/reset.css" />
    <link rel="stylesheet" type="text/css" href="css/style2.css" />
    <link rel="stylesheet" type="text/css" href="css/responsive.css" />
    
    <link rel="shortcut icon" type="image/png" href="images/header/favicon.ico" />
</head>

<body>
    
     <style>
 /* General styles */
.hs_blog_categories_main_wrapper {
    padding: 40px 0;
    background-color: #f9f9f9;
}

.container {
    max-width: 1200px;
    margin: 0 auto;
    padding: 0 15px;
}

.dsn-posts {
    display: grid;
    grid-template-columns: repeat(auto-fit, minmax(300px, 1fr));
    gap: 20px;
    justify-content: center;
}

.blog-item {
    background: #fff;
    border-radius: 10px;
    overflow: hidden;
    box-shadow: 0 4px 10px rgba(0, 0, 0, 0.1);
    transition: transform 0.3s ease;
}

.blog-item:hover {
    transform: translateY(-5px);
}

.box-meta {
    padding: 15px;
    font-size: 14px;
    color: #555;
    background: #f0f0f0;
    text-align: center;
}

.box-img img {
    width: 100%;
    height: 200px;
    object-fit: cover;
    display: block;
}

.box-content {
    padding: 20px;
    text-align: center;
}

.title-block {
    font-size: 20px;
    font-weight: bold;
    color: #333;
    margin-bottom: 10px;
}

.link-vist {
    display: inline-block;
    color: #007bff;
    text-decoration: none;
    font-size: 14px;
    margin-top: 10px;
    transition: color 0.3s;
}

.link-vist:hover {
    color: #0056b3;
}

/* Pagination */
.pagination {
    display: flex;
    justify-content: center;
    margin-top: 20px;
}

.pagination .page-item {
    margin: 0 5px;
}

.pagination .page-link {
    padding: 10px 15px;
    border: 1px solid #ddd;
    border-radius: 5px;
    color: #333;
    text-decoration: none;
}

.pagination .page-item.active .page-link {
    background: #007bff;
    color: #fff;
    border-color: #007bff;
}

.pagination .page-link:hover {
    background: #0056b3;
    color: #fff;
}

/* Responsive Design */
@media (max-width: 768px) {
    .dsn-posts {
        grid-template-columns: repeat(auto-fit, minmax(100%, 1fr));
    }

.box-content {
        padding: 15px;
    }

.title-block {
        font-size: 18px;
    }

.box-img img {
        height: 180px;
    }
}

@media (max-width: 480px) {
    .box-meta {
        font-size: 12px;
    }

.box-img img {
        height: 150px;
    }

.pagination .page-link {
        padding: 8px 12px;
        font-size: 12px;
    }
}

</style>

<?php

include 'header.php';

?>

<div class="hs_indx_title_main_wrapper">
        <div class="hs_title_img_overlay"></div>
        <div class="container">
            <div class="row">
                <div class="col-lg-12 col-md-12 col-sm-12 col-xs-12 full_width">
                    <div class="hs_indx_title_left_wrapper">
                        <h2>Blog</h2>
                    </div>
                </div>
                <div class="col-lg-12 col-md-12 col-sm-12 col-xs-12  full_width">
                   
                </div>
            </div>
        </div>
    </div>
    
    
    <div class="hs_blog_categories_main_wrapper">
       <div class="wrapper">
    <div class="root-blog section-margin">
        <div class="container">
        <?php
ini_set('display_errors', 1);
ini_set('display_startup_errors', 1);
error_reporting(E_ALL);

$servername = "localhost";
$username = "u322583024_pkpanda";
$password = "PKpandit@2025";
$dbname = "u322583024_pkpanda";

// Establish database connection
$conn = new mysqli($servername, $username, $password, $dbname);
if ($conn->connect_error) {
    die("Connection failed: " . $conn->connect_error);
}

$limit = 6;
$page = isset($_GET['page']) ? (int)$_GET['page'] : 1;
$start = ($page - 1) * $limit;

// Fetch total records securely
$stmt = $conn->prepare("SELECT COUNT(id) AS total FROM blog WHERE deleted_at IS NULL");
$stmt->execute();
$result = $stmt->get_result();
$total_rows = $result->fetch_assoc()['total'];
$total_pages = ceil($total_rows / $limit);
$stmt->close();

// Fetch paginated blog data securely
$stmt = $conn->prepare("SELECT * FROM blog WHERE deleted_at IS NULL ORDER BY id DESC LIMIT ?, ?");
$stmt->bind_param("ii", $start, $limit);
$stmt->execute();
$blogs = $stmt->get_result();
$stmt->close();
?>

<div class="hs_blog_categories_main_wrapper">
    <div class="wrapper">
        <div class="root-blog section-margin">
            <div class="container">
                <div class="dsn-posts d-grid grid-lg-3 grid-sm-2 our-blog our-blog-classic our-blog-full-img">
                    <?php if ($blogs->num_rows > 0) { ?>
                        <?php while ($row = $blogs->fetch_assoc()) { 
                            $formatted_date = date("M d, Y", strtotime($row['created_at']));
                            $url_slug = htmlspecialchars(str_replace(' ', '-', strtolower($row['url_name'])));
                        ?>
                        <div class="blog-item p-relative d-flex align-items-center h-100 w-100" data-swiper-parallax-scale="0.85">
                            <div class="box-meta">
                                <div class="entry-date">
                                    <a href="blog-details.php/<?php echo $url_slug; ?>" class="effect-ajax">
                                        <?php echo $formatted_date; ?>
                                    </a>
                                </div>
                            </div>
                            <div class="box-img over-hidden">
                           <img class="cover-bg-img" src="admin/<?php echo htmlspecialchars($row['image']); ?>" alt="">

</div>
                            <div class="box-content p-relative">
                                <div class="box-content-body">
                                    <h4 class="title-block mb-20">
                                        <a href="blog-details.php/<?php echo $url_slug; ?>" class="effect-ajax">
                                            <?php echo htmlspecialchars($row['blog_name']); ?>
                                        </a>
                                    </h4>
                                    <a href="blog-details.php/<?php echo $url_slug; ?>" class="effect-ajax link-vist p-relative mt-20">
                                        <span class="link-vist-text">Read More</span>
                                        
                                        
                                        
                                        
                                        
                                        
                                    </a>
                                </div>
                            </div>
                        </div>
                        <?php } ?>
                    <?php } else { ?>
                        <p>No blogs found.</p>
                    <?php } ?>
                </div>
                
                
                <div class="pagination-area">
                    <div aria-label="Page navigation example">
                        <ul class="pagination">
                            <?php if ($page > 1) { ?>
                                <li class="page-item"><a class="page-link" href="?page=1">First</a></li>
                                <li class="page-item">
                                    <a class="page-link" href="?page=<?php echo ($page - 1); ?>" aria-label="Previous">
                                        <span aria-hidden="true"><i class="fas fa-angle-double-left"></i></span>
                                    </a>
                                </li>
                            <?php } ?>

<?php for ($i = max(1, $page - 2); $i <= min($total_pages, $page + 2); $i++) { ?>
                                <li class="page-item <?php echo ($i == $page) ? 'active' : ''; ?>">
                                    <a class="page-link" href="?page=<?php echo $i; ?>"><?php echo $i; ?></a>
                                </li>
                            <?php } ?>

<?php if ($page < $total_pages) { ?>
                                <li class="page-item">
                                    <a class="page-link" href="?page=<?php echo ($page + 1); ?>" aria-label="Next">
                                        <span aria-hidden="true"><i class="fas fa-angle-double-right"></i></span>
                                    </a>
                                </li>
                                <li class="page-item"><a class="page-link" href="?page=<?php echo $total_pages; ?>">Last</a></li>
                            <?php } ?>
                        </ul>
                    </div>
                </div>
            </div>
        </div>
    </div>
</div>

<?php $conn->close(); ?>
</div>
</div>
</div>
</div>
    
    
    <?php
include 'footer.php';

?>
    <script src="https://cdn.jsdelivr.net/npm/bootstrap@5.3.0/dist/js/bootstrap.bundle.min.js"></script>
    <script src="js/jquery_min.js"></script>
    <script src="js/bootstrap.js"></script>
    <script src="js/modernizr.js"></script>
    <script src="js/jquery.menu-aim.js"></script>
    <script src="js/parallax.min.js"></script>
	<script src="js/owl.carousel.js"></script>
	
    <script src="js/datepicker.js"></script>
    <script src="js/jquery.shuffle.min.js"></script>
    <script src="js/jquery.countTo.js"></script>
    <script src="js/jquery.inview.min.js"></script>
    <script src="js/jquery.magnific-popup.js"></script>
    <script src="js/custom.js"></script>
    
</body>

</html>