使用php pdo选择原始计数不工作[重复]

Question

This question already has an answer here:

• Row count with PDO 22 answers

I tried to select number of users that is following any of my site member, but it keep returning 0 even when is not empty from database or it will show 1 when is empty

<?php
 $db_conn = new PDO('mysql:host='.DB_HOST.';dbname='.DB_NAME,DB_USERNAME,DB_PASSWORD);
 $db_conn->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
      $followings = $db_conn->prepare("SELECT COUNT(*) FROM memberfollow WHERE following = :followMe");
      $followings->bindParam(":followMe", $_POST['username']);
      $followings->execute();
      $Numfollowing = $followings->rowCount();//this will return 0 when is empty and not empty
      $col = $followings->fetchColumn();// this will return 1 in all
  echo "FL".$Numfollowing."/".$col."<br/>";  
?>

</div>

Answer 1

You can write

    <?php
 $db_conn = new PDO('mysql:host='.DB_HOST.';dbname='.DB_NAME,DB_USERNAME,DB_PASSWORD);
 $db_conn->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
      $followings = $db_conn->prepare("SELECT * FROM memberfollow WHERE following = :followMe");
      $followings->bindParam(":followMe", $_POST['username']);
      $followings->execute();
      $Numfollowing = $followings->rowCount();//this will return 0 when is empty and not empty
      $col = $followings->fetchColumn();// this will return 1 in all
  echo "FL".$Numfollowing."/".$col."<br/>";  
?>

This might solve your problem