/home/awneajlw/www/codestechvista.com/admin/reset_admin_password.php
<?php
/**
* Admin Password Reset Script
* Use this to reset admin password if you forget it
* DELETE THIS FILE AFTER USE FOR SECURITY!
*/
require_once '../config/database.php';
echo "<h2>Admin Password Reset Tool</h2>";
$database = new Database();
$db = $database->getConnection();
// New password
$new_password = 'admin123';
$hashed_password = password_hash($new_password, PASSWORD_DEFAULT);
// Update admin password
$query = "UPDATE users SET password = ? WHERE email = 'admin@eyeclinic.com' AND role = 'admin'";
$stmt = $db->prepare($query);
if ($stmt->execute([$hashed_password])) {
echo "<div style='padding: 20px; background: #d4edda; color: #155724; border-radius: 5px; margin: 20px 0;'>";
echo "<h3>✅ Password Reset Successful!</h3>";
echo "<p><strong>Email:</strong> admin@eyeclinic.com</p>";
echo "<p><strong>New Password:</strong> admin123</p>";
echo "<p><strong>Login URL:</strong> <a href='login.php'>admin/login.php</a></p>";
echo "<hr>";
echo "<p style='color: #721c24; background: #f8d7da; padding: 10px; border-radius: 5px;'>";
echo "<strong>⚠️ IMPORTANT:</strong> Delete this file (reset_admin_password.php) immediately after use for security!";
echo "</p>";
echo "</div>";
// Test the password
$test_query = "SELECT password FROM users WHERE email = 'admin@eyeclinic.com'";
$test_stmt = $db->prepare($test_query);
$test_stmt->execute();
$user = $test_stmt->fetch(PDO::FETCH_ASSOC);
if (password_verify($new_password, $user['password'])) {
echo "<p style='color: green;'>✓ Password verification successful!</p>";
} else {
echo "<p style='color: red;'>✗ Password verification failed!</p>";
}
} else {
echo "<div style='padding: 20px; background: #f8d7da; color: #721c24; border-radius: 5px;'>";
echo "❌ Error resetting password!";
echo "</div>";
}
echo "<hr>";
echo "<h3>All Admin Users:</h3>";
$all_admins = $db->query("SELECT id, name, email, role FROM users WHERE role = 'admin'")->fetchAll(PDO::FETCH_ASSOC);
echo "<table border='1' cellpadding='10' style='border-collapse: collapse;'>";
echo "<tr><th>ID</th><th>Name</th><th>Email</th><th>Role</th></tr>";
foreach ($all_admins as $admin) {
echo "<tr>";
echo "<td>" . $admin['id'] . "</td>";
echo "<td>" . $admin['name'] . "</td>";
echo "<td>" . $admin['email'] . "</td>";
echo "<td>" . $admin['role'] . "</td>";
echo "</tr>";
}
echo "</table>";
?>