<?php
error_reporting(E_ALL);
ini_set('display_errors', 1);

include 'config.php';
echo "Starting script...<br>";

// Check if ID is provided
if (isset($_GET['id']) && intval($_GET['id']) > 0) {
    $id = intval($_GET['id']);
    echo "Received ID: $id<br>";

    // Test database connection
    $conn = new mysqli(DB_HOST, DB_USER, DB_PASS, DB_NAME);
    if ($conn->connect_error) {
        die("Database connection failed: " . $conn->connect_error);
    }
    echo "Database connected successfully.<br>";

    // Test fetching data
    $stmt = $conn->prepare("SELECT username FROM admins WHERE id = ?");
    $stmt->bind_param("i", $id);
    $stmt->execute();
    $stmt->bind_result($username);
    if ($stmt->fetch()) {
        echo "User found: $username<br>";
    } else {
        echo "No user found with ID: $id<br>";
    }
    $stmt->close();
    $conn->close();
} else {
    echo "Invalid user ID.<br>";
}
?>