getConnection(); echo ""; echo ""; echo "

🔍 Structure de la table 'utilisateurs'

"; echo "

📊 Colonnes de la table

"; echo ""; echo ""; $stmt = $db->query("DESCRIBE utilisateurs"); $columns = $stmt->fetchAll(PDO::FETCH_ASSOC); foreach ($columns as $col) { $null_status = $col['Null'] == 'NO' ? "NON (obligatoire)" : "OUI"; $default = $col['Default'] ?? 'NULL'; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; } echo "

Colonne	Type	NULL autorisé	Valeur par défaut	Extra
{$col['Field']}	{$col['Type']}	$null_status	$default	{$col['Extra']}

"; echo "

📋 Utilisateurs existants (5 premiers)

"; $stmt = $db->query("SELECT * FROM utilisateurs LIMIT 5"); $users = $stmt->fetchAll(PDO::FETCH_ASSOC); if (!empty($users)) { echo ""; echo ""; foreach (array_keys($users[0]) as $key) { echo ""; } echo ""; foreach ($users as $row) { echo ""; foreach ($row as $value) { echo ""; } echo ""; } echo "

$key
" . htmlspecialchars($value ?? 'NULL') . "

"; } echo ""; ?>