[wp-hackers] WP 3.5.2/multisite: How to use NOT IN in $wpdb->prepare()?

Micky Hulse mickyhulse.lists at gmail.com
Tue Jul 16 02:36:21 UTC 2013

Situation and example code:


$ignore = implode(',', array('1', '19', '21',));
echo '<pre>';
$rows = $wpdb->get_results($wpdb->prepare("SELECT blog_id FROM
$wpdb->blogs WHERE blog_id NOT IN (%s) AND public = '1' AND archived =
'0' AND mature = '0' AND spam = '0' AND deleted = '0'", $ignore),
echo '</pre>';



The "NOT IN ()" filter fails to ignore blog ids.


I'm not certain, but I assume my code fails because $ignore isn't of
the %s, %d or %f types.


Move $ignore into the statement like so:

... blog_id NOT IN ($ignore) ...


I get this PHP notice:

PHP Notice:  wpdb::prepare was called <strong>incorrectly</strong>.
wpdb::prepare() requires at least two arguments. Please see <a
href="http://codex.wordpress.org/Debugging_in_WordPress">Debugging in
WordPress</a> for more information. (This message was added in version
3.5.) in /rgblog/html/wp-includes/functions.php on line 2962

Reason for the notice:

"PHP Warning: Missing argument 2 for wpdb::prepare()"



you’re passing $id directly into the query, unprepared. And this,
right here, is why $wpdb->prepare() now issues a warning if it isn’t
called with more than one argument. Because you can’t prepare a query
without more than one argument.


With that said, how can I accomplish my goal of passing several blog
IDs into a query that uses wpdb::prepare() (like my example above)?

Any tips would be appreciated. :)

More information about the wp-hackers mailing list