<?php
// Database config - update these to match your server
$host = 'localhost';
$user = 'yourusername';       // your DB username
$pass = 'yourpassword';           // your DB password
$name = 'yourusername_connect_store'; // your DB name

try {
    $pdo = new PDO("mysql:host=$host;dbname=$name;charset=utf8mb4", $user, $pass);
    $pdo->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);

    $username = 'Admin';
    $email    = 'admin@nex.com';
    $password = password_hash('Admin1234', PASSWORD_DEFAULT);
    $role     = 'superadmin';

    $pdo->prepare("INSERT INTO admins (username, email, password, role) VALUES (?, ?, ?, ?)")
        ->execute([$username, $email, $password, $role]);

    echo "✅ Admin created successfully!<br>";
    echo "Email: <strong>$email</strong><br>";
    echo "Password: <strong>Admin1234</strong><br><br>";
    echo "<strong style='color:red;'>DELETE this file now!</strong>";

} catch (PDOException $e) {
    echo "❌ Error: " . $e->getMessage();
}
