sql语名查询"今天","昨天","本周","本月"数据方法！

来源：互联网发布：人工智能编程语言编辑：程序博客网时间：2024/04/29 16:01

switch ($datetype) {                case 1://今天                    $sql .= " AND `lastupdate` BETWEEN '".(strtotime(date('Y-m-d')." 00:00:00"))."' AND '".(strtotime(date('Y-m-d')." 23:59:59"))."'";                    break;                                    case 2://昨天                    $sql .= " AND `lastupdate` BETWEEN '".(strtotime(date('Y-m-d')." 00:00:00")-86400)."' AND '".(strtotime(date('Y-m-d')." 23:59:59")-86400)."'";                    break;                                    case 3://本周                    $week = date('w');                    if (empty($week)) $week = 7;                    $sql .= " AND `lastupdate` BETWEEN '".(strtotime(date('Y-m-d')." 23:59:59")-86400*$week)."' AND '".(strtotime(date('Y-m-d')." 23:59:59")+(86400*(7-$week)))."'";                    break;                                case 4://本月                    $day = date('t');                    $sql .= " AND `lastupdate` BETWEEN '".strtotime(date('Y-m-1')." 00:00:00")."' AND '".strtotime(date('Y-m-'.$day)." 23:59:59")."'";                    break;                                    case 5://所有                    $sql .= " AND `lastupdate` <= '".SYS_TIME."'";                    break;            }