How can I connect to another WP database and use WP_Query?

I can connect to the other database with $db2 = new wpdb( $user, $pass, $db, $host );, but how to I get WP_Query() to use $db2?

I want to be able to use the loop just the same with $db2 as I can with the original connection.

Answers 1

  • WP_Query uses the global $wpdb. What you'll have to do is replace $wpdb, use WP_Query, then set it back when you're done.

    global $wpdb;
    $wpdb_backup = $wpdb;
    $wpdb = new wpdb( $user, $pass, $db, $host );
    # Do your stuff here...
    # then when done...
    $wpdb = $wpdb_backup;

Related Questions