How to get the total number of rows of a GROUP BY query?

by

Here is the solution for you

$sql="SELECT count(*) FROM [tablename] WHERE key == ? ";
$sth = $this->db->prepare($sql);
$sth->execute(array($key));
$rows = $sth->fetch(PDO::FETCH_NUM);
echo $rows[0];

More Related Contents:

  1. PDOException SQLSTATE[HY000] [2002] No such file or directory
  2. PDO get the last ID inserted
  3. PDO mysql: How to know if insert was successful
  4. MySQL check if a table exists without throwing an exception
  5. Fetching single row, single column with PDO
  6. How to connect to mssql using pdo through PHP and Linux?
  7. Replacing mysql_* functions with PDO and prepared statements
  8. PDO::PARAM for type decimal?
  9. Using LIKE in bindParam for a MySQL PDO Query [duplicate]
  10. pdo sqlite could not find driver… php file not processing
  11. Is it ” RTSi6+yxLwIW7KsnoehVDA== ” md5? or How to get original string? [closed]
  12. save user images in MYSQL database by which method? [closed]
  13. How to apply bindValue method in LIMIT clause?
  14. Importing CSV data using PHP/MySQL
  15. How to debug PDO database queries?
  16. PDO multiple queries
  17. Get last insert id after a prepared insert with PDO
  18. Do SQL connections opened with PDO in PHP have to be closed
  19. What is the advantage of using try {} catch {} versus if {} else {}
  20. ERROR: SQLSTATE[HY000] [2002] No connection could be made because the target machine actively refused it
  21. Call to undefined method PDO::execute()
  22. return one value from database with mysql php pdo
  23. Trying to access array offset on value of type bool
  24. How to get a query error from prepare() in PDO PHP?
  25. How can I pass an array of PDO parameters yet still specify their types?
  26. mysql injection damages?
  27. PHP Laravel: No connection could be made because the target machine actively refused it
  28. What is the PDO equivalent of function mysql_real_escape_string?
  29. Installing PDO driver on MySQL Linux server
  30. PDO Exception Questions – How to Catch Them

Leave a Comment