在mysql中通过电子邮件登录Php

CREATE TABLE users (
    id INT AUTO_INCREMENT PRIMARY KEY,
    email VARCHAR(255) NOT NULL,
    password VARCHAR(255) NOT NULL,
    name VARCHAR(255) NOT NULL
);

<?php
// 连接到MySQL数据库
$connection = mysqli_connect("localhost", "username", "password", "database");

// 获取用户输入的电子邮件、密码和姓名
$email = $_POST['email'];
$password = $_POST['password'];
$name = $_POST['name'];

// 插入用户信息到数据库
$query = "INSERT INTO users (email, password, name) VALUES ('$email', '$password', '$name')";
mysqli_query($connection, $query);

// 关闭数据库连接
mysqli_close($connection);
?>

<?php
// 连接到MySQL数据库
$connection = mysqli_connect("localhost", "username", "password", "database");

// 获取用户输入的电子邮件和密码
$email = $_POST['email'];
$password = $_POST['password'];

// 查询数据库中是否存在匹配的用户
$query = "SELECT * FROM users WHERE email='$email' AND password='$password'";
$result = mysqli_query($connection, $query);

// 检查查询结果
if (mysqli_num_rows($result) == 1) {
    // 用户名和密码匹配，登录成功
    echo "登录成功！";
} else {
    // 用户名和密码不匹配，登录失败
    echo "用户名或密码错误！";
}

// 关闭数据库连接
mysqli_close($connection);
?>