wpdb select from using array as search parameters

Pass your information through prepare as in this example from the Codex:

$metakey = "Harriet's Adages";
$metavalue = "WordPress' database interface is like Sunday Morning: Easy.";

$wpdb->query( $wpdb->prepare( 
    "
        INSERT INTO $wpdb->postmeta
        ( post_id, meta_key, meta_value )
        VALUES ( %d, %s, %s )
    ", 
        array(
        10, 
        $metakey, 
        $metavalue
    ) 
) );

Your array should have the same number of elements as your query string has placeholders.

Related Posts:

  1. Get 3 row ID’s via ARRAY_A
  2. Fetch array with $wpdb
  3. Create an array with a string key from wpdb->get_results
  4. How to fetch an array in $wpdb?
  5. Save data from a checkbox to a wpdb array
  6. PHP | left join avg query give me Array()
  7. Access to numerically indexed array in wpdb Class and undefined offset
  8. $wpdb->get_results in not an array
  9. Echo only gives me the first part of string
  10. wpdb Cannot Access Associative Array Data in a Count Query
  11. WordPress 4.8.1 uses mysql_connect which doesn’t work with PHP 7
  12. How to use $wpdb to delete in a custom table
  13. Matching database content types to PHP types
  14. Does $wpdb->prepare not create a prepared statement that I can execute multiple times?
  15. $wpdb->last_error doesn’t show the query on error
  16. $wpdb-prepare : Do I have to bind a parameter to the table name?
  17. Saving custom form data into database
  18. Get data from database table by post_id to get data from second database table
  19. wp-content/db.php : where is this file?
  20. $wpdb sql help. Select post id and post meta value based on 2 other post_meta values
  21. $wpdb->get_results() returns good result only in first foreach iteration
  22. $wpdb->insert – inserting multiple rows
  23. $wpdb prepared with search term
  24. WPDB->insert with special characters
  25. Is there a (better) way to access $wpdb results?
  26. $wpdb->prepare not working with update table prefix
  27. How to use prepare to query with variables
  28. Use $wpdb in wordpress theme files
  29. wpdb->get_row() / get_results – is it possible to return an object instances of my own class?
  30. Problem in creating table through plugin code
  31. I want to update my postcontent with $wpdb
  32. $wpdb->replace / Replace or update primary key
  33. $wpdb – do you have to use foreach even if there will always only be one result?
  34. Replicating the WP_Query ‘s’ param with $wpdb
  35. Need help writing a $wpdb query
  36. How to use IN array properly in WordPress?
  37. get the number of queries made on a page(inside my plugin)
  38. Doing a loop with multiple DBs simultaneoulsy
  39. $wpdb->insert query changes to SHOW COLUMNS query Output
  40. Fixing wpdb->get_results and wpdb->prepare?
  41. How does the WXR file differ from the WPDB?
  42. WordPress SQL query – returning ‘true’ ‘false’ or ‘null’
  43. Modify the structure of data returned by $wpdb
  44. WPDB If primary key already exists, add +1 to integer field
  45. How to get an array of user roles with or without a specific capability?
  46. What is wrong with this wpdb update?
  47. Programmatically Creating Page using $wpdb and getting 404 error
  48. Constructing a dynamic WPDB query with multiple LIKEs
  49. Selecting and outputting results from DB with an array
  50. Problem in inserting row to custom database table
  51. 301 Redirect Code
  52. How to write: $wpdb->update having WHERE NOT value pair in the array
  53. Counting posts with argument without retrieving the posts
  54. Read post meta values, only if posts are public
  55. How to display a specific category using a custom Query?
  56. $wpdb->insert inserting only f character in custom table
  57. Why does wpdb->update delete other meta?
  58. Increment integer field in database when WHERE needs to be dynamic [closed]
  59. Getting variable from Database
  60. Create new database through static page code
  61. Custom $wpdb returns unexpected time based results
  62. WordPress “wpdb->update” – Append Text Value
  63. how to connect to another database in wordpress
  64. Need help converting get_user_meta [keys] into own array
  65. Can’t call WPDB inside RSS template
  66. Save sql file after doing insert wpdb
  67. Can I use wpdb to insert query results into a post?
  68. $wpdb->prepare error after WordPress update [duplicate]
  69. Query and get meta as object(stdClass) on wp postmeta table?
  70. How do I query a table?
  71. check that the data exists before sending it to wpdb
  72. How to pass an input value into wpdb->Prepare
  73. no result returns when using $wpdb->get_results with where clause
  74. SQL queries to another wordpress site
  75. update not working using wpdb
  76. get_posts() SQL Injection
  77. og:image functions.php
  78. wpdb replace returning 1 where delete and insert is expected
  79. update_post_meta not working in template_redirect action
  80. How to work with constraints on wordpress user metadata?
  81. $wpdb select returns empty array
  82. Show error messages to a user when database insert fails
  83. Unable to use $wpdb in WordPress
  84. Intermittent problem writing update_user_meta
  85. Create multidimensional array of taxonomies
  86. How to use WHERE NOT EXISTS query to avoid duplicate entry using $wpdb to save in custom table?
  87. Combine posts and postmeta
  88. Getting record from three wpdb tables
  89. wpdb insert working in one function, but not another
  90. Fetching array of postmeta with $wpdb and in_array conditional
  91. wp_commentdata: error in documentation?
  92. Can’t get expected result from a wpdb query
  93. Can’t seem to get set_blog_id working, it just doesn’t reset the blog ID
  94. selecting row using wpdb which contain special symbols
  95. Query Problem in Clustom Plugin
  96. How does $wpdb->get_var work with offset?
  97. Get count of rows based if column exists in two different tables
  98. Table wont load into WPDB
  99. $wpdb:insert, more arguements in $format array than in $data
  100. WPDB prepare – like % – placeholders?