// DATABASE CONNECTION
$host = "localhost";
$user = "root";
$password = "";
$database = "your_database_name"; // change this

$conn = new mysqli($host, $user, $password, $database);

if ($conn->connect_error) {
    die("Connection failed: " . $conn->connect_error);
}


// GET FORM DATA
$fullname = $_POST['fullname'];
$mobile   = $_POST['mobile'];
$email    = $_POST['email'];
$password = $_POST['password'];

// GENERATE MEMBER ID
$member_id = "GBHS" . date("Y") . rand(1000,9999);


// INSERT INTO DATABASE
$sql = "INSERT INTO members (fullname, mobile, email, password, member_id)
VALUES ('$fullname', '$mobile', '$email', '$password', '$member_id')";

if ($conn->query($sql) === TRUE) {

    // ================== MAIL CODE ==================

    use PHPMailer\PHPMailer\PHPMailer;
    use PHPMailer\PHPMailer\Exception;

    require 'PHPMailer/src/PHPMailer.php';
    require 'PHPMailer/src/SMTP.php';
    require 'PHPMailer/src/Exception.php';

    $mail = new PHPMailer(true);

    try {
        $mail->isSMTP();
        $mail->Host       = 'smtp.gmail.com';
        $mail->SMTPAuth   = true;
        $mail->Username   = 'yourgmail@gmail.com'; // 🔴 CHANGE
        $mail->Password   = 'yourapppassword';     // 🔴 CHANGE (no spaces)
        $mail->SMTPSecure = 'tls';
        $mail->Port       = 587;

        $mail->setFrom('yourgmail@gmail.com', 'Member Portal');
        $mail->addAddress($email);

        $mail->isHTML(true);
        $mail->Subject = 'Your Member ID - Greater Bengaluru Housing Society';

        $mail->Body = "
        <h2>Welcome to Greater Bengaluru Housing Society</h2>
        <p>Dear <b>$fullname</b>,</p>
        <p>Your account has been successfully created.</p>

        <p><b>Your Member ID:</b> $member_id</p>

        <p>Please keep this ID safe for login.</p>

        <br>
        <p>Regards,<br>GBHS Team</p>
        ";

        $mail->send();

        echo "<script>
            alert('Registration Successful! Member ID sent to your email.');
            window.location.href='member-login.html';
        </script>";

    } catch (Exception $e) {
        echo "Mail Error: " . $mail->ErrorInfo;
    }

} else {
    echo "Error: " . $conn->error;
}

$conn->close();
?>