Is there a way to fetch Wordpress posts so that meta calls don't actually do database calls?
For example, I currently have:
$args = array(
'posts_per_page' => 1000,
'post_type' => 'portfoliosample'
);
$query = new WP_Query($args);
while($query->have_posts()):
$query->the_post();
$style = '';
if(has_post_thumbnail($post->ID)){
$image = wp_get_attachment_image_src( get_post_thumbnail_id( $post->ID ), 'single-post-thumbnail' );
$largeurl = $image[0];
$style = ' style="background-image:url('.$largeurl.');"';
}
?>
<li id="post-<?php the_ID(); ?>" <?php post_class('half'); ?>>
<a href="<?php the_permalink()?>"<?php echo $style?> ng-click="lightbox('portfolio','<?php the_permalink()?>')">
<h3 class="entry-title caps"><?php echo strtoupper(the_title('', '', false)); ?></h3>
</a>
</li>
<?php
endwhile;
Things like the_title() do not make database calls because post has that information. However, $post seemingly does not have the post's thumbnail ID or that thumbnail's image source.
If I do a custom query like this:
global $wpdb;
$query = "
SELECT posts.*
FROM $wpdb->posts posts
WHERE posts.post_type = 'portfoliosample'
AND posts.post_status = 'publish'
ORDER BY posts.menu_order ASC
";
$pageposts = $wpdb->get_results($query, OBJECT);
if($pageposts)
{
global $post;
foreach($pageposts as $post)
{
setup_postdata($post);
$style = '';
if(has_post_thumbnail($post->ID)){
$image = wp_get_attachment_image_src( get_post_thumbnail_id( $post->ID ), 'single-post-thumbnail' );
$largeurl = $image[0];
$style = ' style="background-image:url('.$largeurl.');"';
}
?>
<li id="post-<?php the_ID(); ?>" <?php post_class('half'); ?>>
<a href="<?php the_permalink()?>"<?php echo $style?> ng-click="lightbox('portfolio','<?php the_permalink()?>')">
<h3 class="entry-title caps"><?php echo strtoupper(the_title('', '', false)); ?></h3>
</a>
</li><!-- #post-## -->
<?php
}
}
Can I fetch the meta at the same time but still allow functions like get_post_thumbnail()? I was hoping that setup_postdata() would have a way to handle that.
