Ajax $wpdb not returning table data

The main problem, I see in your code, is that you use query method of wpdb and assume that it is PDO statement object…

But it is not.

Take a look at wpdb Codex:
https://codex.wordpress.org/Class_Reference/wpdb

query method is used to run custom queries on DB – that’s all.

What you want to use is get_results.

And BTW, seriously, do never concatenate user input with SQL statements. Such data should ALWAYS be escaped properly – otherwise you create SQL Injection vulnerability. You can use prepare method to create safe queries in WP.

I also don’t think you should echo wp_send_json_success – I’m pretty sure this function already echoes values…

And one more thing… Your hooks are wrong. You send action wc_get_..., but then use hooks like wp_ajax_call_wc_get... (so your php code assumes the action is call_wc_get....

Related Posts:

  1. How to use AJAX in WordPress in MYSQL query?
  2. MySQL query in WordPress with AJAX
  3. How to return number of found rows from SELECT query
  4. Can i use php sql functions instead of $wpdb?
  5. $wpdb->delete column values IN ARRAY()?
  6. Custom query to get post names beginning with a digit
  7. simple wordpress ajax plugin not working when not logged in
  8. Jquery ajax to custom php file: returning blank data
  9. Can’t use get_results() in ajax query
  10. Is the regular ajax request method safe or I should use admin-ajax.php?
  11. Use ajax to update_post_meta
  12. AJAX in WordPress, sending coords data to MySQL and show after into map
  13. WordPress get pagination on wpdb get_results
  14. Converting MYSQL to WordPress $WPDB
  15. How to Fetch values from WP database based on selected option value by onchange using PHP?
  16. Why is variable not working on custom sql query using wpdb?
  17. Show MySQL errors that occur when I excute $wpdb->insert()
  18. Any possible way to make $wpdb->get_results() return anything else than array?
  19. Checking for new message using AJAX and PHP. Server overload?
  20. Can’t get wp_insert_post to work
  21. WSoD being caused by this piece of code
  22. I want to select the from values from database in WordPress? [closed]
  23. Update results, Before deleting the related category [closed]
  24. wp query foreach deleting record returning only first or last item
  25. Refresh table data with Ajax
  26. Database query works fine outside WordPress
  27. Using $wpdb (WPDB class) ‘replace’ with multiple WHERE criteria problem
  28. $wpdb->insert() does not Insert record in a table
  29. Help with a $wpdb MySQL Query
  30. Custom array from a query only write the last row of the query
  31. $wpdb returns duplicate posts
  32. Mixing variables into an array when inserting values
  33. Use $wpdb or other PHP script method to find/replace in WP database
  34. How can I add a new row in a separate database when someone registers via WordPress?
  35. Basic wpdb update question
  36. I can’t update my data through $wpdb
  37. A $_POST should occur when submit form but is not?
  38. Output: “Array”
  39. How to use mysql LIKE with wpdb?
  40. Cannot access $wpdb, comes back NULL
  41. Submitting a form, using Ajax, to run a SQL Select query based on user input from the form
  42. How do I prepare strings for insertions as values into a MySQL table?
  43. Live search from database table
  44. Processing ajax call to php to insert into mysql database
  45. form $_post action value gets truncated after it passes through two forms
  46. Why won’t this wpdb get_results query return results?
  47. WPDB secure custom form
  48. Add row to custom database Table and delete all rows older than 1 day
  49. select a single val though a table in wordpress
  50. populate select options from extra mysql table data
  51. Query the links Database
  52. MySQL Query Returns Array () In Shortcode
  53. Using Ajax to submit a form, and run a SQL Select query based on user input from the form
  54. Passing in MySQL prepare statement parameter separately throwing error
  55. Convert a column of a table containing an Array as response in HTML
  56. Database SQL query error
  57. MYSQL TIMESTAMP when adding DATE_FORMAT then the output is blank, PHP conflict?
  58. Conditional formatting on data fetched from MYSQL
  59. What is the correct way to search 3 custom fields only in WordPress?
  60. Using wpdb to connect to a different database is not working
  61. autocomplete in wordpress using ajax with json-data
  62. Rewrite SQL query as a prepared statement and use in foreach loop
  63. Prepared DB Query from _POST array
  64. Advanced WordPress SQL Query
  65. Ajax not updating to database
  66. Passed variable gets undefined variable error on insert on next page
  67. Run insert if no entry otherwise run update with ajax
  68. MySQL queries in WordPress
  69. Using the same shortcode to show any table from the database
  70. AJAX with Selectbox Plugins (Select2, Chosen, Selectize)
  71. MySQL database migration to WordPress
  72. How to display inputted data in Ajax without button or click event
  73. WordPress Query -> Ajax Query
  74. how to display tables via ajax
  75. Error resetting database index using ALTER TABLE in $wpdb->query
  76. Putting form result in my database
  77. How can I update a value of a field depending on outside source?
  78. Fatal error: Call to undefined function mysql_connect()
  79. the_date() not working
  80. PHP calling AJAX function that relies on passed PHP function values not working
  81. WordPress Ajax Data problem
  82. PHP/MySQL issues when running WP on EC2 cloud [closed]
  83. ajax_object is not defined when ajax calls the function
  84. How to prevent those PHP variables from being cached on WordPress?
  85. Use ajax from function.php
  86. database interactions using OOP
  87. Ajax loaded form replaces form action with Ajax url
  88. prevent default not stopping page refresh. Passing form information to and from php with ajax in a wordpress site
  89. get_posts() and WP_query limits ‘AND’ conditions to a maximum of 6 for meta value queries in WordPress
  90. [jQuery]Adding shortcode
  91. Display parent and child taxonomies in separate drop down select fields
  92. WordPress admin-ajax.php 400 bad request
  93. javascript variable to wordpress php variable
  94. Output votes to div dynamically in wordpress
  95. Load more posts using AJAX based on posts inside WP_Query
  96. Store GA Client ID in User DB
  97. Not getting ajax success response on insert/update row to database
  98. Need help with format of nested array in MySQL
  99. Site doesnt work once PHP changed to 7.1
  100. can’t delete a row from post_meta table