Laravel Eloquent insertOrIgnore Example - Yudhy Network

Share on:

Yudhy Network - Laravel insertOrIgnore() eloquent query with example. Here you will learn how to use insertOrIgnore() query with eloquent and model in laravel app.

Laravel insertOrIgnore() eloquent method example, you will learn how to use insertorignore query in laravel application.

Whenever you want to insert records in bulk in database table. But you want the records that already exist in the database table. Don’t have a duplicate entry. So you can use insertOrIgnore() eloquent query in laravel apps.

So this post will guide how to use insertOrIgnore query in laravel. Because this is used to insert records but ignore duplicate records while inserting records into DB table in laravel application.

Laravel insertOrIgnore Eloquent Example

Here, you will learn how to use insertOrIgnore() Eloquent method with queries in laravel. You can see the following examples of insertOrIgnore() eloquent method:

Example 1: Laravel InsertOrIgnore With Eloquent

/**
* The attributes that are mass assignable.
*
* @var array
*/
public function index()
{
   $array = [
		      ['name' => 'taylor', 'email' => '[email protected]'],
		      ['name' => 'dayle', 'email' => '[email protected]'],
            ];

    DB::table('users')->insertOrIgnore($array);
}         
Recommended:- Laravel whereBetween Eloquent Query

Note that, Laravel insertOrIgnore method will ignore duplicate record errors while inserting records into the database.

Example 2: Laravel InsertOrIgnore Query With Eloquent Model

/**
* The attributes that are mass assignable.
*
* @var array
*/
public function index()
{
   $array = [
		      ['name' => 'taylor', 'email' => '[email protected]'],
		      ['name' => 'dayle', 'email' => '[email protected]'],
            ];

    User::insertOrIgnore($array);
}         
Recommended:- Laravel whereExists and whereNotExists Query Example

Conclusion

In this laravel insertOrIgnore() eloquent method with example, you have learned how to use insertOrIgnore query with eloquent and model in laravel. And insertOrIgnore method will ignore duplicate record errors while inserting records into the database table in laravel apps.

Please ask in the comments!

Suport : Cotekno.Com

comments powered by Disqus