Category Archives: Laravel

Laravel Tutorials

Laravel Eloquent Relationships Example

In this Laravel Eloquent Relationships example tutorial, I’ll show you how to create and use eloquent relationships in laravel database model. In this article we will learn to implement and use different types of eloquent model relation available in laravel. We will also learn to perform create, insert and to delete operations in different type of relationships.

Type of Laravel Eloquent Relationships

In laravel, there are following types of eloquent relationships available:

Laravel One to One Relationship Example

The one to one relationship is a very common relationship in laravel model. In this example we will learn to implement and use one to one relationship in laravel. We will also show you how to insert, retrieve, update, and delete data with the eloquent model from the database table in laravel.

Laravel Eloquent One to One Relationship Example

Let suppose we have two tables posts and contents in our example tutorial. In laravel we can create both tables using migration as following:

Post table migration:

Schema::create('posts', function (Blueprint $table) {
 
    $table->increments('id');
 
    $table->string('title');
 
    $table->text('short_desc');
 
    $table->timestamps();
 
});

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

$table->increments('id');

$table->string('title');

$table->text('short_desc');

$table->timestamps();

});

Contents table migration:

Schema::create('contents', function (Blueprint $table) {
 
    $table->increments('id');
 
    $table->integer('post_id')->unsigned();
 
    $table->text('description');
 
    $table->timestamps();
 
 
    $table->foreign('post_id')->references('id')->on('posts')
 
        ->onDelete('cascade');
 
});

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

$table->increments('id');

$table->integer('post_id')->unsigned();

$table->text('description');

$table->timestamps();

$table->foreign('post_id')->references('id')->on('posts')

->onDelete('cascade');

});

In this example, the Post model is closely associated with a Content model in one to one relationship. In one to one relationship we will create a post_content() method within the Post model and there is hasOne() method to relate it with Content model as following.

<?php
 
namespace App;
 
use Illuminate\Database\Eloquent\Model;
 
class Post extends Model
{
    public function post_content()
    {
        return $this->hasOne('App\Content');
    }
}

<?php

namespace App;

use Illuminate\Database\Eloquent\Model;

class Post extends Model

{

public function post_content()

{

return $this->hasOne('App\Content');

}

The Eloquent model adds a foreign key based on the model name and should have a matching id value in it. In this relationship the post_id is the foreign_key for Content model,

Inverse of One to One Relationship Example

For now we can have the access to the content from the post model. Now we create an inverse relationship in the content model. For this we will use the belongsTo method for getting the post data from the content model as following.

<?php
 
namespace App;
 
use Illuminate\Database\Eloquent\Model;
 
class Content extends Model
{
    public function post()
    {
        return $this->belongsTo('App\Post');
    }
}

<?php

namespace App;

use Illuminate\Database\Eloquent\Model;

class Content extends Model

{

public function post()

{

return $this->belongsTo('App\Post');

}

We can now access the post content using the relation method as following:

$content = Post::find(10)->post_content;

1	$content = Post::find(10)->post_content;

Laravel One to Many Relationship Example

In this step by step tutorial I’ll guide you through to create many to many relationship and learn how to use this relationship. In this example we will use one to many relationship, and perform crud (create, read, update, delete) operation with the eloquent model from the database table in laravel.

Laravel Eloquent One to Many Relationship Example

Let suppose we have tables name posts and authors. Using laravel migration, you can create both tables with the following fields:

Author table migration:

Schema::create('authors', function (Blueprint $table) {
 
    $table->increments('id');
 
    $table->string('name');
 
    $table->timestamps();
 
});

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

$table->increments('id');

$table->string('name');

$table->timestamps();

});

Post table migration:

Schema::create('posts', function (Blueprint $table) {
 
    $table->increments('id');
 
    $table->string('title');
 
    $table->text('description');
 
    $table->integer('author_id')->unsigned();
 
    $table->timestamps();
 
 
    $table->foreign('author_id')->references('id')->on('authors')
 
        ->onDelete('cascade');
 
});

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

$table->increments('id');

$table->string('title');

$table->text('description');

$table->integer('author_id')->unsigned();

$table->timestamps();

$table->foreign('author_id')->references('id')->on('authors')

->onDelete('cascade');

});

Define One To Many Relationship

Now we will define One To Many Relationship for the model we have created. In One to many relationships means a relationship where one single model can owns the number of the other model. As per the example model we created, a single author can have written many post articles. Let’s take an example of one to many relationships.

<?php
 
namespace App;
 
use Illuminate\Database\Eloquent\Model;
 
class Author extends Model
{
    ...
    public function post()
    {
        return $this->hasMany('App\Post');
    }
}

<?php

namespace App;

use Illuminate\Database\Eloquent\Model;

class Author extends Model

{

...

public function post()

{

return $this->hasMany('App\Post');

}

Now, we can access the collection of post articles by using the post() method as.

$posts = App\Author::find(10)->post()->get();

 foreach ($posts as $post) {
     //do something
 }

$posts = App\Author::find(10)->post()->get();

foreach ($posts as $post) {

//do something

}

Defining Inverse One To Many Relationship in Laravel

As of now we can access all the post articles of an author, now suppose if we want to allow a post model to access its Author model or access author details by using the post model. The inverse relationship of both One to One and One to Many works the same way. The inverse of the one to many relationship can be defined using the belongsTo method. Thus we can define in example mode as following:

<?php
 
namespace App;
 
use Illuminate\Database\Eloquent\Model;
 
class Post extends Model
{
    public function author()
    {
        return $this->belongsTo('App\Author');
    }
}

<?php

namespace App;

use Illuminate\Database\Eloquent\Model;

class Post extends Model

{

public function author()

{

return $this->belongsTo('App\Author');

}

Now we can get the author details by using posts in one to many relationship as following:

$post->author->name;

1	$post->author->name;

Retrieving Data In One to many relationship

In one to many relationship you can retrieve data from model as following:

You can get all posts of a particular author:

$posts = Author::find(10)->post()->get();

 foreach ($posts as $post) {
     //do something
 }

$posts = Author::find(10)->post()->get();

foreach ($posts as $post) {

//do something

}

Similarly, you can retrieve the inverse related model.

$posts = Post::find(10)->author()->get();

 foreach ($posts as $post) {
     //do something
 }

$posts = Post::find(10)->author()->get();

foreach ($posts as $post) {

//do something

}

Laravel Many to Many Relationship Example

In laravel using belongsToMany() method, you can define many to many relationship in laravel eloquent models. Then you can insert, update and delete data from table using many to many relationship in laravel.

Laravel Eloquent Many to Many Relationship Example

In this example we will demonstrate the implementation of Many to Many Relationship using two tables posts and tags. In this relationship each of the post can have many tags and each of the tag can be associated with many posts.

Now, lets understand how to define many to many relationships, Using belongsToMany() method:

<?php
 
namespace App;
 
use Illuminate\Database\Eloquent\Model;
 
class Post extends Model
{
   ...
    public function tags()
    {
        return $this->belongsToMany('App\Tag');
    }
}

<?php

namespace App;

use Illuminate\Database\Eloquent\Model;

class Post extends Model

{

...

public function tags()

{

return $this->belongsToMany('App\Tag');

}

Now, you can access the tags in the post model as follow:

$post = App\Post::find(8);

 foreach ($post->tags as $tag) {
    //do something
 }

$post = App\Post::find(8);

foreach ($post->tags as $tag) {

//do something

}

The inverse of Many to Many Relationship Example

In Laravel, the inverse relationship of a many to many relationships can be defined using belongsToMany method on the reverse model.

<?php
 
namespace App;
 
use Illuminate\Database\Eloquent\Model;
 
class Tag extends Model
{
    public function posts()
    {
        return $this->belongsToMany('App\Post');
    }
}

<?php

namespace App;

use Illuminate\Database\Eloquent\Model;

class Tag extends Model

{

public function posts()

{

return $this->belongsToMany('App\Post');

}

Now you can access the post in the tag model as follow:

$tag = App\Tag::find(8);

