debug_user.php

<?php
require_once __DIR__ . '/config.php';

if (session_status() === PHP_SESSION_NONE) {
    session_start();
}

$user_id = $_SESSION['user_id'] ?? 0;

$query = "SELECT id, fullname, department, role, staff_id 
          FROM users 
          WHERE id = ?";
          
$stmt = $conn->prepare($query);
$stmt->bind_param('i', $user_id);
$stmt->execute();
$result = $stmt->get_result();

if ($result && $row = $result->fetch_assoc()) {
    echo "Staff User Info:\n";
    echo "ID: " . $row['id'] . "\n";
    echo "Name: " . $row['fullname'] . "\n";
    echo "Department: " . ($row['department'] ?? 'NULL') . "\n";
    echo "Role: " . $row['role'] . "\n";
    echo "Staff ID: " . ($row['staff_id'] ?? 'NULL') . "\n";
} else {
    echo "User not found or error occurred";
}