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             }