doutun1875 2017-06-22 20:52
浏览 95
已采纳

Laravel:分页只返回第一块

I pull in the paginated data via AJAX requests in my Laravel application. This works fine for the first chunk. For the following however, it's only passing one column (the id).

What is the problem?

The relevant code:

Route::get('contacts', function (Request $request) {
    return buildQuery($request, User::class)->simplePaginate(50);
});

function buildQuery(Request $request, $model) {
    $query = DB::table('users')->select('id as ID');
    $properties = $request->all();

    $searchString = "";
    if (in_array('q', array_keys($properties)) && $properties['q']) {
        $searchString = $properties['q'];
        $query->orWhere('id', 'like', '%'.$searchString.'%');
    }

    foreach ($properties as $property => $value) {
        if ($property == "id" || $property == "q")
            continue;

        if (in_array($property, array_keys($model::$labels))) {
            $query->addSelect($property.' as '.$model::$labels[$property]);

            if ($value == "desc" || $value == "asc")
                $query->orderBy($property, $value);

            if ($searchString)
                $query->orWhere($property, 'like', '%'.$searchString.'%');
        }
    }

    return $query;
}
  • 写回答

1条回答 默认 最新

  • donglu5728 2017-06-22 21:09
    关注

    Its because the query params are not appended to the subsequent pagination requests.

    Update your logic inside the Route to:

    Route::get('contacts', function (Request $request) {
        return buildQuery($request, User::class)->paginate(50)->appends($request->all());
    });
    

    OR

    Route::get('contacts', function (Request $request) {
            return buildQuery($request, User::class)->simplePaginate(50)->appends($request->all());
        });
    
    本回答被题主选为最佳回答 , 对您是否有帮助呢?
    评论

报告相同问题?

悬赏问题

  • ¥15 pyqt6如何引用qrc文件加载里面的的资源
  • ¥20 RL+GNN解决人员排班问题时梯度消失
  • ¥15 统计大规模图中的完全子图问题
  • ¥15 使用LM2596制作降压电路,一个能运行,一个不能
  • ¥60 要数控稳压电源测试数据
  • ¥15 能帮我写下这个编程吗
  • ¥15 ikuai客户端l2tp协议链接报终止15信号和无法将p.p.p6转换为我的l2tp线路
  • ¥15 phython读取excel表格报错 ^7个 SyntaxError: invalid syntax 语句报错
  • ¥20 @microsoft/fetch-event-source 流式响应问题
  • ¥15 ogg dd trandata 报错