<?php
$pdo = new PDO('mysql:host=127.0.0.1;dbname=bd_insuite_backbones', 'root', '', [
    PDO::ATTR_ERRMODE => PDO::ERRMODE_EXCEPTION,
]);

$output = "-- Export de la table users\n";
$output .= "-- Date: " . date('Y-m-d H:i:s') . "\n\n";

// Structure de la table
$output .= "-- Structure de la table `users`\n";
$createTable = $pdo->query("SHOW CREATE TABLE users")->fetch(PDO::FETCH_ASSOC);
$output .= $createTable['Create Table'] . ";\n\n";

// Données de la table
$output .= "-- Données de la table `users`\n";
$rows = $pdo->query("SELECT * FROM users ORDER BY id")->fetchAll(PDO::FETCH_ASSOC);

if (!empty($rows)) {
    $columns = array_keys($rows[0]);
    $output .= "INSERT INTO `users` (`" . implode("`, `", $columns) . "`) VALUES\n";
    
    $values = [];
    foreach ($rows as $row) {
        $rowValues = [];
        foreach ($row as $value) {
            if ($value === null) {
                $rowValues[] = 'NULL';
            } else {
                $rowValues[] = "'" . addslashes($value) . "'";
            }
        }
        $values[] = "(" . implode(", ", $rowValues) . ")";
    }
    $output .= implode(",\n", $values) . ";\n";
}

// Sauvegarder dans un fichier
$filename = 'users_table_export_' . date('Ymd_His') . '.sql';
file_put_contents($filename, $output);

echo "✓ Export réussi : $filename\n";
echo "Nombre d'utilisateurs exportés : " . count($rows) . "\n\n";
echo "Aperçu des utilisateurs :\n";
foreach ($rows as $row) {
    echo "- ID {$row['id']}: {$row['name']} ({$row['email']}) - Role: {$row['role_key']}\n";
}