<?php
session_start();
include 'db_connection.php';
include 'auth_check.php'; // Ensure user is logged in
include 'audit_trail.php';

// Get current user data 
$user_id = $_SESSION['id'];
$user_data = [];
$success_message = '';
$error_message = '';

// Fetch user details
$user_query = $conn->prepare("
    SELECT u.username, u.role, u.status, u.created_at,
           m.first_name, m.last_name, m.middle_name, m.surcon_reg_no, 
           m.email, m.phone_no, m.address, m.dob, m.photo, 
           m.position, m.address
    FROM users u 
    LEFT JOIN members m ON u.id = m.user_id 
    WHERE u.id = ?
");
$user_query->bind_param("i", $user_id);
$user_query->execute();
$result = $user_query->get_result();
$user_data = $result->fetch_assoc();
$user_query->close();

// Handle form submission
if ($_SERVER['REQUEST_METHOD'] == 'POST') {
    $first_name = trim($_POST['first_name']);
    $last_name = trim($_POST['last_name']);
    $middle_name = trim($_POST['middle_name']);
    $email = trim($_POST['email']);
    $phone_no = trim($_POST['phone_no']);
    $address = trim($_POST['address']);
    $address = trim($_POST['address']);
    $position = trim($_POST['position']);
    $dob = $_POST['dob'];
    
    // Start transaction
    $conn->begin_transaction();
    
    try {
        // Handle photo upload
        $photo_path = $user_data['photo']; // Keep existing photo by default
        
        if (isset($_FILES['photo']) && $_FILES['photo']['error'] === UPLOAD_ERR_OK) {
            $photo = $_FILES['photo'];
            $photo_name = time() . '_' . basename($photo['name']);
            $photo_target_dir = "uploads/profiles/";
            
            // Create directory if it doesn't exist
            if (!file_exists($photo_target_dir)) {
                mkdir($photo_target_dir, 0777, true);
            }
            
            $photo_target_path = $photo_target_dir . $photo_name;
            
            // Check file type
            $allowed_types = ['image/jpeg', 'image/jpg', 'image/png', 'image/gif'];
            $file_type = mime_content_type($photo['tmp_name']);
            
            if (in_array($file_type, $allowed_types)) {
                if (move_uploaded_file($photo['tmp_name'], $photo_target_path)) {
                    // Delete old photo if it exists and is not the default
                    if (!empty($user_data['photo']) && file_exists($user_data['photo']) && 
                        !str_contains($user_data['photo'], 'default_avatar')) {
                        unlink($user_data['photo']);
                    }
                    $photo_path = $photo_target_path;
                }
            }
        }
        
        // Update members table
        $update_member_query = $conn->prepare("
            UPDATE members 
            SET first_name = ?, last_name = ?, middle_name = ?, 
                email = ?, phone_no = ?, address = ?, address = ?, 
                position = ?, dob = ?, photo = ?, updated_at = NOW() 
            WHERE user_id = ?
        ");
        $update_member_query->bind_param(
            "ssssssssssi", 
            $first_name, $last_name, $middle_name, 
            $email, $phone_no, $address, $address,
            $position, $dob, $photo_path, $user_id
        );
        $update_member_query->execute();
        $update_member_query->close();
        
        // Commit transaction
        $conn->commit();
        
        // Add to audit trail
        if (function_exists('addAuditTrail')) {
            addAuditTrail($conn, $user_id, 'Profile Update', "Updated personal profile information");
        }
        
        $success_message = "Profile updated successfully!";
        
        // Refresh user data
        $user_query = $conn->prepare("
            SELECT u.username, u.role, u.status, u.created_at,
                   m.first_name, m.last_name, m.middle_name, m.surcon_reg_no, 
                   m.email, m.phone_no, m.address, m.dob, m.photo, 
                   m.position, m.address
            FROM users u 
            LEFT JOIN members m ON u.id = m.user_id 
            WHERE u.id = ?
        ");
        $user_query->bind_param("i", $user_id);
        $user_query->execute();
        $result = $user_query->get_result();
        $user_data = $result->fetch_assoc();
        $user_query->close();
        
    } catch (Exception $e) {
        $conn->rollback();
        $error_message = "Failed to update profile: " . $e->getMessage();
    }
}

// Log page access
if (function_exists('addAuditTrail')) {
    addAuditTrail($conn, $user_id, 'Page Access', "Accessed edit profile page");
}
?>
<!DOCTYPE html>
<html lang="en">
<head>
    <meta charset="UTF-8">
    <meta name="viewport" content="width=device-width, initial-scale=1.0">
    <title>Edit Profile - APPSN Imo State</title>
    <link href="https://cdn.jsdelivr.net/npm/bootstrap@5.3.0-alpha1/dist/css/bootstrap.min.css" rel="stylesheet">
    <link rel="stylesheet" href="https://cdnjs.cloudflare.com/ajax/libs/font-awesome/6.4.0/css/all.min.css">
    <link href="https://fonts.googleapis.com/css2?family=Poppins:wght@300;400;500;600;700&display=swap" rel="stylesheet">
    <style>
        :root {
            --primary: #1b6006;
            --primary-light: #2a8c0f;
            --secondary: #6c63ff;
            --accent: #ff6584;
            --success: #28a745;
            --warning: #ffc107;
            --info: #17a2b8;
            --light: #f8f9fa;
            --dark: #343a40;
            --gradient-primary: linear-gradient(135deg, #1b6006 0%, #2a8c0f 100%);
            --gradient-secondary: linear-gradient(135deg, #6c63ff 0%, #8a84ff 100%);
            --shadow: 0 4px 20px rgba(0, 0, 0, 0.08);
            --shadow-hover: 0 8px 30px rgba(0, 0, 0, 0.12);
            --radius: 12px;
        }

        * {
            margin: 0;
            padding: 0;
            box-sizing: border-box;
            font-family: 'Poppins', sans-serif;
        }

        body {
            background-color: #f5f7fb;
            color: #4a5568;
            overflow-x: hidden;
        }

        /* Sidebar Styles */
        .sidebar {
            background: var(--gradient-primary);
            color: white;
            height: 100vh;
            position: fixed;
            width: 280px;
            padding: 20px 0;
            transition: all 0.3s;
            z-index: 1000;
            box-shadow: var(--shadow);
        }

        .sidebar-brand {
            padding: 0 20px 20px;
            text-align: center;
            border-bottom: 1px solid rgba(255, 255, 255, 0.1);
            margin-bottom: 20px;
        }

        .sidebar-brand img {
            width: 60px;
            height: 60px;
            margin-bottom: 10px;
        }

        .sidebar-brand h3 {
            font-size: 1.2rem;
            font-weight: 600;
            margin: 0;
        }

        .sidebar-menu {
            list-style: none;
            padding: 0;
        }

        .sidebar-menu li {
            margin-bottom: 5px;
        }

        .sidebar-menu a {
            color: rgba(255, 255, 255, 0.8);
            text-decoration: none;
            padding: 12px 20px;
            display: flex;
            align-items: center;
            transition: all 0.3s;
            border-radius: 0 30px 30px 0;
            margin-right: 20px;
        }

        .sidebar-menu a:hover, .sidebar-menu a.active {
            background: rgba(255, 255, 255, 0.1);
            color: white;
        }

        .sidebar-menu i {
            margin-right: 12px;
            font-size: 1.2rem;
            width: 24px;
            text-align: center;
        }

        /* Main Content */
        .main-content {
            margin-left: 280px;
            padding: 20px;
            transition: all 0.3s;
            min-height: 100vh;
        }

        /* Top Bar */
        .top-bar {
            background: white;
            border-radius: var(--radius);
            padding: 15px 25px;
            margin-bottom: 20px;
            box-shadow: var(--shadow);
            display: flex;
            justify-content: space-between;
            align-items: center;
        }

        .user-info {
            display: flex;
            align-items: center;
        }

        .user-avatar {
            width: 45px;
            height: 45px;
            border-radius: 50%;
            background: var(--gradient-secondary);
            display: flex;
            align-items: center;
            justify-content: center;
            color: white;
            font-weight: 600;
            margin-right: 15px;
            overflow: hidden;
        }

        .user-avatar img {
            width: 100%;
            height: 100%;
            object-fit: cover;
        }

        /* Edit Form Container */
        .edit-container {
            background: white;
            border-radius: var(--radius);
            padding: 25px;
            box-shadow: var(--shadow);
            margin-bottom: 20px;
        }

        .form-header {
            text-align: center;
            margin-bottom: 25px;
            padding-bottom: 20px;
            border-bottom: 2px solid #f1f5f9;
        }

        .profile-avatar-edit {
            width: 100px;
            height: 100px;
            border-radius: 50%;
            border: 4px solid var(--primary);
            margin: 0 auto 15px;
            overflow: hidden;
            position: relative;
        }

        .profile-avatar-edit img {
            width: 100%;
            height: 100%;
            object-fit: cover;
        }

        .profile-avatar-edit .default-avatar {
            width: 100%;
            height: 100%;
            background: var(--gradient-secondary);
            display: flex;
            align-items: center;
            justify-content: center;
            color: white;
            font-weight: 600;
            font-size: 2rem;
        }

        .avatar-upload {
            position: absolute;
            bottom: 5px;
            right: 5px;
            background: var(--primary);
            color: white;
            border-radius: 50%;
            width: 32px;
            height: 32px;
            display: flex;
            align-items: center;
            justify-content: center;
            cursor: pointer;
            transition: all 0.3s;
            font-size: 0.9rem;
        }

        .avatar-upload:hover {
            background: var(--primary-light);
            transform: scale(1.1);
        }

        .form-section {
            margin-bottom: 25px;
            padding: 20px;
            background: #f8fafc;
            border-radius: var(--radius);
            border-left: 4px solid var(--primary);
        }

        .section-title {
            font-size: 1.1rem;
            font-weight: 600;
            color: var(--primary);
            margin-bottom: 15px;
            display: flex;
            align-items: center;
            gap: 8px;
        }

        .form-control:focus {
            border-color: var(--primary);
            box-shadow: 0 0 0 0.2rem rgba(27, 96, 6, 0.25);
        }

        .form-label {
            font-weight: 600;
            color: #4a5568;
            margin-bottom: 8px;
            font-size: 0.9rem;
        }

        .required::after {
            content: " *";
            color: #dc3545;
        }

        .form-text {
            font-size: 0.8rem;
            color: #6c757d;
        }

        /* Action Buttons */
        .action-buttons {
            display: flex;
            gap: 12px;
            justify-content: center;
            margin-top: 25px;
            flex-wrap: wrap;
        }

        .btn-action {
            padding: 10px 20px;
            border-radius: 8px;
            font-weight: 500;
            font-size: 0.9rem;
            text-decoration: none;
            display: flex;
            align-items: center;
            gap: 8px;
            transition: all 0.3s;
            border: none;
            cursor: pointer;
        }

        .btn-action:hover {
            transform: translateY(-2px);
            box-shadow: var(--shadow-hover);
        }

        .btn-primary {
            background: var(--gradient-primary);
            color: white;
        }

        .btn-secondary {
            background: #6c757d;
            color: white;
        }

        .btn-warning {
            background: var(--warning);
            color: #000;
        }

        /* Read-only fields */
        .readonly-field {
            background-color: #e9ecef;
            opacity: 1;
        }

        /* Responsive */
        @media (max-width: 992px) {
            .sidebar {
                width: 80px;
                text-align: center;
            }
            
            .sidebar-brand h3, .sidebar-menu span {
                display: none;
            }
            
            .sidebar-menu a {
                justify-content: center;
                margin-right: 0;
                border-radius: 10px;
                margin: 0 10px 5px;
                padding: 15px 0;
            }
            
            .sidebar-menu i {
                margin-right: 0;
            }
            
            .main-content {
                margin-left: 80px;
            }
        }

        @media (max-width: 768px) {
            .main-content {
                margin-left: 0;
            }
            
            .top-bar {
                flex-direction: column;
                gap: 15px;
            }
            
            .edit-container {
                padding: 20px;
            }
            
            .form-section {
                padding: 15px;
            }
            
            .action-buttons {
                flex-direction: column;
                align-items: center;
            }
            
            .btn-action {
                width: 100%;
                justify-content: center;
            }
        }

        @media (max-width: 576px) {
            .main-content {
                padding: 15px;
            }
            
            .edit-container {
                padding: 15px;
            }
            
            .profile-avatar-edit {
                width: 80px;
                height: 80px;
            }
            
            .avatar-upload {
                width: 28px;
                height: 28px;
                font-size: 0.8rem;
            }
        }
    </style>
</head>
<body>
    <!-- Sidebar -->
    <div class="sidebar">
        <div class="sidebar-brand">
            <img src="appsn_logo.png" alt="APPSN Logo">
            <h3>APPSN Imo State</h3>
        </div>
        <ul class="sidebar-menu">
            <li><a href="user_dashboard.php"><i class="fas fa-home"></i> <span>Dashboard</span></a></li>
            <li><a href="my_profile.php"><i class="fas fa-user"></i> <span>My Profile</span></a></li>
            <li><a href="#" class="active"><i class="fas fa-edit"></i> <span>Edit Profile</span></a></li>
            <li><a href="request_paper.php"><i class="fas fa-print"></i> <span>Request Paper</span></a></li>
            <li><a href="my_requests.php"><i class="fas fa-file-alt"></i> <span>My Requests</span></a></li>
            <li><a href="member_directory.php"><i class="fas fa-users"></i> <span>Member Directory</span></a></li>
            <li><a href="settings.php"><i class="fas fa-cog"></i> <span>Settings</span></a></li>
            <li><a href="logout.php"><i class="fas fa-sign-out-alt"></i> <span>Logout</span></a></li>
        </ul>
    </div>

    <!-- Main Content -->
    <div class="main-content">
        <!-- Top Bar -->
        <div class="top-bar">
            <div>
                <h4 class="mb-0">Edit Profile</h4>
                <small class="text-muted">Update your personal information</small>
            </div>
            <div class="user-info">
                <div class="user-avatar">
                    <?php if (!empty($user_data['photo']) && file_exists($user_data['photo'])): ?>
                        <img src="<?php echo htmlspecialchars($user_data['photo']); ?>" alt="Profile Photo">
                    <?php else: ?>
                        <?php echo substr($user_data['first_name'] ?? 'M', 0, 1) . substr($user_data['last_name'] ?? 'E', 0, 1); ?>
                    <?php endif; ?>
                </div>
                <div>
                    <div class="user-name"><?php echo htmlspecialchars($user_data['first_name'] . ' ' . $user_data['last_name']); ?></div>
                    <div class="user-role"><?php echo htmlspecialchars($user_data['role']); ?> Member</div>
                </div>
            </div>
        </div>

        <?php if ($success_message): ?>
            <div class="alert alert-success alert-dismissible fade show" role="alert">
                <i class="fas fa-check-circle"></i> 
                <strong>Success!</strong> <?= $success_message ?>
                <button type="button" class="btn-close" data-bs-dismiss="alert"></button>
            </div>
        <?php endif; ?>

        <?php if ($error_message): ?>
            <div class="alert alert-danger alert-dismissible fade show" role="alert">
                <i class="fas fa-exclamation-triangle"></i> 
                <strong>Error!</strong> <?= $error_message ?>
                <button type="button" class="btn-close" data-bs-dismiss="alert"></button>
            </div>
        <?php endif; ?>

        <!-- Edit Form -->
        <div class="edit-container">
            <form method="POST" action="" enctype="multipart/form-data" id="editProfileForm">
                <div class="form-header">
                    <div class="profile-avatar-edit">
                        <?php if (!empty($user_data['photo']) && file_exists($user_data['photo'])): ?>
                            <img src="<?php echo htmlspecialchars($user_data['photo']); ?>" alt="Profile Photo" id="avatarPreview">
                        <?php else: ?>
                            <div class="default-avatar" id="avatarPreview">
                                <?php 
                                $initials = substr($user_data['first_name'] ?? '', 0, 1) . substr($user_data['last_name'] ?? '', 0, 1);
                                echo !empty($initials) ? strtoupper($initials) : 'ME';
                                ?>
                            </div>
                        <?php endif; ?>
                        <label for="photo" class="avatar-upload" title="Change Photo">
                            <i class="fas fa-camera"></i>
                        </label>
                        <input type="file" id="photo" name="photo" accept="image/jpeg,image/jpg,image/png,image/gif" style="display: none;">
                    </div>
                    <h3><?php echo htmlspecialchars($user_data['first_name'] . ' ' . $user_data['last_name']); ?></h3>
                    <p class="text-muted">SURCON: <?php echo htmlspecialchars($user_data['surcon_reg_no']); ?></p>
                </div>

                <!-- Personal Information Section -->
                <div class="form-section">
                    <div class="section-title">
                        <i class="fas fa-user"></i>
                        Personal Information
                    </div>
                    <div class="row">
                        <div class="col-md-4">
                            <div class="mb-3">
                                <label for="first_name" class="form-label required">First Name</label>
                                <input type="text" class="form-control" id="first_name" name="first_name" 
                                       value="<?php echo htmlspecialchars($user_data['first_name']); ?>" required>
                            </div>
                        </div>
                        <div class="col-md-4">
                            <div class="mb-3">
                                <label for="last_name" class="form-label required">Last Name</label>
                                <input type="text" class="form-control" id="last_name" name="last_name" 
                                       value="<?php echo htmlspecialchars($user_data['last_name']); ?>" required>
                            </div>
                        </div>
                        <div class="col-md-4">
                            <div class="mb-3">
                                <label for="middle_name" class="form-label">Middle Name</label>
                                <input type="text" class="form-control" id="middle_name" name="middle_name" 
                                       value="<?php echo htmlspecialchars($user_data['middle_name'] ?? ''); ?>">
                            </div>
                        </div>
                    </div>
                    
                    <div class="row">
                        <div class="col-md-6">
                            <div class="mb-3">
                                <label for="surcon_reg_no" class="form-label">SURCON Registration No.</label>
                                <input type="text" class="form-control readonly-field" id="surcon_reg_no" 
                                       value="<?php echo htmlspecialchars($user_data['surcon_reg_no']); ?>" readonly>
                                <div class="form-text">SURCON number cannot be changed</div>
                            </div>
                        </div>
                        <div class="col-md-6">
                            <div class="mb-3">
                                <label for="dob" class="form-label">Date of Birth</label>
                                <input type="date" class="form-control" id="dob" name="dob" 
                                       value="<?php echo htmlspecialchars($user_data['dob'] ?? ''); ?>">
                            </div>
                        </div>
                    </div>
                    
                    <div class="mb-3">
                        <label for="position" class="form-label">Position/Title</label>
                        <input type="text" class="form-control readonly-field" id="position" name="position" 
                               value="<?php echo htmlspecialchars($user_data['position'] ?? ''); ?>" readonly
                               placeholder="e.g., Registered Surveyor, Principal Partner">
                        <div class="form-text">Your position in APPSN CANNOT be changed here</div>
                    </div>
                </div>

                <!-- Contact Information Section -->
                <div class="form-section">
                    <div class="section-title">
                        <i class="fas fa-address-book"></i>
                        Contact Information
                    </div>
                    <div class="row">
                        <div class="col-md-6">
                            <div class="mb-3">
                                <label for="email" class="form-label required">Email Address</label>
                                <input type="email" class="form-control" id="email" name="email" 
                                       value="<?php echo htmlspecialchars($user_data['email']); ?>" required>
                            </div>
                        </div>
                        <div class="col-md-6">
                            <div class="mb-3">
                                <label for="phone_no" class="form-label required">Phone Number</label>
                                <input type="tel" class="form-control" id="phone_no" name="phone_no" 
                                       value="<?php echo htmlspecialchars($user_data['phone_no']); ?>" required>
                            </div>
                        </div>
                    </div>
                    
                    <div class="mb-3">
                        <label for="address" class="form-label">Residential Address</label>
                        <textarea class="form-control" id="address" name="address" rows="2"><?php echo htmlspecialchars($user_data['address'] ?? ''); ?></textarea>
                    </div>
                    
                    <div class="mb-3">
                        <label for="address" class="form-label">Office Address</label>
                        <textarea class="form-control" id="address" name="address" rows="2"><?php echo htmlspecialchars($user_data['address'] ?? ''); ?></textarea>
                        <div class="form-text">Your professional office location</div>
                    </div>
                </div>

                <!-- Account Information Section -->
                <div class="form-section">
                    <div class="section-title">
                        <i class="fas fa-user-cog"></i>
                        Account Information
                    </div>
                    <div class="row">
                        <div class="col-md-6">
                            <div class="mb-3">
                                <label for="username" class="form-label">Username</label>
                                <input type="text" class="form-control readonly-field" id="username" 
                                       value="<?php echo htmlspecialchars($user_data['username']); ?>" readonly>
                                <div class="form-text">Username is auto-generated from SURCON number</div>
                            </div>
                        </div>
                        <div class="col-md-6">
                            <div class="mb-3">
                                <label for="role" class="form-label">Role</label>
                                <input type="text" class="form-control readonly-field" id="role" 
                                       value="<?php echo htmlspecialchars($user_data['role']); ?>" readonly>
                                <div class="form-text">Account role cannot be changed</div>
                            </div>
                        </div>
                    </div>
                </div>

                <!-- Action Buttons -->
                <div class="action-buttons">
                    <a href="my_profile.php" class="btn-action btn-secondary">
                        <i class="fas fa-arrow-left"></i> Back to Profile
                    </a>
                    <button type="reset" class="btn-action btn-warning">
                        <i class="fas fa-undo"></i> Reset Changes
                    </button>
                    <button type="submit" class="btn-action btn-primary">
                        <i class="fas fa-save"></i> Update Profile
                    </button>
                </div>
            </form>
        </div>
    </div>

    <script src="https://cdn.jsdelivr.net/npm/bootstrap@5.3.0-alpha1/dist/js/bootstrap.bundle.min.js"></script>
    <script>
        document.addEventListener('DOMContentLoaded', function() {
            // Photo upload preview
            const photoInput = document.getElementById('photo');
            const avatarPreview = document.getElementById('avatarPreview');
            
            photoInput.addEventListener('change', function(e) {
                const file = e.target.files[0];
                if (file) {
                    const reader = new FileReader();
                    reader.onload = function(e) {
                        if (avatarPreview.classList.contains('default-avatar')) {
                            avatarPreview.classList.remove('default-avatar');
                            avatarPreview.innerHTML = `<img src="${e.target.result}" alt="Profile Photo" style="width: 100%; height: 100%; object-fit: cover;">`;
                        } else {
                            avatarPreview.querySelector('img').src = e.target.result;
                        }
                    };
                    reader.readAsDataURL(file);
                }
            });

            // Form validation
            const form = document.getElementById('editProfileForm');
            form.addEventListener('submit', function(e) {
                let isValid = true;
                const requiredFields = form.querySelectorAll('[required]');
                
                requiredFields.forEach(field => {
                    if (!field.value.trim()) {
                        isValid = false;
                        field.classList.add('is-invalid');
                    } else {
                        field.classList.remove('is-invalid');
                    }
                });

                if (!isValid) {
                    e.preventDefault();
                    alert('Please fill in all required fields.');
                }
            });

            // Reset form
            form.addEventListener('reset', function() {
                // Reset photo preview
                const originalPhoto = "<?php echo !empty($user_data['photo']) && file_exists($user_data['photo']) ? htmlspecialchars($user_data['photo']) : ''; ?>";
                if (originalPhoto) {
                    if (avatarPreview.classList.contains('default-avatar')) {
                        avatarPreview.classList.remove('default-avatar');
                        avatarPreview.innerHTML = `<img src="${originalPhoto}" alt="Profile Photo" style="width: 100%; height: 100%; object-fit: cover;">`;
                    } else {
                        avatarPreview.querySelector('img').src = originalPhoto;
                    }
                } else {
                    const initials = "<?php echo substr($user_data['first_name'] ?? '', 0, 1) . substr($user_data['last_name'] ?? '', 0, 1); ?>";
                    avatarPreview.className = 'default-avatar';
                    avatarPreview.innerHTML = initials || 'ME';
                }
                
                // Clear file input
                photoInput.value = '';
                
                // Remove validation styles
                const invalidFields = form.querySelectorAll('.is-invalid');
                invalidFields.forEach(field => {
                    field.classList.remove('is-invalid');
                });
            });

            // Add animation to form sections
            const formSections = document.querySelectorAll('.form-section');
            formSections.forEach((section, index) => {
                section.style.opacity = '0';
                section.style.transform = 'translateY(20px)';
                
                setTimeout(() => {
                    section.style.transition = 'opacity 0.5s ease, transform 0.5s ease';
                    section.style.opacity = '1';
                    section.style.transform = 'translateY(0)';
                }, index * 100);
            });

            // Track form submission for audit trail
            form.addEventListener('submit', function() {
                fetch('track_user_action.php', {
                    method: 'POST',
                    headers: {
                        'Content-Type': 'application/x-www-form-urlencoded',
                    },
                    body: 'action=Profile Update&page=edit_profile'
                }).catch(error => console.error('Tracking error:', error));
            });
        });
    </script>
</body>
</html>
<?php
// Close database connection
$conn->close();
?>