shaweren's recent timeline updates shaweren's recent timeline updates |
shawerenV2EX member #80354, joined on 2014-11-06 12:14:23 +08:00 |
| MySql 如何查询连续打卡记录？ MySQL • shaweren • Dec 23, 2019 • Lastly replied by a719031256 | 10 |
| /dev/vda1 系统盘满了 问与答 • shaweren • Dec 5, 2019 • Lastly replied by Arnie97 | 1 |
| MYSQL 根据年月如何查询数据？ MySQL • shaweren • Dec 3, 2019 • Lastly replied by ganning | 13 |
| 小程序上拉加载， 100 条后加载不出来了。 微信 • shaweren • Mar 19, 2018 |
| 很多开源软件开头都有一句类似 define('EmpireCMSAdmin','1'); 是什么意思 PHP • shaweren • Nov 22, 2017 • Lastly replied by littlehz | 4 |
| PHP 怎么获取指定信息的排名？ PHP • shaweren • Nov 6, 2017 • Lastly replied by jeff0819 | 7 |
| 微信 JSSDK 二次分享失效的问题。 JavaScript • shaweren • Aug 24, 2017 |
| sql 如何实现在条件为空时查询全部数据?? PHP • shaweren • Sep 6, 2017 • Lastly replied by WheatField | 15 |
| PHP 微信支付问题 PHP • shaweren • Jul 27, 2017 • Lastly replied by gone | 14 |
| PHP str_replace 替换 $变量符号无法识别的问题 问与答 • shaweren • May 20, 2017 • Lastly replied by msg7086 | 14 |
shaweren's recent replies
Dec 20, 2019 Replied to a topic by shaweren › MySQL › MySql 如何查询连续打卡记录？ |
Dec 20, 2019 Replied to a topic by shaweren › MySQL › MySql 如何查询连续打卡记录？ |
@qmzhixu 嗯，可以试试，每次打卡存都存开始日期，查的话就按最新一条记录的开始日期和结束统计，补签就把所有开始日期更新到前一天。脑洞果然大开。
Dec 2, 2019 Replied to a topic by shaweren › MySQL › MYSQL 根据年月如何查询数据？ |
感谢各位大佬 /
<BR>
month(stime)='$month' AND year(stime)='$year' <br>解决办法
<BR>
month(stime)='$month' AND year(stime)='$year' <br>解决办法
Nov 2, 2017 Replied to a topic by shaweren › PHP › PHP 怎么获取指定信息的排名？ |
$key = '';
foreach ($row as $k => $v) {
if ($v['0'] == $id) {
$key = $k + 1;
}
}
return $key;
foreach ($row as $k => $v) {
if ($v['0'] == $id) {
$key = $k + 1;
}
}
return $key;
Aug 16, 2017 Replied to a topic by shaweren › PHP › sql 如何实现在条件为空时查询全部数据?? |
if($fid>0){
$query=$query."and fid='$fid'";
}else{
};
用这种方式解决的..
$query=$query."and fid='$fid'";
}else{
};
用这种方式解决的..
Aug 16, 2017 Replied to a topic by shaweren › PHP › sql 如何实现在条件为空时查询全部数据?? |
@silencefent
$query. = isset($fid) ? 'and fid='$fid'' : ''; 我是这么写的，但是好像不行，不知道是哪里的问题。
$query. = isset($fid) ? 'and fid='$fid'' : ''; 我是这么写的，但是好像不行，不知道是哪里的问题。
Aug 16, 2017 Replied to a topic by shaweren › PHP › sql 如何实现在条件为空时查询全部数据?? |
@macwhirr 因为类似这种需要留空的字段有好几个，用判断就太复杂了
Jul 27, 2017 Replied to a topic by shaweren › PHP › PHP 微信支付问题 |
Jul 27, 2017 Replied to a topic by shaweren › PHP › PHP 微信支付问题 |
@goodspb 当 Google 解决不了的时候就想能天降个大神..
Jul 27, 2017 Replied to a topic by shaweren › PHP › PHP 微信支付问题 |
@zhengwenk 恩，换上也跑通了，但引入自己的业务还有点问题，水平问题，解决起来有点费劲。
Select Language