Server : LiteSpeed System : Linux us-phx-web1202.main-hosting.eu 4.18.0-553.84.1.lve.el8.x86_64 #1 SMP Tue Nov 25 18:33:03 UTC 2025 x86_64 User : u615232177 ( 615232177) PHP Version : 8.1.33 Disable Function : NONE Directory :  /home/u615232177/domains/florencewaltersconsulting.com/public_html/

Upload File : current_dir [ Writeable ] document_root [ Writeable ]

<?php
error_reporting(E_ALL);
ini_set('display_errors', 1);
include("minks1.php");

if ($_SERVER["REQUEST_METHOD"] === "POST" && isset($_POST['email_subscribe'])) {
    header('Content-Type: application/json');
    $response = "";
    $date_firstreg = date("H:i:s d-m-Y");
    $email = $_POST['email'] ?? '';

    if ($email !== "" && filter_var($email, FILTER_VALIDATE_EMAIL)) {
        $stmt = $con->prepare('SELECT email FROM email_subscribers WHERE email = ? LIMIT 1');
         if (!$stmt) {
            echo json_encode(["message" => "DB Prepare failed: " . $con->error]);
            exit;
        }
        $stmt->bind_param('s', $email);
        $stmt->execute();
        $stmt->store_result();

        if ($stmt->num_rows() > 0) {
            $response = "You have already subscribed, thanks!";
        } else {
            $db_id = 0;
            $stmt = $con->prepare('INSERT INTO email_subscribers VALUES (?,?,?)');
            if (!$stmt) {
                echo json_encode(["message" => "Insert prepare failed: " . $con->error]);
                exit;
            }
            $stmt->bind_param('iss', $db_id, $email, $date_firstreg);
            if (!$stmt->execute()) {
                echo json_encode(["message" => "Insert failed: " . $stmt->error]);
                exit;
            }
            $response = "Thanks for subscribing!";
        }
    } else {
        $response = "Please enter a valid email.";
    }

    echo json_encode(["message" => $response]);
    exit;
}