belongsToMany Laravel - find()

Question

I’m developing an Intranet that will contemplate Categories and Posts. A post can receive "n" categories.

To that effect I’m using belongsToMany().

The problem is when returning this data with Post::find($idpost), it returns not only 1 record but all post records in that table pivot is related.

I haven’t found anything like it and I don’t know if I’m doing anything wrong.

The create is running perfectly, the problem is when I ask to return only 1 record.

I inserted belongsToMany() in the 2 tables, Posts and Categories.

Could someone tell me if this behavior is normal or if there is something wrong in the logic/construction?

PS: Laravel 5.2

EDIT

Post
table: posts
pk: id

Category
table: Categories
pk:id

Pivot
table: category_post
pk: id
fk: post_id
fk: category_id

namespace App\Intranet;

use Illuminate\Database\Eloquent\Model;

class Post extends Model
{
    protected $connection = 'mysql_intranet';
    protected $fillable = ['title', 'text', 'categories'];

    public function categories()
    {
        return $this->belongsToMany('App\Intranet\Category');
    }
}



namespace App\Intranet;

use Illuminate\Database\Eloquent\Model;

class Category extends Model
{
    protected $connection = 'mysql_intranet';
    protected $fillable = ['categoria', 'herdado'];

    public function posts()
    {
        return $this->belongsToMany('App\Intranet\Post');
    }
}

Answer 1

You can use the hasMany instead of belongsToMany. Seria belongsToMany if you did the SELECT through the table Categorypost.

Model

Post.php

public function categorias(){
    return $this->hasMany('App\CategoryPost', 'post_id');
}

Controller

MainController.php

use App\Post;    
public function index(){

    $posts = Post::find(1);    
    dd($posts->categorias);
}

Answer 2

Have you tried using the relationship hasManyThrough? It serves exactly for relationship ManyToMany, which is what seems to be your case.

There is a complete example in the Laravel documentation below:

https://laravel.com/docs/5.2/eloquent-relationships#has-Many-through

Using hasManyThrough, you can define the relationship in both Models and access the multiple related records of each.

I hope I’ve helped! ;)

Answer 3

The convention for pivots is the name of each table (singular) separated by _ alphabetically.

category_post