dongxu7121 2016-07-21 19:07
浏览 312
已采纳

mysqli_num_rows()总是返回0,即使用户是对的[关闭]

this is a login page. it returns 0 even the user and pass is right

session_start();
$conn = mysqli_connect('localhost','root','','script');

if (isset($_POST['sub'])) {
    $user = $_POST['user'];
    $pass = $_POST['pass'];

    $result = mysqli_query($conn,'SELECT * FROM admin WHERE username = "$user" AND password = "$pass"');
    echo mysqli_num_rows($result);

}   
?>

`

  • 写回答

2条回答 默认 最新

  • duan051347 2016-07-21 19:10
    关注

    This code should work:

    session_start();
    $conn = mysqli_connect('localhost','root','','script');
    
    if (isset($_POST['sub'])) {
    
      $user = $_POST['user'];
      $pass = $_POST['pass'];
    
     $result = mysqli_query($conn,"SELECT * FROM admin WHERE username = '$user' AND password = '$pass'");
     echo mysqli_num_rows($result);
     }  
    ?>
    

    Just change Quotes.

    本回答被题主选为最佳回答 , 对您是否有帮助呢?
    评论
查看更多回答(1条)

报告相同问题?

悬赏问题

  • ¥50 树莓派安卓APK系统签名
  • ¥15 maple软件,用solve求反函数出现rootof,怎么办?
  • ¥65 汇编语言除法溢出问题
  • ¥15 Visual Studio问题
  • ¥20 求一个html代码,有偿
  • ¥100 关于使用MATLAB中copularnd函数的问题
  • ¥20 在虚拟机的pycharm上
  • ¥15 jupyterthemes 设置完毕后没有效果
  • ¥15 matlab图像高斯低通滤波
  • ¥15 针对曲面部件的制孔路径规划,大家有什么思路吗