练习KS小项目——显示数据库信息查询功能和分页显示

54 篇文章 2 订阅
53 篇文章 1 订阅
1.D:\PHPTutorial\WWW\ks88\application\admin\controller\Kuaishou.php
<?php
namespace app\admin\controller;
use think\Controller;
use think\Db;
class Kuaishou extends Controller
{
  public function lst()
  {

      if(request()->isPost()){
          $uid = $_POST["uid"];
      //          dump($uid);

          $kuaishou = Db::table('kuaishou')->where('uid',$uid)->paginate(10);
        //    dump($kuaishou); //打印

          $this->assign('kuaishou',$kuaishou); //把查找数据发送给视图
          return $this->fetch();
      }

      // 在数据库查找 kuaishou表的信息,把信息分页显示出来每页显示10条
      $kuaishou = \think\Db::name('kuaishou')->paginate(10);

    //把查找数据发送给视图
    $this->assign('kuaishou',$kuaishou);
    return $this->fetch();

  }
    public function edit(){
        $id=input('id');
        dump($id);

        $uids = Db::table('kuaishou')->where('uid',$id)->select();
        dump($uids);

        if(request()->isPost()){
            $userinfo=\think\Db::name('admin')->find($id);
            $password=$userinfo['password'];
            $data=[
                'id'=>input('id'),
                'username'=>input('username'),
                'password'=>input('password') ? md5(input('password')) : $password,
            ];
            $validate = \think\Loader::validate('Admin');
            if($validate->scene('edit')->check($data)){
                if($db=\think\Db::name('admin')->update($data)){
                    return $this->success('修改管理员成功!','lst');
                }else{
                    return $this->error('修改管理员失败!');
                }
            }else{
                return $this->error($validate->getError());
            }
            return;
        }
        $admins=db('admin')->find($id);
        $this->assign('admins',$admins);
        return $this->fetch();
    }
}
.D:\PHPTutorial\WWW\ks88\application\admin\view\Kuaishou\lst.html
<!DOCTYPE html>
<html><head>
    <meta charset="utf-8">
    <title>KS</title>
    <meta name="description" content="Dashboard">
    <meta name="viewport" content="width=device-width, initial-scale=1.0">
    <meta http-equiv="X-UA-Compatible" content="IE=edge">
    <meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
    <!--Basic Styles-->
    <link href="__PUBLIC__/style/bootstrap.css" rel="stylesheet">
    <link href="__PUBLIC__/style/font-awesome.css" rel="stylesheet">
    <link href="__PUBLIC__/style/weather-icons.css" rel="stylesheet">

    <!--Beyond styles-->
    <link id="beyond-link" href="__PUBLIC__/style/beyond.css" rel="stylesheet" type="text/css">
    <link href="__PUBLIC__/style/demo.css" rel="stylesheet">
    <link href="__PUBLIC__/style/typicons.css" rel="stylesheet">
    <link href="__PUBLIC__/style/animate.css" rel="stylesheet">

    <link rel="stylesheet" href="__PUBLIC__/css/index.css">

    <link rel="stylesheet" type="text/css" href="__PUBLIC__/css/common.css"/>
    <link rel="stylesheet" type="text/css" href="__PUBLIC__/css/main.css"/>
    <script type="text/javascript" src="__PUBLIC__/js/libs/modernizr.min.js"></script>

</head>

<style type="text/css">
    ul.pagination  li{
        float: left;
    }

    div.list-page{
        width: 400px;
        margin: 0 auto;
        text-align: center;
    }
</style>

