Laravel Caching not storing database result array

Question

I am trying to cache database query as given below (Laravel 5.7):

Cache::remember('footer_pages', 180, function () {
    DB::table('pages')->select('id', 'title')->where(array('status' => 'Published', 'menu_position' => 'Footer'))->orderBy('sort', 'ASC')->get();
});

But Cache is empty. Please help me find what mistake I did.

do return DB::table.... The function remember will cache the result of the callback — apokryfos
– apokryfos, Commented Dec 6, 2018 at 18:09

apokryfos · Accepted Answer · 2018-12-06 18:11:17Z

2

The remember function will store the result of the callback in the cache if a callback is provided.

That means you need to make your callback return the result you want stored:

Cache::remember('footer_pages', 180, function () {
    return DB::table('pages')->select('id', 'title')->where(array('status' => 'Published', 'menu_position' => 'Footer'))->orderBy('sort', 'ASC')->get();
});

answered Dec 6, 2018 at 18:11

apokryfos

40.9k11 gold badges85 silver badges128 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Laravel Caching not storing database result array

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related