-
phpcms之模板GET标签调用
- 昨天的:
- SELECT * FROM `…` WHERE FROM_UNIXTIME(dateline,’%Y-%c-%e’)=FROM_UNIXTIME(UNIX_TIMESTAMP()-3600*24,’%Y-%c-%e’)
- 今天的:
- SELECT * FROM `…` WHERE FROM_UNIXTIME(dateline,’%Y-%c-%e’)=FROM_UNIXTIME(UNIX_TIMESTAMP(),’%Y-%c-%e’)
- 本周:
- WHERE dateline > UNIX_TIMESTAMP()-7*3600*24
- 本月:
- dateline > UNIX_TIMESTAMP()-30*3600*24