Easy peasy email login

Here is an example of a simple email login system:

Email Login Form

Backend Code (using PHP)

<?php
// Connect to database
$conn = mysqli_connect("localhost", "username", "password", "database");

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

// Get email and password from form
$email = $_POST["email"];
$password = $_POST["password"];

// Query database to check if email and password match
$result = mysqli_query($conn, "SELECT * FROM users WHERE email='$email' AND password='$password'");

// Check if result is not empty
if (mysqli_num_rows($result) > 0) {
    // Login successful, redirect to dashboard
    header("Location: dashboard.php");
    exit;
} else {
    // Login failed, display error message
    echo "Invalid email or password";
}
?>

Note: