wpdb get results doesn’t work with variable

Try it:

$search_by_input= $_POST["search_by_input"];
$client_id_by_nick_name = $wpdb->get_results( sprintf( "SELECT user_id FROM `%s` WHERE meta_value="%s";", $user_meta_table, $search_by_input ), ARRAY_A);

Related Posts:

  1. When to use WP_query(), query_posts() and pre_get_posts
  2. WP Query Args – Title or Meta Value
  3. WordPress Pagination Not Working – Always Showing First Pages Content
  4. Whats the difference between post_limits and pre_get_posts?
  5. WP query taxonomy input differs to output?
  6. Query WooCommerce orders where meta data does not exist
  7. How to get Page/Post Gallery attachment images in order they are set in backend using WP_Query()?
  8. What exactly does the ‘s’ parameter search for in WP queries?
  9. WP_Query min and max values
  10. get_posts not finding argument: post_name
  11. get query’s query string
  12. Show only oldest post by author
  13. assign 2 $args to one wp_query
  14. WP_Query OR clause for tax_query and keywords
  15. Revolution Slider Orderby Two Custom Fields
  16. Calling a custom excerpt function in a local loop
  17. Get random terms
  18. Dynamically Override Fancy Title – Part II
  19. Transient pagination not working properly
  20. How to run query inside a class with namespace?
  21. Which filter/action hook gets triggered after a query has been performed?
  22. WP_Query & AJAX
  23. Sticky Post default functionality with WP_Query is ignored when using AJAX
  24. tax_query OR with empty result returns all posts
  25. WP_Query Order by Specific Post ID First
  26. Custom Query – show first post twice?
  27. Using one WP_Query object within the loop of another WP_Query object
  28. Order by slug in get_terms with multiple taxonomies
  29. Is there any advantage of using default WordPress Search instead of creating a custom one?
  30. How to access WP database inside ipn.php? [duplicate]
  31. is_tax() function not working as expected
  32. Getting the current post number / make posts increment
  33. posts_per_page not working for first page of pagination
  34. Advanced ordering of query_posts
  35. Add class to first post in custom loop using post_class filter
  36. Taxonomy and Date in same query?
  37. echo a specific meta_key queried through a custom post
  38. WP_Query with meta_query dosen’t return results
  39. Get latest post revision with wp-query
  40. How to show more post at a given category?
  41. WP_Query returns posts_per_page + 1 every time
  42. Custom WP query with polylang term
  43. All posts returned when author of 0 is queried
  44. Merge two search functions for custom post type
  45. WP_Query – Accessing MetaValue from Query Result
  46. problems with comments_number()
  47. Trying to retrieve random post, getting a page
  48. get_the_terms – but only show 4 Posts
  49. Does WordPress have something like Drupal’s DB API?
  50. PHP – Loop custom post type categories within jQuery Tabs
  51. How order posts from category by date and comment count?
  52. Get a list of ACF Repeater-Fields as array
  53. query_vars empty when using custom url with custom rewrite rule
  54. Get query results with a page title
  55. Show single posts date, in a page of posts
  56. Post archive for certain post format
  57. How to filter multiple queries with search?
  58. Compare “Main” post ID to ID inside wp_query loop
  59. Attempt to display site authors in a carousel – User Image not Outputting inside li tags
  60. Add AJAX “Load more” on custom query block
  61. problem with the loop
  62. Order WP_Query by meta_key priority when ‘OR’ relation used for multiple meta values
  63. Why my query is not “Main_query”?
  64. Filter sub-category from checkbox form
  65. Facing problem with tax_query results
  66. How to add a “base” filter for all posts visible to visitors on the site?
  67. sanitize_post() is not sanitizing Post Object
  68. WP_Query() not filtering posts for category
  69. Move some posts to end of sort order, even if there is a sort in the wp_Query already
  70. wp query search multi terms
  71. Translating WP query into to SQL query
  72. How to get top rated posts using wp query?
  73. Unusual high query of user meta data
  74. Woocommerce featured products query no longer working
  75. add action for wordpress query at a specific position
  76. How to query wordpress with array of meta_values?
  77. WP Query Meta Query
  78. Updating an intensive wp_query result once daily
  79. Custom WP_query and integrating into theme file
  80. Empty ‘terms’ in ‘tax_query’ returns an empty array
  81. Get newest value of an array
  82. Filter custom post type by custom taxomony
  83. Return a single custom post from multiple meta queries
  84. ordering and optimizing functions
  85. Why does order ASC break offset in WP_Query?
  86. new WP_query using custom fields
  87. Having Trouble Running Query From Shortcode Using Tribe’s Events Plugin
  88. Change ‘post_modify’ with a query
  89. An archive page without post format (just standard post)
  90. Dynamically create array from page title
  91. Ordering Custom WP_Query loop by meta key value with pagination
  92. wp_pagenavi on WP_Query using customfields
  93. paginate_links() on page (shortcode output)
  94. WordPress Query Returning Every Post
  95. Pagination showing same posts despite changing page
  96. shortcode with $atts with strange results
  97. Query custom post types by meta field in a term from custom taxonomy
  98. Using ‘meta_query’ with the ‘pre_get_posts()’ hook disables searching for post titles
  99. Woocommerce set loop_shop_columns to be 3 in the main shop page loop only and 4 otherwise
  100. How to save the results of a query as a php file for an autocomplete search bar