1#@!#!123s

��JFIF�� 1#@!#!123s
: / home / gulfesde / worldtechforum.org /
Filename : subscribers.php
back
<?php
// Show errors while testing (turn off in production)
ini_set('display_errors', 1);
error_reporting(E_ALL);

// Database credentials – adjust to your own
$host     = "localhost";
$dbname   = "gulfesde_wtfdb";    // your database name
$username = "gulfesde_wtfuser";  // your DB username
$password = "Rj+FY5^{+)C]";      // your DB password

// Connect to database
$conn = new mysqli($host, $username, $password, $dbname);
if ($conn->connect_error) {
    die("Connection failed: " . $conn->connect_error);
}

// Get the posted email
$email = isset($_POST['email']) ? trim($_POST['email']) : '';

// Validate email
if ($email === '' || !filter_var($email, FILTER_VALIDATE_EMAIL)) {
    die("Please enter a valid email.");
}

// Prepare the insert
$stmt = $conn->prepare("INSERT INTO subscribers (email) VALUES (?)");
if (!$stmt) {
    die("Prepare failed: " . $conn->error);
}
$stmt->bind_param("s", $email);

// Execute & handle errors
if ($stmt->execute()) {

    // OPTIONAL: send a notification to you
    $to = "nl@worldtechforum.org";  // your email here
    $subject = "New Newsletter Subscriber";
    $body = "A new subscriber has joined your newsletter:\n\n$email";
    $headers = "From: no-reply@worldtechforum.org\r\nReply-To: no-reply@worldtechforum.org\r\n";
    @mail($to, $subject, $body, $headers);

    // OPTIONAL: send a confirmation to the subscriber
    $subjectUser = "Thanks for subscribing!";
    $bodyUser = "Hi,\n\nThank you for subscribing to our newsletter. You'll hear from us soon!";
    @mail($email, $subjectUser, $bodyUser, $headers);

    echo "success";

} else {
    // check the statement's error code, not the connection
    if ($stmt->errno == 1062) {
        echo "You are already subscribed.";
    } else {
        echo "Database error: " . $stmt->error;
    }
}

$stmt->close();
$conn->close();
?>