mardi 5 janvier 2021

Multiple Foreign Key on Laravel

I'm trying to work with foreign keys on Laravel. It's quite simple how to add foreign key on table. But if table can contain more than one foreign key, for example:

Table posts:

id,
post_title
post_content
post_category (can be more than one)

Table category

id,
category_title,

--

I want to get posts list with each category_title. I tried this:

$data = DB::table('posts')
        ->join('post_category', 'posts.post_category', '=', 'post_category.id')
        ->orderBy('id', 'DESC')
        ->paginate(10);

And the result:

enter image description here

But it just get 1 category name instead of 2. How can i get posts list with each category_title (not id) included?



via Chebli Mohamed

Aucun commentaire:

Enregistrer un commentaire