<?php
$pdo = new PDO('mysql:host=127.0.0.1;dbname=bd_insuite_backbones', 'root', '');
$cols = $pdo->query('DESCRIBE users')->fetchAll(PDO::FETCH_ASSOC);
foreach ($cols as $col) {
    echo $col['Field'] . " - " . $col['Type'] . "\n";
}

echo "\n--- Utilisateurs existants ---\n";
$users = $pdo->query("SELECT id, name, email, role_key FROM users")->fetchAll(PDO::FETCH_ASSOC);
foreach ($users as $u) {
    echo $u['id'] . " | " . $u['name'] . " | " . $u['email'] . " | " . $u['role_key'] . "\n";
}
