使用meta_query将当前日期与Wordpress中的时间戳进行比较 [英] Compare the current date to a timestamp in Wordpress with meta_query
本文介绍了使用meta_query将当前日期与Wordpress中的时间戳进行比较的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
我想进行查询以将当前日期与数据库中的日期进行比较.这样,我将展示今天之前发生的事件.
I would like to make a query to compare the current date to a date in the database. This way I would show events that happened before today.
我尝试了meta_query,但显示了所有事件.
I tried the meta_query but all events are shown.
'meta_query' => array(
array(
'key' => 'event_start_date_number',
'value' => date('Y-m-d'),
'compare' => '<=',
'type' => 'DATETIME,'
),
),
在我的数据库中供参考,我得到了许多看起来像这样的记录:
For reference in my database I got many records that looks like this:
meta_key: event_start_date_number
meta_value: 1472576400
它们是通过以下方式保存的:
And they was saved this way:
$date = "".$event_start_date." ".$event_start_time."";
$event_start_date_number = strtotime($date);
if(!empty($event_start_date_number)) {
update_post_meta($post_id, 'event_start_date_number', $event_start_date_number);
}
推荐答案
将meta_value转换为日期格式以进行比较
convert the meta_value to date format for comparison
'meta_query' => array(
array(
'key' => 'event_start_date_number',
'value' => date("Y-m-d", $event_start_date_number),
'compare' => '<=',
'type' => 'DATETIME',
),
),
这篇关于使用meta_query将当前日期与Wordpress中的时间戳进行比较的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文