<?php
$pdo = new PDO('mysql:host=127.0.0.1;dbname=bd_insuite_backbones', 'root', '');
$users = $pdo->query("SELECT id, name, email, role_key FROM users ORDER BY id")->fetchAll(PDO::FETCH_ASSOC);

echo "=== Utilisateurs dans la base ===\n\n";
foreach ($users as $u) {
    echo "ID: " . $u['id'] . "\n";
    echo "Nom: " . $u['name'] . "\n";
    echo "Email: [" . $u['email'] . "]\n";
    echo "Email length: " . strlen($u['email']) . " caractères\n";
    echo "Role: " . $u['role_key'] . "\n";
    echo "---\n";
}