 foreach ($tag->posts as $post) {
     //do something
  }

$tag = App\Tag::find(8);

foreach ($tag->posts as $post) {

//do something

}

Laravel Eloquent HasMany Through Relationship Example

In this Laravel Has Many Through Eloquent Relationship tutorial we will implement an example for the Laravel Has Many Through Eloquent Relationship. We will generate migration files of “users”, “posts” and “countries” table and then add a foreign key with users and posts table as following:

In users migration file:

Schema::create('users', function (Blueprint $table) {
 
    $table->increments('id');
 
    $table->string('name');
 
    $table->string('email')->unique();
 
    $table->string('password');
 
    $table->integer('country_id')->unsigned();
 
    $table->rememberToken();
 
    $table->timestamps();
 
    $table->foreign('country_id')->references('id')->on('countries')
 
                ->onDelete('cascade');
 
});

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

$table->increments('id');

$table->string('name');

$table->string('email')->unique();

$table->string('password');

$table->integer('country_id')->unsigned();

$table->rememberToken();

$table->timestamps();

$table->foreign('country_id')->references('id')->on('countries')

->onDelete('cascade');

});

In posts migration file:

Schema::create('posts', function (Blueprint $table) {
 
    $table->increments('id');
 
    $table->string("name");
 
    $table->integer('user_id')->unsigned();
 
    $table->timestamps();
 
    $table->foreign('user_id')->references('id')->on('users')
 
                ->onDelete('cascade');
 
});

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

$table->increments('id');

$table->string("name");

$table->integer('user_id')->unsigned();

$table->timestamps();

$table->foreign('user_id')->references('id')->on('users')

->onDelete('cascade');

});

In countries migration file:

Schema::create('countries', function (Blueprint $table) {
 
    $table->increments('id');
 
    $table->string('name');
 
    $table->timestamps();
 
});

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

$table->increments('id');

$table->string('name');

$table->timestamps();

});

In laravel, the “has-many-through” relationship provides a shortcut for accessing distant relations via an intermediate model relation. For example, a Country model might have many Post models through an intermediate User model. In this example, we can easily get all blog posts of a given country. I’ll show you how to define HasMany Through relationship:

<?php
 
namespace App;
 
use Illuminate\Database\Eloquent\Model;
 
class Country extends Model
{
    /**
     * Get all of the posts for the country.
     */
    public function posts()
    {
        return $this->hasManyThrough('App\Post', 'App\User');
    }
}

<?php

namespace App;

use Illuminate\Database\Eloquent\Model;

class Country extends Model

{

/**

* Get all of the posts for the country.

public function posts()

{

return $this->hasManyThrough('App\Post', 'App\User');

}

To fetch data using this relationship as follow:

$country = Country::find(1);    
  
dd($country->posts);

$country = Country::find(1);

dd($country->posts);

Laravel One to One Relationship Example

In this Laravel one to one relationship example tutorial, I’ll show you to implement one to one relationships In laravel eloquent model. You will also learn how to create and use one to many relationship in laravel.

Laravel One to One Relationship Example

Laravel Eloquent One to One Relationship Example

Let suppose we have two tables posts and contents in our example tutorial. In laravel we can create both tables using migration as following:

Post table migration:

Schema::create('posts', function (Blueprint $table) {
 
    $table->increments('id');
 
    $table->string('title');
 
    $table->text('short_desc');
 
    $table->timestamps();
 
});

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

$table->increments('id');

$table->string('title');

$table->text('short_desc');

$table->timestamps();

});

Contents table migration:

Schema::create('contents', function (Blueprint $table) {
 
    $table->increments('id');
 
    $table->integer('post_id')->unsigned();
 
    $table->text('description');
 
    $table->timestamps();
 
 
    $table->foreign('post_id')->references('id')->on('posts')
 
        ->onDelete('cascade');
 
});

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

$table->increments('id');

$table->integer('post_id')->unsigned();

$table->text('description');

$table->timestamps();

$table->foreign('post_id')->references('id')->on('posts')

->onDelete('cascade');

});

<?php
 
namespace App;
 
use Illuminate\Database\Eloquent\Model;
 
class Post extends Model
{
    public function post_content()
    {
        return $this->hasOne('App\Content');
    }
}

<?php

namespace App;

use Illuminate\Database\Eloquent\Model;

class Post extends Model

{

public function post_content()

{

return $this->hasOne('App\Content');

}

The Eloquent model adds a foreign key based on the model name and should have a matching id value in it. In this relationship the post_id is the foreign_key for Content model,

Inverse of One to One Relationship Example

<?php
 
namespace App;
 
use Illuminate\Database\Eloquent\Model;
 
class Content extends Model
{
    public function post()
    {
        return $this->belongsTo('App\Post');
    }
}

<?php

namespace App;

use Illuminate\Database\Eloquent\Model;

class Content extends Model

{

public function post()

{

return $this->belongsTo('App\Post');

}

We can now access the post content using the relation method as following:

$content = Post::find(10)->post_content;

1	$content = Post::find(10)->post_content;

Laravel Insert record in one to one relationship

You can insert record in post and content table using one to one relationship as following:

public function addPost()
 {
     $post = new Post;
     $post->title= "Hello world";
     $post->short_desc= "Hello world";
     $post->save();
 
     $content = new Content;
     $content->description= 'helllo world post description';
     $content->post_content()->save($content);
 }

public function addPost()

{

$post = new Post;

$post->title= "Hello world";

$post->short_desc= "Hello world";

$post->save();

$content = new Content;

$content->description= 'helllo world post description';

$content->post_content()->save($content);

}

Now, if you want to retrieve data from both post and content table, you can use one to one relationship as following:

public function index()
{
    // get post and content from Post Model
    $post = Post::find(1);
    var_dump($post->title);
    var_dump($post->post_content->description);
 
    // get post data from PostContent model
    $post= Content::find(1)->post;
    dd($post);
 
}

public function index()

{

// get post and content from Post Model

$post = Post::find(1);

var_dump($post->title);

var_dump($post->post_content->description);

// get post data from PostContent model

$post= Content::find(1)->post;

dd($post);

}

Laravel Delete record in One to One relationship

Now, to delete record from both tables posts and contents in one to one relationship, you can do it as following:

public function delete()
{
    $post = Post::find(1);
    $post->delete();
}

public function delete()

{

$post = Post::find(1);

$post->delete();

}

Laravel One to Many Relationship Example

In this Laravel one to many relationship example tutorial I’ll show you how to implement one to many relationship in laravel eloquent model. You will also learn how to use create, and retrieve records from database tables using one to many relationship.

Laravel One to Many Relationship Example

Laravel Eloquent One to Many Relationship Example

Let suppose we have tables name posts and authors. Using laravel migration, you can create both tables with the following fields:

Author table migration:

Schema::create('authors', function (Blueprint $table) {
 
    $table->increments('id');
 
    $table->string('name');
 
    $table->timestamps();
 
});

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

$table->increments('id');

$table->string('name');

$table->timestamps();

});

Post table migration:

Schema::create('posts', function (Blueprint $table) {
 
    $table->increments('id');
 
    $table->string('title');
 
    $table->text('description');
 
    $table->integer('author_id')->unsigned();
 
    $table->timestamps();
 
 
    $table->foreign('author_id')->references('id')->on('authors')
 
        ->onDelete('cascade');
 
});

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

$table->increments('id');

$table->string('title');

$table->text('description');

$table->integer('author_id')->unsigned();

$table->timestamps();

$table->foreign('author_id')->references('id')->on('authors')

->onDelete('cascade');

});

Define One To Many Relationship

<?php
 
namespace App;
 
use Illuminate\Database\Eloquent\Model;
 
class Author extends Model
{
    ...
    public function post()
    {
        return $this->hasMany('App\Post');
    }
}

<?php

namespace App;

use Illuminate\Database\Eloquent\Model;

class Author extends Model

{

...

public function post()

{

return $this->hasMany('App\Post');

}

Now, we can access the collection of post articles by using the post() method as.

$posts = App\Author::find(10)->post()->get();

 foreach ($posts as $post) {
     //do something
 }

$posts = App\Author::find(10)->post()->get();

foreach ($posts as $post) {

//do something

}

Defining Inverse One To Many Relationship in Laravel

<?php
 
namespace App;
 
use Illuminate\Database\Eloquent\Model;
 
class Post extends Model
{
    public function author()
    {
        return $this->belongsTo('App\Author');
    }
}

<?php

namespace App;

use Illuminate\Database\Eloquent\Model;

class Post extends Model

{

public function author()

{

return $this->belongsTo('App\Author');

}

Now we can get the author details by using posts in one to many relationship as following:

$post->author->name;

1	$post->author->name;

Retrieving Data In One to many relationship

In one to many relationship you can retrieve data from model as following:

You can get all posts of a particular author:

$posts = Author::find(10)->post()->get();

 foreach ($posts as $post) {
     //do something
 }

$posts = Author::find(10)->post()->get();

foreach ($posts as $post) {

//do something

}

Similarly, you can retrieve the inverse related model.

$posts = Post::find(10)->author()->get();

 foreach ($posts as $post) {
     //do something
 }

$posts = Post::find(10)->author()->get();

foreach ($posts as $post) {

//do something

}

Inserting Data In One to Many relationship

To Insert data in one to many relationship between two models, we can first create a child object and then save it using the parent object as following:

$author = Author::find(1);

$post= new Post();
$post->title = 'iPhone X';
$post->description = 'Some description';

// Saving related model
$author->post()->save($post);

$author = Author::find(1);

$post= new Post();

$post->title = 'iPhone X';

$post->description = 'Some description';

// Saving related model

$author->post()->save($post);

Filtering Data In one to many relationship

If you want to filter the related records and want them to sort when retrieving. You can chain the methods on your retrieving query.

$author = Author::find(1); 
$post = $author->post() 
 ->orderBy('name', 'asc') 
 ->get();

$author = Author::find(1);

$post = $author->post()

->orderBy('name', 'asc')

->get();

Deleting Data In One to Many relationship

Deleting of records in one to many relationship is performed same as we have created them. To delete all posts for a particular author use below code example.

$author = Author::find(1); 
$author->post()->delete();

1 2	$author = Author::find(1); $author->post()->delete();

Laravel Many to Many Relationship Example

In this Laravel many to many relationship example tutorial.I’ll show you how to implement and use many to many relationship along with the inverse of the many to many relationship.

Laravel Many to Many Relationship Example

Laravel Eloquent Many to Many Relationship Example

Now, lets understand how to define many to many relationships, Using belongsToMany() method:

<?php
 
namespace App;
 
use Illuminate\Database\Eloquent\Model;
 
class Post extends Model
{
   ...
    public function tags()
    {
        return $this->belongsToMany('App\Tag');
    }
}

<?php

namespace App;

use Illuminate\Database\Eloquent\Model;

class Post extends Model

{

...

public function tags()

{

return $this->belongsToMany('App\Tag');

}

Now, you can access the tags in the post model as follow:

$post = App\Post::find(8);

 foreach ($post->tags as $tag) {
    //do something
 }

$post = App\Post::find(8);

foreach ($post->tags as $tag) {

//do something

}

The inverse of Many to Many Relationship Example

In Laravel, the inverse relationship of a many to many relationships can be defined using belongsToMany method on the reverse model.

<?php
 
namespace App;
 
use Illuminate\Database\Eloquent\Model;
 
class Tag extends Model
{
    public function posts()
    {
        return $this->belongsToMany('App\Post');
    }
}

<?php

namespace App;

use Illuminate\Database\Eloquent\Model;

class Tag extends Model

{

public function posts()

{

return $this->belongsToMany('App\Post');

}

Now you can access the post in the tag model as follow:

$tag = App\Tag::find(8);

 foreach ($tag->posts as $post) {
     //do something
  }

$tag = App\Tag::find(8);

foreach ($tag->posts as $post) {

//do something

}

Laravel Has Many Through Eloquent Relationship Example

In this Laravel HasManyThrough relationship example tutorial, I’ll show you how to create hasmany through relationship in eloquent models. In this tutorial you will also learn to implement and use Laravel Has Many Through Eloquent Relationship.

Laravel Eloquent HasMany Through Relationship Example

In users migration file:

Schema::create('users', function (Blueprint $table) {
 
    $table->increments('id');
 
    $table->string('name');
 
    $table->string('email')->unique();
 
    $table->string('password');
 
    $table->integer('country_id')->unsigned();
 
    $table->rememberToken();
 
    $table->timestamps();
 
    $table->foreign('country_id')->references('id')->on('countries')
 
                ->onDelete('cascade');
 
});

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

$table->increments('id');

$table->string('name');

$table->string('email')->unique();

$table->string('password');

$table->integer('country_id')->unsigned();

$table->rememberToken();

$table->timestamps();

$table->foreign('country_id')->references('id')->on('countries')

->onDelete('cascade');

});

In posts migration file:

Schema::create('posts', function (Blueprint $table) {
 
    $table->increments('id');
 
    $table->string("name");
 
    $table->integer('user_id')->unsigned();
 
    $table->timestamps();
 
    $table->foreign('user_id')->references('id')->on('users')
 
                ->onDelete('cascade');
 
});

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

$table->increments('id');

$table->string("name");

$table->integer('user_id')->unsigned();

$table->timestamps();

$table->foreign('user_id')->references('id')->on('users')

->onDelete('cascade');

});

In countries migration file:

Schema::create('countries', function (Blueprint $table) {
 
    $table->increments('id');
 
    $table->string('name');
 
    $table->timestamps();
 
});

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

$table->increments('id');

$table->string('name');

$table->timestamps();

});

<?php
 
namespace App;
 
use Illuminate\Database\Eloquent\Model;
 
class Country extends Model
{
    /**
     * Get all of the posts for the country.
     */
    public function posts()
    {
        return $this->hasManyThrough('App\Post', 'App\User');
    }
}

