国产av日韩一区二区三区精品,成人性爱视频在线观看,国产,欧美,日韩,一区,www.成色av久久成人,2222eeee成人天堂

mysql - ThinkPHP3.2.3?? ??? ??? ??? ?????
過去多啦不再A夢
過去多啦不再A夢 2017-07-05 10:46:05
0
3
1043

??


SQL ??
SELECT crsIpint,crsIpout,crsName,wfdz,CheckStatus,0 AS flag FROM vehicle.crossing AS t1 LEFT JOIN ( SELECT * FROM caminfo.devs_ip_status WHERE type = 95 ) AS t2 ON( t1.crsId = t2.DeviceID ) WHERE t1.type <> 0 LIMIT 0,20 UNION ( SELECT ip AS crsIpint,"" AS crsIpout,name AS crsName,"主服務器" AS wfdz,1 AS CheckStatus,1 AS flag FROM trk.devs_other WHERE type = 101 )

???.

?? ??? ??
SELECT crsIpint,crsIpout,crsName,wfdz,CheckStatus,0 AS flag FROM vehicle.crossing AS t1 LEFT JOIN ( SELECT * FROM caminfo.devs_ip_status WHERE type = 95 ) AS t2 ON( t1.crsId = t2.DeviceID ) WHERE t1.type <> 0 UNION ( SELECT ip AS crsIpint,"" AS crsIpout,name AS crsName,"主服務器" AS wfdz,1 AS CheckStatus,1 AS flag FROM trk.devs_other WHERE type = 101 ) LIMIT 0,20
? ??????. ??? ??? ???? ??? ???????? ? ?

??? ???? SQL? ??? ? ?? ?? ???? ???? ???? ?????

過去多啦不再A夢
過去多啦不再A夢

?? ??(3)
ringa_lee

$Model = M(); ?????? ? ???? ???? ??? ??? ? ????

扔個三星炸死你

?? ???? ???? ????. ?? $crossingModel? ??? ???? ?????. $crossingModel

? ??? ???.
洪濤

?? 1
?? ??
$sql='';//?? SQL ?
$res = M()->query($sql);
?? 2:
1 $count=M('')- Join ()->where($where)->count();//? ??? ? ????
//$page ??? ?? 10? ? ???? ???? ?????
2 $pagearr=getPageArr($page,10, $count) ;
//???? ???? ???? ???? ???? ?? ????
function getPageArr($page, $pagesize = 10, $count)
{

???

}
3 ??? ??? ??? ? ? ???

->limit($pagearr['start'],$pagearr['pagesize'])