Laravel - Get Data of Multiple Tables

Question

i would like make a select from two tables, clients and loans. The query (In MySQL syntax) would be something like this:

SELECT * FROM loans, clients WHERE loans.status = 1 AND loans.client_id = clients.id;

This are my models:

class Client extends Eloquent {
    public function loans()
    {
        $this->hasMany('App\Loan');
    }
}

class Loan extends Eloquent {
    public function clients()
    {
        $this->belongsTo('App\Client');
    }
}

How it would be the function using the eloquent model?

If you have the relationship in loans to attach to the client it belongs to then why now get all the loans with status=1 and just use that object to pull the client info. $loans = Loans::where('status',1)->get(); then $loans->clients()->field — Webtect
– Webtect, Commented Feb 26, 2018 at 19:13
Okay, i get the part of bring all the loans ($loans = Loans::where('status',1_->get()) — Dan Cruz
– Dan Cruz, Commented Feb 26, 2018 at 19:18
But, how it would be this: $loans->clients()->field?? How it would be the syntax? — Dan Cruz
– Dan Cruz, Commented Feb 26, 2018 at 19:18

Don't Panic · Accepted Answer · 2018-02-26 19:22:39Z

2

Use the with method to get the loans and clients in one query rather than a separate query for each client.

$loans = Loans::with('clients')->where('status', 1)->get();

See the docs on Eager Loading for more info.

This will get you a collection of Loans which each contains a collection of Clients. If you want to iterate all the loans and clients, you could use a nested loop:

foreach ($loans as $loan) {
    // show loan info
    foreach ($loans->clients as $client) {
        // show client info
    }
}

edited Feb 26, 2018 at 19:22

answered Feb 26, 2018 at 19:15

Don't Panic

41.9k11 gold badges70 silver badges87 bronze badges

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

Comments

AH.Pooladvand · Accepted Answer · 2018-02-26 19:16:57Z

2

Here is what you want

Loans::with('clients')->get();

here is documentation of eager loading
https://laravel.com/docs/5.5/eloquent-relationships#eager-loading

answered Feb 26, 2018 at 19:16

AH.Pooladvand

2,0792 gold badges15 silver badges29 bronze badges

Collectives™ on Stack Overflow

Laravel - Get Data of Multiple 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