in this codes (<?php
// includes/header.php

// Start session and include database connection
session_start();
require_once __DIR__ . '/../db_connect.php'; // Adjust the path as per directory structure

// Check if the admin is logged in
if (!isset($_SESSION['admin_id'])) {
    header("Location: ../admin_login.php");
    exit();
}

// Fetch new comments count
$new_comments_query = "
    SELECT COUNT(*) AS new_comments_count
    FROM comments c
    WHERE c.parent_id IS NULL 
      AND c.sender = 'patient' 
      AND NOT EXISTS (
          SELECT 1 FROM comments r 
          WHERE r.parent_id = c.id 
            AND r.sender = 'admin'
      )
";
$stmt = $pdo->query($new_comments_query);
$new_comments_count = $stmt->fetchColumn();
?>
<!DOCTYPE html>
<html lang="en">
<head>
    <!-- Required meta tags -->
    <meta charset="UTF-8">
    <meta name="viewport" content="width=device-width, initial-scale=1.0">
    <title>Longevacare Admin Dashboard</title>

    <!-- Bootstrap CSS -->
    <link rel="stylesheet" href="https://stackpath.bootstrapcdn.com/bootstrap/4.5.2/css/bootstrap.min.css">
    <!-- FontAwesome for Icons -->
    <link rel="stylesheet" href="https://cdnjs.cloudflare.com/ajax/libs/font-awesome/5.15.4/css/all.min.css">
    <!-- Custom CSS -->
    <link rel="stylesheet" href="../css/custom.css"> <!-- Optional -->

    <!-- Inline Custom Styles -->
    <style>
        /* Root Variables for Colors */
        :root {
            --primary-color: #4F3F02; /* Dark Brown */
            --secondary-color: #D1C287; /* Light Golden */
            --background-color: #f8f9fa; /* Light Grey */
            --text-color: #000000; /* Black */
            --navbar-height: 60px;
        }

        /* Body Styling */
        body {
            font-family: 'Segoe UI', Tahoma, Geneva, Verdana, sans-serif;
            background-color: var(--background-color);
            color: var(--text-color);
            margin: 0;
            padding: 0;
        }

        /* Top Bar Styling */
        .top-bar {
            background-color: var(--primary-color);
            padding: 5px 0;
            font-size: 0.9rem;
            color: #ffffff;
            transition: background-color 0.3s ease;
        }

        .top-bar a {
            color: var(--secondary-color);
            margin-right: 15px;
            transition: color 0.3s ease;
        }

        .top-bar a:hover {
            color: #ffffff;
            text-decoration: none;
        }

        /* Navbar Styling */
        .navbar-custom {
            background-color: var(--primary-color);
            padding: 0.5rem 1rem;
            transition: background-color 0.3s ease;
            box-shadow: 0 2px 10px rgba(0,0,0,0.1);
        }

        .navbar-custom .navbar-brand {
            color: #ffffff;
            font-weight: bold;
            font-size: 1.5rem;
            transition: transform 0.3s ease;
        }

        .navbar-custom .navbar-brand img {
            max-height: 40px;
            margin-right: 10px;
            transition: transform 0.3s ease;
        }

        .navbar-custom .navbar-brand:hover img {
            transform: scale(1.05);
        }

        .navbar-custom .nav-link {
            color: var(--secondary-color) !important;
            font-weight: 500;
            margin-right: 15px;
            transition: all 0.3s ease;
            position: relative;
        }

        .navbar-custom .nav-link:hover, .navbar-custom .nav-link:focus {
            color: #ffffff !important;
            background-color: rgba(209, 194, 135, 0.1); /* Semi-transparent gold */
            border-radius: 5px;
            text-decoration: none;
        }

        /* Badge Positioning */
        .badge-position {
            position: absolute;
            top: -5px;
            right: -10px;
            transform: translate(50%, -50%);
            font-size: 0.75rem;
            padding: 0.25em 0.4em;
        }

        /* Search Form Styling */
        .search-form {
            position: relative;
            margin-left: auto;
            margin-right: 15px;
        }

        .search-form .form-control {
            background-color: rgba(255,255,255,0.1);
            border: none;
            color: #ffffff;
            padding-left: 2.5rem;
            border-radius: 20px;
            transition: background-color 0.3s ease, color 0.3s ease;
        }

        .search-form .form-control::placeholder {
            color: rgba(255,255,255,0.7);
            transition: color 0.3s ease;
        }

        .search-form .fa-search {
            position: absolute;
            top: 50%;
            left: 1rem;
            transform: translateY(-50%);
            color: var(--secondary-color);
        }

        .search-form .form-control:focus {
            background-color: rgba(255,255,255,0.2);
            color: #ffffff;
            outline: none;
        }

        /* Primary Button Styling */
        .btn-primary {
            background-color: var(--secondary-color);
            border-color: var(--secondary-color);
            color: var(--primary-color);
            font-weight: bold;
            transition: all 0.3s ease;
        }

        .btn-primary:hover {
            background-color: #c0b176; /* Slightly darker gold */
            border-color: #c0b176;
            color: var(--primary-color);
        }

        /* Responsive Adjustments */
        @media (max-width: 992px) {
            .navbar-custom .nav-link {
                margin-right: 0;
                padding: 0.5rem 1rem;
            }

            .search-form {
                margin: 1rem 0;
            }
        }

        @media (max-width: 576px) {
            .navbar-custom .navbar-brand {
                font-size: 1.2rem;
            }

            .search-form {
                width: 100%;
                margin-right: 0;
            }

            .search-form .form-control {
                width: 100%;
                padding-left: 2.5rem;
            }
        }
    </style>
</head>
<body>

<!-- Top Bar -->
<div class="top-bar">
    <div class="container">
        <div class="d-flex justify-content-between">
            <div>
                <a href="../admin_profile.php"><i class="fas fa-user-circle"></i> Profile</a>
                <a href="../admin_settings.php"><i class="fas fa-cog"></i> Settings</a>
            </div>
            <div>
                <a href="../admin_logout.php"><i class="fas fa-sign-out-alt"></i> Logout</a>
            </div>
        </div>
    </div>
</div>

<!-- Main Navigation -->
<nav class="navbar navbar-expand-lg navbar-custom">
    <div class="container">
        <!-- Navbar Brand with Logo -->
        <a class="navbar-brand d-flex align-items-center" href="../admin_dashboard.php">
            <img src="../images/white-logo.png" alt="Longevacare Logo">
            Longevacare Admin
        </a>
        <!-- Navbar Toggler for Mobile View -->
        <button class="navbar-toggler" type="button" data-toggle="collapse" data-target="#navbarNavDropdown" 
            aria-controls="navbarNavDropdown" aria-expanded="false" aria-label="Toggle navigation">
            <!-- FontAwesome Hamburger Icon -->
            <span class="navbar-toggler-icon"><i class="fas fa-bars"></i></span>
        </button>
        <!-- Navbar Links -->
        <div class="collapse navbar-collapse" id="navbarNavDropdown">
            <ul class="navbar-nav mr-auto">
                <!-- Dropdown for Patient Management -->
                <li class="nav-item dropdown">
                    <a class="nav-link dropdown-toggle" href="#" id="patientDropdown" role="button" data-toggle="dropdown" aria-haspopup="true" aria-expanded="false">
                        Patient
                    </a>
                    <div class="dropdown-menu" aria-labelledby="patientDropdown">
                        <a class="dropdown-item" href="../create_patient.php">Create Patient</a>
                        <a class="dropdown-item" href="../invoice/">Invoices</a>
                        <a class="dropdown-item" href="../prescription/view_prescriptions.php">Prescriptions</a>
                    </div>
                </li>
                <li class="nav-item">
                    <a href="../admin_report.php" class="nav-link">Reports</a>
                </li>
                <li class="nav-item position-relative">
                    <a href="../manage_comments.php" class="nav-link">
                        Comments
                        <?php if ($new_comments_count > 0): ?>
                            <span class="badge badge-danger badge-position">
                                <?= htmlspecialchars($new_comments_count) ?>
                            </span>
                        <?php endif; ?>
                    </a>
                </li>
                <li class="nav-item">
                    <a href="../doctor_patient.php" class="nav-link">Doctor-Patient</a>
                </li>
            </ul>
            <!-- Search Form -->
            <form class="form-inline my-2 my-lg-0 search-form">
                <i class="fas fa-search"></i>
                <input class="form-control" type="search" placeholder="Search" aria-label="Search">
            </form>
        </div>
    </div>
</nav>) remove Longevacare Admin text and make it cool design and add welcome user in the top row and type full codes