laravel条件搜索分页

最新推荐文章于 2022-10-16 20:16:02 发布

柴米油盐那点事儿

最新推荐文章于 2022-10-16 20:16:02 发布

阅读量233

点赞数

文章标签： php

本文链接：https://blog.csdn.net/qq_36774734/article/details/116596958

版权

laravel条件搜索分页

路由：Route::any('admin_userlist','Admin\User\UserController@userlist');

第一步：建表

CREATE TABLE `bk_users` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `account` varchar(255) NOT NULL,
  `password` varchar(255) NOT NULL,
  `updated_at` datetime DEFAULT NULL,
  `created_at` datetime DEFAULT NULL,
  `token` varchar(255) DEFAULT NULL,
  `auth` varchar(255) DEFAULT '1',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=83 DEFAULT CHARSET=utf8;

第二步：创建模型 User.php

<?php
namespace App\Models;
use Illuminate\Database\Eloquent\Model;
class User extends Model
{
    protected $table = 'bk_users';
}

第三步：创建控制器 UserController。

<?php
namespace App\Http\Controllers\Admin\user;
use Illuminate\Http\Request;
use App\Http\Controllers\Controller;
use App\Models\User;
class UserController extends Controller
{
    public function userlist(Request $request)
    {
      $count = $request->input('count',5);
      $params=$request->all();
      $user = new User;
      if($request->account){
        $user =  $user->where('account','like','%'.$request->account.'%');
      } 
      $data = $user->paginate($count);
      return view('admin.user.userlist',['data'=>$data,'params'=>$params]);
    }
}

第四步：html userlist.blade.php

    <form action="/admin_userlist" method="get" >
                <select name="count">
                <option value="2" @if(isset($params) && !empty($params['count']) && $params['count'] == 2) selected @endif>2</option>
                <option value="5" @if(isset($params) && !empty($params['count']) && $params['count'] == 5) selected @endif>5</option>
                <option value="10" @if(isset($params) && !empty($params['count']) && $params['count'] == 10) selected @endif>10</option>
                <option value="15" @if(isset($params) && !empty($params['count']) && $params['count'] == 15) selected @endif>15</option>
                <option value="20" @if(isset($params) && !empty($params['count']) && $params['count'] == 20) selected @endif>20</option>
                <option value="25" @if(isset($params) && !empty($params['count']) && $params['count'] == 25) selected @endif>25</option>
                </select>条
                <br>账号搜索：<input type="text" name="account" value="{{$params['account'] or '' }}">
                <input type="submit" value="搜索" class="btn btn-success">
    </form>
    <br>
                <div class="space15"></div>
                <table class="table table-striped table-hover table-bordered" id="editable-sample">
                <thead>
                <tr>
                    <th>编号</th>
                    <th>头像</th>
                    <th>账号</th>
                </tr>
                </thead>
                @foreach($data as $v)
                <tbody>
                <tr class="">
                    <td>{{ $v->id }}</td>
                    <td><img src="{{$v->userinfo->tou}}" style="width: 40px;height: 40px"></td>
                    <td>{{ $v->account }}</td>
                </tr>
                </tbody>
                 @endforeach
                </table>
                <div class="page">
                        {!! $data->appends($params)->render() !!}
                </div>