Using network_query_posts to get from certain blogs only?

We want to use network_query_posts to get posts from two blogs only (id = 3 and id = 4)

How to accomplish this?

Thanks.

Sun, 22 Jun 2014 22:05:09

Vinod Dalvi

WP Unicorn

1,565 pts: Hero points 17,482 pts: Rep. points LEVEL 29

Hi @IDGIT,

I hope you are well today and thank you for your question.

You can achieve by suing the following custom code.

I assume you network activated the Post Indexer plugin and built the post indexes.

You will find more information about usage of Post Indexer plugin on the following page.

https://wpmudev.com/project/post-indexer/#usage

Add the following code in the functions.php file of your child theme.

add_filter( 'network_posts_where', 'include_blogs', 10, 2 );

if ( !function_exists( 'include_blogs' ) ) :

/**

* Excludes blogs from network query.

*

* @since 3.0.4

*

* @param string $where Initial WHERE clause of the network query.

* @param Network_Query $query The network query object.

* @return string Updated WHERE clause.

*/

function include_blogs( $where, Network_Query $query ) {

return !empty( $query->query_vars['blogs_in'] )

? $where . sprintf( ' AND %s.BLOG_ID IN (%s) ', $query->network_posts, implode( ', ', (array)$query->query_vars['blogs_in'] ) )

: $where;

}

endif;

Add the following code in the template file where you want to display posts from certain blogs.

<?php	$network_query = network_query_posts( array(

'blogs_in'   => array( 1, 2 ) // Enter the blog ids from where you want to retrieve posts

) );



if ( network_have_posts() ) {

echo '<ul>';

while ( network_have_posts() ) {

network_the_post();

echo '<li>';

$the_permalink = network_get_permalink();

$the_title = network_get_the_title();

$the_content = network_get_the_content();

echo '<a href="', $the_permalink, '">', '[', $the_title, ']</a>';

echo '<br>';

echo $the_content;

echo '</li>';

}

echo '</ul>';

} ?>

Pass the blog ids as a parameter for the argument blogs_in in the above code from which blogs you want to get posts.

Best Regards,

Vinod Dalvi

IDGIT
- Flash Drive
- 70 pts: Hero points 46 pts: Rep. points LEVEL 2
Works fine, thanks!
Vinod Dalvi
- WP Unicorn
- 1,565 pts: Hero points 17,482 pts: Rep. points LEVEL 29
You are most welcome, if I can be of any further assistance please don’t hesitate to ask :slight_smile:

Hosting

Trial free for 7 days

Just US$12AU$18.7/m after. Cancel anytime.

Ready to get started?

How do you rate me?

Thank you for rating your experience!