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. Trying to GET data with ajax from database and show in fullcalendar
  79. How to use update and delete query in wordpress
  80. How to implement WP_List_Table? WP_List_Table giving array instead of a value in listing table
  81. Show only one post for each author ( Page loads too slow )
  82. Would manually deleting the dumping data fix a “#1062 – Duplicate entry ‘1’ for key ‘PRIMARY'” phpMyAdmin error?
  83. WP database error for comments_popup_link()
  84. How to speed up admin-ajax.php in wordpress
  85. wp_insert_post() is returning the correct post ID, no failure, but the post content does not get updated
  86. Show success or error messages in Ajax response to WordPress custom registration form
  87. How to add a Custom Mailchimp AJAX Newsletter Subscribe Form
  88. Error using WordPress $wpdb object to get result from custom table
  89. How to retrieve the data from the sever and displaying it in a page?
  90. SOAP Request/Parsing XML From wp_send_json_success
  91. Errors being created by admin-ajax.php
  92. Ajaxurl suddenly not defined
  93. How to split AJAX response into two divs
  94. How to set variables with AJAX request to use in another function in WordPress
  95. WordPress mysql deos not work with php7
  96. Need help with AJAX login to call php in functions.php to handle redirects based on user cap (role)
  97. Ajax in a class instantiated via shortcode
  98. Add two or multiple functions in WordPress Post or Page
  99. How to set max users to 17.000
  100. WordPress will suddenly stop saving files uploaded by my code (ran in nopriv ajax)