1.单个操作:代码
$dateYear=date('Y');//当前年份
$dateMonth = date('m');//当前月份
//exit($dateMonth);
//判断当前年月份是否有记录
$sql="SELECT * FROM ".tname('creditlog_byMonth')." WHERE uid='".$uid."' and year(FROM_UNIXTIME(dateline))='".$dateYear."' and month(FROM_UNIXTIME(dateline))='".$dateMonth."'";
//exit ($sql);
$query = $_SGLOBAL['db']->query($sql);
$creditlog_byMonth = $_SGLOBAL['db']->fetch_array($query);
$curDetailID=0;//当前详细记录ID(以方便修改操作)
//判断是否有记录...
if(empty($creditlog_byMonth))
{
//添加:
$sql="insert into ".tname('creditlog_byMonth')."(uid,credit,dateline) values ('".$uid."','".$rule['credit']."','".$_SGLOBAL[timestamp]."')";
//exit($sql);
$_SGLOBAL['db']->query($sql) ;
}
else {//修改:
$curDetailID=$creditlog_byMonth[id];
$sql="update ".tname('creditlog_byMonth')." set credit=credit+".$rule['credit']." where id=".$curDetailID;
$_SGLOBAL['db']->query($sql) ;
}
$dateMonth = date('m');//当前月份
//exit($dateMonth);
//判断当前年月份是否有记录
$sql="SELECT * FROM ".tname('creditlog_byMonth')." WHERE uid='".$uid."' and year(FROM_UNIXTIME(dateline))='".$dateYear."' and month(FROM_UNIXTIME(dateline))='".$dateMonth."'";
//exit ($sql);
$query = $_SGLOBAL['db']->query($sql);
$creditlog_byMonth = $_SGLOBAL['db']->fetch_array($query);
$curDetailID=0;//当前详细记录ID(以方便修改操作)
//判断是否有记录...
if(empty($creditlog_byMonth))
{
//添加:
$sql="insert into ".tname('creditlog_byMonth')."(uid,credit,dateline) values ('".$uid."','".$rule['credit']."','".$_SGLOBAL[timestamp]."')";
//exit($sql);
$_SGLOBAL['db']->query($sql) ;
}
else {//修改:
$curDetailID=$creditlog_byMonth[id];
$sql="update ".tname('creditlog_byMonth')." set credit=credit+".$rule['credit']." where id=".$curDetailID;
$_SGLOBAL['db']->query($sql) ;
}
![](https://images.cnblogs.com/OutliningIndicators/ExpandedBlockStart.gif)
$dateYear=date('Y');//当前年份
$dateMonth = date('m');//当前月份
//exit($dateMonth);
//判断当前年月份是否有记录
$sql="SELECT * FROM ".tname('creditlog_byMonth')." WHERE uid='".$uid."' and year(FROM_UNIXTIME(dateline))='".$dateYear."' and month(FROM_UNIXTIME(dateline))='".$dateMonth."'";
//exit ($sql);
$query = $_SGLOBAL['db']->query($sql);
$creditlog_byMonth = $_SGLOBAL['db']->fetch_array($query);
$curDetailID=0;//当前详细记录ID(以方便修改操作)
//判断是否有记录...
if(empty($creditlog_byMonth))
{
//添加:
$sql="insert into ".tname('creditlog_byMonth')."(uid,credit,dateline) values ('".$uid."','".$rule['credit']."','".$_SGLOBAL[timestamp]."')";
//exit($sql);
$_SGLOBAL['db']->query($sql) ;
}
else {//修改:
$curDetailID=$creditlog_byMonth[id];
$sql="update ".tname('creditlog_byMonth')." set credit=credit+".$rule['credit']." where id=".$curDetailID;
$_SGLOBAL['db']->query($sql) ;
}
$dateMonth = date('m');//当前月份
//exit($dateMonth);
//判断当前年月份是否有记录
$sql="SELECT * FROM ".tname('creditlog_byMonth')." WHERE uid='".$uid."' and year(FROM_UNIXTIME(dateline))='".$dateYear."' and month(FROM_UNIXTIME(dateline))='".$dateMonth."'";
//exit ($sql);
$query = $_SGLOBAL['db']->query($sql);
$creditlog_byMonth = $_SGLOBAL['db']->fetch_array($query);
$curDetailID=0;//当前详细记录ID(以方便修改操作)
//判断是否有记录...
if(empty($creditlog_byMonth))
{
//添加:
$sql="insert into ".tname('creditlog_byMonth')."(uid,credit,dateline) values ('".$uid."','".$rule['credit']."','".$_SGLOBAL[timestamp]."')";
//exit($sql);
$_SGLOBAL['db']->query($sql) ;
}
else {//修改:
$curDetailID=$creditlog_byMonth[id];
$sql="update ".tname('creditlog_byMonth')." set credit=credit+".$rule['credit']." where id=".$curDetailID;
$_SGLOBAL['db']->query($sql) ;
}
2.循环操作:
![](https://images.cnblogs.com/OutliningIndicators/ExpandedBlockStart.gif)
$sql="SELECT * FROM ".tname('creditlog_byMonth')." WHERE year(FROM_UNIXTIME(dateline))='".$dateYear."' and month(FROM_UNIXTIME(dateline))='".$dateMonth."' order by dateline desc limit 0,9";
//exit ($sql);
$query = $_SGLOBAL['db']->query($sql);
$tmpArr=array();
while ($tmpArr = $_SGLOBAL['db']->fetch_array($query)) {
$out.=$tmpArr['credit']."<br/>";
}
exit($out);
//exit ($sql);
$query = $_SGLOBAL['db']->query($sql);
$tmpArr=array();
while ($tmpArr = $_SGLOBAL['db']->fetch_array($query)) {
$out.=$tmpArr['credit']."<br/>";
}
exit($out);
上面是自己对其简单用法,其实它还有高级用法,,,
1 $dateYear=date('Y');//当前年份
2 $dateMonth = date('m');//当前月份
3 //exit($dateMonth);
4 //判断当前年月份是否有记录
5 $sql="SELECT * FROM ".tname('creditlog_byMonth')." WHERE uid='".$uid."' and year(FROM_UNIXTIME(dateline))='".$dateYear."' and month(FROM_UNIXTIME(dateline))='".$dateMonth."'";
6 //exit ($sql);
7 $query = $_SGLOBAL['db']->query($sql);
8 $creditlog_byMonth = $_SGLOBAL['db']->fetch_array($query);
9 $curDetailID=0;//当前详细记录ID(以方便修改操作)
10 //判断是否有记录...
11 if(empty($creditlog_byMonth))
12 {
13 //添加:
14 $sql="insert into ".tname('creditlog_byMonth')."(uid,credit,dateline) values ('".$uid."','".$rule['credit']."','".$_SGLOBAL[timestamp]."')";
15 //exit($sql);
16 $_SGLOBAL['db']->query($sql) ;
17
18 }
19 else {//修改:
20 $curDetailID=$creditlog_byMonth[id];
21 $sql="update ".tname('creditlog_byMonth')." set credit=credit+".$rule['credit']." where id=".$curDetailID;
22 $_SGLOBAL['db']->query($sql) ;
23
24 }
2 $dateMonth = date('m');//当前月份
3 //exit($dateMonth);
4 //判断当前年月份是否有记录
5 $sql="SELECT * FROM ".tname('creditlog_byMonth')." WHERE uid='".$uid."' and year(FROM_UNIXTIME(dateline))='".$dateYear."' and month(FROM_UNIXTIME(dateline))='".$dateMonth."'";
6 //exit ($sql);
7 $query = $_SGLOBAL['db']->query($sql);
8 $creditlog_byMonth = $_SGLOBAL['db']->fetch_array($query);
9 $curDetailID=0;//当前详细记录ID(以方便修改操作)
10 //判断是否有记录...
11 if(empty($creditlog_byMonth))
12 {
13 //添加:
14 $sql="insert into ".tname('creditlog_byMonth')."(uid,credit,dateline) values ('".$uid."','".$rule['credit']."','".$_SGLOBAL[timestamp]."')";
15 //exit($sql);
16 $_SGLOBAL['db']->query($sql) ;
17
18 }
19 else {//修改:
20 $curDetailID=$creditlog_byMonth[id];
21 $sql="update ".tname('creditlog_byMonth')." set credit=credit+".$rule['credit']." where id=".$curDetailID;
22 $_SGLOBAL['db']->query($sql) ;
23
24 }