php - PHP登录系统-通过电子邮件或用户名进行用户登录

Question

我想问一下如何仅使用一个功能通过电子邮件或用户名登录。我已经尝试过此代码

    function loginemail($username,$password)
{
    $timestamp = time();
    $time = date("d/m/y h:i:s a", $timestamp);
    $sql = mysql_query("SELECT * FROM users WHERE username ='$username'");
    $sql = mysql_query("SELECT * FROM users WHERE email ='$username'");
    $row = mysql_fetch_assoc($sql);
    $maintenance = mysql_query("SELECT * FROM settings");
    $row2 = mysql_fetch_assoc($maintenance);
    $main = $row2['maintenance'];

if($main == 1)
{
    if($row['password'] == $password && $row['username'] == $username)
    {
        $query = mysql_query("INSERT INTO log (id,username,time,action) VALUES 

(NULL,'$username','$time','Login')");
        if(!$query)
        {
            echo "FAILED";
        }
        else
        {
        $_SESSION['username'] = $row['username'];
        header('Location: /dash');
        }
    }
    elseif($row['password'] == $password && $row['email'] == $username && $row['rank'] == 5)
    {
        $user = $row['username'];
        $_SESSION['username'] = $row['username'];
        $_SESSION['email'] = $row['email'];
        header('Location: /user/chooser');
    }
    else
    {
        header("Location: /index/error");
    }
}
else
{
    if($row['password'] == $password && $row['username'] == $username)
    {
        $query = mysql_query("INSERT INTO log (id,username,time,action) VALUES 

(NULL,'$username','$time','Login')");
        if(!$query)
        {
            echo "FAILED";
        }
        else
        {
        $_SESSION['username'] = $row['username'];
        header('Location: /dash');
        }
    }
    elseif($row['password'] == $password && $row['email'] == $username)
    {
        $user = $row['username'];
        $_SESSION['username'] = $row['username'];
        $_SESSION['email'] = $row['email'];
        header('Location: /user/chooser');
    }
    else
    {
        header("Location: /index/error");
    }
}
}

但这对用户名部分无效。现在我已更改代码以使用php oop。所以这是我当前的代码。

class User {

    public function check($uname,$passwd)
    {
            $p=md5($passwd);
            $run=mysql_query("SELECT * FROM users WHERE username='$uname'");
            $user_data = mysql_fetch_array($run);
            $row=mysql_num_rows($run);
            if ($row == 1)
            {
                $_SESSION['login'] = true;                                                  $_SESSION['username'] = $user_data['username'];
                header('Location: /dash');
            }
            else
            {
                return FALSE;
            }
    }

    public function logout()
    {
        $_SESSION['login'] = FALSE;
            session_destroy();
    }
}

Answer 1

尝试这个：

$user = mysql_query("SELECT * FROM users WHERE (username = '$username' OR email = '$email') AND password = '$password'");

编辑

由于输入的登录名是用户名或电子邮件，

$user = mysql_query("SELECT * FROM users WHERE (username = '$login_name' OR email = '$login_name') AND password = '$password'");