Laravel 4 : getting json from database tables

Question

I have tables festivals, addressess and locations. A festival has one address and a address has one location. Now I want to get json from these 3 tables with laravel. At the moment I get festivals and addresses. How to retrieve the 3th table locations?

public function json()
        {
            $festival = Festival::with('address')->get();

            return Response::json(array('festivals' => $festival))->setCallback(Input::get('callback'));

        }

Razor · Accepted Answer · 2014-08-17 11:59:34Z

2

You can eager load nested relationships:

$festival = Festival::with('address.location')->get();

answered Aug 17, 2014 at 11:59

Razor

9,8633 gold badges39 silver badges52 bronze badges

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

Comments

Gareth Daine · Accepted Answer · 2014-08-18 09:21:24Z

0

You can also get relationships via eager loading using comma separated values in the with() method, like so:

$festivals = Festival::with('address', 'address.location')->get();

Hope this helps.

answered Aug 18, 2014 at 9:21

Gareth Daine

4,2065 gold badges44 silver badges67 bronze badges

Collectives™ on Stack Overflow

Laravel 4 : getting json from database tables

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related