<!doctype html>
<html lang="en">
<head>
<meta charset="UTF-8">
<meta name="viewport" content="width=device-width, initial-scale=1">
<meta http-equiv="X-UA-Compatible" content="ie=edge">
<title>Diabease</title>
<link rel="shortcut icon" href="../assets/images/diabease/DiabEaseLogo.png" />
<link rel="stylesheet" href="vendors/bundle.css" type="text/css">
<!-- Slick -->
<link rel="stylesheet" href="vendors/slick/slick.css" type="text/css">
<link rel="stylesheet" href="vendors/slick/slick-theme.css" type="text/css">
<!-- Daterangepicker -->
<link rel="stylesheet" href="vendors/datepicker/daterangepicker.css" type="text/css">
<!-- DataTable -->
<link rel="stylesheet" href="vendors/dataTable/datatables.min.css" type="text/css">
<!-- App styles -->
<link rel="stylesheet" href="assets/css/app.min.css" type="text/css">
</head>
<body class="">
<?php include('header.php')?>
<div class="content-body">
<div class="content">
<div class="row">
<div class="col-md-12">
<div class="row">
<div class="col-lg-3 col-md-12">
<div class="card">
<div class="card-body">
<div class="d-flex justify-content-between mb-3">
<div>
<p class="text-muted">Total Blogs</p>
<?php
// Include database connection
include 'connection.inc.php';
// Query to get the total count of blogs
$sql = "SELECT COUNT(*) AS total_blogs FROM blog";
$result = $con->query($sql);
if ($result->num_rows > 0) {
$row = $result->fetch_assoc();
// Display the total blog count
echo '<h2 class="font-weight-bold">' . $row['total_blogs'] . '</h2>';
} else {
echo '<h2 class="font-weight-bold">0</h2>';
}
?>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
<?php include('footer.php')?>
</div>
</div>
</div>
<!-- Plugin scripts -->
<script src="vendors/bundle.js"></script>
<!-- Apex chart -->
<script src="https://apexcharts.com/samples/assets/irregular-data-series.js"></script>
<script src="vendors/charts/apex/apexcharts.min.js"></script>
<!-- Daterangepicker -->
<script src="vendors/datepicker/daterangepicker.js"></script>
<!-- DataTable -->
<script src="vendors/dataTable/datatables.min.js"></script>
<!-- Dashboard scripts -->
<script src="assets/js/examples/dashboard.js"></script>
<!-- Vamp -->
<script src="vendors/vmap/jquery.vmap.min.js"></script>
<script src="vendors/vmap/maps/jquery.vmap.usa.js"></script>
<script src="assets/js/examples/vmap.js"></script>
<script src="assets/js/examples/pages/ecommerce-dashboard.js"></script>
<script src="assets/js/app.min.js"></script>
</body>
</html>