fix-admin.php

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

$password = 'admin123';
$email = 'admin@fptb.edu.ng';

// Generate the hash
$hash = password_hash($password, PASSWORD_BCRYPT);

// Update the database
$stmt = $pdo->prepare("UPDATE users SET password_hash = ? WHERE email = ? AND role = 'admin'");
$result = $stmt->execute([$hash, $email]);

if ($result && $stmt->rowCount() > 0) {
    echo "SUCCESS! Admin password has been reset.\n\n";
    echo "Login Credentials:\n";
    echo "Email: " . $email . "\n";
    echo "Password: " . $password . "\n\n";
    echo "Hash: " . $hash . "\n\n";
    
    // Verify it works
    $verify = password_verify($password, $hash);
    echo "Verification: " . ($verify ? "✓ PASS - Hash is correct" : "✗ FAIL") . "\n";
} else {
    echo "ERROR: Failed to update admin password.\n";
}
?>