Laravel 8 One To Many Polymorphic Relationship

Websolutionstuff | Nov-19-2021 | Categories : Laravel PHP MySQL

In this tutorial we will learn about laravel 8 one to many polymorphic relationship. A one-to-many polymorphic relation is similar to a typical one-to-many relation.  the child model can belong to more than one type of model using a single association. One to many polymorphic relationship used when a model belongs to more than one other model on a single association model.

For Example, users of your application can comment on posts and videos. Using polymorphic relationships, you may use a single comments table to contain comments for both posts and videos. using morphMany() and morphTo() you can access data.

In this example we will create posts, comments and videos table. all tables are connected with each other like below screenshot and we are create migration and model all table and retrive data using one to many polymorphic relationship in laravel 6, laravel 7, laravel 8.

laravel_one_to_many_polymorphic_relationship

 

 

Create Migration :

Now, we will create migration for posts, comments and videos table. and add foreign key in posts and videos table.

Post Table :

Schema::create('posts', function (Blueprint $table) {

    $table->increments('id');

    $table->string("name");

    $table->timestamps();

});

Comment Table :

Schema::create('comments', function (Blueprint $table) {

    $table->increments('id');

    $table->text("comments");

    $table->integer('commentable_id');

    $table->string("commentable_type");

    $table->timestamps();

});

Video Table :

Schema::create('videos', function (Blueprint $table) {

    $table->increments('id');

    $table->string("title");

    $table->timestamps();

});

 

 

Create Model :

Now, we will create Post, Comment and Video model.

Post Model :

class Post extends Model
{
    /**
     * Get all of the post's comments.
     */
    public function comments()
    {
        return $this->morphMany(Comment::class, 'commentable');
    }
}

Comment Model :

class Comment extends Model
{
    /**
     * Get the parent commentable model (post or video).
     */
    public function commentable()
    {
        return $this->morphTo();
    }
}

Video Model :

class Video extends Model
{
    /**
     * Get all of the video's comments.
     */
    public function comments()
    {
        return $this->morphMany(Comment::class, 'commentable');
    }
}

 

 

Retrieve Record :

Once your database table and models are defined, you may access the relationships via your model's dynamic relationship properties. For example, to access all of the comments for a post, we can use the comments property.

$post = Post::find(1);

foreach ($post->comments as $comment) {
    //
}


You may also retrieve the parent of a polymorphic child model by accessing the name of the method like below code.

$comment = Comment::find(1);

$commentable = $comment->commentable;

 

Create Record :

Now, we will give you example of create record for one to many polymorphic relationship like below code. 

$post = Post::find(1);	
 
$comment = new Comment;
$comment->comments = "this is test comments from websolutionstuff";
 
$post->comments()->save($comment);

 


You might also like :

Recommended Post
Featured Post
How to Upload File on the FTP Server Using PHP
How to Upload File on the FTP...

In this small post i will show you how to upload file on the ftp server using php. As we know there are many ftp functio...

Read More

May-20-2021

Multiple Row Grouping Datatables jQuery
Multiple Row Grouping Datatabl...

In this article, we will see how to row group in datatable in jquery. Datatables doesn't have row grouping buil...

Read More

Jun-04-2022

How to File Upload in Angular 17 Tutorial
How to File Upload in Angular...

In this article, we'll see how to file upload in the angular 17 tutorial. Here, we'll learn about file uplo...

Read More

Apr-03-2024

Google Line Chart Example in Laravel 8
Google Line Chart Example in L...

In this article, we will see the google line chart example in laravel 8. Google charts use to visualize d...

Read More

Feb-24-2021