✏ 编辑: admin_forget_password.php

<?php
session_start();

// Database connection
$servername = "localhost";
$username = "askmanisha_newuser";
$password = "Webgennie@developers";
$dbname = "askmanisha_astrology_site";

$conn = new mysqli($servername, $username, $password, $dbname);

if ($conn->connect_error) {
    die(json_encode(['status' => 'error', 'message' => 'Connection failed']));
}

// Get first active admin
$sql = "SELECT * FROM admin_users WHERE status = 'active' ORDER BY id ASC LIMIT 1";
$result = $conn->query($sql);

if ($result->num_rows > 0) {
    $admin = $result->fetch_assoc();
    $admin_email = $admin['email'];
    $admin_name = $admin['name'];
    
    // Generate 6-digit OTP
    $otp = rand(100000, 999999);
    
    // Store OTP in session (60 minutes expiry)
    $_SESSION['reset_otp'] = $otp;
    $_SESSION['otp_expiry'] = time() + (60 * 60);
    $_SESSION['reset_admin_id'] = $admin['id'];
    
    // Send Email
    $to = $admin_email;
    $subject = "Password Reset OTP - Ask Manisha Admin";
    
    $message = "Dear $admin_name,\n\n";
    $message .= "Your OTP for password reset is: $otp\n\n";
    // $message .= "This OTP is valid for 60 minutes.\n\n";
    $message .= "If you did not request this, please ignore this email.\n\n";
    $message .= "Best Regards,\n";
    $message .= "Ask Manisha Team";
    
    $headers = "From: Ask Manisha <admin@askmanisha.com>\r\n";
    $headers .= "Reply-To: admin@askmanisha.com\r\n";
    $headers .= "Content-Type: text/plain; charset=UTF-8\r\n";
    
    mail($to, $subject, $message, $headers);
    
    echo json_encode(['status' => 'success', 'message' => 'OTP sent successfully']);
    
} else {
    echo json_encode(['status' => 'error', 'message' => 'Admin not found']);
}

$conn->close();
?>

[X] 取消