GetOne($sqlyes); if($rowyes['cckyes']>0){ $cckyes = $rowyes['cckyes']; }else{ $cckyes = 0; } if($ckey !=""){ $sqlyesu="SELECT SUM( climit ) AS cckyes FROM sea_cck where status=1 and uname='$ckey'"; $rowyesu = $dsql->GetOne($sqlyesu); if($rowyesu['cckyes']>0){ $cckyesu = $rowyesu['cckyes']; }else{ $cckyesu = 0; } } $w=""; $numPerPage=20; $page = isset($page) ? intval($page) : 1; if($page==0) $page=1; if (!empty($climit) AND $climit != "all") {$w.=" and climit=$climit";} else {$w.='';} if (!empty($ckey)) {$w.=" and uname = '$ckey'";} //计算有多少条数据 $csqlStr="select count(*) as dd from sea_cck where status=1 ".$w; $rowTotal = $dsql->GetOne($csqlStr); if(is_array($rowTotal)){ $TotalResult = $rowTotal['dd']; }else{ $TotalResult = 0; } $TotalPage = ceil($TotalResult/$numPerPage); if ($page>$TotalPage) $page=$TotalPage; $limitstart = ($page-1) * $numPerPage; if($limitstart<0) $limitstart=0; $sqlStr="select * from sea_cck where status=1 ".$w." ORDER BY usetime DESC limit $limitstart,$numPerPage"; ?>
充值记录 【充值总额
】 0){echo '【用户
'.$ckey.'
充值总额
'.$cckyesu.'
】';} ?>
面值:
选择面值
全部
SetQuery($sqlclimit); $dsql->Execute('alimit'); while($rowalimit=$dsql->GetObject('alimit')) {echo '
'.$rowalimit->climit.'
';} ?>
用户:
无充值信息
";} ?>
用户
面值
充值时间
充值卡号
SetQuery($sqlStr); $dsql->Execute('key_list'); while($row=$dsql->GetObject('key_list')) { $id=$row->id; $copy.=$row->ckey."\n" ?>
uname;?>
climit;?>
usetime;?>
ckey;?>
页次:/ 每页 总收录数据条
首页
上一页
下一页
尾页
跳转