plugin development - How to fetch only current hour posts?

admin管理员组

文章数量:1022795

How can I fetch the post which is posted only this hour?

Example: It's 9:00 am here I want to show all the post that is posted within 9:00am to 10am and it will check all the hours in same way.

How can I fetch the post which is posted only this hour?

Example: It's 9:00 am here I want to show all the post that is posted within 9:00am to 10am and it will check all the hours in same way.

• plugin-development
• wp-query

Share Improve this question edited May 8, 2019 at 4:13 Krzysiek Dróżdż 25.6k99 gold badges5353 silver badges7474 bronze badges asked May 8, 2019 at 3:40 Mahbub AnsaryMahbub Ansary 3122 bronze badges

Add a comment  | 

2 Answers 2

Sorted by: Reset to default 0

I think Date Parameters is the thing you’re looking for.

So if you want to get posts from given hour, you can construct a query like this:

$hour_posts = new WP_Query( array(
'date_query' => array(
    array(
        'before' => '2019-05-08 10:00',
    ),
    array(
        'after'  => '2019-05-08 09:00',
    ),
),
'posts_per_page' => -1,
) );

And if the day doesn’t matter and you want all posts published within given hour but from all days, then this will come handy:

$args = array(
    'date_query' => array(
        array(
            'hour'      => 9,
            'compare'   => '>=',
        ),
        array(
            'hour'      => 10,
            'compare'   => '<'
    ),
    'posts_per_page' => -1,
);
$query = new WP_Query( $args );

Solved!!!

//set up the round figure of this hour
$timeWithoutA  = date('h:')."00";
$curr_time  = date('h').":00".date('a');

//Add 1 hour to current hour
$timestamp = strtotime($timeWithoutA) + 60*60;
$addedOneHour = date('h:ia', $timestamp);


//Today's date
$this_date = getdate();
$year = $this_date['year'];
$mon = $this_date['mon'];
$day = $this_date['mday'];
$today = $year."-".$mon."-".$day;

//Add them together
$after = $today." ".$curr_time;
$before  = $today." ".$addedOneHour;

$custArgs = array(
    'post_type' => 'payment',
    'date_query' => array(
        array(
            'before' => $before,
        ),
        array(
            'after'  => $after,
        )
    )
);
$query = new WP_Query ( $custArgs );


while($query->have_posts()) : $query->the_post(); 
    echo "hello"."<br />";
endwhile;

How can I fetch the post which is posted only this hour?

Example: It's 9:00 am here I want to show all the post that is posted within 9:00am to 10am and it will check all the hours in same way.

How can I fetch the post which is posted only this hour?

Example: It's 9:00 am here I want to show all the post that is posted within 9:00am to 10am and it will check all the hours in same way.

• plugin-development
• wp-query

Share Improve this question edited May 8, 2019 at 4:13 Krzysiek Dróżdż 25.6k99 gold badges5353 silver badges7474 bronze badges asked May 8, 2019 at 3:40 Mahbub AnsaryMahbub Ansary 3122 bronze badges

Add a comment  | 

2 Answers 2

Sorted by: Reset to default 0

I think Date Parameters is the thing you’re looking for.

So if you want to get posts from given hour, you can construct a query like this:

$hour_posts = new WP_Query( array(
'date_query' => array(
    array(
        'before' => '2019-05-08 10:00',
    ),
    array(
        'after'  => '2019-05-08 09:00',
    ),
),
'posts_per_page' => -1,
) );

And if the day doesn’t matter and you want all posts published within given hour but from all days, then this will come handy:

$args = array(
    'date_query' => array(
        array(
            'hour'      => 9,
            'compare'   => '>=',
        ),
        array(
            'hour'      => 10,
            'compare'   => '<'
    ),
    'posts_per_page' => -1,
);
$query = new WP_Query( $args );

Solved!!!

//set up the round figure of this hour
$timeWithoutA  = date('h:')."00";
$curr_time  = date('h').":00".date('a');

//Add 1 hour to current hour
$timestamp = strtotime($timeWithoutA) + 60*60;
$addedOneHour = date('h:ia', $timestamp);


//Today's date
$this_date = getdate();
$year = $this_date['year'];
$mon = $this_date['mon'];
$day = $this_date['mday'];
$today = $year."-".$mon."-".$day;

//Add them together
$after = $today." ".$curr_time;
$before  = $today." ".$addedOneHour;

$custArgs = array(
    'post_type' => 'payment',
    'date_query' => array(
        array(
            'before' => $before,
        ),
        array(
            'after'  => $after,
        )
    )
);
$query = new WP_Query ( $custArgs );


while($query->have_posts()) : $query->the_post(); 
    echo "hello"."<br />";
endwhile;

本文标签： plugin developmentHow to fetch only current hour posts