SELECT COUNT(*) AS count – How to use this count

by

It’s not recommended to use reserved words for names in SQL. So I call the count result cnt instead. As your function is scalar, i.e. you expect only one value back, you can use:

$count = $mysqli->query("select count(*) as cnt from cars")->fetch_object()->cnt;

More Related Contents:

  1. Save the data into a database and return another value from database using PHP
  2. Commands out of sync; you can’t run this command now
  3. How to get count of rows in MySQL table using PHP?
  4. Correct way to use LIKE ‘%{$var}%’ with prepared statements?
  5. Fatal error: Uncaught exception ‘mysqli_sql_exception’ with message ‘No index used in query/prepared statement’
  6. You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ‘WHERE `id` [closed]
  7. Get table column names in MySQL?
  8. Example of how to use bind_result vs get_result
  9. mysqli::query(): Couldn’t fetch mysqli
  10. How to resolve ambiguous column names when retrieving results?
  11. mysqli::mysqli(): (HY000/2002): Can’t connect to local MySQL server through socket ‘MySQL’ (2)
  12. PHP MySQLI Prevent SQL Injection [duplicate]
  13. Use bound parameter multiple times
  14. What is the difference between MySQL, MySQLi and PDO? [closed]
  15. How to test if a MySQL query was successful in modifying database table data?
  16. mysqli_fetch_array() expects parameter 1 to be mysqli_result, boolean given in [duplicate]
  17. MySQL “NOT IN” query 3 tables
  18. Mysql No connection could be made because the target machine actively refused it
  19. MYSQLi error: User already has more than ‘max_user_connections’ active connections [duplicate]
  20. How to connect to MySQL database in PHP using mysqli extension?
  21. Why does this return Resource id #2? [duplicate]
  22. Fatal error: Call to undefined function mysqli_result()
  23. How to generate unique id in MySQL?
  24. Fatal error: Call to undefined method mysqli_stmt::fetch_array() [duplicate]
  25. How to SELECT DEFAULT value of a field
  26. mysqli prepared statement num_rows returns 0 while query returns greater than 0 [duplicate]
  27. Which is fastest in PHP- MySQL or MySQLi?
  28. UNION syntax in Cakephp
  29. How do i search from serialize field in mysql database?
  30. MySqli Commands out of sync; you can’t run this command now [duplicate]

Leave a Comment