<?php

namespace App;

use Illuminate\Database\Eloquent\Model;

class Country extends Model

{

/**

* Get all of the posts for the country.

public function posts()

{

return $this->hasManyThrough('App\Post', 'App\User');

}

To fetch data using this relationship as follow:

$country = Country::find(1);    
  
dd($country->posts);

$country = Country::find(1);

dd($country->posts);

Laravel One to Many Polymorphic Relationship Example

In this Laravel One to Many Polymorphic Relationship Example tutorial, I’ll show you how to implement laravel one to many polymorphic relationship and you will also learn how to use create, and retrieve records from database tables using this relationship.

Laravel One to Many Polymorphic Relationship Example

Developing any blogging portal application and you would have many tables like posts, videos and comments. You would need to add comments for posts and videos. In this scenario you can use One to Many Polymorphic Model Relationship in laravel. Because your comments model belongs to more than one model.

In Laravel “morphMany()” and “morphTo()” eloquent method allows you to create One to Many Polymorphic Relationship in your laravel eloquent models.

Create Migration File

In this example we will create posts, videos and comments migration files with following files:

posts migration file:

Schema::create('posts', function (Blueprint $table) {
 
    $table->increments('id');
 
    $table->string("name");
 
    $table->timestamps();
 
});

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

$table->increments('id');

$table->string("name");

$table->timestamps();

});

videos migration file:

Schema::create('videos', function (Blueprint $table) {
 
    $table->increments('id');
 
    $table->string("name");
 
    $table->timestamps();
 
});

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

$table->increments('id');

$table->string("name");

$table->timestamps();

});

comments migration file:

Schema::create('comments', function (Blueprint $table) {
 
    $table->increments('id');
 
    $table->string("body");
 
    $table->integer('commentable_id');
 
    $table->string("commentable_type");
 
    $table->timestamps();
 
});

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

$table->increments('id');

$table->string("body");

$table->integer('commentable_id');

$table->string("commentable_type");

$table->timestamps();

});

Create one to many polymorphic relationships in model

Now, we can create one to many polymorphic relationships as following:

Post Model:

<?php
  
namespace App;
use Illuminate\Database\Eloquent\Model;
  
class Post extends Model
{
    /**
     * Get all of the post's comments.
     */
    public function comments()
    {
        return $this->morphMany(Comment::class, 'commentable');
    }
}

<?php

namespace App;

use Illuminate\Database\Eloquent\Model;

class Post extends Model

{

/**

* Get all of the post's comments.

public function comments()

{

return $this->morphMany(Comment::class, 'commentable');

}

Video Model:

<?php
  
namespace App;
  
use Illuminate\Database\Eloquent\Model;
  
class Video extends Model
{
    /**
     * Get all of the post's comments.
     */
    public function comments()
    {
        return $this->morphMany(Comment::class, 'commentable');
    }
}

<?php

namespace App;

use Illuminate\Database\Eloquent\Model;

class Video extends Model

{

/**

* Get all of the post's comments.

public function comments()

{

return $this->morphMany(Comment::class, 'commentable');

}

Comment Model:

<?php
  
namespace App;
  
use Illuminate\Database\Eloquent\Model;
  
class Comment extends Model
{
    /**
     * Get all of the owning commentable models.
     */
    public function commentable()
    {
        return $this->morphTo();
    }
}

<?php

namespace App;

use Illuminate\Database\Eloquent\Model;

class Comment extends Model

