prepare('SELECT id, name, email, role, agent_tier, cumulative_bookings, phone, company, notes FROM users WHERE id = ?'); $stmt->execute([$user_id]); $user = $stmt->fetch(PDO::FETCH_ASSOC); if (!$user) { header('Location: admin_dashboard.php?error=user_not_found'); exit; } } if ($_SERVER['REQUEST_METHOD'] === 'POST') { $name = $_POST['name']; $email = $_POST['email']; $role = $_POST['role']; $agent_tier = $_POST['agent_tier']; $phone = $_POST['phone']; $company = $_POST['company']; $notes = $_POST['notes']; $user_id = $_POST['user_id']; if (empty($name) || empty($email) || empty($role)) { header('Location: edit_user.php?id=' . $user_id . '&error=empty_fields'); exit; } $db = db(); $stmt = $db->prepare('UPDATE users SET name = ?, email = ?, role = ?, agent_tier = ?, phone = ?, company = ?, notes = ? WHERE id = ?'); $stmt->execute([$name, $email, $role, $agent_tier, $phone, $company, $notes, $user_id]); header('Location: admin_dashboard.php'); exit; } ?>