discuz操作mysql实例

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) ;
                
            }

 

 

$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) ;
                
}

 

2.循环操作：

$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);

 
上面是自己对其简单用法，其实它还有高级用法，，，

 

 

 

 

 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             }