$wpdb-prepare : Do I have to bind a parameter to the table name?

No, you do not want to swap out the tablename. If you do, the table name will be wrapped in quotes and it will trigger a SQL error. Try:

$table = $wpdb->prefix . 'members';
$qry = $wpdb->prepare("SELECT * FROM %s", $table); 
var_dump($qry);

$qry = "SELECT * FROM $table";
var_dump($result);

The first string is invalid SQL. The second should work provided that you have a table of the correct name.

prepare() is meant to operate on user supplied data– data that could be from questionable sourced with malicious intent. You do not need to swap out data, like your table name, that is not from a questionable source.

What you want is:

$table = $wpdb->prefix . 'members';
$qry = "SELECT * FROM $table";
$result = $wpdb->get_results($qry, ARRAY_A);
var_dump($result);

By the way, your parenthesis are wrong here (even if the rest worked):

$result = $wpdb->get_results($wpdb->prepare("SELECT * FROM %s", $table, ARRAY_A));

The ARRAY_A is an argument to the prepare and not to the get_results. It should be (though the value swapping is wrong as explained above):

$result = $wpdb->get_results(
  $wpdb->prepare("SELECT * FROM %s", $table), 
  ARRAY_A
);

Related Posts:

  1. SELECT query with prepare and placeholder for string
  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. Best way to do nested case statement logic in SQL Server
  23. Using wpdb to connect to a separate database
  24. wpdb->insert multiple record at once
  25. Delete row of custom table in WordPress using AJAX
  26. $wpdb->insert Database Error Duplicate Entry Error Logging
  27. Make Selected Mutiselect Items “selected”
  28. Set media metadata (i.e. “dimensions” field) on SVG file after extracting it with a filter
  29. $wpdb not returning data
  30. How to replace a javascript select box onchange event to a form submit action?
  31. When and why should I use $wpdb different return types?
  32. $wpdb->insert inserting two rows in database
  33. How to best delete orphan wp_postmeta
  34. How do I batch create revisions of all posts?
  35. How to email user after inserting the username in database in WordPress
  36. Bootstrapping WordPress MultiSite Outsite of WordPress – No $wpdb
  37. $wpdb select date range of posts
  38. Extracting the post_id via the wp_insert_post action (external db query)
  39. Rolling Back from current WordPress version to previous one
  40. Can’t get wp_insert_post to work
  41. Wp_query function to search from product_title ‘OR’ product tags name
  42. Intermittent database errors when accessing WordPress database
  43. Get parent and children taxonomy in different dropbox
  44. Foreach loop not working as expected – custom tables and references while submitting a form
  45. Update from 4.5 to 4.6 failing
  46. Undefined offset: 0
  47. Connect to separate database using $wpdb and authenticate user
  48. how to use $wpdb->prepare to update a custom table
  49. Super administrator db name
  50. Creating a post from data returned from HTML form
  51. Sorting main query by custom taxonomy slug
  52. Accessing two databases wordpress
  53. How to pass orderby params to $wpdb->prepare()?
  54. $wpdb->query can’t insert data
  55. Build index page from custom fields
  56. wpdb->get_row is selecting the variable as a column name
  57. Problem migrating to localhost
  58. wpdb Cannot Update column in Database
  59. Display category names on edit user profile using $wpdb
  60. How to set MYSQLI_OPT_INT_AND_FLOAT_NATIVE option
  61. Sorting dynamic select/dropdown for Contact Form 7 of Modern Tribe Events posts
  62. How do I prepare strings for insertions as values into a MySQL table?
  63. WPDB – Read and write value from / to database
  64. How to insert dash (-) into database using wpdb and new_to_publish hook?
  65. wpquery properties last_query and last_result : should these be public or private?
  66. Add a select-option to the default widgets
  67. Disable (or limit) queries when certain content (or data) is not needed (or showed)
  68. Formatting a date/time returned from a custom $wpdb query
  69. How to display specific data from a custom table to logged in users with a custom role
  70. wpdb->insert with special chars failing with collation utf8mb4_unicode_520_ci
  71. How to escape percentage sign(%) in sql query with $wpdb->prepare?
  72. $wpdb->delete not working for me
  73. WordPress Gutenberg Signal on Block Alignment Change
  74. How to securely controlling data without keeping it in postmeta?
  75. Doing $wpdb->get_results returns NULL, doing the same query in my DB returns correct value
  76. Looping through custom data in a custom table to display all items in a post
  77. Images names not inserting in WordPress Database from Dynamic Add / Remove fields
  78. Echo Option Value Based On WordPress User Role
  79. Debugging db calls: $wpdb->insert works on test site, not on identical production site
  80. Update custom table on metabox POST
  81. Should I Use only wpdb Class to Write Custom Queries?
  82. CONCAT_WS in custom sql query
  83. Include post_status check within $wpdb query
  84. wpdb get_row database query inquiry
  85. Depreciated Call -> Function wpdb::escape()
  86. Run insert if no entry otherwise run update with ajax
  87. Inserting and updating rows with wpdb indreases integer fields by 1 point sometimes
  88. Widget & storing a Select box choice
  89. Can’t save drop down select date in meta boxes
  90. Save/retrieve form data best practises for theme development
  91. Select Menu for Custom post Type does not save
  92. MySQL database migration to WordPress
  93. Error inserting row into table
  94. How does offset works on pagination? (get_results)
  95. How to reference same column name but different table in custom db query
  96. Retrieving custom field array value through db query
  97. Form Value of drop down category + Translation of ‘show option none’
  98. Initialization of table in database using ‘CREATE … IF NOT EXISTS’
  99. WP_Query post_tilte search in posts table
  100. Uploading to WordPress Database

Leave a Comment

tech