{

/**

* Get all of the owning commentable models.

public function commentable()

{

return $this->morphTo();

}

Retrieve, create a record using polymorphic relationship

Now you will learn how to retrieve and create a record from posts, videos and comments table using one to many polymorphic relationship:

Retrieve Records:

// for posts comments
$post = Post::find(1);  
  
dd($post->comments);
 
// for videos comments
$video = Video::find(1);    
  
dd($video->comments);

// for posts comments

$post = Post::find(1);

dd($post->comments);

// for videos comments

$video = Video::find(1);

dd($video->comments);

Create Records:

// for posts comments
$post = Post::find(1);  
  
$comment = new Comment;
$comment->body = "Hello world";
  
$post->comments()->save($comment);
 
// for videos comments
$video = Video::find(1);    
  
$comment = new Comment;
$comment->body = "hello world";
  
$video->comments()->save($comment);

// for posts comments

$post = Post::find(1);

$comment = new Comment;

$comment->body = "Hello world";

$post->comments()->save($comment);

// for videos comments

$video = Video::find(1);

$comment = new Comment;

$comment->body = "hello world";

$video->comments()->save($comment);

Laravel Many to Many Polymorphic Relationship Example

In this Laravel Many to Many Polymorphic Relationship Example tutorial, I’ll show you how to implement laravel many to many polymorphic relationship in laravel eloquent model. You will also learn how to use create, and retrieve records from database tables using Many to Many Polymorphic Relationship.

Laravel Many to Many Polymorphic Relationship Example

In laravel, “morphToMany()” and “morphedByMany()” eloquent method allows you to create Many to Many Polymorphic Relationship in your laravel eloquent models.

In this step by step tutorial I’ll guide you through to create many to many polymorphic relationship and learn how to use this relationship:

Create Migration File

In this example we will create posts, videos, tags and taggables migration files as following:

database/migrations/posts

Schema::create('posts', function (Blueprint $table) {
 
    $table->bigIncrements('id');
 
    $table->string("name");
 
    $table->timestamps();
 
});

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

$table->bigIncrements('id');

$table->string("name");

$table->timestamps();

});

database/migrations/videos

Schema::create('videos', function (Blueprint $table) {
 
    $table->bigIncrements('id');
 
    $table->string("name");
 
    $table->timestamps();
 
});

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

$table->bigIncrements('id');

$table->string("name");

$table->timestamps();

});

database/migrations/tags

Schema::create('tags', function (Blueprint $table) {
 
    $table->bigIncrements('id');
 
    $table->string("name");
 
    $table->timestamps();
 
});

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

$table->bigIncrements('id');

$table->string("name");

$table->timestamps();

});

database/migrations/taggables

Schema::create('taggables', function (Blueprint $table) {
 
    $table->integer("tag_id");
 
    $table->integer("taggable_id");
 
    $table->string("taggable_type");
 
});

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

$table->integer("tag_id");

$table->integer("taggable_id");

$table->string("taggable_type");

});

Create many to many polymorphic relationships in model

Next, create many to many polymorphic relationships as follow:

app/Post.php

namespace App;
  
use Illuminate\Database\Eloquent\Model;
  
class Post extends Model
{
    
    public function tags()
    {
        return $this->morphToMany(Tag::class, 'taggable');
    }
}

namespace App;

use Illuminate\Database\Eloquent\Model;

class Post extends Model

{

public function tags()

{

return $this->morphToMany(Tag::class, 'taggable');

}

app/Video.php

namespace App;
  
use Illuminate\Database\Eloquent\Model;
  
class Video extends Model
{
 
    public function tags()
    {
        return $this->morphToMany(Tag::class, 'taggable');
    }
}

namespace App;

use Illuminate\Database\Eloquent\Model;

class Video extends Model

{

public function tags()

{

return $this->morphToMany(Tag::class, 'taggable');

}

app/Tag.php

namespace App;
  
use Illuminate\Database\Eloquent\Model;
  
class Tag extends Model
{
    
    public function posts()
    {
        return $this->morphedByMany(Post::class, 'taggable');
    }
  
    public function videos()
    {
        return $this->morphedByMany(Video::class, 'taggable');
    }
}

namespace App;

use Illuminate\Database\Eloquent\Model;

class Tag extends Model

{

public function posts()

{

return $this->morphedByMany(Post::class, 'taggable');

}

public function videos()

{

return $this->morphedByMany(Video::class, 'taggable');

}

Insert and retrieve a record using many to many polymorphic relationship

Now I will show you how to insert and retrieve a record from posts, videos tags, and taggables table in many to many polymorphic relationship:

Retrieve Records From table

Find post tags as follow:

$post = Post::find(1);  
  
dd($post->tags);

$post = Post::find(1);

dd($post->tags);

Find video tags as follow:

$video = Video::find(1);    
  
dd($video->tags);

$video = Video::find(1);

dd($video->tags);

and you can find post and video of a specific tag like

$tag = Tag::find(1);    
  
dd($tag->posts);

$tag = Tag::find(1);

dd($tag->posts);

$tag = Tag::find(1);    
  
dd($tag->videos);

$tag = Tag::find(1);

dd($tag->videos);

Insert Records in Table

Now we can Insert tag for the post into DB table as following:

$post = Post::find(1);  
  
$tag = new Tag;
$tag->name = "Laravel";
  
$post->tags()->save($tag);

$post = Post::find(1);

$tag = new Tag;

$tag->name = "Laravel";

$post->tags()->save($tag);

Insert tag for the following video into DB table as follow:

$video = Video::find(1);    
  
$tag = new Tag;
$tag->name = "Madona";
  
$video->tags()->save($tag);

$video = Video::find(1);

$tag = new Tag;

$tag->name = "Madona";

$video->tags()->save($tag);

Insert Multiple Tags for Post:

$post = Post::find(1);  
  
$tag1 = new Tag;
$tag1->name = "Laravel";
  
$tag2 = new Tag;
$tag2->name = "jQuery";
  
$post->tags()->saveMany([$tag1, $tag2]);

$post = Post::find(1);

$tag1 = new Tag;

$tag1->name = "Laravel";

$tag2 = new Tag;

$tag2->name = "jQuery";

$post->tags()->saveMany([$tag1, $tag2]);

Using sync or attach to insert multiple tag as follow:

$post = Post::find(1);  
  
$tag1 = Tag::find(3);
$tag2 = Tag::find(4);
  
$post->tags()->attach([$tag1->id, $tag2->id]);

$post = Post::find(1);

$tag1 = Tag::find(3);

$tag2 = Tag::find(4);

$post->tags()->attach([$tag1->id, $tag2->id]);

Or use sync

$post = Post::find(1);  
  
$tag1 = Tag::find(3);
$tag2 = Tag::find(4);
  
$post->tags()->sync([$tag1->id, $tag2->id]);

$post = Post::find(1);

$tag1 = Tag::find(3);

$tag2 = Tag::find(4);

$post->tags()->sync([$tag1->id, $tag2->id]);

Laravel whereExists and whereNotExists Query Example

In this Laravel whereExists and whereNotExists Query Example tutorial, I will show how to use whereExists and whereNotExists methods with eloquent in laravel query builder and laravel model.

Laravel whereExists and whereNotExists Query Example

Suppose you are developing a job portal in laravel. In this portal an employer can post a job and hire employees as per the require positions. When an employer posts a job and they wants to hire only manager or web developer. In this case we have to face problem because you have registered users of different designations.

Suppose you have the following tables into your job application:

`positions` table

id | title | timestamps

`users` table

id | name | email | timestamps

`users_position` table (a pivot table for user and position)

id | user_id | position_id | description | timestamps

`jobs` table

id | position_id | name | description | timestamps

Laravel whereExists Using Eloquent Model Example

In this example we will demonstrate the use of whereExists() method in laravel. As per the above database tables If you are an employer and you are looking to hire for some specific position employee. Then you have posted a new job and wants to hire an employees. So you will be notified by sending an email for a new job opportunity for specific designation users.

If you have a large amount of registered users in your job application, now you don’t want to get them all and to make sure that only those job applicants who are Banker will receive the email.

Here you can use laravel whereExist query as following:

$users = User::whereExists(
               function($query) use($job) {  
                 $query->from('users_position')
                       ->where('position_id', $job->position_id);
               })->get();        
return $users;

$users = User::whereExists(

function($query) use($job) {

$query->from('users_position')

->where('position_id', $job->position_id);

})->get();

return $users;

This above query will fetch all users from the users table, and used whereExist clause and use a closure argument to apply condition.

Laravel whereNotExists Using Eloquent Model Example

In this example I’ll demonstrate the use of whereNotExists() method using the above tables as following:

As per the above database schema suppose you want to post a new job and want to hire employees. Now you want to send emails of this new job opening to specific designation users and want to skip other designation users.

Now the problem with this is you have a large amount of users registered in your job portal, now you don’t them all to make sure that only those job applicants who are Not Banker, Designer, etc will receive the email.

Now, here you can use laravel whereNotExist query as following:

$users = User::whereNotExists(
               function($query) use($job) {  
                 $query->from('users_position')
                       ->where('position_id', $job->position_id);
               })->get();        
return $users;

$users = User::whereNotExists(

function($query) use($job) {

$query->from('users_position')

->where('position_id', $job->position_id);

})->get();

return $users;

This above query will fetch all users from the users table, and used whereNotExist clause and use a closure argument.

Laravel 7 Datatables with Relationship Example

In this Laravel dataTables with relationship example tutorial I’ll show you how to display and filter column in yajra dataTables with relationship.

Laravel 7 Datatables with Relationship Example

Let suppose you have two database tables first is posts and the other one is users and you have relationship in each table. Now you want to display and filter posts title and who write these posts (author name). This would require you to use laravel yajra dataTables columns with a relationship.

In this tutorial I’ll demonstrates you to how to use a filter on dataTables columns with relationships.

Download Laravel Fresh App
Setup Database Configuration
Install Yajra DataTable
Create Migration and Modal
Create route
Generate Controller by Command
Create Blade File
Run Development Server

Install Laravel 7/6

First of all we need to create a fresh laravel project, download and install Laravel 7/6 using the below command

composer create-project --prefer-dist laravel/laravel larablog

1	composer create-project --prefer-dist laravel/laravel larablog

Configure Database In .env file

Now, lets create a MySQL database and connect it with laravel application. After creating database we need to set database credential in application’s .env file.

.env

DB_CONNECTION=mysql
DB_HOST=127.0.0.1
DB_PORT=3306
DB_DATABASE=larablog
DB_USERNAME=root
DB_PASSWORD=

DB_CONNECTION=mysql

DB_HOST=127.0.0.1

DB_PORT=3306

DB_DATABASE=larablog

DB_USERNAME=root

DB_PASSWORD=

Run Migration

Now, we need to create migration of tables using following command:

php artisan migrate

1	php artisan migrate

Install Yajra Datatable Package

In this step, we will install Yajra Datatables Package via the composer dependency manager. Use the following command to install Yajra Datatables Package.

composer require yajra/laravel-datatables-oracle

1	composer require yajra/laravel-datatables-oracle

After Installing Yajra Datatables package, we need to add service provider and alias in config/app.php file as following.

config/app.php

'providers' => [
      // Other service providers…
  Yajra\DataTables\DataTablesServiceProvider::class,
 ],

'aliases' => [
 // Other aliases…
 'Datatables' => Yajra\Datatables\Facades\Datatables::class,
 ],

'providers' => [

// Other service providers…

Yajra\DataTables\DataTablesServiceProvider::class,

'aliases' => [

// Other aliases…

'Datatables' => Yajra\Datatables\Facades\Datatables::class,

After set providers and aliases then publish vendor run by the following command.

php artisan vendor:publish

1	php artisan vendor:publish

Now let’s create post table migration and create Post Modal using following artisan command:

php artisan nake:modal Post -m

1	php artisan nake:modal Post -m

This will create migration, open migration file and put the following code in it:

database/migrations/YYY_MM_DD_070104_create_posts_table.php

<?php
use Illuminate\Database\Migrations\Migration;
use Illuminate\Database\Schema\Blueprint;
use Illuminate\Support\Facades\Schema;
class CreatePostsTable extends Migration
{
    /**
     * Run the migrations.
     *
     * @return void
     */
    public function up()
    {
        Schema::create('posts', function (Blueprint $table) {
            $table->id();
            $table->integer('user_id');
            $table->string('title');
            $table->timestamps();
        });
    }
    /**
     * Reverse the migrations.
     *
     * @return void
     */
    public function down()
    {
        Schema::dropIfExists('posts');
    }
}

