select FROM_UNIXTIME(pubtime, '%Y-%m') as pubtime, count(*) as cnt from articles group by FROM_UNIXTIME(pubtime, '%Y-%m')
PHP文章按日期(日)SQL归档
select FROM_UNIXTIME(pubtime, '%Y-%m-%d') as pubtime, count(*) as cnt from articles group by FROM_UNIXTIME(pubtime, '%Y-%m-%d')
非时间戳日期格式归档(date_format格式化日期)
select date_format(`post_date`,'%Y%m%d') as pubtime, count(*) as cnt from wp_posts where `post_status`='publish' group by date_format(`post_date`,'%Y%m%d') order by `ID` desc
select date_format(`post_date`,'%Y%m%d') as pubtime,date_format(`post_date`,'%m 月 %d 日') as shijian,count(*) as cnt from wp_posts where `post_status`='publish' group by date_format(`post_date`,'%Y%m%d') order by `ID` desc limit 0,7
php自动给文章加关键词链接的函数代码
?php$link=array('百度,http://www.baidu.com/','服务器软件,http://s.gimoo.net/','积木网,http://www.gimoo.net/',);$str='在百度中搜索服务器软件就可以到积木网提供的软件br/
利用php实现禁用IE和火狐的缓存问题
在网速找了好多方法,最终还是解决了其实最简单的方法是在头部加meta标签METAHTTP-EQUIV="Cache-Control"CONTENT="no-cache,no-store,must-revalidate"METAHTTP-EQUIV="pragma"CONT
windows下zendframework项目环境搭建(通过命令行配置)
1、首先你要确定你的PHP版本不低于5.1.4,但强烈建议使用5.2.3或更高版本2、确保你的php.ini开启了如下模块:extension=php_pdo.dllextension=php_pdo_mysql.dll3、打开