<body>
<!-- 头部 -->
<div class="navbar">
    <div class="navbar-inner">
        <div class="navbar-container">

            <div class="navbar-header pull-left">
                <div class="navbar-brand">
                    <ul class="account-area">
                        <li>
                            <!--<a class="login-area dropdown-toggle" data-toggle="dropdown">-->
                            <div class="avatar" title="View your public profile">
                                <!--<a href="#" class="navbar-brand"></a>-->
                            </div>
                            <a class="collapse-icon fa fa-inbox">快手助理1.0v</a>
                            <!--</a>-->
                            <!--Login Area Dropdown-->
                            <ul class="pull-right dropdown-menu dropdown-arrow dropdown-login-area">
                                <li class="username"><a>David Stevenson</a></li>
                                <li class="dropdown-footer">
                                    <a href="/admin/user/logout.html">
                                        退出登录
                                    </a>
                                </li>
                                <li class="dropdown-footer">
                                    <a href="/admin/user/changePwd.html">
                                        修改密码
                                    </a>
                                </li>
                            </ul>
                            <!--/Login Area Dropdown-->
                        </li>
                        <!-- /Account Area -->
                        <!--Note: notice that setting div must start right after account area list.
                            no space must be between these elements-->
                        <!-- Settings -->
                    </ul>
                </div>
            </div>
            <!-- /Account Area and Settings -->
        </div>
    </div>
</div>

<!-- /头部 -->
<form class="form-inline" action="" method="post" id="myform" name="myform" enctype="multipart/form-data">
    <div class="form-group">
        <label for="uid">快手ID: </label>
        <input class="form-control" name="uid" id="uid">
        <button type="submit" class="btn btn-default">提交</button>
    </div>
</form>


<form name="myform1" id="myform1" method="post">
    <div class="result-content">
        <table class="result-tab" width="100%">
            {volist name="kuaishou" id="vo"}
            <div class="kuai left">
                <div class="layui-form-item zhanshi" style="background: url('__PUBLIC__/images/bg.jpg') no-repeat center 100%">
                    <img src="__PUBLIC__/images/tu.jpg" alt="">
                </div>
                <div class="layui-form-item xinxi">
                    <p>快手ID:<span class="shenglve">{$vo.uid}</span></p>
                    <p class="right color_6">20分钟前</p>
                </div>
                <div class="layui-form-item xinxi center">
                    <p class="left color_6"><i class="fa fa-thumbs-o-up"></i> 23123</p>
                    <p class="color_6"><i class="fa fa-commenting-o"></i> 23123</p>
                    <p class="right color_6"><i class="fa fa-caret-square-o-right"></i> 32165</p>
                </div>
            </div>
            {/volist}
        </table>
        <div class="list-page">{$kuaishou->render()}</div>
    </div>
</form>

<!-- Page Body -->
<div class="page-body">

</div>

</div>
<!-- /Page Body -->
</div>
<!-- /Page Content -->
</div>
</div>

<!--Basic Scripts-->
<script src="__PUBLIC__/style/jquery_002.js"></script>
<script src="__PUBLIC__/style/bootstrap.js"></script>
<script src="__PUBLIC__/style/jquery.js"></script>
<!--Beyond Scripts-->
<script src="__PUBLIC__/style/beyond.js"></script>
</body></html>
http://www.iheyud.com/ks88/public/index.php/admin/kuaishou/lst?page=1
修改样式以后的lst.html文件
3.D:\PHPTutorial\WWW\ks88\application\admin\view\Kuaishou\lst.html
<!DOCTYPE html>
<html><head>
    <meta charset="utf-8">
    <title>KS</title>
    <meta name="description" content="Dashboard">
    <meta name="viewport" content="width=device-width, initial-scale=1.0">
    <meta http-equiv="X-UA-Compatible" content="IE=edge">
    <meta http-equiv="Content-Type" content="text/html; charset=UTF-8">

    <link rel="stylesheet" href="__PUBLIC__/lib/layui/css/layui.css"> <!--rel="stylesheet" 描述了当前页面与href所指定文档的关系,是,href连接的文档是一个新式表-->
    <link rel="stylesheet" href="__PUBLIC__/css/index.css">
    <link rel="stylesheet" href="__PUBLIC__/lib/font-awesome-4.7.0/css/font-awesome.css">
    <!--Basic Styles-->
    <link rel="stylesheet" href="__PUBLIC__/css/index.css">
    <link href="__PUBLIC__/style/bootstrap.css" rel="stylesheet">
    <link href="__PUBLIC__/style/font-awesome.css" rel="stylesheet">
    <link href="__PUBLIC__/style/weather-icons.css" rel="stylesheet">
    <!--Beyond styles-->
    <link id="beyond-link" href="__PUBLIC__/style/beyond.css" rel="stylesheet" type="text/css">
    <link href="__PUBLIC__/style/demo.css" rel="stylesheet">
    <link href="__PUBLIC__/style/typicons.css" rel="stylesheet">
    <link href="__PUBLIC__/style/animate.css" rel="stylesheet">

    <link rel="stylesheet" type="text/css" href="__PUBLIC__/css/common.css"/>
    <link rel="stylesheet" type="text/css" href="__PUBLIC__/css/main.css"/>
    <script type="text/javascript" src="__PUBLIC__/js/libs/modernizr.min.js"></script>

