七度&光 2019-06-19 13:35 采纳率: 22.2%
浏览 16

如何缓存查询结果?

I am trying to display random query but to stay it in cache so it wont refresh when reloading page. I am using rememberable so I have remember() function working like it was in older versions. But even if I use Cache::remember I have same problem, In the limit I have selected 1 and on my website I also have message Showing 1 to 1 of 1 entries but actually I see everything there, so It doesn't work properly, but main problem is that cache is not working, after reloading page data is refreshing.

       public function ListGames(Request $request)
{
    $query = Game::select(
        'games.id',
        'games.status',
        'games.title',
        'games.city',
        'games.district',
        'games.type',
        'games.comment',
        'games.points',
        'games.created_at',
        'games.photo')->inRandomOrder()->limit(1)->remember(1)
            ->where('games.user_id', '<>', Auth::user()->id)
            ->where('games.status', '=', '1'); 
            // ->leftJoin('game_bids', 'games.status', '=', 'game_bids.is_awarded');
        // ->whereIn('games.status_id', [ExamManager::getStatus(false, 'regular')->id, ExamManager::getStatus(false, 'retake')->id]);
        return DataTables::of($query)->toJson();

}

and here is my data tables code

        dataTableInit('#data-table', [5, 'desc'], 'POST', '{{ url('list/games') }}', [
            {
                title: '{{ Lang::trans('games.photo') }}',
                data: 'photo', render : function(data, type, row){
                  return '<img src="/images/default.jpg" class="img-fluid ${3|rounded-top,rounded-right,rounded-bottom,rounded-left,rounded-circle,|}" alt="">'
                //   return '<img src="/storage/game-photos/'+data+'" class="img-fluid ${3|rounded-top,rounded-right,rounded-bottom,rounded-left,rounded-circle,|}" alt="">'
            }},
            {
                title: '{{ Lang::trans('games.title') }}',
                data: 'title'
            },
            {
                title: '{{ Lang::trans('games.city') }}',
                data: 'city'
            },
            {
                title: '{{ Lang::trans('games.district') }}',
                data: 'district' 
            },
            {
                title: '{{ Lang::trans('games.type') }}',
                data: 'type'
            },
            {
                title: '{{ Lang::trans('games.created_at') }}',
                data: 'created_at'
            },
            {
            title: '{{ Lang::trans('games.status') }}',
            data: 'status', render : function(data, type, row)
            {
                switch (data)
                {
                    case '1': return '<span class="btn btn-success">{{ Lang::trans('games.going') }}</span>';
                        break;
                    case '2': return '<span class="btn btn-danger">{{ Lang::trans('games.disabled') }}</span>';
                        break;
                }
            }
        },
            {
                title: '{{ Lang::trans('games.actions') }}',
                defaultContent: '<div class="data-table-buttons-wrapper">' +
                                    '<button type="button" class="btn btn-info details-button" title="Details">{{ Lang::trans('games.view') }}</button> ' +
                                '</div>'
            }
        ]);
        detailsButton('{{ url('games/{id}') }}');`
  • 写回答

0条回答 默认 最新

    报告相同问题?

    悬赏问题

    • ¥15 有人能看一下我宿舍管理系统的报修功能该怎么改啊?链表那里总是越界
    • ¥15 cs loadimage运行不了,easyx也下了,没有用
    • ¥15 r包runway详细安装教程
    • ¥15 Html中读取Json文件中数据并制作表格
    • ¥15 谁有RH342练习环境
    • ¥15 STM32F407 DMA中断问题
    • ¥15 uniapp连接阿里云无法发布消息和订阅
    • ¥25 麦当劳点餐系统代码纠错
    • ¥15 轮班监督委员会问题。
    • ¥20 关于变压器的具体案例分析