php - 一周内的趋势标签就像推特一样不起作用

Question

我想在一周内制作一个热门列表，例如 Twitter 趋势标签。以下代码仅适用于1 天，但我想更改它1 周 我该怎么做。我仍然尝试更改它 INTERVAL 1 WEEK 但没有奏效。任何人都可以在这里帮助我吗？

$query = mysqli_query($this->db,"SELECT * FROM posts WHERE FROM_UNIXTIME(created) > CURRENT_DATE AND FROM_UNIXTIME(created) < CURRENT_DATE + INTERVAL 1 DAY AND Tag != ''") or die(mysqli_error($this->db));

Answer 1

我认为你选择的时间间隔有误)如果你想要明天的一周和一周的使用(一周 o 7 天

  SELECT * 
  FROM posts 
  WHERE FROM_UNIXTIME(created) > CURRENT_DATE 
  AND FROM_UNIXTIME(created) < (CURRENT_DATE + INTERVAL 1 WEEK ) 
  AND Tag != ''

  SELECT * 
  FROM posts 
  WHERE FROM_UNIXTIME(created) > CURRENT_DATE 
  AND FROM_UNIXTIME(created) < (CURRENT_DATE + INTERVAL 7 DAY ) 
  AND Tag != ''

否则如果你想选择使用前一周

  SELECT * 
  FROM posts 
  WHERE FROM_UNIXTIME(created) > (DATE_SUB(NOW(), INTERVAL 1 WEEK) 
  AND   FROM_UNIXTIME(created) <= CURRENT_DATE 
  AND Tag != ''

但是如果日期已经是日期时间格式使用

SELECT * 
FROM posts 
WHERE created > CURRENT_DATE 
AND created < (CURRENT_DATE + INTERVAL 7 DAY ) 
AND Tag != ''