Laravel Datatables display data from related tables

Question

I'm using Datatables for displaying data. It works good, but when I want to display data from related tables (models), they do not appear.

Model Keyword.php

public function website() {
    return $this->belongsToMany('App\Website');
}

Model Website.php

 public function keywords() {
    return $this->hasMany('App\Keyword');
}

'websites' database table: id, siteName, siteUrl
'keywords' database table: id, website_id, kwName

Url that should display data: projects/'.$website->id.'/edit (example: projects/2/edit - (edit is a blade)) So, at this Url I want to show a datatable that display all kwName for certain website_id(in this example /2/).

Please, help me what should I use and how to do this.

Jeffrey · Accepted Answer · 2017-02-03 20:52:59Z

1

Your Eloquent relationships are the wrong way around.

keywords has a reference to website via website_id, this is a belongsTo relationship.

website is referenced by many keywords, so this is a hasMany relationship.

Laravel 5.4 Eloquent Relationships

answered Feb 3, 2017 at 20:52

Jeffrey

4834 silver badges13 bronze badges

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

4 Comments

online Thomas Over a year ago

just to comment: you can make them point to eachother no problem e.g. $farmer->hasmany('chicken') and $chicken->hasone('farmer')

Jeffrey Over a year ago

No, that won't work. In a good database design there's always a hasOne/hasMany, and a belongsTo/belongsToMany relation. What you're saying is that a chicken hasOne farmer (farmer keeps record of that 1 chicken, while also keeping record of 'many' other chickens via chicken.farmer_id).

online Thomas Over a year ago

yeah about that you are right, that was a typo. correction: it should be $chicken->belongsto('farmer'). good spot!

R.Jonson Over a year ago

A website may have many keywords (website->hasMany('App\Keyword') A keyword (identical) can be found in many websites(keywords->belongsToMany('App\Website'). So, I think it is possible.

Collectives™ on Stack Overflow

Laravel Datatables display data from related tables

1 Answer 1

4 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

4 Comments

Your Answer

Sign up or log in

Post as a guest

Related