php - 我如何像我的 register.php 一样连接我的 login.php？

Question

我刚刚将我的 register.php 连接到 mysql 数据库。我尝试连接我的 login.php，但我不能。

这是我连接的register.php

$connect = mysqli_connect("mysql13.000webhost.com","a2955851_SW","********");

if(isset($_POST['submit']))
{    
    $username = mysqli_real_escape_string($connect, $_POST['username']);
    $pass = mysqli_real_escape_string($connect, $_POST['pass']);
    $pass1 = mysqli_real_escape_string($connect, $_POST['pass1']);
    $email = mysqli_real_escape_string($connect, $_POST['email']);
    if($username && $pass && $pass1 && $email)
    {
    if($pass==$pass1)
    {
        mysqli_select_db($connect, "a2955851_SW");
        $query = mysqli_query($connect, "INSERT INTO users VALUES('$username','$pass','$email');");
        echo "You have been registered.";
    }
    else
    {
        echo "Password must match.";
    }
    }
    else
    {
        echo "All fields are required.";
    }
    }

这是 login.php 我尝试连接它但是...

    <?php 
    $connect = mysqli_connect("mysql13.000webhost.com","a2955851_SW","********");
    session_start();



    if(isset($_POST['login']))
    {
    $username = mysqli_real_escape_string($connect, $_POST['username']);
    $password = mysqli_real_escape_string($connect, $_POST['password']);
    if($username && $password)
    {
    mysqli_select_db($connect, "a2955851_SW");
    $login = mysql_query("SELECT * FROM users WHERE username = '$username'");
    while($log=mysqli_fetch_assoc($login))
    {        

        $dbusername = $log['username'];
        $dbpassword = $log['password'];

    }
    if($username==$dbusername && $password==$dbpassword)
    {

    $_SESSION['username'] = $dbusername;
    $_SESSION['password'] = $dbpassword;
    header("location:members.php");
    }
    else
    {

    header("location:index.php?notify=Incorrect Username or Password.");
    }

    }
    else
    {

    header("location:index.php?notify=ALL field are required.");
    }
    }









    ?>

我试过连接login.php 类似我不知道

Answer 1

您混合了 mysql 和 mysqli。只使用一个。改变

$login = mysql_query("SELECT * FROM users WHERE username = '$username'");

到

$login = mysqli_query($connect, "SELECT * FROM users WHERE username = '$username'");