How to return count number from a wordpress database

It is recommended to use the $wpdb->get_var() method when retrieving a count of rows. This method will return the count directly, rather than inside of an array or object like wpdb::get_results().

Related Posts:

  1. Would manually deleting the dumping data fix a “#1062 – Duplicate entry ‘1’ for key ‘PRIMARY'” phpMyAdmin error?
  2. How to display data from custom table in wordpress phpmyadmin
  3. phpMyAdmin error #1062 – Duplicate entry ‘1’ for key ‘PRIMARY’
  4. Error establishing a database connection (Set-up locally)
  5. Undefined function mysql_connect()
  6. MySQL column count doesn’t match value count at row 1 [closed]
  7. Fatal error: Call to undefined function mysql_connect()
  8. the_date() not working
  9. How to return number of found rows from SELECT query
  10. Check if post of title already exists
  11. $wpdb->delete column values IN ARRAY()?
  12. How to make WordPress plugin check for database changes and then do something?
  13. Custom SQL query to get List of posts with featured image url
  14. Delete post revisions on post publish
  15. Problems migrating WordPress to localhost
  16. error importing localhost export file to server
  17. How to sort results from a custom database table
  18. Update some database fields when post is saved
  19. Successful or Error Message after running mysql code in functions.php
  20. sql query to put quotes around numbers in img tag
  21. No wp-config.php file on local install of wordpress – site still displays
  22. PHP/MySQL issues when running WP on EC2 cloud [closed]
  23. WordPress get pagination on wpdb get_results
  24. How to create another version of my site based on the same database
  25. Strange wordpress slowness
  26. Looking for most performant way to execute several similar WP queries within shortcodes
  27. Setting All Drafts to ‘exclude-from-catalog’ in WooCommerce
  28. Stumped on migration
  29. PHP code inside shortcodes
  30. Show MySQL errors that occur when I excute $wpdb->insert()
  31. Is XAMPP faster than running LAMP in WSL on Windows 10? [closed]
  32. WordPress Site Running Extremely Slow on Dedicated Server
  33. Create WP_Query to search for posts by their categories or their parent/child categories
  34. Get updated query results on page after insert in database
  35. WordPress not reflecting changed of the database
  36. How can I fix WordPress installation errors?
  37. How to split links generated into an xml sitemap to avoid exceeding 30 sec maximum execution time?
  38. Hacked WordPress website /Homepage redirect [closed]
  39. get_posts() and WP_query limits ‘AND’ conditions to a maximum of 6 for meta value queries in WordPress
  40. Refresh table data with Ajax
  41. Database query works fine outside WordPress
  42. Large Woocommerce Site (83,000 items), What Can I Do? [closed]
  43. Help with a $wpdb MySQL Query
  44. How i can obtain all the post meta for a specific post as an array?
  45. Can’t Query Custom Table Using $wpdb Method
  46. $wpdb returns duplicate posts
  47. Update postmeta after theme switch
  48. Should I use WordPress to skin a database website?
  49. Creating Database Table vs. Adding MetaData to Post & User
  50. WordPress Custom SQL Table with UserID Filter for results
  51. How can I add a new row in a separate database when someone registers via WordPress?
  52. How to use mysql LIKE with wpdb?
  53. Submitting a form, using Ajax, to run a SQL Select query based on user input from the form
  54. WordPress WP_Query without query GET parameters
  55. How to use AJAX in WordPress in MYSQL query?
  56. Way to send multiple values for column to MySQL?
  57. Use variable in SQL statement
  58. Processing ajax call to php to insert into mysql database
  59. WPDB secure custom form
  60. Query the links Database
  61. WordPress Custom Query: Combining Two Functions
  62. MySQL Query Returns Array () In Shortcode
  63. Passing in MySQL prepare statement parameter separately throwing error
  64. Database SQL query error
  65. Display Results of SQL Query on WP site
  66. PHP Warning: mysqli_query(): after updating my websites php from 5.6 to 7.2
  67. MYSQL TIMESTAMP when adding DATE_FORMAT then the output is blank, PHP conflict?
  68. Updated Php version from 5.4 to 7.2 and getting “PHP installation missing the MySQL extension needed by WordPress”
  69. How to optimize and reduce excessive database queries
  70. How to display MySQL table data which is stored as an array?
  71. Store GA Client ID in User DB
  72. Unable to insert two value in two different columns (WordPress database)
  73. why not selecting multiple rows of same standard_id using SQL query from database?
  74. How to import woocommerce custom fields data into another site?
  75. Can I disable auto increment of WordPress Posts Database to utilize previously deleted records?
  76. WordPress PHP version
  77. PHP 7.2.18 | Your PHP installation appears to be missing the MySQL extension which is required by WordPress
  78. Windows Setup: Error establishing a database connection
  79. Need help with format of nested array in MySQL
  80. Inserting other fields to existing registration form in a WordPress theme
  81. Advanced WordPress SQL Query
  82. Splitting table data to pages with numbers
  83. 403 Forbidden Localhost Wamp Apache Php
  84. Site doesnt work once PHP changed to 7.1
  85. Changing WordPress author name in database
  86. How to detect if a revision was made by woocommerce or wordpress?
  87. WordPress WPDB::insert 13th param is always blank (only if format)
  88. Ajax not updating to database
  89. can’t delete a row from post_meta table
  90. MySQL query in WordPress with AJAX
  91. MySQL queries in WordPress
  92. retrieve wordpress post-meta using php not wordpress functions
  93. Splash pages on a high traffic site
  94. Let users register weight each day and save it in DB
  95. I am unable to fetch json data from wp_db
  96. Submit cf7 form to cfdb as pdf/BLOB [closed]
  97. How to set variable to specific field when querying
  98. Getting invalid user ID error when creating a new user with wp_insert_user
  99. Custom form that stores data in mysql database
  100. 404 Error after URL update
tech