tp5项目后台比赛界面

//篮球比赛界面

    public function blist(){

        $list = db('list')->where('fid',0)->select();

        foreach ($list as $key => $val){

            $list[$key]['zlist'] = db('list')->where('fid',$val['id'])->select();

        }

        $this->assign('list',$list);

        //从数据库中查找导航列表父级元素及其子级元素

        $keywords = input('keywords');

        $blist = db('basgame')->where('team1','like',"%".$keywords."%")->whereOr('contest','like',"%".$keywords."%")

        ->whereOr('team2','like',"%".$keywords."%")->whereOr('state','like',"%".$keywords."%")->order('time')->paginate(5);

        $this->assign('blist',$blist);

        //根据查找条件查找并用时间给比赛分页排序，然后使用循环标签在view中打印

        return $this->fetch();

    }

视图

导航

    public function bajax(){

        $id = input('id');

        $arr = [];

        $a = db('basgame')->where('id',$id)->select();

        if($a) {

            $arr['code'] = 1;

            db('basgame')->where('id',$id)->delete();

            db('basguess')->where('gid',$id)->delete();

        }

        return $arr;

        //通过Ajax，将传过来的比赛id在数据库中查询，如果有结果，则在比赛和竞猜数据库中都删除掉该记录，再返回数组来确定是否删除成功

    }

列表

<div class="layui-body">

            <div class="layui-content">

                <div class="layui-row">

                    <div class="layui-card">

                        <div class="layui-card-body">

                            <div class="form-box">

                                <div class="layui-form layui-form-item">

                                  <form action="" method="get">

                                    <div class="layui-inline">

                                        <div class="layui-form-mid">比赛:</div>

                                        <div class="layui-input-inline" style="width: 100px;">

                                          <input type="text" autocomplete="off" class="layui-input" name="keywords">

                                        </div>

                                        <button class="layui-btn layui-btn-blue">查询</button>

                                        <button class="layui-btn layui-btn-primary">重置</button>

                                    </div>

                                  </form>  

                                </div>

                                <button class="layui-btn layui-btn-blue"><i class="layui-icon"><a href="{:url('add/addbasgame')}">新增</a></button>

                                <table class="layui-table">

                                  <thead>

                                    <tr>

                                      <th>队伍一</th>

                                      <th>赛事</th>

                                      <th>时间</th>

                                      <th>队伍二</th>

                                      <th>状态</th>

                                      <th>操作</th>

                                    </tr>

                                  </thead>

                                  <tbody>

                                    {volist name="blist" id="vo"}

                                      <tr>

                                        <td>

                                          <img src="{$vo.img1}" alt="">

                                          {$vo.team1}

                                        </td>

                                        <td>

                                          {$vo.contest}

                                        </td>

                                        <td>

                                          {$vo.time}

                                        </td>

                                        <td>

                                          <img src="{$vo.img2}" alt="">

                                          {$vo.team2}

                                        </td>

                                        <td>

                                          {$vo.state}

                                        </td>

                                        <td>

                                          <a class="layui-btn" href="{:url('admin/edit/editbasgame',['id'=>$vo.id])}">编辑比赛</a>

                                          <a class="layui-btn layui-btn-normal" href="{:url('admin/add/addbasguess',['id'=>$vo.id])}">编辑竞猜</a>

                                          <button class="del layui-btn layui-btn-danger" data-id="{$vo.id}">删除</button>

                                        </td>

                                      </tr>

                                    {/volist}

                                  </tbody>

                                </table> 

                                {$blist->render()}

                            </div>

                        </div>

                    </div>

                </div>

            </div>

        </div>