Database query works fine outside WordPress

After struggling with different functions , I figure out $wpdb->get_row() and $wpdb->get_var()
The first one returns rows into an associative array or numerical array , depends on the second argument in $wpdb->get_row('query',ARRAY_A or ARRAY_N or OBJEECT) and the second one that I used to solve my problem return only one variable from particular table.
e.g,

<?php
$user_count = $wpdb->get_var( "SELECT COUNT(*) FROM $wpdb->users" );
echo "<p>User count is {$user_count}</p>";
?>

Reference link

Related Posts:

  1. How to return number of found rows from SELECT query
  2. Can i use php sql functions instead of $wpdb?
  3. $wpdb->delete column values IN ARRAY()?
  4. Custom query to get post names beginning with a digit
  5. WordPress get pagination on wpdb get_results
  6. Ajax $wpdb not returning table data
  7. Converting MYSQL to WordPress $WPDB
  8. Why is variable not working on custom sql query using wpdb?
  9. Show MySQL errors that occur when I excute $wpdb->insert()
  10. Can’t get wp_insert_post to work
  11. WSoD being caused by this piece of code
  12. I want to select the from values from database in WordPress? [closed]
  13. Update results, Before deleting the related category [closed]
  14. wp query foreach deleting record returning only first or last item
  15. Using $wpdb (WPDB class) ‘replace’ with multiple WHERE criteria problem
  16. $wpdb->insert() does not Insert record in a table
  17. Help with a $wpdb MySQL Query
  18. Custom array from a query only write the last row of the query
  19. $wpdb returns duplicate posts
  20. Mixing variables into an array when inserting values
  21. Use $wpdb or other PHP script method to find/replace in WP database
  22. How can I add a new row in a separate database when someone registers via WordPress?
  23. Basic wpdb update question
  24. I can’t update my data through $wpdb
  25. Output: “Array”
  26. How to use mysql LIKE with wpdb?
  27. How do I prepare strings for insertions as values into a MySQL table?
  28. How to use AJAX in WordPress in MYSQL query?
  29. form $_post action value gets truncated after it passes through two forms
  30. Why won’t this wpdb get_results query return results?
  31. WPDB secure custom form
  32. Add row to custom database Table and delete all rows older than 1 day
  33. select a single val though a table in wordpress
  34. populate select options from extra mysql table data
  35. Query the links Database
  36. MySQL Query Returns Array () In Shortcode
  37. Passing in MySQL prepare statement parameter separately throwing error
  38. Convert a column of a table containing an Array as response in HTML
  39. Database SQL query error
  40. MYSQL TIMESTAMP when adding DATE_FORMAT then the output is blank, PHP conflict?
  41. Conditional formatting on data fetched from MYSQL
  42. What is the correct way to search 3 custom fields only in WordPress?
  43. Using wpdb to connect to a different database is not working
  44. Rewrite SQL query as a prepared statement and use in foreach loop
  45. Advanced WordPress SQL Query
  46. MySQL query in WordPress with AJAX
  47. Passed variable gets undefined variable error on insert on next page
  48. MySQL queries in WordPress
  49. Using the same shortcode to show any table from the database
  50. MySQL database migration to WordPress
  51. Error resetting database index using ALTER TABLE in $wpdb->query
  52. Putting form result in my database
  53. How can I update a value of a field depending on outside source?
  54. Fatal error: Call to undefined function mysql_connect()
  55. Query both first_name and last_name from wp_usermeta at the same time
  56. How to add query vars with paginated URLs?
  57. How to Join two tables from separate databases within WordPress
  58. simple wordpress ajax plugin not working when not logged in
  59. Install will not load: PHP does not have MYSQL installed
  60. Insert post without actions/hooks
  61. Import 10,000 Users into WordPress WITH a specific ID for each user
  62. Unusable menus and “Illegal widget setting ID: nav_menu_item[]” error
  63. How to get the post_id from postmeta
  64. Styling images coming from another blog
  65. register_activation_hook isn’t adding table to DB
  66. Query String being Removed Creating a Pagination Issue within a Custom Plugin
  67. How to Fetch values from WP database based on selected option value by onchange using PHP?
  68. Custom Plugin For Converting CSV To MySQL
  69. Checking for new message using AJAX and PHP. Server overload?
  70. Trying to establish connection to External Database
  71. $wpdb->update with multiple parameters gives error
  72. inserting a post from an extern php file but post content doesn’t show on wp site
  73. Not connecting to database in file with multiple MySQL connections
  74. Way to bulk make all my tags lowercase?
  75. $Wpdb post meta query is not working with mutliple meta keys and values? [closed]
  76. php include not working in custom page
  77. email alert for product availability
  78. wpdb Cannot Update column in Database
  79. add category to posts with tag wordpress
  80. How can I Use 2 databases with one WordPress install
  81. WPDB – Read and write value from / to database
  82. How to Generate a list of Most Commented post?
  83. Using Ajax to submit a form, and run a SQL Select query based on user input from the form
  84. WordPress low speed after migrating to new host
  85. AWS Lightsail WordPress – connect to database on instance using mysqli
  86. call to undefined function mysql_connect
  87. How to edit content in WordPress and the Polylang – plugin? – with demosite
  88. Looping through custom data in a custom table to display all items in a post
  89. Insert data from form to database
  90. Prepared DB Query from _POST array
  91. Conditional statement within WP SQL query
  92. Run insert if no entry otherwise run update with ajax
  93. WordPress upload images not displaying
  94. two wordpress sites, two themes, one database, same content
  95. how to check for wordpress Query errors
  96. Custom query_posts() parameter
  97. Query Concatenation
  98. Display total count of products in orders of a specific order status
  99. inner-wrap div pushing custom table far down on page
  100. running an existing WordPress site from Visual Studio Code?