prepare("SELECT id FROM admins WHERE username = ?"); $stmt->execute([$new_username]); $user = $stmt->fetch(); if ($user) { // A. If user exists -> UPDATE the password $update = $pdo->prepare("UPDATE admins SET password = ? WHERE username = ?"); $update->execute([$hashed_password, $new_username]); echo "
"; echo "

✅ Success!

"; echo "

Password updated for existing user: $new_username

"; } else { // B. If user does not exist -> INSERT new user $insert = $pdo->prepare("INSERT INTO admins (username, password) VALUES (?, ?)"); $insert->execute([$new_username, $hashed_password]); echo "
"; echo "

✅ Success!

"; echo "

Created new admin user: $new_username

"; } echo "

You can now login at /admin

"; echo "

⚠️ IMPORTANT: Delete this file (reset_admin.php) from your server now.

"; echo "
"; } catch (PDOException $e) { echo "
"; echo "

❌ Error

"; echo "

" . $e->getMessage() . "

"; echo "
"; } ?>