$wpdb->prepare was called incorrectly when inserting multiple records

Well, you don’t need the second $wpdb->prepare() and just do $wpdb->query( $query );. The reason is because the $query does not contain any placeholders just as stated in the notice; only the items in $values contain the placeholders, but you already prepared them in the foreach. Additionally, be sure to run the query() only if the array $values is not empty.

Related Posts:

  1. $wpdb->get_row() only returns a single row?
  2. what is the way to see the currently executing query in wordpress?
  3. WordPress 4.8.1 uses mysql_connect which doesn’t work with PHP 7
  4. How to use $wpdb to delete in a custom table
  5. Matching database content types to PHP types
  6. Does $wpdb->prepare not create a prepared statement that I can execute multiple times?
  7. Saving custom form data into database
  8. Get data from database table by post_id to get data from second database table
  9. wp-content/db.php : where is this file?
  10. Delete/replace img tags in post content for auto published posts [closed]
  11. $wpdb sql help. Select post id and post meta value based on 2 other post_meta values
  12. $wpdb->get_results() returns good result only in first foreach iteration
  13. $wpdb->insert – inserting multiple rows
  14. $wpdb prepared with search term
  15. WPDB->insert with special characters
  16. Is there a (better) way to access $wpdb results?
  17. $wpdb->prepare not working with update table prefix
  18. How to use prepare to query with variables
  19. Use $wpdb in wordpress theme files
  20. wpdb->get_row() / get_results – is it possible to return an object instances of my own class?
  21. Problem in creating table through plugin code
  22. I want to update my postcontent with $wpdb
  23. How to save html and text in the database?
  24. XOR functionality for meta_query
  25. $wpdb->replace / Replace or update primary key
  26. Create an array with a string key from wpdb->get_results
  27. $wpdb – do you have to use foreach even if there will always only be one result?
  28. Replicating the WP_Query ‘s’ param with $wpdb
  29. Need help writing a $wpdb query
  30. get the number of queries made on a page(inside my plugin)
  31. Doing a loop with multiple DBs simultaneoulsy
  32. $wpdb->insert query changes to SHOW COLUMNS query Output
  33. How can I migrate mysql_fetch_array to $wbpdb?
  34. Fixing wpdb->get_results and wpdb->prepare?
  35. How does the WXR file differ from the WPDB?
  36. WordPress SQL query – returning ‘true’ ‘false’ or ‘null’
  37. Modify the structure of data returned by $wpdb
  38. WPDB If primary key already exists, add +1 to integer field
  39. How to get an array of user roles with or without a specific capability?
  40. What is wrong with this wpdb update?
  41. Programmatically Creating Page using $wpdb and getting 404 error
  42. Return XML of Post Metadata
  43. Constructing a dynamic WPDB query with multiple LIKEs
  44. $wpdb->prepare with ON DUPLICATE KEY UPDATE
  45. 301 Redirect Code
  46. wpdb updating record in wordpress with json adds extra array elements
  47. Counting posts with argument without retrieving the posts
  48. $wpdb->insert inserting only f character in custom table
  49. AWS Bitnami WordPress – SELECT command denied to user
  50. WPDB Placeholders and second argument for prepared statements
  51. Why does wpdb->update delete other meta?
  52. Increment integer field in database when WHERE needs to be dynamic [closed]
  53. Getting variable from Database
  54. Create new database through static page code
  55. Custom $wpdb returns unexpected time based results
  56. How to protect a script execution on WordPress?
  57. how to connect to another database in wordpress
  58. $wpdb->insert() doesnt work anymore
  59. WordPress wpdb->insert returns int(0) => doesn’t insert anything, no errors!
  60. Save sql file after doing insert wpdb
  61. Perform a function when a user clicks register button
  62. $wpdb->get_results not returning an array
  63. Can I use wpdb to insert query results into a post?
  64. $wpdb->prepare error after WordPress update [duplicate]
  65. wpdb result arrray inside an array
  66. $wpdb->get_var next var?
  67. How do I modify this wpdb query to include posts that have a post_status of publish and draft?
  68. Can’t find out why dbDelta dosen’t create my table
  69. How to pass an input value into wpdb->Prepare
  70. How capturate wpdb exceptions?
  71. Limit left join
  72. Check if Value Exists in Database, adding row details to variables and echoing result
  73. wpdb replace returning 1 where delete and insert is expected
  74. wpdb discards duplicate column names?
  75. update_post_meta not working in template_redirect action
  76. Get records from Formidable Table using $wpdb->get_col
  77. WPDB SQL query SELECT from category
  78. How to work with constraints on wordpress user metadata?
  79. How to Update multiple rows using $wpdb->update
  80. Unable to use $wpdb in WordPress
  81. How to display specific data from custom database table in WordPress
  82. Get 3 row ID’s via ARRAY_A
  83. Getting record from three wpdb tables
  84. Missing argument 2 for wpdb::prepare() [duplicate]
  85. Why is an empty result an error? ( $wpdb->get_row )
  86. get_row returns empty when data exists
  87. wpdb insert working in one function, but not another
  88. How to set up prepared query using IN statement
  89. Save customizer default values to DB on theme activation
  90. Plugin with connection to database – Single function
  91. WPDB Prepared Delete
  92. wpdb select from using array as search parameters
  93. wpdb Cannot Access Associative Array Data in a Count Query
  94. Can’t get expected result from a wpdb query
  95. Can’t seem to get set_blog_id working, it just doesn’t reset the blog ID
  96. DBDelta: “table doesn’t exist” for a table that was just created
  97. selecting row using wpdb which contain special symbols
  98. Query Problem in Clustom Plugin
  99. How does $wpdb->get_var work with offset?
  100. WP Recommended Table Exclusions?