芝麻web文件管理V1.00

编辑当前文件:/home/qrafawbu/thefirstcookout.com/subscribe.php

<?php
// Database credentials
$host = 'localhost'; // or your host
$dbname = 'qrafawbu_thefirstcookout_db';
$username = 'qrafawbu_thefirstcookout_usr';
$password = 'F-?)o&KmrA&o';

// Connect to the database
$pdo = new PDO("mysql:host=$host;dbname=$dbname", $username, $password);

// Check if the form is submitted
if ($_SERVER["REQUEST_METHOD"] == "POST" && isset($_POST['email'])) {
    $email = filter_var($_POST['email'], FILTER_SANITIZE_EMAIL);

// Validate the email
    if (filter_var($email, FILTER_VALIDATE_EMAIL)) {
        // Check for duplicate email
        $stmt = $pdo->prepare("SELECT * FROM subscribers WHERE email = :email");
        $stmt->execute(['email' => $email]);
        if ($stmt->rowCount() > 0) {
            echo "<script>alert('This email is already subscribed!'); window.location.href='index.html';</script>";
        } else {
            // Prepare SQL statement for insertion
            $stmt = $pdo->prepare("INSERT INTO subscribers (email) VALUES (:email)");
            $stmt->execute(['email' => $email]);

// Redirect or inform the user
            echo "<script>alert('Thank you for subscribing!'); window.location.href='index.html';</script>";
        }
    } else {
        echo "Invalid email address.";
    }
} else {
    // Not a POST request
    http_response_code(403);
    echo "There was a problem with your submission, please try again.";
}
?>