使用UNIX_TIMESTAMP一周 - Using UNIX_TIMESTAMP for a week

Using UNIX_TIMESTAMP for a week

本文关键字：一周 TIMESTAMP UNIX 使用 | 更新日期: 2023-09-27

我得到了按日期从周一到周五显示帖子的代码，但我认为代码显示的是我发布的最后一篇帖子

<?php
    $query = mysqli_query($c, 'SELECT c.chapter, n.name, n.img FROM chapters AS c LEFT JOIN novels AS n ON c.novel = n.id WHERE c.time <= unix_timestamp()');
    while($row = mysqli_fetch_row($query)):
?>

有人能告诉我从周一到周五我必须用什么代码来显示发布帖子吗？

我试着这样做，服务器时间是第25天，我没有得到结果，我至少有显示1后

$query = mysqli_query($c, 'SELECT c.chapter, n.name, n.img FROM chapters AS c LEFT JOIN novels AS n ON c.novel = n.id WHERE FROM_UNIXTIME(c.time,''%N'')>=1 AND FROM_UNIXTIME(c.time,''%N'')<=5');

现在用这个修复了吗

$query = mysqli_query($c, 'SELECT c.chapter, n.name, n.img FROM chapters AS c LEFT JOIN novels AS n ON c.novel = n.id WHERE DAYOFWEEK(FROM_UNIXTIME(c.time))>=1 AND DAYOFWEEK(FROM_UNIXTIME(c.time))<=5'); 
while($row = mysqli_fetch_row($query)):
?>

您可以通过此获取日期名称

SELECT DAYNAME(CURDATE()), DAYNAME(DATE_ADD(CURDATE(), INTERVAL 4 DAY));

或

SELECT DAYNAME('2013-11-25'), DAYNAME(DATE_ADD('2013-11-25', INTERVAL 4 DAY));

希望对你有所帮助。