Skip to content
TheChatArchiveThe Chat Archive
o1-mini-2024-09-12· OpenAIAi2 WildChat-4.8M (AI2)

based on this database (-- phpMyAdmin SQL Dump -- version 5.2.1 --…

  1. User

    based on this database (-- phpMyAdmin SQL Dump -- version 5.2.1 -- https://www.phpmyadmin.net/

    -- Host: 127.0.0.1:3306 -- Generation Time: Oct 26, 2024 at 01:03 AM -- Server version: 10.11.9-MariaDB -- PHP Version: 7.2.34

    SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO"; START TRANSACTION; SET time_zone = "+00:00";

    /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT /; /!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS /; /!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION /; /!40101 SET NAMES utf8mb4 */;

    -- -- Database: u406552082_info


    -- -- Table structure for table admins

    CREATE TABLE admins ( id int(11) NOT NULL, username varchar(50) NOT NULL, password varchar(255) NOT NULL, email varchar(100) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;


    -- -- Table structure for table appointments

    CREATE TABLE appointments ( id int(11) NOT NULL, package_id int(11) NOT NULL, appointment_date datetime NOT NULL, proposed_appointment_date datetime DEFAULT NULL, name varchar(255) NOT NULL, email varchar(255) NOT NULL, phone varchar(20) NOT NULL, age int(3) DEFAULT NULL, gender enum('Male','Female','Other') DEFAULT NULL, address varchar(255) DEFAULT NULL, preferred_contact_method enum('Email','Phone','WhatsApp') DEFAULT NULL, additional_notes text DEFAULT NULL, admin_notes text DEFAULT NULL, status enum('Pending','Confirmed','Completed','Cancelled') DEFAULT 'Pending', created_at timestamp NULL DEFAULT current_timestamp(), patient_id int(11) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;


    -- -- Table structure for table budgets

    CREATE TABLE budgets ( id int(11) NOT NULL, month varchar(7) DEFAULT NULL, budgeted_revenue decimal(10,2) DEFAULT NULL, budgeted_expenses decimal(10,2) DEFAULT NULL, notes text DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;


    -- -- Table structure for table comments

    CREATE TABLE comments ( id int(11) NOT NULL, patient_id int(11) NOT NULL, sender enum('patient','doctor','admin') NOT NULL, message text NOT NULL, timestamp datetime DEFAULT current_timestamp(), parent_id int(11) DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;


    -- -- Table structure for table doctors

    CREATE TABLE doctors ( id int(11) NOT NULL, employee_id int(11) NOT NULL, name varchar(255) NOT NULL, username varchar(100) NOT NULL, password varchar(255) NOT NULL, email varchar(255) NOT NULL, specialization varchar(255) DEFAULT NULL, phone varchar(20) DEFAULT NULL, registration_date date DEFAULT curdate(), profile_picture varchar(255) DEFAULT NULL, department varchar(100) DEFAULT NULL, date_of_joining date DEFAULT NULL, status enum('active','inactive') DEFAULT 'active' ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;


    -- -- Table structure for table doctor_patient

    CREATE TABLE doctor_patient ( id int(11) NOT NULL, doctor_id int(11) NOT NULL, patient_id int(11) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;


    -- -- Table structure for table employees

    CREATE TABLE employees ( id int(11) NOT NULL, name varchar(255) NOT NULL, role enum('admin','doctor','staff','accountant') NOT NULL, email varchar(255) NOT NULL, phone varchar(20) DEFAULT NULL, department varchar(100) DEFAULT NULL, date_of_joining date DEFAULT NULL, status enum('active','inactive') DEFAULT 'active', username varchar(100) NOT NULL, password varchar(255) NOT NULL, created_at timestamp NULL DEFAULT current_timestamp(), updated_at timestamp NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(), profile_picture varchar(255) DEFAULT NULL, specialization varchar(255) DEFAULT NULL, is_online tinyint(1) DEFAULT 0 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;


    -- -- Table structure for table expenses

    CREATE TABLE expenses ( id int(11) NOT NULL, expense_date date NOT NULL, category varchar(100) NOT NULL, description varchar(255) DEFAULT NULL, amount decimal(10,2) NOT NULL, created_at timestamp NULL DEFAULT current_timestamp(), updated_at timestamp NULL DEFAULT current_timestamp() ON UPDATE current_timestamp() ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;


    -- -- Table structure for table health_records

    CREATE TABLE health_records ( id int(11) NOT NULL, patient_id int(11) NOT NULL, blood_pressure varchar(20) DEFAULT NULL, weight decimal(5,2) DEFAULT NULL, bmi decimal(4,2) DEFAULT NULL, cholesterol decimal(5,2) DEFAULT NULL, prescription text DEFAULT NULL, treatment_progress text DEFAULT NULL, record_date date NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;


    -- -- Table structure for table insurance_claims

    CREATE TABLE insurance_claims ( id int(11) NOT NULL, patient_id int(11) DEFAULT NULL, invoice_id int(11) DEFAULT NULL, claim_amount decimal(10,2) DEFAULT NULL, status enum('Pending','Approved','Rejected') DEFAULT NULL, submission_date date DEFAULT NULL, processing_date date DEFAULT NULL, notes text DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;


    -- -- Table structure for table invoices

    CREATE TABLE invoices ( id int(11) NOT NULL, patient_id int(11) NOT NULL, service_name varchar(255) NOT NULL, service_description text DEFAULT NULL, cost decimal(10,2) NOT NULL, tax_rate decimal(5,2) DEFAULT 0.00, discount decimal(5,2) DEFAULT 0.00, total_amount decimal(10,2) NOT NULL, invoice_date date DEFAULT curdate(), due_date date DEFAULT NULL, notes text DEFAULT NULL, tax decimal(5,2) DEFAULT 0.00 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;


    -- -- Table structure for table invoice_services

    CREATE TABLE invoice_services ( id int(11) NOT NULL, invoice_id int(11) NOT NULL, service_id int(11) NOT NULL, service_name varchar(255) NOT NULL, cost decimal(10,2) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;


    -- -- Table structure for table medical_notes

    CREATE TABLE medical_notes ( id int(11) NOT NULL, patient_id int(11) NOT NULL, doctor_id int(11) NOT NULL, note text NOT NULL, created_at timestamp NULL DEFAULT current_timestamp(), updated_at timestamp NULL DEFAULT current_timestamp() ON UPDATE current_timestamp() ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;


    -- -- Table structure for table packages

    CREATE TABLE packages ( id int(11) NOT NULL, package_name varchar(255) NOT NULL, description text DEFAULT NULL, details text DEFAULT NULL, created_at timestamp NULL DEFAULT current_timestamp() ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;


    -- -- Table structure for table patients

    CREATE TABLE patients ( id int(11) NOT NULL, name varchar(100) NOT NULL, age int(3) DEFAULT NULL, gender enum('Male','Female','Other') DEFAULT NULL, phone varchar(20) DEFAULT NULL, email varchar(100) DEFAULT NULL, medical_history text DEFAULT NULL, created_at timestamp NULL DEFAULT current_timestamp(), updated_at timestamp NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(), date_of_birth date DEFAULT NULL, registration_datetime datetime DEFAULT current_timestamp(), registration_date date DEFAULT NULL, status enum('Initial Consultation','Diagnostic Phase','Treatment in Progress','Improving','Monitoring','Maintenance Phase','Awaiting Test Results','Follow-up Needed','Paused','Completed Program','Relapsed','Discontinued','Inactive') DEFAULT 'Initial Consultation', doctor_id int(11) DEFAULT NULL, address varchar(255) DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;


    -- -- Table structure for table patient_basic_info

    CREATE TABLE patient_basic_info ( patient_id int(11) NOT NULL, gender enum('Male','Female','Other') NOT NULL, age int(3) NOT NULL, weight decimal(5,2) NOT NULL, height decimal(5,2) NOT NULL, address varchar(255) DEFAULT NULL, name varchar(100) NOT NULL, email varchar(100) NOT NULL, phone varchar(20) NOT NULL, created_at timestamp NULL DEFAULT current_timestamp(), updated_at timestamp NULL DEFAULT current_timestamp() ON UPDATE current_timestamp() ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;


    -- -- Table structure for table patient_consent

    CREATE TABLE patient_consent ( patient_id int(11) NOT NULL, consent enum('accepted','declined') NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;


    -- -- Table structure for table patient_consultation

    CREATE TABLE patient_consultation ( patient_id int(11) NOT NULL, scheduled_at datetime NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;


    -- -- Table structure for table patient_goals

    CREATE TABLE patient_goals ( patient_id int(11) NOT NULL, primary_health_goals text NOT NULL, health_concerns text NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;


    -- -- Table structure for table patient_health_metrics

    CREATE TABLE patient_health_metrics ( patient_id int(11) NOT NULL, exercise_frequency enum('Daily','Weekly','Rarely','Never') NOT NULL, diet enum('Yes','No') NOT NULL, diet_specify varchar(255) DEFAULT NULL, sleep_average enum('<5 Hours','5-7 Hours','7-9 Hours','>9 Hours') NOT NULL, smoking_status enum('Yes','No','Occasionally') NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;


    -- -- Table structure for table patient_logins

    CREATE TABLE patient_logins ( id int(11) NOT NULL, patient_id int(11) NOT NULL, username varchar(50) NOT NULL, password varchar(255) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;


    -- -- Table structure for table patient_medical_history

    CREATE TABLE patient_medical_history ( patient_id int(11) NOT NULL, chronic_conditions enum('Yes','No') NOT NULL, chronic_conditions_specify varchar(255) DEFAULT NULL, medications enum('Yes','No') NOT NULL, medications_list text DEFAULT NULL, major_surgeries enum('Yes','No') NOT NULL, major_surgeries_specify varchar(255) DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;


    -- -- Table structure for table payments

    CREATE TABLE payments ( id int(11) NOT NULL, patient_id int(11) NOT NULL, invoice_id int(11) NOT NULL, amount_paid decimal(10,2) NOT NULL, payment_date date NOT NULL, payment_method varchar(50) DEFAULT NULL, notes text DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;


    -- -- Table structure for table prescriptions

    CREATE TABLE prescriptions ( id int(11) NOT NULL, patient_id int(11) NOT NULL, doctor_id int(11) DEFAULT NULL, medications text NOT NULL, instructions text DEFAULT NULL, date_prescribed datetime DEFAULT current_timestamp(), status enum('active','inactive') DEFAULT 'active' ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;


    -- -- Table structure for table questionnaire_responses

    CREATE TABLE questionnaire_responses ( id int(11) NOT NULL, session_id varchar(255) NOT NULL, page_number int(2) NOT NULL, question varchar(255) NOT NULL, answer text NOT NULL, submitted_at timestamp NULL DEFAULT current_timestamp(), consent enum('Yes','No') DEFAULT 'No' ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;


    -- -- Table structure for table salaries

    CREATE TABLE salaries ( id int(11) NOT NULL, employee_id int(11) NOT NULL, basic_salary decimal(10,2) NOT NULL, bonuses decimal(10,2) DEFAULT 0.00, deductions decimal(10,2) DEFAULT 0.00, overtime_hours int(11) DEFAULT 0, overtime_rate decimal(10,2) DEFAULT 0.00, tax decimal(10,2) DEFAULT 0.00, payment_date date NOT NULL, net_salary decimal(10,2) NOT NULL, status enum('Pending','Paid') DEFAULT 'Pending', notes text DEFAULT NULL, payslip_path varchar(255) DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;


    -- -- Table structure for table services

    CREATE TABLE services ( service_id int(11) NOT NULL, service_name varchar(255) NOT NULL, service_price decimal(10,2) NOT NULL, service_description text DEFAULT NULL, created_at timestamp NULL DEFAULT current_timestamp(), updated_at timestamp NULL DEFAULT current_timestamp() ON UPDATE current_timestamp() ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

    -- -- Indexes for dumped tables

    -- -- Indexes for table admins

    ALTER TABLE admins ADD PRIMARY KEY (id), ADD UNIQUE KEY username (username);

    -- -- Indexes for table appointments

    ALTER TABLE appointments ADD PRIMARY KEY (id), ADD KEY package_id (package_id), ADD KEY appointments_ibfk_2 (patient_id);

    -- -- Indexes for table budgets

    ALTER TABLE budgets ADD PRIMARY KEY (id);

    -- -- Indexes for table comments

    ALTER TABLE comments ADD PRIMARY KEY (id), ADD KEY patient_id (patient_id);

    -- -- Indexes for table doctors

    ALTER TABLE doctors ADD PRIMARY KEY (id), ADD UNIQUE KEY username (username), ADD UNIQUE KEY email (email), ADD KEY employee_id (employee_id);

    -- -- Indexes for table doctor_patient

    ALTER TABLE doctor_patient ADD PRIMARY KEY (id), ADD UNIQUE KEY doctor_id (doctor_id,patient_id), ADD KEY fk_doctor_patient_patient_id (patient_id);

    -- -- Indexes for table employees

    ALTER TABLE employees ADD PRIMARY KEY (id), ADD UNIQUE KEY email (email), ADD UNIQUE KEY username (username);

    -- -- Indexes for table expenses

    ALTER TABLE expenses ADD PRIMARY KEY (id);

    -- -- Indexes for table health_records

    ALTER TABLE health_records ADD PRIMARY KEY (id), ADD KEY patient_id (patient_id);

    -- -- Indexes for table insurance_claims

    ALTER TABLE insurance_claims ADD PRIMARY KEY (id), ADD KEY patient_id (patient_id), ADD KEY invoice_id (invoice_id);

    -- -- Indexes for table invoices

    ALTER TABLE invoices ADD PRIMARY KEY (id), ADD KEY patient_id (patient_id);

    -- -- Indexes for table invoice_services

    ALTER TABLE invoice_services ADD PRIMARY KEY (id), ADD KEY invoice_id (invoice_id), ADD KEY service_id (service_id);

    -- -- Indexes for table medical_notes

    ALTER TABLE medical_notes ADD PRIMARY KEY (id), ADD KEY patient_id (patient_id), ADD KEY doctor_id (doctor_id);

    -- -- Indexes for table packages

    ALTER TABLE packages ADD PRIMARY KEY (id);

    -- -- Indexes for table patients

    ALTER TABLE patients ADD PRIMARY KEY (id), ADD KEY doctor_id (doctor_id);

    -- -- Indexes for table patient_basic_info

    ALTER TABLE patient_basic_info ADD PRIMARY KEY (patient_id);

    -- -- Indexes for table patient_consent

    ALTER TABLE patient_consent ADD PRIMARY KEY (patient_id);

    -- -- Indexes for table patient_consultation

    ALTER TABLE patient_consultation ADD PRIMARY KEY (patient_id);

    -- -- Indexes for table patient_goals

    ALTER TABLE patient_goals ADD PRIMARY KEY (patient_id);

    -- -- Indexes for table patient_health_metrics

    ALTER TABLE patient_health_metrics ADD PRIMARY KEY (patient_id);

    -- -- Indexes for table patient_logins

    ALTER TABLE patient_logins ADD PRIMARY KEY (id), ADD UNIQUE KEY patient_id (patient_id), ADD UNIQUE KEY username (username);

    -- -- Indexes for table patient_medical_history

    ALTER TABLE patient_medical_history ADD PRIMARY KEY (patient_id);

    -- -- Indexes for table payments

    ALTER TABLE payments ADD PRIMARY KEY (id), ADD KEY patient_id (patient_id), ADD KEY invoice_id (invoice_id);

    -- -- Indexes for table prescriptions

    ALTER TABLE prescriptions ADD PRIMARY KEY (id), ADD KEY patient_id (patient_id), ADD KEY doctor_id (doctor_id);

    -- -- Indexes for table questionnaire_responses

    ALTER TABLE questionnaire_responses ADD PRIMARY KEY (id);

    -- -- Indexes for table salaries

    ALTER TABLE salaries ADD PRIMARY KEY (id), ADD KEY employee_id (employee_id);

    -- -- Indexes for table services

    ALTER TABLE services ADD PRIMARY KEY (service_id);

    -- -- AUTO_INCREMENT for dumped tables

    -- -- AUTO_INCREMENT for table admins

    ALTER TABLE admins MODIFY id int(11) NOT NULL AUTO_INCREMENT;

    -- -- AUTO_INCREMENT for table appointments

    ALTER TABLE appointments MODIFY id int(11) NOT NULL AUTO_INCREMENT;

    -- -- AUTO_INCREMENT for table budgets

    ALTER TABLE budgets MODIFY id int(11) NOT NULL AUTO_INCREMENT;

    -- -- AUTO_INCREMENT for table comments

    ALTER TABLE comments MODIFY id int(11) NOT NULL AUTO_INCREMENT;

    -- -- AUTO_INCREMENT for table doctors

    ALTER TABLE doctors MODIFY id int(11) NOT NULL AUTO_INCREMENT;

    -- -- AUTO_INCREMENT for table doctor_patient

    ALTER TABLE doctor_patient MODIFY id int(11) NOT NULL AUTO_INCREMENT;

    -- -- AUTO_INCREMENT for table employees

    ALTER TABLE employees MODIFY id int(11) NOT NULL AUTO_INCREMENT;

    -- -- AUTO_INCREMENT for table expenses

    ALTER TABLE expenses MODIFY id int(11) NOT NULL AUTO_INCREMENT;

    -- -- AUTO_INCREMENT for table health_records

    ALTER TABLE health_records MODIFY id int(11) NOT NULL AUTO_INCREMENT;

    -- -- AUTO_INCREMENT for table insurance_claims

    ALTER TABLE insurance_claims MODIFY id int(11) NOT NULL AUTO_INCREMENT;

    -- -- AUTO_INCREMENT for table invoices

    ALTER TABLE invoices MODIFY id int(11) NOT NULL AUTO_INCREMENT;

    -- -- AUTO_INCREMENT for table invoice_services

    ALTER TABLE invoice_services MODIFY id int(11) NOT NULL AUTO_INCREMENT;

    -- -- AUTO_INCREMENT for table medical_notes

    ALTER TABLE medical_notes MODIFY id int(11) NOT NULL AUTO_INCREMENT;

    -- -- AUTO_INCREMENT for table packages

    ALTER TABLE packages MODIFY id int(11) NOT NULL AUTO_INCREMENT;

    -- -- AUTO_INCREMENT for table patients

    ALTER TABLE patients MODIFY id int(11) NOT NULL AUTO_INCREMENT;

    -- -- AUTO_INCREMENT for table patient_logins

    ALTER TABLE patient_logins MODIFY id int(11) NOT NULL AUTO_INCREMENT;

    -- -- AUTO_INCREMENT for table payments

    ALTER TABLE payments MODIFY id int(11) NOT NULL AUTO_INCREMENT;

    -- -- AUTO_INCREMENT for table prescriptions

    ALTER TABLE prescriptions MODIFY id int(11) NOT NULL AUTO_INCREMENT;

    -- -- AUTO_INCREMENT for table questionnaire_responses

    ALTER TABLE questionnaire_responses MODIFY id int(11) NOT NULL AUTO_INCREMENT;

    -- -- AUTO_INCREMENT for table salaries

    ALTER TABLE salaries MODIFY id int(11) NOT NULL AUTO_INCREMENT;

    -- -- AUTO_INCREMENT for table services

    ALTER TABLE services MODIFY service_id int(11) NOT NULL AUTO_INCREMENT;

    -- -- Constraints for dumped tables

    -- -- Constraints for table appointments

    ALTER TABLE appointments ADD CONSTRAINT appointments_ibfk_1 FOREIGN KEY (package_id) REFERENCES packages (id) ON DELETE CASCADE ON UPDATE CASCADE, ADD CONSTRAINT appointments_ibfk_2 FOREIGN KEY (patient_id) REFERENCES patients (id) ON DELETE CASCADE ON UPDATE CASCADE;

    -- -- Constraints for table comments

    ALTER TABLE comments ADD CONSTRAINT comments_ibfk_1 FOREIGN KEY (patient_id) REFERENCES patients (id);

    -- -- Constraints for table doctors

    ALTER TABLE doctors ADD CONSTRAINT doctors_ibfk_1 FOREIGN KEY (employee_id) REFERENCES employees (id);

    -- -- Constraints for table doctor_patient

    ALTER TABLE doctor_patient ADD CONSTRAINT doctor_patient_fk_doctor_id FOREIGN KEY (doctor_id) REFERENCES doctors (id) ON DELETE CASCADE ON UPDATE CASCADE, ADD CONSTRAINT doctor_patient_ibfk_2 FOREIGN KEY (patient_id) REFERENCES patients (id) ON DELETE CASCADE, ADD CONSTRAINT fk_doctor FOREIGN KEY (doctor_id) REFERENCES doctors (id) ON DELETE CASCADE ON UPDATE CASCADE, ADD CONSTRAINT fk_doctor_patient_doctor_id FOREIGN KEY (doctor_id) REFERENCES doctors (id) ON DELETE CASCADE ON UPDATE CASCADE, ADD CONSTRAINT fk_doctor_patient_patient_id FOREIGN KEY (patient_id) REFERENCES patients (id) ON DELETE CASCADE ON UPDATE CASCADE;

    -- -- Constraints for table health_records

    ALTER TABLE health_records ADD CONSTRAINT health_records_ibfk_1 FOREIGN KEY (patient_id) REFERENCES patients (id) ON DELETE CASCADE;

    -- -- Constraints for table insurance_claims

    ALTER TABLE insurance_claims ADD CONSTRAINT insurance_claims_ibfk_1 FOREIGN KEY (patient_id) REFERENCES patients (id) ON DELETE CASCADE, ADD CONSTRAINT insurance_claims_ibfk_2 FOREIGN KEY (invoice_id) REFERENCES invoices (id) ON DELETE CASCADE;

    -- -- Constraints for table invoices

    ALTER TABLE invoices ADD CONSTRAINT invoices_ibfk_1 FOREIGN KEY (patient_id) REFERENCES patients (id);

    -- -- Constraints for table invoice_services

    ALTER TABLE invoice_services ADD CONSTRAINT invoice_services_ibfk_1 FOREIGN KEY (invoice_id) REFERENCES invoices (id) ON DELETE CASCADE, ADD CONSTRAINT invoice_services_ibfk_2 FOREIGN KEY (service_id) REFERENCES services (service_id) ON DELETE CASCADE;

    -- -- Constraints for table medical_notes

    ALTER TABLE medical_notes ADD CONSTRAINT medical_notes_ibfk_1 FOREIGN KEY (patient_id) REFERENCES patients (id) ON DELETE CASCADE ON UPDATE CASCADE, ADD CONSTRAINT medical_notes_ibfk_2 FOREIGN KEY (doctor_id) REFERENCES doctors (id) ON DELETE CASCADE ON UPDATE CASCADE;

    -- -- Constraints for table patients

    ALTER TABLE patients ADD CONSTRAINT patients_ibfk_1 FOREIGN KEY (doctor_id) REFERENCES doctors (id) ON DELETE SET NULL ON UPDATE CASCADE;

    -- -- Constraints for table patient_basic_info

    ALTER TABLE patient_basic_info ADD CONSTRAINT fk_patient_basic_info_patient FOREIGN KEY (patient_id) REFERENCES patients (id) ON DELETE CASCADE ON UPDATE CASCADE;

    -- -- Constraints for table patient_logins

    ALTER TABLE patient_logins ADD CONSTRAINT patient_logins_ibfk_1 FOREIGN KEY (patient_id) REFERENCES patients (id) ON DELETE CASCADE;

    -- -- Constraints for table payments

    ALTER TABLE payments ADD CONSTRAINT payments_ibfk_1 FOREIGN KEY (patient_id) REFERENCES patients (id) ON DELETE CASCADE ON UPDATE CASCADE, ADD CONSTRAINT payments_ibfk_2 FOREIGN KEY (invoice_id) REFERENCES invoices (id) ON DELETE CASCADE ON UPDATE CASCADE;

    -- -- Constraints for table prescriptions

    ALTER TABLE prescriptions ADD CONSTRAINT prescriptions_ibfk_1 FOREIGN KEY (patient_id) REFERENCES patients (id) ON DELETE CASCADE, ADD CONSTRAINT prescriptions_ibfk_2 FOREIGN KEY (doctor_id) REFERENCES doctors (id) ON DELETE SET NULL;

    -- -- Constraints for table salaries

    ALTER TABLE salaries ADD CONSTRAINT salaries_ibfk_1 FOREIGN KEY (employee_id) REFERENCES employees (id) ON DELETE CASCADE ON UPDATE CASCADE; COMMIT;

    /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT /; /!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS /; /!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;), i want to update and add more extra info of patient based on databse and this view_patient.php (<?php session_start(); require_once 'db_connect.php';

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

    patientid=patient_id = _GET['id'] ?? null;

    if (!$patient_id) { header("Location: admin_dashboard.php"); exit(); }

    stmt=stmt = pdo->prepare("SELECT p.*, pl.username FROM patients p LEFT JOIN patient_logins pl ON p.id = pl.patient_id WHERE p.id = ?"); stmt−>execute([stmt->execute([patient_id]); patient=patient = stmt->fetch();

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

    stmt=stmt = pdo->prepare("SELECT * FROM health_records WHERE patient_id = ? ORDER BY record_date DESC"); stmt−>execute([stmt->execute([patient_id]); healthrecords=health_records = stmt->fetchAll(); ?>

        :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);
            overflow: hidden;
        }
    
        .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;
            position: relative;
            overflow: hidden;
        }
    
        .header h2 {
            margin: 0;
            font-size: 32px;
            font-weight: 700;
        }
    
        .header::before {
            content: "";
            position: absolute;
            top: -50%;
            left: -50%;
            width: 200%;
            height: 200%;
            background: radial-gradient(circle, rgba(255,255,255,0.2) 0%, rgba(255,255,255,0) 70%);
            transform: rotate(30deg);
        }
    
        .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);
            transition: transform 0.3s ease, box-shadow 0.3s ease;
        }
    
        .section:hover {
            transform: translateY(-5px);
            box-shadow: 0 6px 12px rgba(0, 0, 0, 0.1);
        }
    
        .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;
        }
    
        .health-records .record-item {
            margin-bottom: 15px;
            padding: 15px;
            background-color: white;
            border-radius: 10px;
            box-shadow: 0 4px 8px rgba(0, 0, 0, 0.05);
        }
    
        .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>
    
        <div class="section">
            <h3>Patient 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>Address:</span>
                <span><?= htmlspecialchars($patient['address']) ?></span>
            </div>
    
            <div class="info-item">
                <span>Medical History:</span>
                <span><?= nl2br(htmlspecialchars($patient['medical_history'])) ?></span>
            </div>
            <div class="info-item">
                <span>Status:</span>
                <span><?= nl2br(htmlspecialchars($patient['status'])) ?></span>
            </div>
    
        </div>
    
        <div class="section">
            <h3>Health Records</h3>
            <div class="health-records">
                <?php foreach ($health_records as $record): ?>
                    <div class="record-item">
                        <div><strong>Date:</strong> <?= $record['record_date'] ?></div>
                        <div><strong>Blood Pressure:</strong> <?= htmlspecialchars($record['blood_pressure']) ?></div>
                        <div><strong>Weight:</strong> <?= $record['weight'] ?> kg</div>
                        <div><strong>BMI:</strong> <?= $record['bmi'] ?></div>
                        <div><strong>Cholesterol:</strong> <?= $record['cholesterol'] ?></div>
                        <div><strong>Prescription:</strong> <?= nl2br(htmlspecialchars($record['prescription'])) ?></div>
                        <div><strong>Treatment Progress:</strong> <?= nl2br(htmlspecialchars($record['treatment_progress'])) ?></div>
                        <div class="actions">
                            <a href="edit_health_record.php?id=<?= $record['id'] ?>&patient_id=<?= $patient_id ?>">Edit</a>
                        </div>
                    </div>
                <?php endforeach; ?>
            </div>
        </div>
    
        <div class="actions">
            <a href="add_health_record.php?patient_id=<?= $patient_id ?>">Add Health Record</a>
            <a href="edit_patient.php?id=<?= $patient_id ?>">Edit Patient Information</a>
            <a href="admin_dashboard.php">Back to Dashboard</a>
        </div>
    </div>
    
  2. Assistant

    Certainly! To enhance the view_patient.php file by incorporating additional patient information from your database, we'll extend the existing functionality to fetch and display data from the supplementary tables such as patient_basic_info, patient_consent, patient_consultation, patient_goals, patient_health_metrics, and patient_medical_history.

    Below is the complete updated view_patient.php file with the necessary modifications:

    <?php
    session_start();
    require_once 'db_connect.php';
    
    // Redirect to login if admin is not authenticated
    if (!isset($_SESSION['admin_id'])) {
        header("Location: admin_login.php");
        exit();
    }
    
    // Get the patient ID from the URL parameter
    $patient_id = $_GET['id'] ?? null;
    
    // Redirect to dashboard if no patient ID is provided
    if (!$patient_id) {
        header("Location: admin_dashboard.php");
        exit();
    }
    
    // Fetch primary patient information along with login details
    $stmt = $pdo->prepare("SELECT p.*, pl.username 
                           FROM patients p 
                           LEFT JOIN patient_logins pl ON p.id = pl.patient_id 
                           WHERE p.id = ?");
    $stmt->execute([$patient_id]);
    $patient = $stmt->fetch();
    
    // Redirect if patient not found
    if (!$patient) {
        header("Location: admin_dashboard.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();
    
    // Fetch additional patient information from other tables
    // Patient Basic Info
    $stmt = $pdo->prepare("SELECT * FROM patient_basic_info WHERE patient_id = ?");
    $stmt->execute([$patient_id]);
    $basic_info = $stmt->fetch();
    
    // Patient Consent
    $stmt = $pdo->prepare("SELECT * FROM patient_consent WHERE patient_id = ?");
    $stmt->execute([$patient_id]);
    $consent = $stmt->fetch();
    
    // Patient Consultation
    $stmt = $pdo->prepare("SELECT * FROM patient_consultation WHERE patient_id = ?");
    $stmt->execute([$patient_id]);
    $consultation = $stmt->fetch();
    
    // Patient Goals
    $stmt = $pdo->prepare("SELECT * FROM patient_goals WHERE patient_id = ?");
    $stmt->execute([$patient_id]);
    $goals = $stmt->fetch();
    
    // Patient Health Metrics
    $stmt = $pdo->prepare("SELECT * FROM patient_health_metrics WHERE patient_id = ?");
    $stmt->execute([$patient_id]);
    $health_metrics = $stmt->fetch();
    
    // Patient Medical History
    $stmt = $pdo->prepare("SELECT * FROM patient_medical_history WHERE patient_id = ?");
    $stmt->execute([$patient_id]);
    $medical_history = $stmt->fetch();
    ?>
    
    <!DOCTYPE html>
    <html lang="en">
    <head>
        <meta charset="UTF-8">
        <meta name="viewport" content="width=device-width, initial-scale=1.0">
        <title>View Patient Record</title>
        <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: 1000px;
                margin: 40px auto;
                padding: 20px;
                background-color: white;
                border-radius: 20px;
                box-shadow: 0 15px 30px rgba(0, 0, 0, 0.1);
                overflow: hidden;
            }
    
            .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;
                position: relative;
                overflow: hidden;
            }
    
            .header h2 {
                margin: 0;
                font-size: 32px;
                font-weight: 700;
            }
    
            .header::before {
                content: "";
                position: absolute;
                top: -50%;
                left: -50%;
                width: 200%;
                height: 200%;
                background: radial-gradient(circle, rgba(255,255,255,0.2) 0%, rgba(255,255,255,0) 70%);
                transform: rotate(30deg);
            }
    
            .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);
                transition: transform 0.3s ease, box-shadow 0.3s ease;
            }
    
            .section:hover {
                transform: translateY(-5px);
                box-shadow: 0 6px 12px rgba(0, 0, 0, 0.1);
            }
    
            .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;
            }
    
            .info-item span:first-child {
                font-weight: 700;
            }
    
            .health-records .record-item,
            .additional-info .info-group {
                margin-bottom: 15px;
                padding: 15px;
                background-color: white;
                border-radius: 10px;
                box-shadow: 0 4px 8px rgba(0, 0, 0, 0.05);
            }
    
            .actions {
                display: flex;
                justify-content: center;
                gap: 10px;
                margin-top: 20px;
                flex-wrap: wrap;
            }
    
            .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;
                text-align: center;
                min-width: 150px;
            }
    
            .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;
                }
    
                .section {
                    padding: 15px;
                }
    
                .header h2 {
                    font-size: 24px;
                }
    
                .actions a {
                    min-width: 100%;
                }
            }
        </style>
    </head>
    <body>
        <div class="container">
            <div class="header">
                <h2>Patient Record: <?= htmlspecialchars($patient['name']) ?></h2>
            </div>
    
            <!-- Patient Information Section -->
            <div class="section">
                <h3>Patient Information</h3>
                <div class="info-item">
                    <span>Patient ID:</span>
                    <span><?= htmlspecialchars($patient['id']) ?></span>
                </div>
                <div class="info-item">
                    <span>Name:</span>
                    <span><?= htmlspecialchars($patient['name']) ?></span>
                </div>
                <div class="info-item">
                    <span>Username:</span>
                    <span><?= htmlspecialchars($patient['username']) ?></span>
                </div>
                <div class="info-item">
                    <span>Email:</span>
                    <span><?= htmlspecialchars($patient['email']) ?></span>
                </div>
                <div class="info-item">
                    <span>Phone:</span>
                    <span><?= htmlspecialchars($patient['phone']) ?></span>
                </div>
                <div class="info-item">
                    <span>Age:</span>
                    <span><?= htmlspecialchars($patient['age']) ?></span>
                </div>
                <div class="info-item">
                    <span>Gender:</span>
                    <span><?= htmlspecialchars($patient['gender']) ?></span>
                </div>
                <div class="info-item">
                    <span>Address:</span>
                    <span><?= htmlspecialchars($patient['address']) ?></span>
                </div>
                <div class="info-item">
                    <span>Date of Birth:</span>
                    <span><?= htmlspecialchars($patient['date_of_birth']) ?></span>
                </div>
                <div class="info-item">
                    <span>Registration Date:</span>
                    <span><?= htmlspecialchars($patient['registration_date']) ?></span>
                </div>
                <div class="info-item">
                    <span>Status:</span>
                    <span><?= htmlspecialchars($patient['status']) ?></span>
                </div>
                <div class="info-item">
                    <span>Registration Datetime:</span>
                    <span><?= htmlspecialchars($patient['registration_datetime']) ?></span>
                </div>
                <div class="info-item">
                    <span>Medical History:</span>
                    <span><?= nl2br(htmlspecialchars($patient['medical_history'])) ?></span>
                </div>
            </div>
    
            <!-- Basic Information Section -->
            <?php if ($basic_info): ?>
                <div class="section">
                    <h3>Basic Information</h3>
                    <div class="info-item">
                        <span>Weight:</span>
                        <span><?= htmlspecialchars($basic_info['weight']) ?> kg</span>
                    </div>
                    <div class="info-item">
                        <span>Height:</span>
                        <span><?= htmlspecialchars($basic_info['height']) ?> cm</span>
                    </div>
                    <div class="info-item">
                        <span>Exercise Frequency:</span>
                        <span><?= htmlspecialchars($health_metrics['exercise_frequency'] ?? 'N/A') ?></span>
                    </div>
                    <div class="info-item">
                        <span>Diet:</span>
                        <span><?= htmlspecialchars($health_metrics['diet'] ?? 'N/A') ?></span>
                    </div>
                    <?php if (!empty($health_metrics['diet_specify'])): ?>
                        <div class="info-item">
                            <span>Diet Specifics:</span>
                            <span><?= htmlspecialchars($health_metrics['diet_specify']) ?></span>
                        </div>
                    <?php endif; ?>
                    <div class="info-item">
                        <span>Average Sleep:</span>
                        <span><?= htmlspecialchars($health_metrics['sleep_average'] ?? 'N/A') ?></span>
                    </div>
                    <div class="info-item">
                        <span>Smoking Status:</span>
                        <span><?= htmlspecialchars($health_metrics['smoking_status'] ?? 'N/A') ?></span>
                    </div>
                </div>
            <?php endif; ?>
    
            <!-- Consent Section -->
            <?php if ($consent): ?>
                <div class="section">
                    <h3>Consent Information</h3>
                    <div class="info-item">
                        <span>Consent Status:</span>
                        <span><?= htmlspecialchars($consent['consent']) ?></span>
                    </div>
                </div>
            <?php endif; ?>
    
            <!-- Consultation Section -->
            <?php if ($consultation): ?>
                <div class="section">
                    <h3>Consultation Details</h3>
                    <div class="info-item">
                        <span>Scheduled At:</span>
                        <span><?= htmlspecialchars($consultation['scheduled_at']) ?></span>
                    </div>
                </div>
            <?php endif; ?>
    
            <!-- Goals Section -->
            <?php if ($goals): ?>
                <div class="section">
                    <h3>Patient Goals</h3>
                    <div class="info-item">
                        <span>Primary Health Goals:</span>
                        <span><?= nl2br(htmlspecialchars($goals['primary_health_goals'])) ?></span>
                    </div>
                    <div class="info-item">
                        <span>Health Concerns:</span>
                        <span><?= nl2br(htmlspecialchars($goals['health_concerns'])) ?></span>
                    </div>
                </div>
            <?php endif; ?>
    
            <!-- Medical History Section -->
            <?php if ($medical_history): ?>
                <div class="section">
                    <h3>Medical History</h3>
                    <div class="info-item">
                        <span>Chronic Conditions:</span>
                        <span><?= htmlspecialchars($medical_history['chronic_conditions']) ?></span>
                    </div>
                    <?php if (!empty($medical_history['chronic_conditions_specify'])): ?>
                        <div class="info-item">
                            <span>Chronic Conditions Specify:</span>
                            <span><?= htmlspecialchars($medical_history['chronic_conditions_specify']) ?></span>
                        </div>
                    <?php endif; ?>
                    <div class="info-item">
                        <span>Medications:</span>
                        <span><?= htmlspecialchars($medical_history['medications']) ?></span>
                    </div>
                    <?php if (!empty($medical_history['medications_list'])): ?>
                        <div class="info-item">
                            <span>Medications List:</span>
                            <span><?= nl2br(htmlspecialchars($medical_history['medications_list'])) ?></span>
                        </div>
                    <?php endif; ?>
                    <div class="info-item">
                        <span>Major Surgeries:</span>
                        <span><?= htmlspecialchars($medical_history['major_surgeries']) ?></span>
                    </div>
                    <?php if (!empty($medical_history['major_surgeries_specify'])): ?>
                        <div class="info-item">
                            <span>Major Surgeries Specify:</span>
                            <span><?= htmlspecialchars($medical_history['major_surgeries_specify']) ?></span>
                        </div>
                    <?php endif; ?>
                </div>
            <?php endif; ?>
    
            <!-- Health Metrics Section -->
            <?php if ($health_metrics): ?>
                <div class="section">
                    <h3>Health Metrics</h3>
                    <div class="info-item">
                        <span>Exercise Frequency:</span>
                        <span><?= htmlspecialchars($health_metrics['exercise_frequency']) ?></span>
                    </div>
                    <div class="info-item">
                        <span>Diet:</span>
                        <span><?= htmlspecialchars($health_metrics['diet']) ?></span>
                    </div>
                    <?php if (!empty($health_metrics['diet_specify'])): ?>
                        <div class="info-item">
                            <span>Diet Specifics:</span>
                            <span><?= htmlspecialchars($health_metrics['diet_specify']) ?></span>
                        </div>
                    <?php endif; ?>
                    <div class="info-item">
                        <span>Average Sleep:</span>
                        <span><?= htmlspecialchars($health_metrics['sleep_average']) ?></span>
                    </div>
                    <div class="info-item">
                        <span>Smoking Status:</span>
                        <span><?= htmlspecialchars($health_metrics['smoking_status']) ?></span>
                    </div>
                </div>
            <?php endif; ?>
    
            <!-- Health Records Section -->
            <div class="section">
                <h3>Health Records</h3>
                <div class="health-records">
                    <?php if ($health_records): ?>
                        <?php foreach ($health_records as $record): ?>
                            <div class="record-item">
                                <div><strong>Date:</strong> <?= htmlspecialchars($record['record_date']) ?></div>
                                <div><strong>Blood Pressure:</strong> <?= htmlspecialchars($record['blood_pressure']) ?></div>
                                <div><strong>Weight:</strong> <?= htmlspecialchars($record['weight']) ?> kg</div>
                                <div><strong>BMI:</strong> <?= htmlspecialchars($record['bmi']) ?></div>
                                <div><strong>Cholesterol:</strong> <?= htmlspecialchars($record['cholesterol']) ?></div>
                                <div><strong>Prescription:</strong> <?= nl2br(htmlspecialchars($record['prescription'])) ?></div>
                                <div><strong>Treatment Progress:</strong> <?= nl2br(htmlspecialchars($record['treatment_progress'])) ?></div>
                                <div class="actions">
                                    <a href="edit_health_record.php?id=<?= htmlspecialchars($record['id']) ?>&patient_id=<?= htmlspecialchars($patient_id) ?>">Edit</a>
                                    <a href="delete_health_record.php?id=<?= htmlspecialchars($record['id']) ?>&patient_id=<?= htmlspecialchars($patient_id) ?>" onclick="return confirm('Are you sure you want to delete this record?');">Delete</a>
                                </div>
                            </div>
                        <?php endforeach; ?>
                    <?php else: ?>
                        <p>No health records found for this patient.</p>
                    <?php endif; ?>
                </div>
            </div>
    
            <!-- Additional Information Section (Optional) -->
            <?php if ($basic_info || $consent || $consultation || $goals || $health_metrics || $medical_history): ?>
                <div class="section">
                    <h3>Additional Information</h3>
                    <!-- Add more groups of information as needed -->
                </div>
            <?php endif; ?>
    
            <!-- Actions -->
            <div class="actions">
                <a href="add_health_record.php?patient_id=<?= htmlspecialchars($patient_id) ?>">Add Health Record</a>
                <a href="edit_patient.php?id=<?= htmlspecialchars($patient_id) ?>">Edit Patient Information</a>
                <a href="admin_dashboard.php">Back to Dashboard</a>
            </div>
        </div>
    </body>
    </html>
    

    Explanation of Changes

    1. Fetching Additional Data:

      • Patient Basic Info: Data from the patient_basic_info table is fetched to include details like weight, height, etc.
      • Patient Consent: Data from the patient_consent table is retrieved to display the consent status.
      • Patient Consultation: Data from the patient_consultation table provides consultation scheduling details.
      • Patient Goals: The patient_goals table holds the patient's health goals and concerns.
      • Patient Health Metrics: Data from the patient_health_metrics table includes exercise frequency, diet details, sleep average, and smoking status.
      • Patient Medical History: The patient_medical_history table offers comprehensive medical history information.
    2. Displaying the Additional Data:

      • Each new data set is displayed in its own section with clear headings.
      • Conditional checks (<?php if ($variable): ?>) ensure that sections are only displayed if data exists to prevent empty fields.
      • HTML Structure: Enhanced readability and organization by grouping related information.
    3. Security Enhancements:

      • Data Sanitization: All output data is wrapped with htmlspecialchars() to prevent XSS attacks.
      • Confirm Delete Action: A confirmation dialog is added for the delete action to prevent accidental deletions.
    4. Styling Enhancements:

      • Responsive Design: Improved responsiveness for smaller screens by adjusting font sizes and layout.
      • Consistent Styling: Unified styling across all new sections to maintain a cohesive look and feel.

    Additional Recommendations

    • Edit and Delete Functionality:

      • Ensure that edit_health_record.php, delete_health_record.php, and edit_patient.php are properly secured and handle user inputs safely to prevent SQL injection and other vulnerabilities.
    • Error Handling:

      • Consider adding more robust error handling to inform the admin of any issues during data retrieval or processing.
    • Modular Code:

      • For better maintainability, consider separating the PHP logic from the HTML by using templates or including separate PHP files for different sections.
    • Styling Improvements:

      • You may enhance the UI further by integrating a CSS framework like Bootstrap or using more advanced CSS techniques for better aesthetics and user experience.

    Final Notes

    This updated view_patient.php provides a comprehensive view of the patient's information by integrating multiple data sources from your database. Ensure that all related scripts and functionalities (like editing and deleting records) adhere to best security practices to maintain the integrity and confidentiality of patient data.

    If you encounter any issues or need further customization, feel free to ask!