laravel框架（添加，展示，删除，修改，搜索后分页）

た入场券 2023-08-17 16:58 48阅读 0赞

控制器代码

public function index()
        {
        
            return view('user/index');
        }
        //执行添加
        public  function  add(Request $request){
        
            $username=$request->input('username');
            $pwd=$request->input('pwd');
            $res= DB::table('user')->insert([
                'username' =>$username,
                'pwd' =>$pwd,
            ]);
            if($res){
        
                return Redirect('show');
            }
            else{
        
                die('添加失败');
            }
        }
        //分页查询开始
        public function show(){
        
            $search = isset($_GET['search'])?$_GET['search']:"";//判断是否接过搜索值
            if($search)
            {
        
                $arr = DB::select("select * from user where username like '%$search%'");//带搜索条件查询
            }else{
        
                $arr = DB::table('user')->get();//不带搜索条件查询
            }
            //总条数
            $count = count($arr);
            //每页条数
            $mys = 3 ;
            //计算总页数
            $zys = ceil($count/$mys);
            //获取当前页
            $page = isset($_GET['page'])?$_GET['page']:1;
            //偏移量
            $pyl = ($page-1)*$mys;
            if($search)
            {
        
                $arr = DB::select("select * from user where username like '%$search%' limit $pyl,$mys");//带搜索分页条件查询
                /*foreach($arr as $key => $value) {
        
                    $arr[$key]['username'] = str_replace($search, "<font color='red'>$search</font>", $value['username']);
                }*/
            }else{
        
                $arr = DB::table('user')->skip($pyl)->take($mys)->get();//带分页条件查询
            }
            //上一页
            $last = $page-1<1?1:$page-1;
            //下一页
            $next = $page+1>$zys?$zys:$page+1;
            // print_R($next);die;
            return view('user/show',['res'=>$arr,'search'=>$search,'last'=>$last,'next'=>$next,'sum_page'=>$zys,'page'=>$page]);
        }
        //分页查询结束
    //删除
        public function del(Request $request){
        
            $id=$request->input('id');
            $res=DB::table('user')->where('id',$id)->delete();
            if($res==1){
        
                return redirect('show');
            }
        }
        //修改页面
        public function upd(Request $request){
        
            $id=$request->input('id');
            $arr=DB::table('user')->where('id',$id)->first();
            return view('user/update',['arr'=>$arr]);
        }
        //执行修改
        public function update(Request $request){
        
            $id=$request->input('id');
            $username=$request->input('username');
            $pwd=$request->input('pwd');
            $res=DB::table('user')->where('id',$id)->update(array('username'=>$username,'pwd'=>$pwd));
            if($res==1){
        
                return redirect('show');
            }
        }
    
    添加页面

<form action="add" method="get">
        <table>
            <tr>
                <td>用户名</td>
                <td><input type="text" name="username"/></td>
            </tr>
            <tr>
                <td>密码：</td>
                <td><input type="password" name="pwd"/></td>
            </tr>
            <tr>
                <td></td>
                <td><input type="submit" value="登录"/></td>
            </tr>
        </table>
    </form>
    
    展示页面

<center>
        <div id="div1">
            <input type="text" name="search" value="{
        {$search}}"/><button οnclick="page(<?php echo $page?>)">搜索</button>
            <table border="1">
                <tr>
                    <td>ID</td>
                    <td>用户名</td>
                    <td>密码</td>
                    <td>操作</td>
                </tr>
                @foreach($res as $key=>$val)
                    <tr>
                        <td>{
        {$val->id}}</td>
                        <td>{
        {$val->username}}</td>
                        <td>{
        {$val->pwd}}</td>
                        <td><a href="{
        {url('del')}}?id={
        {$val->id}}">删除</a>||<a href="{
        {url('upd')}}?id={
        {$val->id}}">修改</a></td>
                    </tr>
                @endforeach
            </table>
            当前页<?php echo $page?>共<?php echo $sum_page?>
            <a href="javascript:void (0)" οnclick="page(1)">首页</a>
            <a href="javascript:void (0)" οnclick="page(<?php echo $last?>)">上一页</a>
            <a href="javascript:void (0)" οnclick="page(<?php echo $next?>)">下一页</a>
            <a href="javascript:void (0)" οnclick="page(<?php echo $sum_page?>)">尾页</a>
        </div>
    </center>

<form action="{
        {url('update')}}" method="get">
        <table>
            <input type="hidden" name="id" value="{
        {$arr->id}}"/>
            <tr>
                <td>用户名</td>
                <td><input type="text" name="username" value="{
        {$arr->username}}"/></td>
            </tr>
            <tr>
                <td>密码：</td>
                <td><input type="password" name="pwd" value="{
        {$arr->pwd}}"/></td>
            </tr>
            <tr>
                <td></td>
                <td><input type="submit" value="修改"/></td>
            </tr>
        </table>
    </form>
    
    web页面

Route::any('index','UserController@index' );
    Route::any('add','UserController@add' );
    Route::any('show','UserController@show' );
    Route::any('del','UserController@del' );
    Route::any('upd','UserController@upd' );
    Route::any('update','UserController@update' );

转载于:https://www.cnblogs.com/xuesensen/p/11234182.html