create_admin_user.php

<?php
require_once 'config/database.php';

// Admin details
$username = 'admin';
$email = 'admin@example.com';
$password = 'admin123';

$stmt = $pdo->prepare("SELECT * FROM users WHERE username = ? OR email = ?");
$stmt->execute([$username, $email]);

if ($stmt->rowCount() > 0) {
    echo "Admin user already exists. Updating password and making sure admin flag is set...\n";
    
    // Update password and ensure admin flag is set
    $hashedPassword = password_hash($password, PASSWORD_DEFAULT);
    $stmt = $pdo->prepare("UPDATE users SET password = ?, is_admin = 1 WHERE username = ?");
    $stmt->execute([$hashedPassword, $username]);
    
    echo "Password updated for admin user $username.\n";
} else {
    // Create admin user
    $hashedPassword = password_hash($password, PASSWORD_DEFAULT);
    
    $stmt = $pdo->prepare("INSERT INTO users (username, email, password, is_admin) VALUES (?, ?, ?, 1)");
    $stmt->execute([$username, $email, $hashedPassword]);
    
    echo "Created new admin user: $username\n";
}

// Verify admin user
$stmt = $pdo->prepare("SELECT * FROM users WHERE username = ?");
$stmt->execute([$username]);
$user = $stmt->fetch();

echo "User ID: " . $user['id'] . "\n";
echo "Username: " . $user['username'] . "\n";
echo "Email: " . $user['email'] . "\n";
echo "Is Admin: " . ($user['is_admin'] ? 'Yes' : 'No') . "\n";
echo "Password hash length: " . strlen($user['password']) . "\n";

echo "\nLogin credentials:\n";
echo "Username: $username\n";
echo "Password: $password\n";
?>