Sql formatting for post data within function

It isn’t showing wp_posts.post_content LIKE '%test%' because the wildcards (%) in the prepared statement are converted to placeholder escape strings (like the {a19f0a6c3d866f7270be0f3954cbb2600270400c15f488e112449a8a131701f0} in your post) when wpdb::prepare() calls wpdb::add_placeholder_escape() which “Adds a placeholder escape string, to escape anything that resembles a printf() placeholder“, i.e. a placeholder like %s.

But those placeholder escape strings will be changed back to % when the statement is passed to MySQL, so there’s no need to worry about those escape strings.

Additionally, make sure to use the correct prepare() syntax — there should be at least one placeholder and a substitution argument (for that placeholder) like so: $wpdb->prepare( "SELECT * FROM foo WHERE bar = %s", 'bar value' ).

Also, you should apply wpdb::esc_like() on the $search value to ensure % in the value are properly escaped.

And you might also want to check out my recent answer here because (I thought) the question there seemed quite similar to your question..

Related Posts:

  1. Can’t get result from sql using ajax result
  2. Counting Posts with multiple taxonomy and terms condition using MySQL and AJAX
  3. ASP.NET MVC controller actions that return JSON or partial html
  4. How to cache json with wp-super cache
  5. Why use wp_send_json() over echo json_encode()?
  6. How to call a PHP function with Ajax when the user clicks a button
  7. WordPress function that makes HTML safe to be sent via AJAX request
  8. Delete row of custom table in WordPress using AJAX
  9. WP REST API route request explain
  10. How to use wp_send_json_error?
  11. Most performant way of fetching remote API data?
  12. json encode not work in wordpress
  13. Unable to parse JSON response from wp_send_json_success [closed]
  14. Updating a checkbox value to database for specific row in table
  15. Ajax store response json in variables
  16. How do I query posts by a sub value with the API?
  17. Cache wp-json/posts without a plugin?
  18. merge wp rest api query to get posts per category does not work
  19. Retrieve JSON file from JS trough php
  20. Ajax insert or update data
  21. Creating an auto result search bar
  22. Ajax call in wordpress not working for subscriber user
  23. Upload data from weather station to WordPress Website
  24. How can I wp_send_json data?
  25. Full Front End, AJAX comment system and comment reply script
  26. Send checkbox status with Ajax / JSON and save it
  27. Chained ajax call, second call returns 0
  28. Use AJAX in a WordPress Plugin to Get Data From Custom Database?
  29. WordPress ajax response save into database
  30. Display full WordPress post under search form using AJAX
  31. Can I use application/json content type in WordPress
  32. Using wp_send_json_success instead of $result[‘message’], die, etc
  33. Not getting ajax success response on insert/update row to database
  34. AJAX POST Value not being returned – WordPress – AutoTrader API
  35. Ajax call works for logged in users and returns “Bad Request” for guests [duplicate]
  36. AJAX is not submitting data to database
  37. How to inject data content from external json into a modal, using UIkit?
  38. how to correctly use json_encode with ajax
  39. WorddPress website admin part not working correctly – I think ajax/json issue
  40. 403 error for ajax POST request
  41. Ajax WordPress pass post URLs
  42. How to populate data from JSON using AJAX in TypeScript? [closed]
  43. Creating an Angular factory from custom database table
  44. AJAX call in backend results in empty update_option
  45. WordPress Ajax JSON success return no being recognized
  46. Ajax contact form returnig 0
  47. Ajax Form data is not posted back to the get_results()
  48. AJAX Call in Plugin Returns More than JSON
  49. Usage of wp_send_json_success and wp_redirect at the same time
  50. Can’t access data from database using AJAX
  51. Translating wordpress foreach to ajax
  52. WordPress Ajax – looping data into a table
  53. $wpdb Ajax not redirecting to main page
  54. Adding custom fields to Wired Impact Volunteer Management Plugin
  55. Bad Request 400… jQuery ajax post of json data to wordpress admin-ajax.php
  56. Successful ajax call returns lots of whitespace and text of code with 0
  57. Using $.ajax getting 500 error
  58. JSON parsing error syntax error unexpected end of input
  59. Can JavaScript connect with MySQL?
  60. wpdb->prepare function remove single quote for %s in SQL statment
  61. Admin Notification after save_post, when ajax saving in gutenberg
  62. Cannot load admin-ajax.php. No access-control allow origin*
  63. Initialize JS with an ajax loaded ACF form
  64. AJAX returns response 0
  65. Nonces and Ajax request to REST API and verification
  66. Vue.js + AJAX Shortcode
  67. Is there a (better) way to access $wpdb results?
  68. wp_ajax action is not running
  69. wp_verify_nonce doesn’t return true on server when it matches the nonce
  70. get posts and postmetas in assoc array
  71. wp-admin AJAX with Fetch API is done without user
  72. Need help writing a $wpdb query
  73. Populating content dynamically via AJAX and Advanced Custom Fields [closed]
  74. SSO autologin WordPress + Ajax
  75. How to handle 400 status in Ajax [duplicate]
  76. How to process wordpress ajax call without action parameter?
  77. 400 Bad Request when sending XHR from React.js to admin-ajax.php
  78. Making POST request with AJAX returns a 400 error (without jQuery)
  79. Load image src through Ajax by ID?
  80. Using get_theme_mod in php ajax form doesn’t work
  81. PHP session when called wp_ajax_nopriv
  82. What exactly does ‘authenticated’ mean for wp_ajax_nopriv?
  83. WordPress Ajax Not Firing
  84. Is it good practice to use REST API in wp-admin plugin page? [closed]
  85. get a bad request 400 on my ajax-admin.php file
  86. Help posting values to DB on submit using $wpdb->query
  87. How to check Ajax request only when i opened the Notifications list?
  88. How to send the checkbox value to email
  89. wp_send_json erase last value
  90. Ajax take too long to return code
  91. problem when adding wp_editor with ajax [duplicate]
  92. Get wp-load.php PATH with wp_localize_script and JavaScript for plugin
  93. Ajax request to admin-ajax.php and window.location.href
  94. where does my function output from load-* go?
  95. Adding a time stamp on post view
  96. WordPress ajax requst returns zero
  97. WordPress blocking polling request when signed into Admin
  98. Send button using own contact form [closed]
  99. Run PHPMailer function after ajax function completes that adds row to custom table
  100. How to get variable from other function inside class function using add_action for Ajax call