E4A 今天更新的视频

取指定时间戳(到时间(取现行日期文本("/")),2)

时间是从当前的0点0分0秒开始

比如： 2019-05-17 00:00:00

mysql命令 1558022400 = 取指定时间戳(到时间(取现行日期文本("/")),2)

SELECT * FROM `vod_vod` WHERE vod_addtime > 1558022400

按最新显示

SELECT * FROM `vod_vod` WHERE vod_addtime > 1558022400 ORDER BY `vod_vod`.`vod_id` DESC

显示相关数量

select count(*) FROM `vod_vod` WHERE vod_addtime > 1558022400

显示相关类型数量

select count(*) FROM vod_vod WHERE vod_addtime > 1558022400 and `vod_cid` = 10

PHP代码 获得当日凌晨的时间戳

\$today = strtotime(date("Y-m-d"),time());

echo '
';

echo \$today; //1470844800