lg2016's recent timeline updates lg2016's recent timeline updates | lg2016V2EX member #167055, joined on 2016-04-07 15:21:08 +08:00 |
| 微信本地开发测试时候，大家都用哪家的 ngrok？ 微信 lg2016 Jul 7, 2016 Lastly replied by ETiV | 5 |
| 问下哪里可以托管技术文档或产品手册 问与答 lg2016 Apr 22, 2016 Lastly replied by lg2016 | 1 |
| mysql 如何根据发帖的时间戳去统计当天的发帖量？ 问与答 lg2016 Apr 15, 2016 Lastly replied by lg2016 | 14 |
| 问个目录常量定义问题 PHP lg2016 Apr 8, 2016 Lastly replied by lg2016 | 7 |
lg2016's recent replies
Apr 22, 2016 Replied to a topic by lg2016 问与答 问下哪里可以托管技术文档或产品手册 |
看来知道的人不多！
Apr 15, 2016 Replied to a topic by lg2016 问与答 mysql 如何根据发帖的时间戳去统计当天的发帖量？ |
@peter999 先阶段写着玩的，就 10 多条记录，暂时不用写到表里面，如果很多的话那一定要写到表里面。
另外再问大家一个问题， select 查询语句中是否不要大量的出现函数语句，听说会出现很多问题。
另外再问大家一个问题， select 查询语句中是否不要大量的出现函数语句，听说会出现很多问题。
Apr 15, 2016 Replied to a topic by lg2016 问与答 mysql 如何根据发帖的时间戳去统计当天的发帖量？ |
@zouguolvyi @onion83 根据你们的思路，写出下面这段查询语句
$today = date('Y-m-d');
$tomorrow = date('Y-m-d',strtotime('+1 day'));
$sql = "select DATE_FORMAT(FROM_UNIXTIME(pubtime),'%Y-%m-%d') as todayr_date,count(*) as today_sum from publish where DATE_FORMAT(FROM_UNIXTIME(pubtime),'%Y-%m-%d') between '{$today}' and '{$tomorrow}' group by todayr_date";
$today = date('Y-m-d');
$tomorrow = date('Y-m-d',strtotime('+1 day'));
$sql = "select DATE_FORMAT(FROM_UNIXTIME(pubtime),'%Y-%m-%d') as todayr_date,count(*) as today_sum from publish where DATE_FORMAT(FROM_UNIXTIME(pubtime),'%Y-%m-%d') between '{$today}' and '{$tomorrow}' group by todayr_date";
Apr 15, 2016 Replied to a topic by lg2016 问与答 mysql 如何根据发帖的时间戳去统计当天的发帖量？ |
@bianzhifu 嗯，已收到，下课了，我再研究！
Apr 15, 2016 Replied to a topic by lg2016 问与答 mysql 如何根据发帖的时间戳去统计当天的发帖量？ |
@dangyuluo 嗯，纠结了一晚，以后会注意的。
Apr 15, 2016 Replied to a topic by lg2016 问与答 mysql 如何根据发帖的时间戳去统计当天的发帖量？ |
@bianzhifu 楼上真相，谢谢了！
Apr 15, 2016 Replied to a topic by lg2016 问与答 mysql 如何根据发帖的时间戳去统计当天的发帖量？ |
大家还没上班？
Apr 8, 2016 Replied to a topic by lg2016 PHP 问个目录常量定义问题 |
@jugelizi 你这么一说，我就明白了，看来打好基础很重要。
Apr 8, 2016 Replied to a topic by lg2016 PHP 问个目录常量定义问题 |
@audi 嗯，学习环境是在 windows 下的。
另外我还一个小小的疑问， str_replace('\\','/',__DIR__) 为麻是搜索“\\”双斜杠。
另外我还一个小小的疑问， str_replace('\\','/',__DIR__) 为麻是搜索“\\”双斜杠。
Apr 8, 2016 Replied to a topic by lg2016 PHP 问个目录常量定义问题 |
@jfcherng 一针见血,明白是怎么一回事了，谢谢啦！
Select Language