How to block temp mail website in PHP and MySQL project

Blocking Temporary Email websites in a PHP &🤷‍♂️& MySQL project involves several steps. Here's a general outline of how you could approach this:

01. Identify Temporary Email Providers: You need a list of temporary email provider domains. There are some public lists available online, or you can compile your own list by researching common temporary email services.

02. Create a Database Table: You'll need a table in your MySQL database to store the list of blocked domains.

SQL 👇

CREATE TABLE blocked_domains (
    id INT AUTO_INCREMENT PRIMARY KEY,
    domain VARCHAR(255) UNIQUE
);
03. Populate the Table: Insert the list of temporary email domains into this table.
SQL 👇
INSERT INTO blocked_domains (domain) VALUES ('example1.com'), ('example2.com'), ...;
04. PHP Implementation: In your PHP code, whenever a user registers or tries to input an email address, you'll need to check if the domain of the email
 address is in your blocked domains list.
PHP 👇
<?php
// Database connection
$dbHost = 'localhost';
$dbUsername = 'username';
$dbPassword = 'password';
$dbName = 'database';
$conn = new mysqli($dbHost, $dbUsername, $dbPassword, $dbName);

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

// Function to check if the domain is blocked
function isDomainBlocked($email) {
    global $conn;
    $domain = explode('@', $email)[1];
    $query = "SELECT COUNT(*) as count FROM blocked_domains WHERE domain = '$domain'";
    $result = $conn->query($query);
    $row = $result->fetch_assoc();
    return $row['count'] > 0;
}

// Example usage
$email = "example@example.com";
if (isDomainBlocked($email)) {
    echo "Registration using this email domain is not allowed.";
} else {
    echo "Registration allowed.";
}
?>
05. Integration with Registration/Login Process: Integrate the isDomainBlocked() function into 
your registration and login processes to prevent users from registering or using temporary email addresses.
06. Regular Updates: Keep your list of blocked domains updated regularly as new temporary email
 providers emerge.