Learn how to implement the blacklist management function for email sending in the website through PHP and PHPMAILER

Learn how to implement the blacklist management function for email sending in the website through PHP and PHPMailer

As a website developer, you may often need to implement the email sending function in the website. Sending emails is an important way for communication between website users and the website. However, sometimes we may need to restrict certain users or email addresses from sending emails to our site.

In order to achieve this function, we can use PHP and PHPMailer to manage the blacklist and add certain users or email addresses to the blacklist to limit their permission to send emails. In this article, we will learn how to implement blacklist management functionality using PHP and PHPMailer.

First, we need to create a blacklist to store users or email addresses that are restricted from sending emails. We can use a database table to store these blacklist lists, which contains fields such as blacklist ID, user or email address, and time added to the blacklist. The following is a sample SQL statement to create a blacklist list:

CREATE TABLE blacklist (
    id INT(11) UNSIGNED AUTO_INCREMENT PRIMARY KEY,
    email VARCHAR(255) NOT NULL,
    added_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP
);

Next, we will use PHP to connect to the database and write the corresponding functions to add, delete and check users or email addresses in the blacklist. First, we need to connect to the database, you can use the following code:

<?php
$servername = "localhost";
$username = "root";
$password = "your_password";
$dbname = "your_database";

// 创建数据库连接
$conn = new mysqli($servername, $username, $password, $dbname);

// 检查连接是否成功
if ($conn->connect_error) {
    die("数据库连接失败：" . $conn->connect_error);
}
?>

Next, we can write a function to add users or email addresses to the blacklist. Here is an example function:

function addToBlackList($email)
{
    // 全局变量$conn是数据库连接对象

    // 检查邮箱是否已经在黑名单中
    $sql = "SELECT id FROM blacklist WHERE email='$email'";
    $result = $conn->query($sql);

    if ($result->num_rows > 0) {
        // 邮箱已经在黑名单中
        return false;
    } else {
        // 将邮箱添加到黑名单
        $sql = "INSERT INTO blacklist (email) VALUES ('$email')";
        if ($conn->query($sql) === TRUE) {
            return true;
        } else {
            return false;
        }
    }
}

We can then write a function that removes a user or email address from the blacklist. Here is an example function:

function removeFromBlackList($email)
{
    // 全局变量$conn是数据库连接对象

    // 从黑名单中删除邮箱
    $sql = "DELETE FROM blacklist WHERE email='$email'";
    if ($conn->query($sql) === TRUE) {
        return true;
    } else {
        return false;
    }
}

Finally, we need to check if the user or email address is in the blacklist. The following is an example function:

function checkBlackList($email)
{
    // 全局变量$conn是数据库连接对象

    // 检查邮箱是否在黑名单中
    $sql = "SELECT id FROM blacklist WHERE email='$email'";
    $result = $conn->query($sql);

    if ($result->num_rows > 0) {
        // 邮箱在黑名单中
        return true;
    } else {
        // 邮箱不在黑名单中
        return false;
    }
}

Now, we have successfully written the function to manage the blacklist. Next, we use PHPMailer to implement the email sending function and check whether the sender is in the blacklist before sending. The following is a sample code:

<?php
require 'phpmailer/PHPMailerAutoload.php';

// 创建邮件对象
$mail = new PHPMailer;

// 配置SMTP服务器
$mail->isSMTP();
$mail->Host = 'smtp.yourdomain.com';
$mail->SMTPAuth = true;
$mail->Username = 'your_email@example.com';
$mail->Password = 'your_password';
$mail->SMTPSecure = 'tls';
$mail->Port = 587;

// 设置发送方和收件人
$mail->setFrom('your_email@example.com', 'Your Name');
$mail->addAddress('recipient@example.com', 'Recipient Name');

// 设置邮件内容和主题
$mail->Subject = 'Hello from PHPMailer';
$mail->Body    = 'This is the HTML message body <b>in bold!</b>';

// 检查发送者是否在黑名单中
if (checkBlackList('your_email@example.com')) {
    echo "您不能发送邮件。";
} else {
    // 发送邮件
    if (!$mail->send()) {
        echo '邮件发送失败: ' . $mail->ErrorInfo;
    } else {
        echo '邮件发送成功！';
    }
}
?>

In the above example, we first configured the SMTP server and the mail sender and recipient. Then, we use the checkBlackList() function to check if the sender is in the blacklist. If the sender is in the blacklist, we will output a prompt message indicating that the sending failed; otherwise, we use PHPMailer to send the email.

Through the above sample code, we can successfully implement the blacklist management function and check whether the sender is in the blacklist before sending the email. In this way, we can restrict certain users or email addresses from sending emails to our website.

In summary, through PHP and PHPMailer, we can easily implement the blacklist management function for email sending. Through the blacklist management function, we can restrict certain users or email addresses from sending emails to our website to protect our website security and user experience. I hope this article is helpful to you, thank you for reading!

The above is the detailed content of Learn how to implement the blacklist management function for email sending in the website through PHP and PHPMAILER. For more information, please follow other related articles on the PHP Chinese website!