</head>
<style type="text/css">
    ul.pagination  li{
        float: left;
    }

    div.list-page{
        width: 400px;
        margin: 0 auto;
        text-align: center;
    }
</style>

<body>
<!-- 头部 -->
<div class="navbar">
    <div class="navbar-inner">
        <div class="navbar-container">

            <div class="navbar-header pull-left">
                <div class="navbar-brand">
                    <ul class="account-area">
                        <li>
                            <!--<a class="login-area dropdown-toggle" data-toggle="dropdown">-->
                            <div class="avatar" title="View your public profile">
                                <!--<a href="#" class="navbar-brand"></a>-->
                            </div>
                            <a class="collapse-icon fa fa-inbox">快手助理1.0v</a>
                            <!--</a>-->
                            <!--Login Area Dropdown-->
                            <ul class="pull-right dropdown-menu dropdown-arrow dropdown-login-area">
                                <li class="username"><a>David Stevenson</a></li>
                                <li class="dropdown-footer">
                                    <a href="/admin/user/logout.html">
                                        退出登录
                                    </a>
                                </li>
                                <li class="dropdown-footer">
                                    <a href="/admin/user/changePwd.html">
                                        修改密码
                                    </a>
                                </li>
                            </ul>
                            <!--/Login Area Dropdown-->
                        </li>
                        <!-- /Account Area -->
                        <!--Note: notice that setting div must start right after account area list.
                        <!-- Settings -->
                    </ul>
                </div>
            </div>
            <!-- /Account Area and Settings -->
        </div>
    </div>
</div>

<!-- /头部 -->
<form class="form-inline" action="" method="post" id="myform" name="myform" enctype="multipart/form-data">
    <div class="form-group">
        <label for="uid">快手ID: </label>
        <input class="form-control" name="uid" id="uid">
        <button type="submit" class="btn btn-default">提交</button>
    </div>
</form>
      
            {volist name="kuaishou" id="vo"}
            <div class="kuai left">
                <div class="layui-form-item zhanshi" style="background: url('__PUBLIC__/images/bg.jpg') no-repeat center 100%">
                    <img src="__PUBLIC__/images/tu.jpg" alt="">
                </div>
                <div class="layui-form-item xinxi">
                    <p>快手ID:<span class="shenglve">{$vo.uid}</span></p>
                    <p class="right color_6">{$vo.release_time}</p>
                </div>

                <div class="layui-form-item xinxi center">
                    <p class="left color_6"><i class="fa fa-thumbs-o-up"></i>{$vo.like_count}</p>
                    <p class="color_6"><i class="fa fa-commenting-o"></i>{$vo.comment_count}</p>
                    <p class="right color_6"><i class="fa fa-caret-square-o-right"></i>
                        {$vo.play_count}</p>
                </div>
            </div>
            {/volist}
        </table>
        <div class="list-page">{$kuaishou->render()}</div>
    </div>
</form>

<!-- Page Body -->
<div class="page-body">

</div>

</div>
<!-- /Page Body -->
</div>
<!-- /Page Content -->
</div>
</div>
<!--Basic Scripts-->
<script src="__PUBLIC__/style/jquery_002.js"></script>
<script src="__PUBLIC__/style/bootstrap.js"></script>
<script src="__PUBLIC__/style/jquery.js"></script>
<!--Beyond Scripts-->
<script src="__PUBLIC__/style/beyond.js"></script>
<script src="__PUBLIC__/lib/jQuery.js"></script>
<script src="__PUBLIC__/lib/layui/layui.js"></script>

</body></html>
http://www.iheyud.com/ks88/public/index.php/admin/kuaishou/lst?page=1

 

评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值