PHP查询执行无错误，但返回计数0

PHP query execute without error but return count 0

本文关键字：返回 查询 执行 无错误 PHP      更新时间：2023-09-26

我在angularjs中创建登录，在登录。phpage我验证用户是否存在或不存在的行数存在与否意味着使用rowCount()在php pdo，但它总是返回0的结果。这是我的PHP文件:

<?php
   /*
   * Collect all Details from Angular HTTP Request.
   */ 
    $postdata = file_get_contents("php://input");
    $request = json_decode($postdata);
    $email = $request->email;
    $pass = $request->password;

    $user ="root";
$pass ="m2n1shlko";
$dbh = new PDO('mysql:host=localhost;dbname=blog_db', $user, $pass);
$query = $dbh->prepare("SELECT * FROM `signup_tbl` WHERE `email`='$email' AND `password`='$pass'");
$query->execute();
$count = $query->rowcount();
if($count>0){
echo "You have sucessfully login with this Email: ".$count; //this will go back under "data" of angular call.
}else{

  echo "Error While Authentication with this Email: " .$count;
}

    /*
     * You can use $email and $pass for further work. Such as Database calls.
    */    
?>

数据从控制器得到这里我不知道我在哪里错过了代码。感谢你的帮助……由于

将$pass覆盖到数据库(第13行)和用户(第8行)。将数据库密码更改为$db_pass。

...
$email = '...';
$pass = $request->password;
...
$db_pass = '...';
...
$dbh = new PDO('mysql:host=localhost;dbname=blog_db', $user, $db_pass); // $pass to $db_pass

Its $query->rowCount();NOT $query->rowcount(); 

 $count = $query->rowCount();
 if($count>0){
 echo "You have sucessfully login with this Email: ".$count; //this will go back under "data" of angular call.
 }else{
 echo "Error While Authentication with this Email: " .$count;
 }

Read Manual rowCount

我已经在我的本地系统中完成了，它工作得很好，试试下面的例子，这工作得很好。只要遵循这个例子，并按照正确的方式编写代码:

<?php
$host = "localhost";
$username = "root";
$password = "";
$dbname = "xxx";
// Create connection
$conn = new PDO('mysql:host=localhost;dbname=xxx', $username, $password);
$query =$conn->prepare("select * from testing");
$query->execute();
$count = $query->rowCount();
echo "Counting:".$count;
?>
输出

: - 

Counting:3
相关文章：