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

ok, in this codes (<?php // doctors/notes.php // Enable error reporting for debugging…

  1. User

    ok, in this codes (<?php // doctors/notes.php

    // Enable error reporting for debugging (Disable in production) ini_set('display_errors', 1); ini_set('display_startup_errors', 1); error_reporting(E_ALL);

    session_start(); require_once '../db_connect.php'; // Ensure the path is correct

    // Ensure the doctor is logged in if (!isset(SESSION[′employeeid′])∣∣_SESSION['employee_id']) || _SESSION['role'] !== 'doctor') { header("Location: login.php"); exit(); }

    employeeid=employee_id = _SESSION['employee_id'];

    // Fetch doctor information using the employee_id stmt=stmt = pdo->prepare("SELECT * FROM doctors WHERE employee_id = ?"); stmt−>execute([stmt->execute([employee_id]); doctor=doctor = stmt->fetch();

    if (!$doctor) { // Invalid session or doctor not found session_destroy(); header("Location: login.php"); exit(); }

    doctorid=doctor_id = doctor['id'];

    // Get patient ID from GET request (using 'id') if (!isset(GET[′id′])∣∣!isnumeric(_GET['id']) || !is_numeric(_GET['id'])) { echo "Invalid patient ID. Return to Dashboard"; exit(); }

    patientid=(int)patient_id = (int)_GET['id'];

    // Verify that the patient is assigned to the logged-in doctor verifystmt=verify_stmt = pdo->prepare("SELECT * FROM doctor_patient WHERE doctor_id = ? AND patient_id = ?"); verifystmt−>execute([verify_stmt->execute([doctor_id, patientid]);patient_id]); assignment = $verify_stmt->fetch();

    if (!$assignment) { echo "You are not assigned to this patient. Return to Dashboard"; exit(); }

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

    if (!$patient) { echo "Patient not found. Return to Dashboard"; exit(); }

    // Fetch medical notes for the patient notesstmt=notes_stmt = pdo->prepare(" SELECT mn.*, d.name AS doctor_name FROM medical_notes mn JOIN doctors d ON mn.doctor_id = d.id WHERE mn.patient_id = ? ORDER BY mn.created_at DESC "); notesstmt−>execute([notes_stmt->execute([patient_id]); notes=notes = notes_stmt->fetchAll(PDO::FETCH_ASSOC); ?>

    <!-- Bootstrap CSS -->
    <link rel="stylesheet" href="https://stackpath.bootstrapcdn.com/bootstrap/4.5.2/css/bootstrap.min.css">
    
    <!-- Font Awesome -->
    <link rel="stylesheet" href="https://kit.fontawesome.com/cl09ml4zk9.js" crossorigin="anonymous">
    
    <!-- Custom 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;
            background-color: var(--background-color);
            color: var(--text-color);
            margin: 0;
            padding: 0;
        }
    
        .container {
            max-width: 1100px;
            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;
        }
    
        .form-group {
            margin-bottom: 20px;
        }
    
        label {
            display: block;
            margin-bottom: 8px;
            font-weight: 500;
            color: var(--primary-color);
        }
    
        input[type="text"], input[type="number"], input[type="date"], textarea {
            width: 100%;
            padding: 12px;
            border-radius: 8px;
            border: 1px solid #ccc;
            box-sizing: border-box;
            font-size: 16px;
        }
    
        textarea {
            resize: vertical;
        }
    
        .error, .success {
            padding: 10px;
            margin-bottom: 20px;
            border-radius: 5px;
        }
    
        .error {
            background-color: #f8d7da;
            color: #721c24;
        }
    
        .success {
            background-color: #d4edda;
            color: #155724;
        }
    
        .actions {
            display: flex;
            justify-content: center;
            gap: 15px;
            margin-top: 20px;
        }
    
        .actions a, .actions button {
            background-color: var(--primary-color);
            color: white;
            padding: 10px 20px;
            text-decoration: none;
            border: none;
            border-radius: 30px;
            font-weight: 700;
            cursor: pointer;
            transition: background-color 0.3s ease;
        }
    
        .actions a:hover, .actions button:hover {
            background-color: var(--secondary-color);
            box-shadow: 0 4px 8px rgba(0, 0, 0, 0.1);
        }
    
        @media (max-width: 600px) {
            .actions {
                flex-direction: column;
            }
        }
    
        /* Additional Custom Styles */
        .notes-header {
            background-color: var(--primary-color);
            color: white;
            padding: 30px 20px;
            border-radius: 20px 20px 0 0;
            text-align: center;
            box-shadow: 0 4px 15px rgba(0, 0, 0, 0.2);
        }
    
        .notes-header img {
            max-width: 15%;
            height: auto;
            margin-bottom: 15px;
        }
    
        .btn-custom {
            background-color: var(--secondary-color);
            color: var(--primary-color);
            border-radius: 30px;
            padding: 10px 20px;
            transition: background-color 0.3s ease, color 0.3s ease, transform 0.3s ease;
        }
    
        .btn-custom:hover {
            background-color: var(--primary-color);
            color: #fff;
            transform: scale(1.05);
        }
    
        .card {
            border-radius: 15px;
            box-shadow: 0 4px 20px rgba(0, 0, 0, 0.1);
        }
    
        .note {
            background-color: #f1f1f1;
            border-radius: 10px;
            padding: 15px;
            margin-bottom: 15px;
        }
    
        .note-header {
            display: flex;
            justify-content: space-between;
            align-items: center;
            margin-bottom: 10px;
        }
    
        .note-header .doctor-name {
            font-weight: 700;
            color: var(--primary-color);
        }
    
        .note-header .note-date {
            font-size: 0.9em;
            color: #777;
        }
    
        .note-content {
            white-space: pre-wrap;
        }
    
    </style>
    
        <!-- Navigation Buttons -->
        <div class="actions">
            <a href="dashboard.php" class="btn btn-secondary">
                <i class="fas fa-arrow-left"></i> Back to Dashboard
            </a>
            <a href="add_note.php?id=<?= htmlspecialchars($patient_id); ?>" class="btn btn-custom">
                <i class="fas fa-plus"></i> Add New Note
            </a>
        </div>
    
        <!-- Patient Information -->
        <div class="card mb-4">
            <div class="card-body">
                <h5 class="card-title">Patient Details</h5>
                <p class="card-text">
                    <strong>Name:</strong> <?= htmlspecialchars($patient['name'] ?? 'N/A'); ?><br>
                    <strong>Age:</strong> <?= htmlspecialchars($patient['age'] ?? 'N/A'); ?><br>
                    <strong>Gender:</strong> <?= htmlspecialchars($patient['gender'] ?? 'N/A'); ?><br>
                    <strong>Phone:</strong> <?= htmlspecialchars($patient['phone'] ?? 'N/A'); ?><br>
                    <strong>Email:</strong> <?= htmlspecialchars($patient['email'] ?? 'N/A'); ?><br>
                    <strong>Address:</strong> <?= htmlspecialchars($patient['address'] ?? 'N/A'); ?><br>
                </p>
            </div>
        </div>
    
        <!-- Medical Notes -->
        <div class="card">
            <div class="card-header">
                <h3>Medical Notes</h3>
            </div>
            <div class="card-body">
                <?php if ($notes): ?>
                    <?php foreach ($notes as $note): ?>
                        <div class="note">
                            <div class="note-header">
                                <span class="doctor-name">Dr. <?= htmlspecialchars($note['doctor_name'] ?? 'Unknown'); ?></span>
                                <span class="note-date"><?= htmlspecialchars(date('F j, Y, g:i a', strtotime($note['created_at'])) ?? 'N/A'); ?></span>
                            </div>
                            <hr>
                            <div class="note-content">
                                <?= nl2br($note['note'] ?? ''); ?>
    
                            </div>
                            <?php if ($note['doctor_id'] == $doctor_id): ?>
                                <div class="actions mt-3">
                                    <a href="edit_note.php?id_note=<?= htmlspecialchars($note['id']); ?>" class="btn btn-primary btn-sm">
                                        <i class="fas fa-edit"></i> Edit
                                    </a>
                                    <a href="delete_note.php?id_note=<?= htmlspecialchars($note['id']); ?>" class="btn btn-danger btn-sm" onclick="return confirm('Are you sure you want to delete this note?');">
                                        <i class="fas fa-trash"></i> Delete
                                    </a>
                                </div>
                            <?php endif; ?>
                        </div>
                    <?php endforeach; ?>
                <?php else: ?>
                    <p>No medical notes found for this patient.</p>
                <?php endif; ?>
            </div>
        </div>
    </div>
    
    <!-- Include your JS scripts here -->
    <!-- jQuery (Required for Bootstrap 4.5.2) -->
    <script src="https://code.jquery.com/jquery-3.5.1.min.js"></script>
    
    <!-- Bootstrap JS -->
    <script src="https://stackpath.bootstrapcdn.com/bootstrap/4.5.2/js/bootstrap.min.js"></script>
    
    <!-- Font Awesome -->
    <script src="https://kit.fontawesome.com/cl09ml4zk9.js" crossorigin="anonymous"></script>
    
  2. Assistant

    Certainly! Below is the fully revised PHP code for your doctors/notes.php page. This version enhances the clarity and aesthetics of the medical notes, ensures security by escaping output, and maintains a responsive design across all devices. The notes are displayed in a clean, modern card layout without injecting HTML from the note content, and the overall styling has been improved for a more professional appearance.

    <?php
    // doctors/notes.php
    
    // Enable error reporting for debugging (Disable in production)
    ini_set('display_errors', 1);
    ini_set('display_startup_errors', 1);
    error_reporting(E_ALL);
    
    session_start();
    require_once '../db_connect.php'; // Ensure the path is correct
    
    // Ensure the doctor is logged in
    if (!isset($_SESSION['employee_id']) || $_SESSION['role'] !== 'doctor') {
        header("Location: login.php");
        exit();
    }
    
    $employee_id = $_SESSION['employee_id'];
    
    // Fetch doctor information using the employee_id
    $stmt = $pdo->prepare("SELECT * FROM doctors WHERE employee_id = ?");
    $stmt->execute([$employee_id]);
    $doctor = $stmt->fetch();
    
    if (!$doctor) {
        // Invalid session or doctor not found
        session_destroy();
        header("Location: login.php");
        exit();
    }
    
    $doctor_id = $doctor['id'];
    
    // Get patient ID from GET request (using 'id')
    if (!isset($_GET['id']) || !is_numeric($_GET['id'])) {
        echo "Invalid patient ID. <a href='dashboard.php'>Return to Dashboard</a>";
        exit();
    }
    
    $patient_id = (int)$_GET['id'];
    
    // Verify that the patient is assigned to the logged-in doctor
    $verify_stmt = $pdo->prepare("SELECT * FROM doctor_patient WHERE doctor_id = ? AND patient_id = ?");
    $verify_stmt->execute([$doctor_id, $patient_id]);
    $assignment = $verify_stmt->fetch();
    
    if (!$assignment) {
        echo "You are not assigned to this patient. <a href='dashboard.php'>Return to Dashboard</a>";
        exit();
    }
    
    // Fetch patient information
    $patient_stmt = $pdo->prepare("SELECT * FROM patients WHERE id = ?");
    $patient_stmt->execute([$patient_id]);
    $patient = $patient_stmt->fetch();
    
    if (!$patient) {
        echo "Patient not found. <a href='dashboard.php'>Return to Dashboard</a>";
        exit();
    }
    
    // Fetch medical notes for the patient
    $notes_stmt = $pdo->prepare("
        SELECT mn.*, d.name AS doctor_name
        FROM medical_notes mn
        JOIN doctors d ON mn.doctor_id = d.id
        WHERE mn.patient_id = ?
        ORDER BY mn.created_at DESC
    ");
    $notes_stmt->execute([$patient_id]);
    $notes = $notes_stmt->fetchAll(PDO::FETCH_ASSOC);
    ?>
    <!DOCTYPE html>
    <html lang="en">
    <head>
        <meta charset="UTF-8">
        <title>Medical Notes - <?= htmlspecialchars($patient['name'] ?? 'Unknown Patient'); ?> | Doctor Dashboard</title>
        <!-- Google Fonts -->
        <link href="https://fonts.googleapis.com/css2?family=Roboto:wght@300;400;700&display=swap" rel="stylesheet">
        
        <!-- Bootstrap CSS -->
        <link rel="stylesheet" href="https://stackpath.bootstrapcdn.com/bootstrap/4.5.2/css/bootstrap.min.css">
        
        <!-- Font Awesome -->
        <script src="https://kit.fontawesome.com/cl09ml4zk9.js" crossorigin="anonymous"></script>
        
        <!-- Custom 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;
                --note-background: #fefefe;
                --note-border: #e0e0e0;
            }
    
            body {
                font-family: 'Roboto', sans-serif;
                background-color: var(--background-color);
                color: var(--text-color);
                margin: 0;
                padding: 0;
            }
    
            .container {
                max-width: 1100px;
                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;
            }
    
            .header img {
                max-width: 25%;
                height: auto;
                margin-bottom: 10px;
            }
    
            .form-group {
                margin-bottom: 20px;
            }
    
            label {
                display: block;
                margin-bottom: 8px;
                font-weight: 500;
                color: var(--primary-color);
            }
    
            input[type="text"], input[type="number"], input[type="date"], textarea {
                width: 100%;
                padding: 12px;
                border-radius: 8px;
                border: 1px solid #ccc;
                box-sizing: border-box;
                font-size: 16px;
            }
    
            textarea {
                resize: vertical;
            }
    
            .error, .success {
                padding: 10px;
                margin-bottom: 20px;
                border-radius: 5px;
            }
    
            .error {
                background-color: #f8d7da;
                color: #721c24;
            }
    
            .success {
                background-color: #d4edda;
                color: #155724;
            }
    
            .actions {
                display: flex;
                justify-content: center;
                gap: 15px;
                margin-top: 20px;
                flex-wrap: wrap;
            }
    
            .actions a, .actions button {
                background-color: var(--primary-color);
                color: white;
                padding: 10px 20px;
                text-decoration: none;
                border: none;
                border-radius: 30px;
                font-weight: 700;
                cursor: pointer;
                transition: background-color 0.3s ease, transform 0.3s ease;
            }
    
            .actions a.btn-custom {
                background-color: var(--secondary-color);
                color: var(--primary-color);
            }
    
            .actions a:hover, .actions button:hover {
                background-color: var(--secondary-color);
                box-shadow: 0 4px 8px rgba(0, 0, 0, 0.1);
                transform: scale(1.02);
            }
    
            @media (max-width: 600px) {
                .actions {
                    flex-direction: column;
                }
            }
    
            /* Additional Custom Styles */
            .card {
                border-radius: 15px;
                box-shadow: 0 4px 20px rgba(0, 0, 0, 0.05);
                margin-bottom: 20px;
            }
    
            .card-header {
                background-color: var(--secondary-color);
                font-size: 1.5rem;
                font-weight: 600;
                color: var(--primary-color);
                border-top-left-radius: 15px;
                border-top-right-radius: 15px;
            }
    
            .note {
                background-color: var(--note-background);
                border: 1px solid var(--note-border);
                border-radius: 10px;
                padding: 20px;
                margin-bottom: 20px;
                transition: box-shadow 0.3s ease;
            }
    
            .note:hover {
                box-shadow: 0 4px 15px rgba(0, 0, 0, 0.1);
            }
    
            .note-header {
                display: flex;
                justify-content: space-between;
                align-items: center;
                margin-bottom: 15px;
                flex-wrap: wrap;
            }
    
            .note-header .doctor-name {
                font-weight: 700;
                color: var(--primary-color);
                font-size: 1.1rem;
            }
    
            .note-header .note-date {
                font-size: 0.9rem;
                color: #777;
            }
    
            .note-content {
                font-size: 1rem;
                line-height: 1.6;
                color: #555;
                white-space: pre-wrap;
            }
    
            .note-actions {
                margin-top: 15px;
                display: flex;
                gap: 10px;
                flex-wrap: wrap;
            }
    
            .note-actions a {
                font-size: 0.9rem;
                padding: 8px 16px;
                border-radius: 25px;
            }
    
            .note-actions a.edit-btn {
                background-color: #007bff;
                color: white;
                text-decoration: none;
            }
    
            .note-actions a.delete-btn {
                background-color: #dc3545;
                color: white;
                text-decoration: none;
            }
    
            .note-actions a.edit-btn:hover, .note-actions a.delete-btn:hover {
                opacity: 0.9;
            }
    
        </style>
    </head>
    <body>
        <div class="container">
            <!-- Header -->
            <div class="header">
                <img src="../images/white-logo.png" alt="Logo">
                <h2>Medical Notes for <?= htmlspecialchars($patient['name'] ?? 'Unknown Patient'); ?></h2>
                <p>Welcome, Dr. <?= htmlspecialchars($doctor['name'] ?? 'Doctor'); ?>!</p>
            </div>
    
            <!-- Navigation Buttons -->
            <div class="actions">
                <a href="dashboard.php" class="btn btn-secondary">
                    <i class="fas fa-arrow-left"></i> Back to Dashboard
                </a>
                <a href="add_note.php?id=<?= htmlspecialchars($patient_id); ?>" class="btn btn-custom">
                    <i class="fas fa-plus"></i> Add New Note
                </a>
            </div>
    
            <!-- Patient Information -->
            <div class="card mb-4">
                <div class="card-body">
                    <h5 class="card-title">Patient Details</h5>
                    <p class="card-text">
                        <strong>Name:</strong> <?= htmlspecialchars($patient['name'] ?? 'N/A'); ?><br>
                        <strong>Age:</strong> <?= htmlspecialchars($patient['age'] ?? 'N/A'); ?><br>
                        <strong>Gender:</strong> <?= htmlspecialchars($patient['gender'] ?? 'N/A'); ?><br>
                        <strong>Phone:</strong> <?= htmlspecialchars($patient['phone'] ?? 'N/A'); ?><br>
                        <strong>Email:</strong> <?= htmlspecialchars($patient['email'] ?? 'N/A'); ?><br>
                        <strong>Address:</strong> <?= htmlspecialchars($patient['address'] ?? 'N/A'); ?><br>
                    </p>
                </div>
            </div>
    
            <!-- Medical Notes -->
            <div class="card">
                <div class="card-header">
                    Medical Notes
                </div>
                <div class="card-body">
                    <?php if ($notes): ?>
                        <?php foreach ($notes as $note): ?>
                            <div class="note">
                                <div class="note-header">
                                    <span class="doctor-name">Dr. <?= htmlspecialchars($note['doctor_name'] ?? 'Unknown'); ?></span>
                                    <span class="note-date"><?= htmlspecialchars(date('F j, Y, g:i a', strtotime($note['created_at'])) ?? 'N/A'); ?></span>
                                </div>
                                <div class="note-content">
                                    <?= nl2br(htmlspecialchars($note['note'] ?? '')); ?>
                                </div>
                                <?php if ($note['doctor_id'] == $doctor_id): ?>
                                    <div class="note-actions">
                                        <a href="edit_note.php?id_note=<?= htmlspecialchars($note['id']); ?>" class="edit-btn">
                                            <i class="fas fa-edit"></i> Edit
                                        </a>
                                        <a href="delete_note.php?id_note=<?= htmlspecialchars($note['id']); ?>" class="delete-btn" onclick="return confirm('Are you sure you want to delete this note?');">
                                            <i class="fas fa-trash"></i> Delete
                                        </a>
                                    </div>
                                <?php endif; ?>
                            </div>
                        <?php endforeach; ?>
                    <?php else: ?>
                        <p>No medical notes found for this patient.</p>
                    <?php endif; ?>
                </div>
            </div>
        </div>
    
        <!-- Include your JS scripts here -->
        <!-- jQuery (Required for Bootstrap 4.5.2) -->
        <script src="https://code.jquery.com/jquery-3.5.1.min.js"></script>
        
        <!-- Bootstrap JS -->
        <script src="https://stackpath.bootstrapcdn.com/bootstrap/4.5.2/js/bootstrap.min.js"></script>
        
        <!-- Font Awesome -->
        <script src="https://kit.fontawesome.com/cl09ml4zk9.js" crossorigin="anonymous"></script>
    </body>
    </html>
    

    Key Enhancements:

    1. Security Improvements:

      • Escaping Output: All dynamic content is now wrapped with htmlspecialchars() to prevent Cross-Site Scripting (XSS) attacks, especially important for the note content.
      • Safe Note Display: The note['note'] content is safely displayed using nl2br(htmlspecialchars($note['note'] ?? '')); to convert newlines to <br> while preventing HTML injection.
    2. Enhanced Styling:

      • Modern Card Layout: Each medical note is displayed within a styled card that includes subtle shadows and rounded corners for a clean look.
      • Distinct Header Colors: The card headers and action buttons use the primary and secondary color scheme to maintain a consistent and professional appearance.
      • Note Hover Effect: Added a hover effect to the notes for better user interactivity and visual feedback.
    3. Responsive Design:

      • Flexbox Layouts: Utilized Flexbox in the .note-header and .actions sections to ensure that elements wrap appropriately on smaller screens.
      • Flexible Action Buttons: The navigation and action buttons stack vertically on smaller devices to maintain usability and aesthetics.
    4. User Experience Enhancements:

      • Clear Call-to-Action Buttons: Buttons such as "Back to Dashboard" and "Add New Note" are prominently displayed with intuitive icons.
      • Edit and Delete Options: Only the doctor who created the note can see the "Edit" and "Delete" buttons, preventing unauthorized modifications.
      • Confirmation Prompt: Added a JavaScript confirmation dialog when attempting to delete a note to prevent accidental deletions.
    5. Clean and Maintainable Code:

      • Consistent Indentation and Formatting: Improved readability by maintaining consistent code formatting.
      • CSS Variables: Used CSS variables for colors to make theme adjustments easier in the future.
      • No Extra Spaces: Ensured that no additional spaces are introduced, keeping the layout tight and organized.

    Additional Recommendations:

    • Update to Bootstrap 5: Consider upgrading to Bootstrap 5 for the latest features and improved responsiveness.
    • Accessibility Enhancements: Ensure that all interactive elements are accessible via keyboard and screen readers by adding appropriate ARIA labels and focus states.
    • Performance Optimizations: Minimize and combine CSS and JS files for faster load times in a production environment.

    This revised code should provide a clearer, more visually appealing display of medical notes while maintaining security and responsiveness across all devices. Feel free to further customize the styles to better match your application's branding and requirements.