WP Query only future posts WordPress
- SOLVED
I am building a simple calendar for a client. I used the [[LINK href="http://www.tomsdimension.de/wp-plugins/no-future-posts"]]No Future Posts Plugin[[/LINK]] to enable me to publish posts whose date are set for a future date.
My problem is now, that in this list of posts, I'd like to be able to show only posts <strong>today</strong> or in the <strong>future</strong>, no past posts so it's only upcoming events. Is this possible? How might I modify the wp_Query below to accomplish this?
<?php $my_query = new WP_Query( array( 'post_type'=>'post', 'posts_per_page' => 6, 'order' => 'ASC', 'cat' => 5 ) );while ($my_query->have_posts()) : $my_query->the_post();$do_not_duplicate = $post->ID; ?>
<li><a href="<?php the_permalink() ?>"><strong><?php the_date( 'n/d'); ?></strong><?php the_title(); ?></a></li>
<?php endwhile; ?>
Answers (5)
wjm answers:
hi,
your query should look like
new WP_Query( array( 'post_type'=>'post', 'posts_per_page' => 6, 'order' => 'ASC', 'cat' => 5, 'post_status' => 'publish,future', ) );
and based on
http://codex.wordpress.org/Template_Tags/query_posts#Time_Parameters
you can apply a filter (i modified the code to suit your needs)
<?php
//based on Austin Matzko's code from wp-hackers email list
function filter_where($where = '') {
$where .= " AND post_date >= DATE( NOW() )";
return $where;
}
add_filter('posts_where', 'filter_where');
query_posts($query_string);
?>
so you will end up with something like this,
<?php
//based on Austin Matzko's code from wp-hackers email list
function filter_where($where = '') {
$where .= " AND post_date >= DATE( NOW() )";
return $where;
}
add_filter('posts_where', 'filter_where');
$my_query = new WP_Query( array( 'post_type'=>'post', 'posts_per_page' => 6, 'order' => 'ASC', 'cat' => 5, 'post_status' => array( 'publish', 'future' ), ) );while ($my_query->have_posts()) : $my_query->the_post();$do_not_duplicate = $post->ID; ?>
<li><a href="<?php the_permalink() ?>"><?php the_date( 'n/d'); ?><?php the_title(); ?></a></li>
<?php endwhile; ?>
<?php
remove_filter('posts_where', 'filter_where');
?>
I will try this code in my site and submit any improvement as i havent run it yet.
wjm comments:
ok. this is the revised version as the above had a little error,
<ul>
<?php
function filter_where($where = '') {
$where .= " AND post_date >= DATE( NOW() )";
return $where;
}
add_filter('posts_where', 'filter_where');
$my_query = new WP_Query(
array(
'post_type'=>'post',
'posts_per_page' => 6,
//'orderby' => 'date',
'order' => 'ASC',
'cat' => 5,
'post_status' => 'publish,future',
)
);
while ( $my_query->have_posts() ) :
$my_query->the_post();
$do_not_duplicate = $post->ID;
?>
<li><a href="<?php the_permalink() ?>"><?php the_date( 'n/d'); ?> <?php the_title(); ?></a></li>
<?php
endwhile;
remove_filter('posts_where', 'filter_where');
?>
</ul>
and it works.
Note: the above code lists today's posts (they could have been published a couple of hours ago today and they will be still showed).
if you just want future, change
$where .= " AND post_date >= DATE( NOW() )";
to
$where .= " AND post_date >= NOW()";
you may want to uncomment
//'orderby' => 'date',
but i think posts are sorted by date by default.
let me know if you have any questions
- wjm
Utkarsh Kukreti answers:
Use
Today's posts
$today = getdate();
$my_query = new WP_Query( array( 'post_type'=>'post', 'posts_per_page' => 6, 'order' => 'ASC', 'cat' => 5, 'year' => $today["year"], 'monthnum' => $today["mon"], 'day' => $today["mday"] ) );
Future posts
$my_query = new WP_Query( array( 'post_type'=>'post', 'posts_per_page' => 6, 'order' => 'ASC', 'cat' => 5, 'post_status' => 'future') );
Oleg Butuzov answers:
just filter query... add post_date > NOW() for that
Oleg Butuzov comments:
as sample of query parse (btw its a bit related to your issue)
http://wpquestions.com/question/show/id/485
Oleg Butuzov comments:
oh... take a look to the solution posted <strong>wjm</strong>. same as i tald. and its perfectly fit your needs.
Pippin Williamson answers:
Take a look at these links:
http://lorelle.wordpress.com/2006/10/01/working-ahead-future-posts-with-wordpress/
http://www.studionashvegas.com/tutorial/displaying-future-posts-in-wordpress/
http://wordpress.org/extend/plugins/display-future-posts/
Darrin Boutote answers:
<?php
$my_query = new WP_Query( array(
'post_status' => 'future,publish',
'post_type'=>'post',
'posts_per_page' => -1,
'order' => 'ASC',
'cat' => 5 )
);
if ( $my_query->have_posts() ) :
while ($my_query->have_posts()) : $my_query->the_post();
if( strtotime($post->post_date) < time() ) {
//do nothing
} else { ?>
<li><a href="<?php the_permalink() ?>"> <?php the_date( 'n/d'); ?> <?php the_title(); ?></a></li>
<?php } ?>
<?php endwhile; ?>
<?php endif; ?>