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. Selecting multiple columns in a Pandas dataframe
  23. How do I UPDATE from a SELECT in SQL Server?
  24. SQL SELECT WHERE field contains words
  25. SQL query to get the employee name and their manager name from the same table
  26. SQL SELECT WHERE field contains words
  27. Select objects based on value of variable in object using jq
  28. SQL SELECT WHERE field contains words
  29. ORA-01843 not a valid month- Comparing Dates
  30. SQL update from one Table to another based on a ID match
  31. MySQL SELECT increment counter
  32. Best way to do nested case statement logic in SQL Server
  33. ORA-01830: date format picture ends before converting entire input string / Select sum where date query
  34. MySQL “Or” Condition
  35. MySQL – UPDATE query based on SELECT Query
  36. How to write a SQL DELETE statement with a SELECT statement in the WHERE clause?
  37. Create a temporary table in a SELECT statement without a separate CREATE TABLE
  38. SQL: Two select statements in one query
  39. grant select on view
  40. SQL conditional SELECT
  41. MySQL Select Multiple VALUES
  42. DATEDIFF function in Oracle
  43. MySQL error: Unknown column in ‘where clause’
  44. Postgresql column reference “id” is ambiguous
  45. How to order by column A and then by column B?
  46. Using wpdb to connect to a separate database
  47. How do you properly prepare a %LIKE% SQL statement?
  48. How to print the excuted sql right after its execution
  49. $wpdb->get_row() only returns a single row?
  50. Should I use wpdb prepare?
  51. WPDB Insert or if exists Update
  52. Query to sort a list by meta key first (if it exists), and show remaining posts without meta key ordered by title
  53. Showing errors with $wpdb update
  54. How to return number of found rows from SELECT query
  55. How to use wp_nav_menu to create a select menu dropdown?
  56. Is it mandatory to use $wpdb->prefix in custom tables
  57. wpdb->insert: do I need to prepare against SQL injection?
  58. get_results using wpdb
  59. How to programatically change username (user_login)?
  60. Contact form 7 select box different value-text than content-text in option [closed]
  61. $wpdb won’t insert NULL into table column
  62. How to parse row results from $wpdb -> get_results
  63. Why $wpdb->show_errors() and print_error() is showing an output even if the query output is correct?
  64. what is the way to see the currently executing query in wordpress?
  65. Fetch array with $wpdb
  66. How do I check for a duplicate record before inserting using wpdb
  67. Pagination with custom SQL query
  68. Get error messages when $wpdb->insert() returns false?
  69. Return only Count from a wp_query request?
  70. Detecting errors generated by $wpdb->get_results()
  71. Does dbDelta delete columns as well?
  72. WordPress 4.8.1 uses mysql_connect which doesn’t work with PHP 7
  73. wpdb update add current timestamp not working
  74. How to fetch Data in WordPress using MySQLi or $wpdb
  75. How to use $wpdb to delete in a custom table
  76. $wpdb->insert not working in any way
  77. WPDB prepare – like % – placeholders?
  78. How to delete all records from or empty a custom database table?
  79. dbDelta only creates the last table
  80. WordPress Paginate $wpdb->get_results
  81. wpdb->insert multiple record at once
  82. Differences between wpdb->get_results() and wpdb->query()
  83. $wpdb->insert_id
  84. Can i use php sql functions instead of $wpdb?
  85. Does a query executed through wpdb class get cached?
  86. $wpdb->update multiple rows, like IN in normal SQL
  87. What are the differences between wp_users and wp_usermeta tables?
  88. What is the best way to sanitize data?
  89. Matching database content types to PHP types
  90. $wpdb->get_results(…) returns empty array despite correct query
  91. Assign a Class to the Current “Tag” for Formatting
  92. Does $wpdb->prepare not create a prepared statement that I can execute multiple times?
  93. WordPress Unit Testing – Cannot Create Tables
  94. Use wpdb->prepare for `order by` column name
  95. How to define composite keys with dbDelta()
  96. get_results on large datasets
  97. Does wpdb add considerable overhead on queries with large result sets?
  98. $wpdb->insert() and Values for Datetime Columns?
  99. How to correctly submit a search form and display the result in an independent page
  100. SELECT max(meta_value) FROM wp_postmeta WHERE meta_key=’price’… stops working when value is over 999
Hata!: SQLSTATE[HY000] [1045] Access denied for user 'divattrend_liink'@'localhost' (using password: YES)