One Hat Cyber Team

Edit File: blog.php

<?php
// Database connection setup (change credentials as per your setup)
$servername = "localhost";
$username = "u322583024_diabease";
$password = "Diabease@2025";
$dbname = "u322583024_diabease";

$conn = new mysqli($servername, $username, $password, $dbname);

error_reporting(E_ALL);
ini_set('display_errors', 1);

// Check connection
if ($conn->connect_error) {
    die("Connection failed: " . $conn->connect_error);
}

// Fetch blog entries from database, backtick `desc` because it's a reserved word
$sql = "SELECT id, title, `desc`, img, added_on FROM blog ORDER BY added_on DESC";
$result = $conn->query($sql);

if(!$result){
    die("Error fetching blogs: " . $conn->error);
}
?>
<!DOCTYPE html>
<html lang="en-US">
<head>
    <meta charset="UTF-8" />
    <meta http-equiv="x-ua-compatible" content="ie=edge" />
    <title>DiabEase Sugar and Thyroid Clinic</title>
    <meta name="description" content="" />
    <meta name="viewport" content="width=device-width, initial-scale=1" />
    
    <link
      rel="icon"
      type="image/png"
      sizes="56x56"
      href="assets/images/diabease/DiabEaseLogo.png"
    />
    
    <link
      rel="stylesheet"
      href="assets/css/bootstrap.min.css"
      type="text/css"
      media="all"
    />

<link
      rel="stylesheet"
      href="assets/css/animate.css"
      type="text/css"
      media="all"
    />

<link
      rel="stylesheet"
      href="assets/css/all.min.css"
      type="text/css"
      media="all"
    />
    
    <link
      rel="stylesheet"
      href="assets/css/flaticon.css"
      type="text/css"
      media="all"
    />
    
    <link
      rel="stylesheet"
      href="assets/css/theme-default.css"
      type="text/css"
      media="all"
    />

<link
      rel="stylesheet"
      href="assets/css/meanmenu.min.css"
      type="text/css"
      media="all"
    />
    
    <link
      rel="stylesheet"
      href="venobox/venobox.css"
      type="text/css"
      media="all"
    />
    
    <link
      rel="stylesheet"
      href="assets/css/bootstrap-icons.css"
      type="text/css"
      media="all"
    />
    
    <link
      rel="stylesheet"
      href="assets/css/magnific-popup.css"
      type="text/css"
      media="all"
    />

<link
      rel="stylesheet"
      href="assets/css/owl.carousel.min.css"
      type="text/css"
      media="all"
    />

<link
      rel="stylesheet"
      href="assets/css/style.css"
      type="text/css"
      media="all"
    />
    <link rel="stylesheet" href="assets/css/odometer-theme-default.css" />
    
    <link rel="stylesheet" href="assets/css/aos.css" />
    <link
      rel="stylesheet"
      href="assets/css/responsive.css"
      type="text/css"
      media="all"
    />
    <link rel="stylesheet" href="assets/css/swiper-bundle.css" />
    
    <script src="assets/js/vendor/modernizr-3.5.0.min.js"></script>
     <style>
        .breadcumb-area {
    background: url(assets/images/diabease/banner/banner.png);
    padding: 150px 0 165px;
    background-repeat: no-repeat;
    background-size: cover;
}

.style-two .blog-thumb img:nth-child(1) {
    -webkit-transform: unset !important;
    transform: unset !important;
    opacity: unset !important;
    -webkit-filter: unset !important;
    filter: unset !important;
}
</style>
  </head>
  <body>
   <?php include 'header.php' ?>

<div class="breadcumb-area">
      <div class="container">
        <div class="row">
          <div class="col-lg-12">
            <div class="breadcumb-content">
              <h4>Blog</h4>
              <ul class="breadcumb-list">
                <li><a href="index.php">Home</a></li>
                <li class="list-arrow">/</li>
                <li>Blog</li>
              </ul>
            </div>
          </div>
        </div>
      </div>
    </div>

<div class="blog-area style-two">
  <div class="container">
    <div class="row">
      <div class="col-lg-12 text-center">
        <div class="section-title text-center">
          <div class="section-sub-title">
            <h5>OUR NEWS</h5>
          </div>
          <div class="section-main-title">
            <h1>Latest News & Articles!</h1>
          </div>
        </div>
      </div>
    </div>
  <div class="row">
<?php 
if ($result->num_rows > 0) {
    while($row = $result->fetch_assoc()) {
        // Format date
        $date = date("F d, Y", strtotime($row['added_on']));
        ?>
        <div class="col-xl-3 col-lg-4 col-md-6">
            <div class="single-blog-box">
               <div class="blog-thumb">
    <img src="admin/assets/images/blog/<?php echo htmlspecialchars($row['img']); ?>" alt="<?php echo htmlspecialchars($row['title']); ?>" />
</div>
                <div class="blog-content">
                    <div class="blog-meta">
                        <a href="#"><?php echo $date; ?></a>
                       
                    </div>
                    <h3>
                        <a href="blog-details.php?id=<?php echo $row['id']; ?>"><?php echo htmlspecialchars($row['title']); ?></a>
                    </h3>
                    <p><?php echo htmlspecialchars(substr($row['desc'], 0, 100)) . '...'; ?></p> 
                </div>
            </div>
        </div>
<?php
    }
} else {
    echo "<p>No blogs found.</p>";
}
$conn->close();
?>
</div>
  </div>
</div>

<?php include 'footer.php' ?>