Laravel 5 - 在分页搜索结果中出错

Question

I have a problem with the pagination of search results. I get the first page right, but for page 2 I get this error:

QueryException in Connection.php line 729:
SQLSTATE[42S22]: Column not found: 1054 Unknown column 'page' in 'where clause' (SQL: select count(*) as aggregate from `books` where `id` like %% and `page` like %2% and `books`.`deleted_at` is null)

My route:

Route::get('books/search', 'BookController@searchForm');
Route::get('books/results', 'BookController@searchProcess');

Controller:

use Search; //search trait
public function searchForm(){
    return view('books.search.form');
 }
public function searchProcess(Request $request){
     $result = $this->performSearch($request, $this->model);
     return view('books.search.result', compact('result'));
}

Search Trait (A class in another file):

protected function performSearch($request, $model){
    $searchFields = $request->toArray();
    unset($searchFields['_token']);
    $searchFields = array_filter($searchFields);
    if (empty($searchFields)) {
        return back();
    }
    $list = $model->where('id', 'like', '%%');
    foreach ($searchFields as $column => $value) {
        $list->where($column, 'like', '%'.$value.'%');
    }
    return $list->paginate(10);
}

View for showing results:

    <div class="table-responsive">
        <table class="table table-hover table-bordered">
            <tr>
                <th>Results</th>
            </tr>
            @foreach($result as $datum)
                <tr>
                    <td><a href="{{route('books.show', $datum->id)}}">{{$datum->title}}</a></td>
                </tr>    
            @endforeach
        </table>
    </div>
    @if($result->lastPage() > 1)
        <nav class="text-center">
            {{$result->links()}}
        </nav>
    @endif

I am using Laravel 5.2

Answer 1

seems you are passing page parameter in the query so i think you need to remove page parameter from the query building

protected function performSearch($request, $model)
{
    $searchFields = $request->except(['_token', 'page']); // get all fields except _token and page you can add more parameters in array if they are in request but not in database table column
    $searchFields = array_filter($searchFields);
    if (empty($searchFields)) {
        return back();
    }
    $list = $model->where('id', 'like', '%%');
    foreach ($searchFields as $column => $value) {
        $list->where($column, 'like', '%'.$value.'%');
    }
    return $list->paginate(10);
}