How to set up prepared query using IN statement

My solution to the problem:

$prepare = array();
        $in = implode(',', array_fill(0, count($product_ids), '%d'));
        foreach ($product_ids as $ids){
            $prepare[] = $ids;   
        }
        $prepare[] = "post";
        $prepare[] = $num;
        $results = $this->db->get_results($this->db->prepare("SELECT ID, post_title FROM {$this->db->posts} WHERE ID NOT IN({$in}) AND post_type=%s ORDER BY ID DESC LIMIT %d", $prepare));

Related Posts:

  1. How to use $wpdb to delete in a custom table
  2. get_results on large datasets
  3. Is there a (better) way to access $wpdb results?
  4. Using $wpdb generates DB error
  5. How do you use prepare when asking for a list of id’s
  6. how to execute different sql query in non-sanitized $wpdb->get_results function
  7. WPDB update row with != in where clause
  8. How to update records using $wpdb?
  9. Need help writing a $wpdb query
  10. show badge with count for pending items in custom post type
  11. WP Sql query multiple where clause
  12. WordPress SQL query – returning ‘true’ ‘false’ or ‘null’
  13. Modify the structure of data returned by $wpdb
  14. Syntax for $wpdb->prepare when searching in two columns
  15. Confused by $wpdb->prepare
  16. How to display user_nicename and usermeta values by custom query in WordPress?
  17. Optimizing WordPress Queries – Removing Group By ID
  18. How can I combine one field using wpdb and group by?
  19. $wpdb->prepare with ON DUPLICATE KEY UPDATE
  20. how to use $wpdb->prepare to update a custom table
  21. WPDB Placeholders and second argument for prepared statements
  22. Increment integer field in database when WHERE needs to be dynamic [closed]
  23. Custom SQL query ORDER BY term_order
  24. Custom $wpdb returns unexpected time based results
  25. How to left join meta in queries [closed]
  26. wpdb->get_row is selecting the variable as a column name
  27. CREATE TABLE with dbDelta does not create table
  28. $wpdb query outputs php code instead of executing it
  29. wpdb query not working
  30. WordPress wpdb->insert returns int(0) => doesn’t insert anything, no errors!
  31. WPDB SQL Ignore `post_status` Parameter
  32. how to list all post that are in the custom taxonomy using $wpdb
  33. WPDB SQL query SELECT from category
  34. How to use WHERE NOT EXISTS query to avoid duplicate entry using $wpdb to save in custom table?
  35. Creating an Angular factory from custom database table
  36. wpdb->update update the entire table instead of one row
  37. How do I update post based on meta_key in another table?
  38. Custom database query to validate data
  39. Alter the main search query to search posts by coauthor user name
  40. Creates only one table and not the other
  41. Protect custom form from SQL injection
  42. looking for a way to allow users to backup the plugin db data(save as)
  43. SQL Query to select post title & post ID from a particular category
  44. Get comments after specific date
  45. query using wpdb in wordpress gets me no result
  46. Get count of rows based if column exists in two different tables
  47. query_vars doesn’t return query string (trying to get data from $wpdb)
  48. Matching database content types to PHP types
  49. Use wpdb->prepare for `order by` column name
  50. wpdb->prepare function remove single quote for %s in SQL statment
  51. Saving custom form data into database
  52. wp-content/db.php : where is this file?
  53. $wpdb->get_results() returns good result only in first foreach iteration
  54. $wpdb->insert – inserting multiple rows
  55. WPDB->insert with special characters
  56. $wpdb->prepare not working with update table prefix
  57. How to use prepare to query with variables
  58. Use $wpdb in wordpress theme files
  59. get posts and postmetas in assoc array
  60. wpdb->get_row() / get_results – is it possible to return an object instances of my own class?
  61. Problem in creating table through plugin code
  62. $wpdb – do you have to use foreach even if there will always only be one result?
  63. Replicating the WP_Query ‘s’ param with $wpdb
  64. wpdb_prepare with multiple or condition
  65. $wpdb->insert query changes to SHOW COLUMNS query Output
  66. Fixing wpdb->get_results and wpdb->prepare?
  67. How does the WXR file differ from the WPDB?
  68. What’s wrong with my $wpdb prepare?
  69. Get stock by custom meta field on all Woocommerce variable products
  70. Display fields as values in array from external SQL DB
  71. What is wrong with this wpdb update?
  72. Constructing a dynamic WPDB query with multiple LIKEs
  73. Counting posts with argument without retrieving the posts
  74. Create new database through static page code
  75. Use $wpdb or other PHP script method to find/replace in WP database
  76. WordPress “wpdb->update” – Append Text Value
  77. Need help converting get_user_meta [keys] into own array
  78. Can’t call WPDB inside RSS template
  79. wpdb prepare sql problem
  80. Query and get meta as object(stdClass) on wp postmeta table?
  81. How do I query a table?
  82. check that the data exists before sending it to wpdb
  83. no result returns when using $wpdb->get_results with where clause
  84. Customising the default wordpress search functionality
  85. SQL queries to another wordpress site
  86. PHP | left join avg query give me Array()
  87. update not working using wpdb
  88. get_posts() SQL Injection
  89. og:image functions.php
  90. $wpdb select returns empty array
  91. Show error messages to a user when database insert fails
  92. Intermittent problem writing update_user_meta
  93. How to get specific table by current user login
  94. Combine posts and postmeta
  95. WPDB delivers wrong results from complex queries
  96. I can’t write in my DB using $wpdb->insert
  97. wpdb select from using array as search parameters
  98. Can’t get expected result from a wpdb query
  99. selecting row using wpdb which contain special symbols
  100. Query Problem in Clustom Plugin
tech