Verifier email php to

Here is an example of a PHP script that sends a verification email to a user:

<?php

// Configuration
$db_host = 'localhost';
$db_username = 'root';
$db_password = '';
$db_name = 'mydatabase';

// Connect to database
$conn = mysqli_connect($db_host, $db_username, $db_password, $db_name);

// Check connection
if (!$conn) {
    die("Connection failed: ". mysqli_connect_error());
}

// Get user data from form submission
$username = $_POST['username'];
$email = $_POST['email'];

// Check if user already exists
$query = "SELECT * FROM users WHERE email = '$email'";
$result = mysqli_query($conn, $query);
if (mysqli_num_rows($result) > 0) {
    echo "User already exists";
    exit;
}

// Insert user into database
$query = "INSERT INTO users (username, email) VALUES ('$username', '$email')";
mysqli_query($conn, $query);

// Generate verification token
$token = bin2hex(random_bytes(16));

// Store token in database
$query = "UPDATE users SET verification_token = '$token' WHERE email = '$email'";
mysqli_query($conn, $query);

// Send verification email
$subject = "Verify your email address";
$message = "Hello $username,\r\n\r\nPlease click on the following link to verify your email address:\r\n\r\n<a href='http://example.com/verify.php?token=$token'>Verify Email</a>";
$headers = "From: [email protected]\r\nReply-To: [email protected]\r\nContent-Type: text/html; charset=UTF-8";

mail($email, $subject, $message, $headers);

// Close database connection
mysqli_close($conn);

?>

This script assumes you have a users table in your database with columns for username and email. It also assumes you have a verification_token column to store the verification token.

Here's how the script works:

1. It connects to the database and checks if the user already exists.
2. If the user doesn't exist, it inserts the user into the database and generates a verification token.
3. It stores the verification token in the database.
4. It sends a verification email to the user with a link to verify their email address.
5. The link includes the verification token as a query parameter.
6. The user can click on the link to verify their email address.

On the verification page (verify.php), you can use the following script to verify the email address:

<?php

// Configuration
$db_host = 'localhost';
$db_username = 'root';
$db_password = '';
$db_name = 'mydatabase';

// Connect to database
$conn = mysqli_connect($db_host, $db_username, $db_password, $db_name);

// Check connection
if (!$conn) {
    die("Connection failed: ". mysqli_connect_error());
}

// Get verification token from URL
$token = $_GET['token'];

// Check if token exists in database
$query = "SELECT * FROM users WHERE verification_token = '$token'";
$result = mysqli_query($conn, $query);
if (mysqli_num_rows($result) == 0) {
    echo "Invalid token";
    exit;
}

// Update user status to verified
$query = "UPDATE users SET verified = 1 WHERE verification_token = '$token'";
mysqli_query($conn, $query);

// Delete verification token
$query = "UPDATE users SET verification_token = NULL WHERE verification_token = '$token'";
mysqli_query($conn, $query);

// Close database connection
mysqli_close($conn);

?>

This script assumes you have a verified column in your users table to store the user's verification status.

Here's how the script works:

1. It connects to the database and gets the verification token from the URL.
2. It checks if the token exists in the database.
3. If the token exists, it updates the user's status to verified.
4. It deletes the verification token from the database.

Note that this is just an example script and you should modify it to fit your specific needs. You may also want to add additional security measures, such as validating user input and using prepared statements to prevent SQL injection.