• thinkphp多表关联并且分页


    $db_prefix = C('DB_PREFIX');
    $Model = new Model();
    
     $data = $Model->table("{$db_prefix}ordernum as ou")->join("{$db_prefix}orderinfo as oi on  ou.ofid=oi.id")->join("{$db_prefix}weekprice as wk  on oi.wkid=wk.id")->join("{$db_prefix}stadiums as stm on wk.stm_id=stm.id")->join("{$db_prefix}sports as sp on wk.sp_id=sp.id")->field('ou.uid,oi.id,oi.ordernum,oi.total_money,oi.order_date,oi.ostat,oi.other,stm.stm_name,stm.stm_addr,stm.stm_unique,stm.id as stmid,sp.sp_name,sp.remarks')->where("ou.uid={$_SESSION['uid']}")->group("oi.ordernum")->order("oi.order_date desc")->limit($Page->firstRow . ',' . $Page->listRows)->select();
  • 相关阅读:
    Codeforces Round #534 (Div. 2) D. Game with modulo 交互题
    传球游戏 dp
    欧拉通路和欧拉回路
    HDU 1116
    HDU 4970
    HDU 4557
    HDU 4864
    HDU 1565
    HDU 3046
    HDU 4240
  • 原文地址:https://www.cnblogs.com/wenzichiqingwa/p/3483081.html
Copyright © 2020-2023  润新知