<?php

use Illuminate\Database\Migrations\Migration;

use Illuminate\Database\Schema\Blueprint;

use Illuminate\Support\Facades\Schema;

class CreatePostsTable extends Migration

{

/**

* Run the migrations.

* @return void

public function up()

{

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

$table->id();

$table->integer('user_id');

$table->string('title');

$table->timestamps();

});

}

/**

* Reverse the migrations.

* @return void

public function down()

{

Schema::dropIfExists('posts');

}

Now run the following command

php artisan migrate

1	php artisan migrate

After you have to put bellow code in your Post model file for create posts table.Now you need to open app/Post.php model and create relationship in this model as following:

app/Post.php

<?php
namespace App;
use Illuminate\Database\Eloquent\Model;
use App\User;
class Post extends Model
{
    protected $fillable = ['title'];
    public function users()
    {
        return $this->belongsTo(User::class,'user_id','id');
    }
}

<?php

namespace App;

use Illuminate\Database\Eloquent\Model;

use App\User;

class Post extends Model

{

protected $fillable = ['title'];

public function users()

{

return $this->belongsTo(User::class,'user_id','id');

}

Create route

Now, open your “routes/web.php” file and add the following route in it:

routes/web.php

Route::get('posts','PostController@index')->name('posts.index');

1	Route::get('posts','PostController@index')->name('posts.index');

Generate Controller by Command

Now, create a new controller PostController using following artisan command:

php artisan make:controller PostController

1	php artisan make:controller PostController

Once the above command executed, it will create a controller file PostController.php in app/Http/Controllers/directory. Open the PostController.php file and put the following code in it.

app/Http/Controllers/PostController.php

<?php
namespace App\Http\Controllers;
use Illuminate\Http\Request;
use App\User;
use App\Post;
use DataTables;
class PostController extends Controller
{
    /**
     * Show the application dashboard.
     *
     * @return \Illuminate\Contracts\Support\Renderable
     */
    public function index(Request $request)
    {
        if ($request->ajax()) {
            $model = Post::with('users');
                return DataTables::eloquent($model)
                ->addColumn('users', function (Post $post) {
                    return $post->users->name;
                })
                ->toJson();
        }
        return view('users');
    }
}

<?php

namespace App\Http\Controllers;

use Illuminate\Http\Request;

use App\User;

use App\Post;

use DataTables;

class PostController extends Controller

