Posts modified in the last 48 hours

Question

Posts modified in the last 48 hours

cody.me

2021年3月1日 10:27

I am using the code below to generate posts created in the last 48 hours.

  function filter_where($where = '') {
    $where .= " AND post_date  '" . date('Y-m-d', strtotime('-2 days')) . "'";
    return $where;
  }
add_filter('posts_where', 'filter_where');

But I also want to get the posts modified in the last 48 hours. Even if their creation date is older. Does anyone know how to do this?

I'd appreciate your help...

Topic recent-posts Wordpress sql

Category Web

cybmeta · Accepted Answer · 2016年1月25日 08:19

You can do it easily with WP_Query:

$args = array(
    'date_query' => array(
        'relation'   => 'OR',
        array(
            'column'  => 'post_date',
            'after'   => '-2 days'
        ),
        array(
            'column'  => 'post_modified',
            'after'   => '-2 days'
        )
    )
);

$query = new WP_Query( $args );

More information about date_query parameter of WP_Query.

If, for some reason, you still want to alter the WHERE clausele, something like this should work (not tested):

function filter_where($where = '') {
    $where .= " AND ( post_date > '" . date('Y-m-d', strtotime('-2 days')) . " OR post_modified > " . date('Y-m-d', strtotime('-2 days')) . " )'";
    return $where;
  }
add_filter('posts_where', 'filter_where');

Also, you must note that in the post where filter, you are using Y-m-d date format, which doesn't include time. That can cause unexpected results; you may need to use MySQL datetime format: Y-m-d H:i:s.

Posts modified in the last 48 hours

About