SELECT query with prepare and placeholder for string

You need to define $wpdb as global.

Try this code.

global $wpdb;

$mail = $_POST['email'];

$table = $wpdb->prefix . 'members';

$result = $sql->get_results( "SELECT * FROM $table WHERE email = %s", $mail);

Related Posts:

  1. $wpdb-prepare : Do I have to bind a parameter to the table name?
  2. How to check if page has status published
  3. Triple meta_key on custom SELECT query
  4. MySQL Rank & $wpdb
  5. wp_Qwery works to slow
  6. How to get last user with wpdb?
  7. Read post meta values, only if posts are public
  8. ACF Pro select field problem [closed]
  9. Custom select query two tables by a meta key
  10. Get results from wordpress data custom table
  11. Select From wpdb – Author/User Directory page
  12. Database SQL query error
  13. SELECT rows between two datetimes when the range is dynamic [closed]
  14. How to search usermeta table
  15. Get 3 row ID’s via ARRAY_A
  16. Ajax Form data is not posted back to the get_results()
  17. wpdb select from using array as search parameters
  18. AJAX with Selectbox Plugins (Select2, Chosen, Selectize)
  19. Ajax Query returns zero
  20. Is there a way to select posts and print to a template page dynamically?
  21. Display the posts in a category with
  22. MySQL SELECT increment counter
  23. How do you properly prepare a %LIKE% SQL statement?
  24. How to correctly submit a search form and display the result in an independent page
  25. Using $wpdb to query posts with meta value containing current post_id
  26. WPDB Multiple site’s posts and get featured images
  27. How to select one major category (or custom taxonomy) for a custom post type?
  28. Merging PHP download script into `functions.php`
  29. Want to filter only parent post in admin area
  30. get_query_var(‘paged’) giving same result
  31. $wpdb is get_results escaped
  32. Safe way to find last inserted id in a table?
  33. wpdb prepare: passing varible number of fields as second argument
  34. How to get a list of taxonomy terms which are being used only within certain post types?
  35. Wpdb query for comment meta for current post
  36. What’s the proper way to use a custom table? [closed]
  37. How to Modify this $wpdb query to accept an array of post statuses
  38. Multiple postmeta with same name for one post in wp_postmeta table
  39. Using $wpdb->update but confused on the WHERE in and SET
  40. WPDB Update using Conditional Arrays
  41. Get published posts and pages?
  42. What’s the purpose / logic of split_the_query in WP_Query->get_posts
  43. Make one query for adding entries to database
  44. WordPress select field – show current value?
  45. WSoD being caused by this piece of code
  46. Converting the_content string to an array?
  47. Creating mySQL procedure with $wpdb
  48. Display custom fields from custom posts in RSS feed
  49. How to Instantiate wpdb Object in New File
  50. Return terms from multiple taxonomies using $wpdb
  51. How WordPress reacts to a lack of memory of the server [closed]
  52. Optimizing WordPress Queries – Removing Group By ID
  53. External DB Connection [closed]
  54. $wpdb->insert() does not Insert record in a table
  55. custom hooks before a comment is updated/edited in the database
  56. Custom query: Get all posts that are from a certain category?
  57. $wpdb error (Call to a member function insert() on a non-object)
  58. Custom Query based on custom field of a single post
  59. WordPress db prepare
  60. Can’t update multiple rows with $wpdb query
  61. how to get db values without using an loop with wpdb->get_results()
  62. Mixing variables into an array when inserting values
  63. paginate_links on custom query in admin – ‘sufficient permissions’ error
  64. get_results query with accent
  65. Output: “Array”
  66. Is querying wpdb directly and skipping actions provided by WP’s core “wp_update_post” a good idea?
  67. Delete database record using plugin from admin panel
  68. Using “->” in a page to exceute $wpdb query gives error
  69. How to get product order by two custom taxonomy in wordpress
  70. Why is this $wpdb query looping 5 times?
  71. wpdb query not returning results containing single quotes
  72. form $_post action value gets truncated after it passes through two forms
  73. Making jQuery .change() event persistent after widget save
  74. Updating with $qpdb->query() always returns 0 rows affected
  75. duplicate entries in database while using save_post or wp_insert_post
  76. WP MS: How to query over the network
  77. $wpdb is queried but results don’t show
  78. Plugin to create Posts and Forums then choose category and parent forum
  79. when using $wpdb sudden connection rejection without changing anything. Access denied, with errors from repair tool
  80. sort title descending with title with number
  81. How to have differents sites share the same tables of DB?
  82. Using external DB within wordpress
  83. Get last element from wpdb as a string
  84. Optimising amount of calls to custom fields
  85. Update all fields of table with ON DUPLICATE KEY UPDATE command
  86. WordPress – wpdb query does not list same result as sql query
  87. What is the best practice to initialise $wpdb by loading wp-load.php?
  88. wpdb->insert adds too many rows
  89. Search Query that Includes Custom Table
  90. Querying multiple meta_keys in WordPress SQL query
  91. WordPress plugin tables become corrupt
  92. $wpdb returns no results with SELECT query on custom post type, works on default post type
  93. Jeditable Plugin working as it should – scope issue?
  94. Fixing plugin for wpdb::prepare
  95. how to use transient method?
  96. Issues on saving data from CPT select metabox
  97. How to dispaly post informations (such as titles) in an admin plugin menu page?
  98. WordPress shortcode select option not working [closed]
  99. How to create a fully functional user registration in WordPress?
  100. Table wont load into WPDB