AJAX search posts and pages

The error seams to come from another source, not your query. You don’t use wp_options table. So maybe skipping

$wpdb->show_errors();
$wpdb->print_error();

would make things even work. But probably there is an error somewhere else.

To get an overview how to create AJAX search helper, you can check here:
http://www.wpcodelab.com/archives/create-a-custom-ajax-search-for-wordpress

Related Posts:

  1. What’s the preferred method of writing AJAX-enabled plugins?
  2. Creating two database tables via plugin
  3. Query Posts by Custom Field ‘Price’
  4. How to pass JavaScript variable to PHP in wordpress widget?
  5. AJAX Call Via Vanilla JavaScript In WordPress Plugin Development
  6. How to get posts by content?
  7. Custom plugin giving: wp-admin/admin-ajax.php 400 (Bad Request)
  8. Execute a function using ajax
  9. Errors while using ajax from external wordpress page
  10. Built in admin ajax hooks?
  11. Ajax call doesn’t work in frontend but it’s working in backend (when I’m logged in)
  12. Why is my ajax call refreshing the page?
  13. Admin-ajax.php is dying “0” without processing function
  14. how to use ajax to display from database and load more in wordpress plugin
  15. How to remove an Ajax action
  16. How to create popup same as wordpress popup feature
  17. Only execute jQuery function(on document ready) on the page has shortcode from plugin [duplicate]
  18. How can I reuse the WordPress search form for a custom plugin / widget?
  19. $wpdb working with ajax but showing ajax error instead of success
  20. How use %like% in sql statement wordpress
  21. Ajax gives 400 error
  22. Accessing GET variable named ‘error’
  23. Check if email address exists front end with AJAX in a plugin
  24. WP_Query ordering numbers as letters
  25. WordPress Plugin Page is Loading in Admin Content Container Instead of Separate Page
  26. What is the best way to mimic a search query within a plugin
  27. WooCommerce get_price returning wrong price when used via ajax
  28. Simple ajax call not working in wordpress plugin
  29. switched from query_posts to WP_query, not working now?
  30. __callStatic method handler passed to add_action causes bug in PHP
  31. Using a custom plugin to capture input data via Ajax and PHP
  32. Ajax contact form widget plugin data not insert in database
  33. Search for categories
  34. Best place for if/else piece of code related to custom plugin?
  35. Ajax call returning 0
  36. how to use in custom single.php template using php?
  37. Create tabs in admin options page from custom post type loop
  38. How to create a custom shortcode based on the layout?
  39. Using AJAX to generate front end / viewer end pages
  40. AJAX search as you type? [duplicate]
  41. WooCommerce search products between price range using WP_Query
  42. What are the Best Practises When Using AJAX in Plugin Development?
  43. Redirect to another page using contact form 7? [closed]
  44. Admin AJAX doesn’t work in plugin admin page – Even though code is copied verbatim from WordPress Codex
  45. Submit Form data to another page via Ajax (WordPress Way)
  46. WordPress front end AJAX. Return 0 :?
  47. Using WordPress to build membership Page
  48. woocommerce search by sku and title ajax
  49. Asynchronous request in wordpress
  50. Is there a better way of handling AJAX requests in WordPress?
  51. How to get CPT category checkbox list and show post of selected(multiply) checkboxes via ajax?
  52. WordPress API functions not working at AJAX functions.php call
  53. Calling a class method instantiated by ajax call in wordpress [closed]
  54. Delete data from custom table when deleting a post
  55. Ajax request sends url rather than data
  56. best way to run a php script away from the template?
  57. can’t unzip file
  58. How to search post titles with whole words only, but not the exact word only?
  59. wp_query ‘s’ parameter does not work with WC_AJAX
  60. wc_get_template_part doesnt display the content [duplicate]
  61. How to add the search page link to the anchor tag?
  62. WC Fix Attributes – ‘Add New’ Not Searchable/Delayed
  63. Error datatable whit ajax
  64. adding dynamic/multiple slug values in ‘option_none_value’
  65. How to use Datatable with Ajax when creating plugin on WordPress?
  66. Performance considerations – postmeta table versus new table for custom posts with foreign keys?
  67. AJAX update fails for public/non-admin users
  68. Checkbox field that add a subscription product and change prices of other products in checkout and cart page
  69. WordPress Ajax request “Failed to load resource: the server responded with a status of 400 ()”
  70. WordPress ajax error 400 bad request for sending data to remote site [duplicate]
  71. How to use information from the database in the front-end?
  72. ajax voting for custom post type
  73. User Following System
  74. Custom plugin giving: wp-admin/admin-ajax.php 400 (Bad Request)
  75. Overwriting Plugin’s Ajax callback function from theme
  76. My ajax request don´t work and return 0
  77. WordPress environment not loading properly
  78. wordpress ajax pagination object value does not change
  79. History of page, interval of years
  80. How to insert variable which contain array value in wp_options table?
  81. How can I use wp_ajax_response for front-end error reporting?
  82. How to limit each front-end user to view just his own uploaded files on Amazon S3?
  83. WordPress ajax not working in registration
  84. Shortcode in a blog post, footer and related products stop working
  85. What’s the preferred method of writing AJAX-enabled plugins?
  86. Ajax, jQuery and WordPress
  87. How to get site homepage from plugin?
  88. WP-Snap too slow (caused by WP_Query?)
  89. WordPress Meta Query: Relation is not working correctly
  90. Capturing POST data
  91. Making a Custom Post Type Publish Loop
  92. Checking url from plugin [duplicate]
  93. Help me with my first very basic plugin
  94. Load css classes after using ajax calls
  95. wordpress Ajax success doesn’t return the value
  96. Jquery post responses 500 error after some time and lastly an 503 error
  97. Inline AJAX script passing variables to PHP
  98. Can we install 3d product configurator into wordpress
  99. wordpress admin-ajax bad request 400
  100. Accessing Correct Database to Create REST API Endpoint