php - 如何将日期过滤器添加到mysql。 Joomla

Question

<?php
        $database = & JFactory::getDBO();
        $query = "SELECT asset_id FROM #__content WHERE state = 1";
        $database->setQuery( $query );
        $count_at = $database->loadObjectList();
        $count_nbr = count($count_at);
?>

所以 $count_nbr 返回所有创建和发布的文章，但我需要向它添加“今天”过滤器。如果有大师能帮上忙...需要两种类型的过滤器:“1 天”和“一周”...

更新:添加 $date = date (Y-m-d); amd 修改字符串到 SELECT asset_id FROM #__content WHERE state = 1 AND publish_up = $date; 不help cause publish_up in mysql Y-m-d H:i:s 我需要忽略时间戳...

Answer 1

获取今天发表的文章:

$today = date('Y-m-d');
$query = "SELECT asset_id FROM #__content WHERE state = 1 AND DATE_FORMAT(publish_up, '%Y-%m-%d') = '$today'";
...

这使用了 MySQL DATE_FORMAT()函数将发布日期格式化为 Y-m-d 格式，以便您可以比较它。

要获取本周发表的文章，请使用 YEARWEEK()功能:

$query = "SELECT asset_id FROM #__content WHERE state = 1 AND YEARWEEK(publish_up) = YEARWEEK(NOW())";