this patient dashbaord php (<?php
session_start();
require_once '../db_connect.php';

if (!isset($_SESSION['patient_id'])) {
    header("Location: patient_login.php");
    exit();
}

$patient_id = $_SESSION['patient_id'];

// Fetch patient information
$stmt = $pdo->prepare("SELECT * FROM patients WHERE id = ?");
$stmt->execute([$patient_id]);
$patient = $stmt->fetch();

if (!$patient) {
    header("Location: patient_login.php");
    exit();
}

// Fetch health records
$stmt = $pdo->prepare("SELECT * FROM health_records WHERE patient_id = ? ORDER BY record_date DESC");
$stmt->execute([$patient_id]);
$health_records = $stmt->fetchAll();
?>
<!DOCTYPE html>
<html lang="en">
<head>
    <meta charset="UTF-8">
    <meta name="viewport" content="width=device-width, initial-scale=1.0">
    <title>Patient Dashboard</title>
    <link rel="stylesheet" href="https://stackpath.bootstrapcdn.com/bootstrap/4.5.2/css/bootstrap.min.css">
    <style>
        @import url('https://fonts.googleapis.com/css2?family=Roboto:wght@300;400;700&display=swap');

        :root {
            --primary-color: #4F3F02;
            --secondary-color: #D1C287;
            --background-color: #f9f9f9;
            --text-color: #333;
        }

        body {
            font-family: 'Roboto', sans-serif;
            line-height: 1.6;
            background-color: var(--background-color);
            color: var(--text-color);
            margin: 0;
            padding: 0;
        }

        .container {
            max-width: 900px;
            margin: 40px auto;
            padding: 20px;
            background-color: white;
            border-radius: 20px;
            box-shadow: 0 15px 30px rgba(0, 0, 0, 0.1);
        }

        .header {
            background: linear-gradient(135deg, var(--primary-color) 0%, var(--secondary-color) 100%);
            color: white;
            padding: 20px;
            text-align: center;
            border-radius: 20px 20px 0 0;
        }

        .header h2 {
            margin: 0;
            font-size: 32px;
            font-weight: 700;
        }

        .section {
            margin-top: 20px;
            padding: 20px;
            background-color: var(--background-color);
            border-radius: 10px;
            box-shadow: 0 4px 6px rgba(0, 0, 0, 0.05);
        }

        .section h3 {
            font-size: 24px;
            margin-top: 0;
            color: var(--primary-color);
            border-bottom: 2px solid var(--secondary-color);
            padding-bottom: 10px;
        }

        .info-item {
            display: flex;
            justify-content: space-between;
            padding: 10px 0;
            border-bottom: 1px solid #e0e0e0;
        }

        .table-responsive {
            margin-top: 20px;
        }

        th, td {
            vertical-align: middle !important;
        }

        .actions {
            display: flex;
            justify-content: center;
            gap: 10px;
            margin-top: 20px;
        }

        .actions a {
            background-color: var(--primary-color);
            color: white;
            padding: 10px 15px;
            text-decoration: none;
            border-radius: 30px;
            font-weight: 700;
            transition: background-color 0.3s ease;
        }

        .actions a:hover {
            background-color: var(--secondary-color);
            box-shadow: 0 4px 8px rgba(0, 0, 0, 0.1);
        }

        @media (max-width: 600px) {
            .info-item {
                flex-direction: column;
                align-items: flex-start;
            }
        }
    </style>
</head>
<body>

<div class="container">
    <div class="header">
        <h2>Welcome, <?= htmlspecialchars($patient['name']) ?></h2>
    </div>

    <div class="section">
        <h3>Your Personal Information</h3>
        <div class="info-item">
            <span>Patient ID:</span> <span><?= $patient['id'] ?></span>
        </div>
        <div class="info-item">
            <span>Age:</span> <span><?= $patient['age'] ?></span>
        </div>
        <div class="info-item">
            <span>Gender:</span> <span><?= $patient['gender'] ?></span>
        </div>
        <div class="info-item">
            <span>Phone:</span> <span><?= htmlspecialchars($patient['phone']) ?></span>
        </div>
        <div class="info-item">
            <span>Email:</span> <span><?= htmlspecialchars($patient['email']) ?></span>
        </div>
        <div class="info-item">
            <span>Medical History:</span> <span><?= nl2br(htmlspecialchars($patient['medical_history'])) ?></span>
        </div>
        <div class="info-item">
            <span>Date of Birth:</span> <span><?= $patient['date_of_birth'] ?></span>
        </div>
        <div class="info-item">
            <span>Registration Date:</span> <span><?= $patient['registration_date'] ?></span>
        </div>
        <div class="info-item">
            <span>Status:</span> <span><?= htmlspecialchars($patient['status']) ?></span>
        </div>
    </div>

    <div class="section">
        <h3>Your Health Records</h3>
        <div class="table-responsive">
            <table class="table table-striped">
                <thead>
                    <tr>
                        <th>Date</th>
                        <th>Blood Pressure</th>
                        <th>Weight</th>
                        <th>BMI</th>
                        <th>Cholesterol</th>
                        <th>Prescription</th>
                        <th>Treatment Progress</th>
                    </tr>
                </thead>
                <tbody>
                    <?php foreach ($health_records as $record): ?>
                    <tr>
                        <td><?= $record['record_date'] ?></td>
                        <td><?= htmlspecialchars($record['blood_pressure']) ?></td>
                        <td><?= $record['weight'] ?></td>
                        <td><?= $record['bmi'] ?></td>
                        <td><?= $record['cholesterol'] ?></td>
                        <td><?= nl2br(htmlspecialchars($record['prescription'])) ?></td>
                        <td><?= nl2br(htmlspecialchars($record['treatment_progress'])) ?></td>
                    </tr>
                    <?php endforeach; ?>
                </tbody>
            </table>
        </div>
    </div>

    <div class="actions">
        <a href="patient_logout.php" class="btn btn-primary">Logout</a>
    </div>
</div>

</body>
</html>
) i want to make cool and add more features  and make it cool design too and make it so amazing and don;t change the style and add more things and features in use this database (1. Database Structure
The database for the admin dashboard and patient management system consists of the following tables:
a. patients
id (INT, AUTO_INCREMENT, PRIMARY KEY): Unique identifier for each patient.
name (VARCHAR): Full name of the patient.
age (INT): Age of the patient.
gender (ENUM('Male', 'Female', 'Other')): Gender of the patient.
phone (VARCHAR): Phone number of the patient.
email (VARCHAR): Email address of the patient.
medical_history (TEXT): Medical history of the patient.
date_of_birth (DATE): Date of birth of the patient.
registration_date (DATE): Date when the patient was registered.
registration_datetime (DATETIME): Date and time when the patient was registered.
status (ENUM): Current status of the patient (e.g., 'Initial Consultation', 'Treatment in Progress', etc.).
b. health_records
id (INT, AUTO_INCREMENT, PRIMARY KEY): Unique identifier for each health record.
patient_id (INT, FOREIGN KEY referencing patients.id): ID of the patient associated with this health record.
blood_pressure (VARCHAR): Blood pressure reading.
weight (DECIMAL): Weight of the patient.
bmi (DECIMAL): Body Mass Index of the patient.
cholesterol (DECIMAL): Cholesterol level of the patient.
prescription (TEXT): Prescriptions given to the patient.
treatment_progress (TEXT): Notes on the treatment progress.
record_date (DATE): Date of the health record.
c. admins
id (INT, AUTO_INCREMENT, PRIMARY KEY): Unique identifier for each admin.
username (VARCHAR): Admin's username.
password (VARCHAR): Hashed password for the admin.
email (VARCHAR): Email address of the admin.
d. patient_logins
id (INT, AUTO_INCREMENT, PRIMARY KEY): Unique identifier for each patient login.
patient_id (INT, FOREIGN KEY referencing patients.id): ID of the patient associated with this login.
username (VARCHAR): Username for patient login.
password (VARCHAR): Hashed password for patient login.
e. invoices
id (INT, AUTO_INCREMENT, PRIMARY KEY): Unique identifier for each invoice.
patient_id (INT NOT NULL, FOREIGN KEY referencing patients.id): ID of the patient associated with this invoice.
service_name (VARCHAR(255) NOT NULL): Name of the service rendered.
service_description (TEXT): Description of the service.
cost (DECIMAL(10, 2) NOT NULL): Cost of the service.
tax_rate (DECIMAL(5, 2) DEFAULT 0): Tax rate applied to the service.
discount (DECIMAL(5, 2) DEFAULT 0): Discount applied to the service.
total_amount (DECIMAL(10, 2) NOT NULL): Total amount due after tax and discount.
invoice_date (DATE DEFAULT CURRENT_DATE): Date of the invoice.
notes (TEXT): Additional notes for the invoice.
Tax decimal(5,2)
f. services
service_id (INT, AUTO_INCREMENT, PRIMARY KEY): Unique identifier for each service.
service_name (VARCHAR(255) NOT NULL): Name of the service.
service_price (DECIMAL(10, 2) NOT NULL): Price of the service.
service_description (TEXT): Description of the service.
created_at (TIMESTAMP DEFAULT CURRENT_TIMESTAMP): Timestamp when the service was created.
updated_at (TIMESTAMP DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP): Timestamp when the service was last updated.
g. invoice_services
id (INT, AUTO_INCREMENT, PRIMARY KEY): Unique identifier for each entry in the invoice services table.
invoice_id (INT NOT NULL, FOREIGN KEY referencing invoices.id): ID of the associated invoice.
service_id (INT NOT NULL, FOREIGN KEY referencing services.service_id): ID of the associated service.
service_name (VARCHAR(255) NOT NULL): Name of the service rendered.
cost (DECIMAL(10, 2) NOT NULL): Cost of the service rendered.


) to help to add more features in it