mysql取今天,明天,工作日,周末,本周,下周,下月数据 if ($date != '') {switch($date){//date_add 加 date_sub 减case '今天': $where .= " AND FROM_UNIXTIME(starttimefrom,'%Y-%m-%d') = curdate() "; break;case '明天': $where .= " AND FROM_UNIXT
mysql取今天,明天,工作日,周末,本周,下周,下月数据
if ($date != '') {
switch($date){//date_add 加 date_sub 减
case '今天':
$where .= " AND FROM_UNIXTIME(starttimefrom,'%Y-%m-%d') = curdate() ";
break;
case '明天':
$where .= " AND FROM_UNIXTIME(starttimefrom,'%Y-%m-%d') = date_add(curdate(), interval 1 day)";
break;
case '工作日':
$where .= " AND dayofweek(FROM_UNIXTIME(starttimefrom)) not in (1,7) ";
break;
case