首先,我在论坛上搜索了我的问题的答案。我正在用PHP&MySQL创建每周一次的时间表,问题是当实际日期是周日时,我无法确定如何设置case语句,我需要将星期一设置为明天。这是我简单的MySQL表周
Fields: dayid(int,primary,auto-increment),day(varchar(25))
Data: (1,'Monday'),(2,'Tuesday'),(3,'Wednesday'),(4,'Thursday'),
(5,'Friday'),(6,'Saturday'),(7,'Sunday');以下是我的php代码:
$today = date("N");
$query = "SELECT *,case when dayid = '$today' THEN 'Today'
when dayid = '$today' + 1 THEN 'Tomorrow'
when dayid = '$today' - 1 THEN 'Yesterday'
ELSE day END days FROM week ";
$results = mysqli_query($link, $query);
while ($r = mysqli_fetch_array($results)) {
echo '<p>'.$r['days'].'</p>'; }就像我之前写的,我不知道如何设置它,所以当$today =7(星期日)那个星期一说明天,当它说的是昨天而不是星期天时,情况正好相反。希望有人能帮我解决这个问题。
提前谢谢你!
发布于 2015-04-29 13:10:39
您需要在周末使用IF进行包装:
CASE dayid
WHEN $today THEN Today
WHEN IF($today = 7, 1, $today + 1) THEN 'Tomorrow'
WHEN IF($today = 1, 7, $today - 1) THEN 'Yesterday'
ELSE day
END dayshttps://stackoverflow.com/questions/29944698
复制相似问题