mysql - 根据用户输入的 mysql 语句 where 和 or 出现问题

Question

$query = "SELECT username, email, password, salt 
          FROM tbl_memembers 
          WHERE (username = $resetuser) OR (email = $resetuser)";

当我知道输入的详细信息与输入的详细信息相匹配时，这会不断返回数据库中没有任何内容($resetuser = $_POST 来自上一页)

Answer 1

尝试使用此查询

 $query = "SELECT username, email, password, salt 
          FROM tbl_memembers 
          WHERE username = '$resetuser'  email = '$resetuser' ";