Help with Posts to Posts query. WordPress

draivika comments:

Thanks for your response dimadin. Yes what you are saying sounds better and I want the code to be more efficient. For the last query, I want to get all connected users to the issue, since that is the page template I am editing. So when the page loads it pulls connected content by genre and then below that lists all connected users to that issue. I hope that makes sense. [[LINK href="https://github.com/scribu/wp-posts-to-posts/wiki/Posts-2-Users"]]This page on Github[[/LINK]] describes it I think, but I couldn't get it to work for me.

To get a list of users connected to a certain post, you can write:


$users = get_users( array(
'connected_type' => 'multiple_authors',
'connected_items' => $post
) );

dimadin comments:

I think that this code should achieve what you want:


$users = get_users( array(
'connected_type' => 'solstice_authors',
'connected_items' => $issue,
) );

foreach ( $users as $user ) {
echo get_avatar( $user->ID );
};


draivika comments:

Hi, I can't get the first part to work, would you be able to give me the full modified PHP statement with the 3 sections based on my original snippet. I was able to get the users with the last part you provided, but it only shows the avatar and no name. I guess I should have been more specific, but I can't figure out how to get the avatar with the author name and link to author archive as well. Do you know if that is possible?

dimadin comments:

First, you should increase time for this question as soon as possible, there is a link " Extend Question by 1 Day?". If that doesn't work for you, you can contact me from my profile page here so we can finish this.

I modified your code to include changes I made. Those are first two sections, I'll look for third one.

Please note that you have variable $meta_key that isn't defined here, if something doesn't work try to remove it by removing whole line ('connected_orderby' => $meta_key,)


<?php
$issue = get_queried_object();

// Gets every term in the genre taxonomy
$genres = get_terms( 'genre' );

foreach ( $genres as $genre ) {
if ( 'editors_note' == $genre->slug ) {
continue;
}

$articles = new WP_Query(array(
'taxonomy' => 'genre',
'term' => $genre->slug,
'posts_per_page' => -1,
'connected_orderby' => $meta_key,
'connected_type' => 'issues_to_content',
'connected_from' => $issue,
'post_type' => 'solstice_article',
) );

if ( $articles->have_posts() ) : ?>
<div class="toc-part column"><h3><?php echo $genre->name ?></h3>
<ul>
<?php while ( $articles->have_posts() ) : $articles->the_post(); ?>
<li>
<a href="<?php the_permalink() ?>"><?php the_title() ?></a>
<br /> by <span><a href="<?php the_permalink() ?>"><?php the_author() ?></a></span>
</li>
<?php endwhile; ?>
</ul>
</div>
<?php endif;

wp_reset_postdata();
}

foreach ( $genres as $genre ) {
if ( 'editors_note' != $genre->slug ) {
continue;
}

$articles = new WP_Query(array(
'taxonomy' => 'genre',
'term' => $genre->slug,
'posts_per_page' => -1,
'connected_orderby' => $meta_key,
'connected_type' => 'issues_to_content',
'connected_from' => $issue,
'post_type' => 'solstice_article',
) );

if ( $articles->have_posts() ) : ?>
<div class="toc-part column"><h3><?php echo $genre->name ?></h3>
<ul>
<?php while ( $articles->have_posts() ) : $articles->the_post(); ?>
<li>
<a href="<?php the_permalink() ?>"><?php the_title() ?></a>
<br /> by <span><a href="<?php the_permalink() ?>"><?php the_author() ?></a></span>
</li>
<?php endwhile; ?>
</ul>
</div>
<?php endif;

wp_reset_postdata();
}
?>


dimadin comments:

This is the code for users list. Note that you should probably style it according to your theme. Also note that it displays user's name from field "Nicename", you might want to change that.


$users = get_users( array(
'connected_type' => 'solstice_authors',
'connected_items' => $issue,
) );

foreach ( $users as $user ) {
echo '<div><div>' . get_avatar( $user->ID ) . '</div><div><a href="' . get_author_posts_url( $user->ID, $user->user_nicename ) . '">' . $user->user_nicename . '</a></div></div>';
};


draivika comments:

Increased the time. Will try this out later today, but looks good. Thanks very much.

draivika comments:

This worked fine. Thanks, but what I am really trying to do is pull out the editor's note into a separate div. When I try to do that with this it lists everything twice. Is it possible to modify so I can get the editor's note first, then make a new section, then get everything except the editors note term?


<div> Editors note</div>
<div> Everything except editor's note</div>
<div>get connected users</div>


If you could help me with hat, I sincerely appreciate it.

draivika comments:

Anyway to get nickname or name instead of nicename?

draivika comments:

Got it "display_name"