{

/**

* Show the application dashboard.

* @return \Illuminate\Contracts\Support\Renderable

public function index(Request $request)

{

if ($request->ajax()) {

$model = Post::with('users');

return DataTables::eloquent($model)

->addColumn('users', function (Post $post) {

return $post->users->name;

})

->toJson();

}

return view('users');

}

Create Blade File

In this step, we will create view/blade file. Lets create a blade file “users.blade.php” in “resources/views/” directory and put the following code in it respectively.

resources/views/users.blade.php

<!DOCTYPE html>
<html>
<head>
<title>Laravel Datatables with Relationship Tutorial</title>
<link rel="stylesheet" href="https://cdnjs.cloudflare.com/ajax/libs/twitter-bootstrap/4.1.3/css/bootstrap.min.css" />
<link href="https://cdn.datatables.net/1.10.16/css/jquery.dataTables.min.css" rel="stylesheet">
<link href="https://cdn.datatables.net/1.10.19/css/dataTables.bootstrap4.min.css" rel="stylesheet">
<script src="https://ajax.googleapis.com/ajax/libs/jquery/1.9.1/jquery.js"></script>  
<script src="https://cdnjs.cloudflare.com/ajax/libs/jquery-validate/1.19.0/jquery.validate.js"></script>
<script src="https://cdn.datatables.net/1.10.16/js/jquery.dataTables.min.js"></script>
<script src="https://stackpath.bootstrapcdn.com/bootstrap/4.1.3/js/bootstrap.min.js"></script>
<script src="https://cdn.datatables.net/1.10.19/js/dataTables.bootstrap4.min.js"></script>
<style type="text/css">
.paginate_button{
padding: 0px !important;
}
</style>
</head>
<body>
<div class="container" style="margin-top: 100px;margin-bottom: 100px; ">
<div class="row justify-content-center">
<div class="col-md-8">
<div class="card">
<div class="card-header bg-info text-white">Laravel Datatables with Relationship Tutorial</div>
<div class="card-body">
@if (session('status'))
<div class="alert alert-success" role="alert">
{{ session('status') }}
</div>
@endif
<table class="table table-bordered data-table">
<thead>
<tr>
<th>No</th>
<th>Title</th>
<th>Auther</th>
</tr>
</thead>
<tbody>
</tbody>
</table>
</div>
</div>
</div>
</div>
</div>
<script type="text/javascript">
$(document).ready(function() {
$('.data-table').DataTable({
processing: true,
serverSide: true,
ajax: "{{ route('posts.index') }}",
columns: [
{data: 'id', name: 'id'},
{data: 'title', name: 'title'},
{data: 'users', name: 'users.name'},
]
});
});
</script>
</body>
</html>

<!DOCTYPE html>

<html>

<head>

<title>Laravel Datatables with Relationship Tutorial</title>

.paginate_button{

padding: 0px !important;

}

</style>

</head>

<body>

<div class="card-header bg-info text-white">Laravel Datatables with Relationship Tutorial</div>

@if (session('status'))

</div>

@endif

<thead>

<tr>

<th>Title</th>

<th>Auther</th>

</tr>

</thead>

<tbody>

</tbody>

</table>

</div>

$(document).ready(function() {

$('.data-table').DataTable({

processing: true,

serverSide: true,

ajax: "{{ route('posts.index') }}",

columns: [

{data: 'id', name: 'id'},

{data: 'title', name: 'title'},

{data: 'users', name: 'users.name'},

]

});

</script>

</body>

</html>

Start Development Server

Let’s start the development server using following artisan command:

php artisan serve

1	php artisan serve

Now, visit the following link in browser to see the output:

http://localhost:8000/posts

1	http://localhost:8000/posts

Laravel Eloquent whereTime Query Example

In this Laravel Eloquent whereTime Query Example tutorial I’ll show you how to use eloquent method with laravel query builder and model.

Laravel Eloquent whereTime Query Example

While working with laravel database you want query records of specific time only. In this case laravel whereTime() method is very helpful to query records with specific time. In this tutorial we will demonstrate the various example of laravel whereTime method:

Laravel whereTime method with query builder

In this example we will be using whereTime method with laravel query builder as following:

$users = DB::table('users')
             ->whereTime('created_at', '=', '09:50:11')
             ->get();
dd($users);

$users = DB::table('users')

->whereTime('created_at', '=', '09:50:11')

->get();

dd($users);

Laravel whereTime method with eloquent model

In this example we will be using laravel whereTime method with eloquent model as following:

$users = User::whereTime('created_at', '=', '09:50:11')
             ->get();
dd($users);

$users = User::whereTime('created_at', '=', '09:50:11')

->get();

dd($users);

you can also write this whereTime query without operator as follow:

$users = User::whereTime('created_at1', '09:50:11')->get();
dd($users);

1 2	$users = User::whereTime('created_at1', '09:50:11')->get(); dd($users);

Laravel Chunk Eloquent Method Example

In this laravel eloquent chunk method example tutorial, I’ll show you how to use laravel chunk method with large records in laravel. You will also learn How to insert big data on the laravel by using chunk.

Laravel Eloquent Chunk() Method

In Laravel, eloquent chunk method is used to break the large amount of data set into smaller group of sub data set also called as chunks.

Suppose, you are working with a large amount of dataset in application database. This makes working with large amount of dataset in one go more difficult that time laravel chunk method will help you break a larger group of data set into a smaller groups of data set (chunks).

In this method we will demonstrate the use of laravel eloquent chunk method with different examples:

Use laravel chunk with Eloquent Model

$users = User::all(); // Fetch some data

1	$users = User::all(); // Fetch some data

View:

@foreach($users->chunk(3) as $row)
    <div class="grid__row">
        @foreach($row as $user)
            <div class="grid__item">
                {{ $user->name}}
            </div>
        @endforeach
    </div>
@endforeach

@foreach($users->chunk(3) as $row)

@foreach($row as $user)

</div>

@endforeach

</div>

@endforeach

This method work with all types of laravel collections, see the following example:

$colors = collect(['orange', 'blue', 'green', 'red', 'yellow', 'purple']);
$chunks = $colors->chunk(3);
 
print_r($chunks);
 
/*
Output:
 
Array
(
    [0] => Array
        (
            [0] => orange
            [1] => blue
            [2] => green
        )
 
    [1] => Array
        (
            [3] => red
            [4] => yellow
            [5] => purple
        )
 
)
*/

$colors = collect(['orange', 'blue', 'green', 'red', 'yellow', 'purple']);

$chunks = $colors->chunk(3);

print_r($chunks);

Output:

Array

(

[0] => Array

(

[0] => orange

[1] => blue

[2] => green

)

[1] => Array

(

[3] => red

[4] => yellow

[5] => purple

)

Send Email with Laravel chunk

Let suppose you have big list of users to send emails and you have to send an email to all users. Sometimes it becomes problem that you cannot send email on 10000 emails in one go. In this case you can use Chunk method of Laravel to break large amount of user list into small sub set of users so you can easily send mail to everyone. See the following example:

User::orderBy('id')->chunk(100, function ($users) {
    foreach ($users as $user) {
 
        // write your email send code here
    }
});

User::orderBy('id')->chunk(100, function ($users) {

foreach ($users as $user) {

// write your email send code here

}

});

Insert big data on the laravel

If you want to insert large amount of data on laravel databse then you can do this with the help of laravel chunk as follow:

$items = collect($items);

1	$items = collect($items);

Make chunk of your choice

$chunks = $items->chunk(100);

1	$chunks = $items->chunk(100);

Then use foreach loop to insert by 100 each time

foreach($chunks as $chunk){
    DB::table('items')->insert($chunk->toArray());
}

foreach($chunks as $chunk){

DB::table('items')->insert($chunk->toArray());

}

Laravel Group by Example Tutorial

In this Laravel group by example tutorial I’ll show you how to use group by in laravel qloquent query. In this tutorial you will learn how to use laravel group with raw, laravel group by multiple, laravel group by date, laravel group by sum, laravel group by month and laravel collection group by count.

Laravel Group by Example Tutorial

In this tutorial I will guide you through different use case of the laravel group by eloquent query.

1: Laravel GroupBy with Collection Example
2: Laravel Collection Group By Preserve Key
3: Laravel Collection Group By with Multiple Columns
4: Laravel Collection Group By with Date
5: Laravel Collection Group By with Count
6: Laravel Collection Group By with Sum

Laravel GroupBy with Collection Example

In this example we will use laravel groupBy with collection.

public function index()
 
{
 
    $collection = collect([
 
            'first' => ['id'=>1, 'name'=>'Rahul', 'city' => 'Mumbai', 'country' => 'India'],
 
            'second' => ['id'=>2, 'name'=>'Sumit', 'city' => 'New York', 'country' => 'US'],
 
            'third' => ['id'=>3, 'name'=>'Ronak', 'city' => 'Gujarat', 'country' => 'India'],
 
            'fourth' => ['id'=>4, 'name'=>'Harish', 'city' => 'New York', 'country' => 'US'],
 
        ]);
 
   
 
    $grouped = $collection->groupBy('country');
 
       
 
    dd($grouped);
 
}

public function index()

{

$collection = collect([

'first' => ['id'=>1, 'name'=>'Rahul', 'city' => 'Mumbai', 'country' => 'India'],

'second' => ['id'=>2, 'name'=>'Sumit', 'city' => 'New York', 'country' => 'US'],

'third' => ['id'=>3, 'name'=>'Ronak', 'city' => 'Gujarat', 'country' => 'India'],

'fourth' => ['id'=>4, 'name'=>'Harish', 'city' => 'New York', 'country' => 'US'],

]);

$grouped = $collection->groupBy('country');

dd($grouped);

}

Result:

Illuminate\Support\Collection Object
 
(
 
    [items:protected] => Array
 
        (
 
            [India] => Illuminate\Support\Collection Object
 
                (
 
                    [items:protected] => Array
 
                        (
 
                            [0] => Array
 
                                (
 
                                    [id] => 1
 
                                    [name] => Rahul
 
                                    [city] => Mumbai
 
                                    [country] => India
 
                                )
 
                            [1] => Array
 
                                (
 
                                    [id] => 3
 
                                    [name] => Sumit
 
                                    [city] => Gujarat
 
                                    [country] => India
 
                                )
 
                        )
 
                )
 
            [US] => Illuminate\Support\Collection Object
 
                (
 
                    [items:protected] => Array
 
                        (
 
                            [0] => Array
 
                                (
 
                                    [id] => 2
 
                                    [name] => Ronak
 
                                    [city] => New York
 
                                    [country] => US
 
                                )
 
                            [1] => Array
 
                                (
 
                                    [id] => 4
 
                                    [name] => Harish
 
                                    [city] => New York
 
                                    [country] => US
 
                                )
 
                        )
 
                )
 
        )
 
)

Illuminate\Support\Collection Object

(

[items:protected] => Array

(

[India] => Illuminate\Support\Collection Object

(

[items:protected] => Array

(

[0] => Array

(

[id] => 1

[name] => Rahul

[city] => Mumbai

[country] => India

)

[1] => Array

(

[id] => 3

[name] => Sumit

[city] => Gujarat

[country] => India

)

[US] => Illuminate\Support\Collection Object

(

[items:protected] => Array

(

[0] => Array

(

[id] => 2

[name] => Ronak

[city] => New York

[country] => US

)

[1] => Array

(

[id] => 4

[name] => Harish

[city] => New York

[country] => US

)

Laravel Collection Group By Preserve Key

In this example use same example as above but we will pass preserve key as true.

$collection-&gt;groupBy('Key_Name', $preserve_key);

1	$collection->groupBy('Key_Name', $preserve_key);

public function index()
 
{
 
    $collection = collect([
 
            'first' => ['id'=>1, 'name'=>'Rahul', 'city' => 'Mumbai', 'country' => 'India'],
 
            'second' => ['id'=>2, 'name'=>'Sumit', 'city' => 'New York', 'country' => 'US'],
 
            'third' => ['id'=>3, 'name'=>'Ronak', 'city' => 'Gujarat', 'country' => 'India'],
 
            'fourth' => ['id'=>4, 'name'=>'Harish', 'city' => 'New York', 'country' => 'US'],
 
        ]);
 
   
 
    $grouped = $collection->groupBy('country', True);
 
       
 
    dd($grouped);
 
}

public function index()

{

$collection = collect([

'first' => ['id'=>1, 'name'=>'Rahul', 'city' => 'Mumbai', 'country' => 'India'],

'second' => ['id'=>2, 'name'=>'Sumit', 'city' => 'New York', 'country' => 'US'],

'third' => ['id'=>3, 'name'=>'Ronak', 'city' => 'Gujarat', 'country' => 'India'],

'fourth' => ['id'=>4, 'name'=>'Harish', 'city' => 'New York', 'country' => 'US'],

]);

$grouped = $collection->groupBy('country', True);

dd($grouped);

}

Result:

Illuminate\Support\Collection Object
 
(
 
    [items:protected] => Array
 
        (
 
            [India] => Illuminate\Support\Collection Object
 
                (
 
                    [items:protected] => Array
 
                        (
 
                            [first] => Array
 
                                (
 
                                    [id] => 1
 
                                    [name] => Rahul
 
                                    [city] => Mumbai
 
                                    [country] => India
 
                                )
 
                            [third] => Array
 
                                (
 
                                    [id] => 3
 
                                    [name] => Ronak
 
                                    [city] => Gujarat
 
                                    [country] => India
 
                                )
 
                        )
 
                )
 
            [US] => Illuminate\Support\Collection Object
 
                (
 
                    [items:protected] => Array
 
                        (
 
                            [second] => Array
 
                                (
 
                                    [id] => 2
 
                                    [name] => Sumit
 
                                    [city] => New York
 
                                    [country] => US
 
                                )
 
                            [fourth] => Array
 
                                (
 
                                    [id] => 4
 
                                    [name] => Harish
 
                                    [city] => New York
 
                                    [country] => US
 
                                )
 
                        )
 
                )
 
        )
 
)

Illuminate\Support\Collection Object

(

[items:protected] => Array

(

[India] => Illuminate\Support\Collection Object

(

[items:protected] => Array

(

[first] => Array

(

[id] => 1

[name] => Rahul

[city] => Mumbai

[country] => India

)

[third] => Array

(

[id] => 3

[name] => Ronak

[city] => Gujarat

[country] => India

)

[US] => Illuminate\Support\Collection Object

(

[items:protected] => Array

(

[second] => Array

(

[id] => 2

[name] => Sumit

[city] => New York

[country] => US

)

[fourth] => Array

(

[id] => 4

[name] => Harish

[city] => New York

[country] => US

)

Laravel Collection Group By with Multiple Columns

In this example we will use laravel groupBy with multiple columns.

public function index()
 
{
 
    $collection = collect([
 
            'first' => ['id'=>1, 'name'=>'Rahul', 'city' => 'Mumbai', 'country' => 'India'],
 
            'second' => ['id'=>2, 'name'=>'Sumit', 'city' => 'New York', 'country' => 'US'],
 
            'third' => ['id'=>3, 'name'=>'Ronak', 'city' => 'Gujarat', 'country' => 'India'],
 
            'fourth' => ['id'=>4, 'name'=>'Harish', 'city' => 'New York', 'country' => 'US'],
 
        ]);
 
   
 
        $grouped = $collection->groupBy(function ($item, $key) {
 
                    return $item['country'].$item['city'];
 
                });
 
       
 
    dd($grouped);
 
}

public function index()

{

$collection = collect([

'first' => ['id'=>1, 'name'=>'Rahul', 'city' => 'Mumbai', 'country' => 'India'],

'second' => ['id'=>2, 'name'=>'Sumit', 'city' => 'New York', 'country' => 'US'],

'third' => ['id'=>3, 'name'=>'Ronak', 'city' => 'Gujarat', 'country' => 'India'],

'fourth' => ['id'=>4, 'name'=>'Harish', 'city' => 'New York', 'country' => 'US'],

]);

$grouped = $collection->groupBy(function ($item, $key) {

return $item['country'].$item['city'];

});

dd($grouped);

}

Result:

Illuminate\Support\Collection Object
 
(
 
    [items:protected] => Array
 
        (
 
            [IndiaMumbai] => Illuminate\Support\Collection Object
 
                (
 
                    [items:protected] => Array
 
                        (
 
                            [0] => Array
 
                                (
 
                                    [id] => 1
 
                                    [name] => Rahul
 
                                    [city] => Mumbai
 
                                    [country] => India
 
                                )
 
                        )
 
                )
 
            [USNew York] => Illuminate\Support\Collection Object
 
                (
 
                    [items:protected] => Array
 
                        (
 
                            [0] => Array
 
                                (
 
                                    [id] => 2
 
                                    [name] => Sumit
 
                                    [city] => New York
 
                                    [country] => US
 
                                )
 
                            [1] => Array
 
                                (
 
                                    [id] => 4
 
                                    [name] => Harish
 
                                    [city] => New York
 
                                    [country] => US
 
                                )
 
                        )
 
                )
 
            [IndiaGujarat] => Illuminate\Support\Collection Object
 
                (
 
                    [items:protected] => Array
 
                        (
 
                            [0] => Array
 
                                (
 
                                    [id] => 3
 
                                    [name] => Ronak
 
                                    [city] => Gujarat
 
                                    [country] => India
 
                                )
 
                        )
 
                )
 
        )
 
)

100

101

102

103

Illuminate\Support\Collection Object

(

[items:protected] => Array

(

[IndiaMumbai] => Illuminate\Support\Collection Object

(

[items:protected] => Array

(

[0] => Array

(

[id] => 1

[name] => Rahul

[city] => Mumbai

[country] => India

)

[USNew York] => Illuminate\Support\Collection Object

(

[items:protected] => Array

(

[0] => Array

(

[id] => 2

[name] => Sumit

[city] => New York

[country] => US

)

[1] => Array

(

[id] => 4

[name] => Harish

[city] => New York

[country] => US

)

[IndiaGujarat] => Illuminate\Support\Collection Object

(

[items:protected] => Array

(

[0] => Array

(

[id] => 3

[name] => Ronak

[city] => Gujarat

[country] => India

)

Laravel Collection Group By with Date

In this example we will use laravel groupBy with date column.

public function index()
 
{
 
    $collection = collect([
 
            ['id'=>1, 'name'=>'Rahul', 'created_at' => '2020-05-15 15:15:00'],
 
            ['id'=>2, 'name'=>'Sumit', 'created_at' => '2020-05-15 15:16:00'],
 
            ['id'=>3, 'name'=>'Ronak', 'created_at' => '2020-05-18 15:18:00'],
 
            ['id'=>4, 'name'=>'Harish', 'created_at' => '2020-05-19 15:10:00'],
 
        ]);
 
   
 
    $grouped = $collection->groupBy(function($item, $key) {
 
                    return \Carbon\Carbon::createFromFormat('Y-m-d H:i:s', $item['created_at'])->format('m/d/Y');
 
                });
 
     
 
    dd($grouped);
 
}

public function index()

{

$collection = collect([

['id'=>1, 'name'=>'Rahul', 'created_at' => '2020-05-15 15:15:00'],

['id'=>2, 'name'=>'Sumit', 'created_at' => '2020-05-15 15:16:00'],

['id'=>3, 'name'=>'Ronak', 'created_at' => '2020-05-18 15:18:00'],

['id'=>4, 'name'=>'Harish', 'created_at' => '2020-05-19 15:10:00'],

]);

$grouped = $collection->groupBy(function($item, $key) {

return \Carbon\Carbon::createFromFormat('Y-m-d H:i:s', $item['created_at'])->format('m/d/Y');

});

dd($grouped);

}

Result:

Illuminate\Support\Collection Object
 
(
 
    [items:protected] => Array
 
        (
 
            [05/15/2020] => Illuminate\Support\Collection Object
 
                (
 
                    [items:protected] => Array
 
                        (
 
                            [0] => Array
 
                                (
 
                                    [id] => 1
 
                                    [name] => Rahul
 
                                    [created_at] => 2020-05-15 15:15:00
 
                                )
 
                            [1] => Array
 
                                (
 
                                    [id] => 2
 
                                    [name] => Sumit
 
                                    [created_at] => 2020-05-15 15:16:00
 
                                )
 
                        )
 
                )
 
            [05/18/2020] => Illuminate\Support\Collection Object
 
                (
 
                    [items:protected] => Array
 
                        (
 
                            [0] => Array
 
                                (
 
                                    [id] => 3
 
                                    [name] => Ronak
 
                                    [created_at] => 2020-05-18 15:18:00
 
                                )
 
                        )
 
                )
 
            [05/19/2020] => Illuminate\Support\Collection Object
 
                (
 
                    [items:protected] => Array
 
                        (
 
                            [0] => Array
 
                                (
 
                                    [id] => 4
 
                                    [name] => Harish
 
                                    [created_at] => 2020-05-19 15:10:00
 
                                )
 
                        )
 
                )
 
        )
 
)

Illuminate\Support\Collection Object

(

[items:protected] => Array

(

[05/15/2020] => Illuminate\Support\Collection Object

(

[items:protected] => Array

(

[0] => Array

(

[id] => 1

[name] => Rahul

[created_at] => 2020-05-15 15:15:00

)

[1] => Array

(

[id] => 2

[name] => Sumit

[created_at] => 2020-05-15 15:16:00

)

[05/18/2020] => Illuminate\Support\Collection Object

(

[items:protected] => Array

(

[0] => Array

(

[id] => 3

[name] => Ronak

[created_at] => 2020-05-18 15:18:00

)

[05/19/2020] => Illuminate\Support\Collection Object

(

[items:protected] => Array

(

[0] => Array

(

[id] => 4

[name] => Harish

[created_at] => 2020-05-19 15:10:00

)

Laravel Collection Group By with Count

In this example we will use laravel groupBy with count method.

public function index()
 
{
 
    $collection = collect([
 
            ['id'=>1, 'name'=>'Rahul', 'created_at' => '2020-05-15 15:15:00'],
 
            ['id'=>2, 'name'=>'Sumit', 'created_at' => '2020-05-15 15:16:00'],
 
            ['id'=>3, 'name'=>'Ronak', 'created_at' => '2020-05-18 15:18:00'],
 
            ['id'=>4, 'name'=>'Harish', 'created_at' => '2020-05-19 15:10:00'],
 
        ]);
 
   
 
    $grouped = $collection->groupBy('country')->map(function ($row) {
 
                    return $row->count();
 
                });
 
     
 
    dd($grouped);
 
}

public function index()

{

$collection = collect([

['id'=>1, 'name'=>'Rahul', 'created_at' => '2020-05-15 15:15:00'],

['id'=>2, 'name'=>'Sumit', 'created_at' => '2020-05-15 15:16:00'],

['id'=>3, 'name'=>'Ronak', 'created_at' => '2020-05-18 15:18:00'],

['id'=>4, 'name'=>'Harish', 'created_at' => '2020-05-19 15:10:00'],

]);

$grouped = $collection->groupBy('country')->map(function ($row) {

return $row->count();

});

dd($grouped);

}

Result:

Illuminate\Support\Collection Object
 
(
 
    [items:protected] => Array
 
        (
 
            [India] => 2
 
            [US] => 2
 
        )
 
)

Illuminate\Support\Collection Object

(

[items:protected] => Array

(

[India] => 2

[US] => 2

)

Laravel Collection Group By with Sum

In this example we will use laravel groupBy with sum method.

public function index()
 
{
 
    $collection = collect([
 
            ['id'=>1, 'name'=>'Rahul', 'created_at' => '2020-05-15 15:15:00'],
 
            ['id'=>2, 'name'=>'Sumit', 'created_at' => '2020-05-15 15:16:00'],
 
            ['id'=>3, 'name'=>'Ronak', 'created_at' => '2020-05-18 15:18:00'],
 
            ['id'=>4, 'name'=>'Harish', 'created_at' => '2020-05-19 15:10:00'],
 
        ]);
 
   
 
    $grouped = $collection->groupBy('country')->map(function ($row) {
 
                    return $row->sum('amount');
 
                });
 
     
 
    dd($grouped);
 
}

public function index()

{

$collection = collect([

['id'=>1, 'name'=>'Rahul', 'created_at' => '2020-05-15 15:15:00'],

['id'=>2, 'name'=>'Sumit', 'created_at' => '2020-05-15 15:16:00'],

['id'=>3, 'name'=>'Ronak', 'created_at' => '2020-05-18 15:18:00'],

['id'=>4, 'name'=>'Harish', 'created_at' => '2020-05-19 15:10:00'],

]);

$grouped = $collection->groupBy('country')->map(function ($row) {

return $row->sum('amount');

});

dd($grouped);

}

Result:

Illuminate\Support\Collection Object
 
(
 
    [items:protected] => Array
 
        (
 
            [India] => 5000
 
            [US] => 3000
 
        )
 
)

Illuminate\Support\Collection Object

(

[items:protected] => Array

(

[India] => 5000

[US] => 3000

)

Type of Laravel Eloquent Relationships

Laravel One to One Relationship Example

Laravel Eloquent One to One Relationship Example

Inverse of One to One Relationship Example

Laravel One to Many Relationship Example

Laravel Eloquent One to Many Relationship Example

Define One To Many Relationship

Defining Inverse One To Many Relationship in Laravel

Retrieving Data In One to many relationship

Laravel Many to Many Relationship Example

Laravel Eloquent Many to Many Relationship Example

The inverse of Many to Many Relationship Example

Laravel Eloquent HasMany Through Relationship Example

Laravel One to One Relationship Example

Laravel Eloquent One to One Relationship Example

Inverse of One to One Relationship Example

Laravel Insert record in one to one relationship

Laravel Delete record in One to One relationship

Laravel One to Many Relationship Example

Laravel Eloquent One to Many Relationship Example

Define One To Many Relationship

Defining Inverse One To Many Relationship in Laravel

Retrieving Data In One to many relationship

Inserting Data In One to Many relationship

Filtering Data In one to many relationship

Deleting Data In One to Many relationship

Laravel Many to Many Relationship Example

Laravel Eloquent Many to Many Relationship Example

The inverse of Many to Many Relationship Example

Laravel Eloquent HasMany Through Relationship Example

Laravel One to Many Polymorphic Relationship Example

Create Migration File

Create one to many polymorphic relationships in model

Retrieve, create a record using polymorphic relationship

Laravel Many to Many Polymorphic Relationship Example

Create Migration File

Create many to many polymorphic relationships in model

Insert and retrieve a record using many to many polymorphic relationship

Retrieve Records From table

Insert Records in Table

Laravel whereExists and whereNotExists Query Example

positions table

users table

users_position table (a pivot table for user and position)

jobs table

Laravel whereExists Using Eloquent Model Example

Laravel whereNotExists Using Eloquent Model Example

Laravel 7 Datatables with Relationship Example

Install Laravel 7/6

Configure Database In .env file

Run Migration

Install Yajra Datatable Package

Create Migration and Modal

Create route

Generate Controller by Command

Create Blade File

Start Development Server

Laravel Eloquent whereTime Query Example

Laravel whereTime method with query builder

Laravel whereTime method with eloquent model

Laravel Eloquent Chunk() Method

Use laravel chunk with Eloquent Model

Send Email with Laravel chunk

Insert big data on the laravel

Laravel Group by Example Tutorial

Laravel GroupBy with Collection Example

Result:

Laravel Collection Group By Preserve Key

Result:

Laravel Collection Group By with Multiple Columns

Result:

Laravel Collection Group By with Date

Result:

Laravel Collection Group By with Count

Result:

Laravel Collection Group By with Sum

Result:

`positions` table

`users` table

`users_position` table (a pivot table for user and position)

`jobs` table