Category Archives: Laravel

Laravel Tutorials

How to Create Notification in Laravel 8

In this How to Create Notification in Laravel 8 tutorial I will show you how to send notification in laravel 8 application. In this tutorial you will learn to send notification using laravel notification system. Laravel notification system is used to notify users in laravel application. Using laravel notification you can send email, send sms and send slack message notification to user. In this article I will share example to in this example to create notification to send mail in laravel. In laravel you can easily generate a notifications table, bind some information, and send the notification laravel 8. It is easy to generate a notifications table in laravel using artisan command.

How to Create Notification in Laravel 8

In this step by step tutorial I will demonstrate you with example how to create and send notification in laravel using laravel notification system. Please follow the instruction given below:

Install Laravel Project
Set Up Database Connection
Produce Notification Table
Create Notification
Define Route
Create Controller
Summary

Install Laravel Project

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

composer create-project laravel/laravel laravel-notification-system --prefer-dist

1	composer create-project laravel/laravel laravel-notification-system --prefer-dist

Switch into the project directory using following command.

Laravel 8 Multiple Authentication

In this Laravel 8 Multiple Authentication Tutorial I’ll show you how to create multiple authentication system in laravel 8. In this tutorial you will learn to create or implement multiple authentication in laravel. In this article we will be creating multiple authentication system using custom middleware in laravel 8. Multiple authentication system means to allow multiple users to login in one application according to their roles. In this example we will create a middleware for checking the user’s role whether it is an admin or normal user.

Laravel 8 Multiple Authentication

In this step by step Laravel 8 Multiple Authentication Example we will learn to implement multi auth system using middleware in laravel 8.

Install Laravel Application
Configure Database Connection
Set Up Model and Run Migration
Generate Auth Scaffolding
Set Up Admin Middleware
Set Up Route
Configure Home Controller
Configure Blade View
Configure Login Controller
Seed Database with User Data
Run & Test The Laravel Multi Auth App
The Bottom Line

Download Laravel Application

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

composer create-project laravel/laravel laravel-multi-auth --prefer-dist

1	composer create-project laravel/laravel laravel-multi-auth --prefer-dist

Now switch inside the project directory using following command.

How to Integrate Paypal Payment Gateway in Laravel 8

In this How to Integrate Paypal Payment Gateway in Laravel 8 tutorial I will show you how to integrate paypal payment gateway in laravel 8 application. In this tutorial you will learn to integrate paypal in laravel application. In this article I will share example to integrate paypal payment gateway in laravel application. We will be using srmklive laravel paypal package for paypal payment gateway integration in laravel 8.

Paypal Payment Gateway

Paypal is one of the most popular payment gateway, that allows us to accept payment from customer. paypal is very simple, hassle free and easy to integrate payment gateway. Integrating paypal payment gateway in laravel is a breeze.

How to Integrate Paypal Payment Gateway in Laravel 8

In this tutorial, you will learn to integrate paypal payment gateway in your laravel project. Follow this step by step tutorial to learn paypal payment gateway integration in laravel.

Install New Laravel Project
Database Settings
Install Essential Composer Package
Inject PayPal Details
Define Imperative Routes
The Controller Archetype
Configure Blade View

Install New Laravel Project

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

composer create-project laravel/laravel laravel-paypal-app --prefer-dist

1	composer create-project laravel/laravel laravel-paypal-app --prefer-dist

Database Settings

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.

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

DB_CONNECTION=mysql

DB_HOST=127.0.0.1

DB_PORT=3306

DB_DATABASE=laravel

DB_USERNAME=root

DB_PASSWORD=

Laravel 8 Traits Example Create Use Trait in Laravel

In this Laravel 8 Traits Example Create Use Trait in Laravel tutorial I will show you how to create and use reusable traits in laravel 8 application. In this tutorial you will learn to create and use traits in laravel. In this article I will share example to create and use traits in laravel application.

What Is Laravel Traits?

In this article we are going to learn about Laravel 8 Traits. Traits is a independent reusable class that is that allows you to implement single inheritance in order to reuse it. With traits we can create a reusable piece of code and inject it in controller and modal in a Laravel application.

Laravel 8 Traits Example: Create & Use Trait in Laravel

In this step by step tutorial I will demonstrate you with example to create and use traits in laravel 8. Please follow the instruction given below:

Traits in Laravel Example
Install New Laravel Application
Configure Database Connection
Model and Migrations
Insert Fake Data
Create a Trait
Using Traits in Laravel

Laravel Traits Example

In this example we will be creating and use a reusable traits.

Install New Laravel Application

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

composer create-project laravel/laravel laravel-traits-example --prefer-dist

1	composer create-project laravel/laravel laravel-traits-example --prefer-dist

Configure Database Connection

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.

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

DB_CONNECTION=mysql

DB_HOST=127.0.0.1

DB_PORT=3306

DB_DATABASE=laravel

DB_USERNAME=root

DB_PASSWORD=

Model and Migrations

Now, in this step we will create model and migration file. Please run the following command:

php artisan make:model Student -m

1	php artisan make:model Student -m

Open database/migrations/timestamp_students_table.php file and incorporate the following code.

<?php

use Illuminate\Database\Migrations\Migration;
use Illuminate\Database\Schema\Blueprint;
use Illuminate\Support\Facades\Schema;

class CreateStudentsTable extends Migration
{
    /**
     * Run the migrations.
     *
     * @return void
     */
    public function up()
    {
        Schema::create('students', function (Blueprint $table) {
            $table->id();
            $table->string('name');
            $table->string('email')->unique();
            $table->timestamps();
        });
    }

    /**
     * Reverse the migrations.
     *
     * @return void
     */
    public function down()
    {
        Schema::dropIfExists('students');
    }
}

<?php

use Illuminate\Database\Migrations\Migration;

use Illuminate\Database\Schema\Blueprint;

use Illuminate\Support\Facades\Schema;

class CreateStudentsTable extends Migration

{

/**

* Run the migrations.

* @return void

public function up()

{

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

$table->id();

$table->string('name');

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

$table->timestamps();

});

}

/**

* Reverse the migrations.

* @return void

public function down()

{

Schema::dropIfExists('students');

}

Next, go to app/Models/Student.php file and add the $fillable property in the Student model as following.

<?php

namespace App\Models;

use Illuminate\Database\Eloquent\Factories\HasFactory;
use Illuminate\Database\Eloquent\Model;

class Student extends Model
{
    use HasFactory;
    public $fillable = [
        'name',
        'email',
    ];
}

<?php

namespace App\Models;

use Illuminate\Database\Eloquent\Factories\HasFactory;

use Illuminate\Database\Eloquent\Model;

class Student extends Model

{

use HasFactory;

public $fillable = [

'name',

'email',

];

}

Now, run the migration to create database table using following artisan command:

Laravel 8 REST API with Passport Authentication Tutorial

In this Laravel 8 REST API with Passport Authentication Tutorial I will show you how to create REST API with passport authentication In laravel. In this tutorial you will learn to create rest api for crud operation with passport authentication In laravel 8 application. In this article I will share example to create rest api with passport authentication in laravel. I will also show you how to install passport auth package in laravel. After installing and configure passport authentication in laravel we will create simple crud operation rest api. In this article we will be creating a post management crud operation rest api with passport authentication in laravel.

Laravel 8 REST API with Passport Authentication Tutorial

In this step by step tutorial I will guide you through create a fully functional restful API with passport authentication in Laravel 8. We will be creating fully functional REST API along with passport Authentication. Please follow the instruction given below:

Install New Laravel Project
Set Up Database
Install Passport Package
Configure Passport Module
Create Post Model & Run Migration
Create a New Controller
Define API Routes
Test Laravel Passport API

Install New Laravel Project

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

composer create-project laravel/laravel laravel-passport-auth --prefer-dist

1	composer create-project laravel/laravel laravel-passport-auth --prefer-dist

Set Up Database

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.

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

DB_CONNECTION=mysql

DB_HOST=127.0.0.1

DB_PORT=3306

DB_DATABASE=laravel

DB_USERNAME=root

DB_PASSWORD=

Install Passport Package

In this step, we need to install Laravel Passport package via the composer dependency manager. Use the following command to install passport package.

composer require laravel/passport

1	composer require laravel/passport

Now, run following command to migrate database schema.

php artisan migrate

1	php artisan migrate

Now, it is mandatory to install passport using the command below. This command will generate encryption keys required to generate secret access tokens.

php artisan passport:install

1	php artisan passport:install

Configure Passport Module

Open App/User.php model file and add ‘Laravel\Passport\HasApiTokens’ trait in it.

<?php

namespace App\Models;

use Illuminate\Contracts\Auth\MustVerifyEmail;
use Illuminate\Database\Eloquent\Factories\HasFactory;
use Illuminate\Foundation\Auth\User as Authenticatable;
use Illuminate\Notifications\Notifiable;

use Laravel\Passport\HasApiTokens;

class User extends Authenticatable
{
    use HasFactory, Notifiable, HasApiTokens;

    /**
     * The attributes that are mass assignable.
     *
     * @var array
     */
    protected $fillable = [
        'name',
        'email',
        'password',
    ];

    /**
     * The attributes that should be hidden for arrays.
     *
     * @var array
     */
    protected $hidden = [
        'password',
        'remember_token',
    ];

    /**
     * The attributes that should be cast to native types.
     *
     * @var array
     */
    protected $casts = [
        'email_verified_at' => 'datetime',
    ];
}

<?php

namespace App\Models;

use Illuminate\Contracts\Auth\MustVerifyEmail;

use Illuminate\Database\Eloquent\Factories\HasFactory;

use Illuminate\Foundation\Auth\User as Authenticatable;

use Illuminate\Notifications\Notifiable;

use Laravel\Passport\HasApiTokens;

class User extends Authenticatable

{

use HasFactory, Notifiable, HasApiTokens;

/**

* The attributes that are mass assignable.

* @var array

protected $fillable = [

'name',

'email',

'password',

];

/**

* The attributes that should be hidden for arrays.

* @var array

protected $hidden = [

'password',

'remember_token',

];

/**

* The attributes that should be cast to native types.

* @var array

protected $casts = [

'email_verified_at' => 'datetime',

];

}

Next, open app/Providers/AuthServiceProvider.php file and register the registerPolicies() method inside the boot() function, It will evoke the required routes.

<?php

namespace App\Providers;
use Illuminate\Foundation\Support\Providers\AuthServiceProvider as ServiceProvider;
use Illuminate\Support\Facades\Gate;

use Laravel\Passport\Passport;


class AuthServiceProvider extends ServiceProvider
{
    /**
     * The policy mappings for the application.
     *
     * @var array
     */
    protected $policies = [
        'App\Models\Model' => 'App\Policies\ModelPolicy',
    ];


    /**
     * Register any authentication / authorization services.
     *
     * @return void
     */
    public function boot()
    {
        $this->registerPolicies();
        Passport::routes();
    }
}

<?php

namespace App\Providers;

use Illuminate\Foundation\Support\Providers\AuthServiceProvider as ServiceProvider;

use Illuminate\Support\Facades\Gate;

use Laravel\Passport\Passport;

class AuthServiceProvider extends ServiceProvider

{

/**

* The policy mappings for the application.

* @var array

protected $policies = [

'App\Models\Model' => 'App\Policies\ModelPolicy',

];

/**

* Register any authentication / authorization services.

* @return void

public function boot()

{

$this->registerPolicies();

Passport::routes();

}

'providers' => [
        ...
        ... 
        ...
        Laravel\Passport\PassportServiceProvider::class,

    ],

'providers' => [

...

Laravel\Passport\PassportServiceProvider::class,

Configure driver for the Passport, get inside the config/auth.php file and make the changes as shown below.

<?php
    return [
    ....
    ....
    
        'guards' => [
            'web' => [
                'driver' => 'session',
                'provider' => 'users',
            ],
    
            'api' => [
                'driver' => 'passport',
                'provider' => 'users',
            ],
        ],
    
    ....
    ....
]

<?php

return [

....

'guards' => [

'web' => [

'driver' => 'session',

'provider' => 'users',

'api' => [

'driver' => 'passport',

'provider' => 'users',

....

]

Create Posts Model & Run Migration

Now, in this step we will create model and migration file. Please run the following command:

php artisan make:model Post -m

1	php artisan make:model Post -m

Once above command is executed there will be a migration file created inside database/migrations/ directory, just open timestamp_create_posts_table.php migration file and update the function up() method as following:

<?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->increments('id');
            $table->unsignedBigInteger('user_id');
            $table->text('title');
            $table->longText('description');
            $table->timestamps();

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

    /**
     * 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->increments('id');

$table->unsignedBigInteger('user_id');

$table->text('title');

$table->longText('description');

$table->timestamps();

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

});

}

/**

* Reverse the migrations.

* @return void

public function down()

{

Schema::dropIfExists('posts');

}

Next, go to app/Models/Post.php file and add the $fillable property in the Post model as following.

<?php

namespace App\Models;

use Illuminate\Database\Eloquent\Factories\HasFactory;
use Illuminate\Database\Eloquent\Model;

class Post extends Model
{
    use HasFactory;
    protected $fillable = [
        'title', 'description'
    ];    
}

<?php

namespace App\Models;

use Illuminate\Database\Eloquent\Factories\HasFactory;

use Illuminate\Database\Eloquent\Model;

class Post extends Model

{

use HasFactory;

protected $fillable = [

'title', 'description'

];

}

Now, run the migration to create database table using following artisan command:

Laravel 8 Dynamic Autocomplete Search with Select2 Example

In this Laravel 8 Dynamic Autocomplete Search with Select2 Example tutorial, I will show you how to create dynamic ajax driven autocomplete search with select2 in laravel 8 application. In this tutorial you will learn to create dynamic autocomplete search with select2 in laravel 8. In this article I will share example to create dynamic autocomplete search with select2 in laravel 8. In this example we will be using Select2 jQuery plugin in Laravel 8 with AJAX. The jquery Select2 plugin is used to create dynamic autocomplete input with several options.

Laravel 8 Dynamic Autocomplete Search with Select2 Example

In this step by step tutorial I will demonstrate you how to implement Select2 dynamic autocomplete search in laravel application. Please follow the instruction given below:

Install Laravel Application
Configure Database
Model & Migration
Create Routes
Create Autocomplete Controller
Create View
Test App

Install Laravel Application

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

composer create-project laravel/laravel laravel-autocomplete-search --prefer-dist

1	composer create-project laravel/laravel laravel-autocomplete-search --prefer-dist

Switch into the project directory using following command.

How to Enable CORS in Laravel

In this How to Enable CORS in Laravel tutorial, I will show you how to enable CORS (Cross-Origin Resource Sharing) in Laravel 8 application. In this tutorial you will learn to enable CORS in laravel application. You will also learn to install and configure CORS to get rid of CORS header ‘access-control-allow-origin’ missing problem. When a request is made between two between two different servers or domains because of security concern we usually get No ‘Access-Control-Allow-Origin’ warning. Enabling CORS authenticate the resource sharing between two different domains.

How to Enable CORS in Laravel

In this step by step tutorial I will demonstrate you how to enable CORS (Cross-Origin Resource Sharing) in Laravel 8. Please follow the instruction given below:

Laravel CORS Example
CORS Middleware Nitty-Gritty
Create API in Laravel
Make Http GET Request with AJAX
Malevolent Laravel CORS Error
Installing CORS Package in Laravel
Registering CORS Middleware

Laravel 8 CORS Example

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

composer create-project laravel/laravel laravel-cors-tutorial --prefer-dist

1	composer create-project laravel/laravel laravel-cors-tutorial --prefer-dist

switch into the project directory using following command:

cd laravel-cors-tutorial

1	cd laravel-cors-tutorial

Run the command to start the laravel app.

Laravel 8 WhereNotIn Database Query Examples

In this Laravel 8 WhereNotIn Database Query Examples tutorial I will show you how to use where not in query in laravel. In this tutorial you will learn to use WhereNotIn with laravel query builder and eloquent model. In this article I will share various example to use WhereNotIn query in laravel. In this tutorial you will learn about syntax and use of laravel WhereNotIn method.

Laravel WhereNotIn Database Query

Laravel WhereNotIn method will return the records with not having column values in provided list. Here is the general syntax of the laravel WhereNotIn method:

Syntax:-

whereNotIn(Coulumn_name, Array);

1	whereNotIn(Coulumn_name, Array);

In wherenotin() you need to pass two argument one is column name and another if array of ids or anything that you want.

How to Use WhereIn Query in Laravel

In this Laravel 8 WhereIn Database Query Examples tutorial I will show you how to use WhereIn query in laravel. In this tutorial you will learn to use WhereIn with laravel query builder and eloquent model. In this article I will share various example to use WhereIn query in laravel. In this tutorial you will learn about syntax and use of laravel WhereIn method.

Laravel WhereIn Database Query

Laravel WhereIn method will return the records with having column values in provided list. Here is the general syntax of the laravel WhereIn method:

Syntax:-

whereIn(CoulumnName, Array);

1	whereIn(CoulumnName, Array);

Laravel WhereIn Query with Laravel Query Builder

<?php
namespace App\Http\Controllers;

use App\Http\Controllers\Controller;
use Illuminate\Support\Facades\DB;

class UserController extends Controller
{

    public function index()
    {
        $users = DB::table('products')
            -> whereIn('name', ['1', '3', '5'])
            ->get();

        return view('home', ['products' => $products]);
    }

}

<?php

namespace App\Http\Controllers;

use App\Http\Controllers\Controller;

use Illuminate\Support\Facades\DB;

class UserController extends Controller

{

public function index()

{

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

-> whereIn('name', ['1', '3', '5'])

->get();

return view('home', ['products' => $products]);

}

Laravel WhereIn Query with Laravel Model

In this example we will use laravel WhereIn method with laravel model.

Example:-

Simple way to Print or Get Last Executed Query in Laravel 8

In this Simple way to Print or Get Last Executed Query in Laravel 8 tutorial I will show you how to print last executed query in laravel application. In this tutorial you will learn to get or print last executed query. In this article I will share various example to print last executed query. I will also show you simple way to get last executed query in laravel. You will also learn to output of print sql query.

Simple way to Print or Get Last Executed Query in Laravel 8

In this step by step tutorial I will demonstrates to get sql query in laravel 8 using toSql(), DB::enableQueryLog() and DB::getQueryLog().

Example 1:-

<?php

namespace App\Http\Controllers;
use App\Models\User;

class UserController extends Controller
{
    /**
     * Create a new controller instance.
     *
     * @return void
     */
    public function redirectToGoogle()
    {
        $query = User::select("*")->toSql();
        dd($query);
    }
}

<?php

namespace App\Http\Controllers;

use App\Models\User;

class UserController extends Controller

{

/**

* Create a new controller instance.

* @return void

public function redirectToGoogle()

{

$query = User::select("*")->toSql();

dd($query);

}

Output:-

select * from `users`

1	select * from `users`

Example 2:-

<?php
namespace App\Http\Controllers;
use App\Models\User;
use DB;
class UserController extends Controller
{
    /**
     * Create a new controller instance.
     *
     * @return void
     */
    public function redirectToGoogle()
    {
        DB::enableQueryLog();
        $users = User::select("*")->get();
        $quries = DB::getQueryLog();
        dd($quries);
    }
}

<?php

namespace App\Http\Controllers;

use App\Models\User;

use DB;

class UserController extends Controller

{

/**

* Create a new controller instance.

* @return void

public function redirectToGoogle()

{

DB::enableQueryLog();

$users = User::select("*")->get();

$quries = DB::getQueryLog();

dd($quries);

}

Output:-

array:1 [▼

  0 => array:3 [▼

    "query" => "select * from `users`"

    "bindings" => []

    "time" => 4.25

  ]

]

array:1 [▼

0 => array:3 [▼

"query" => "select * from `users`"

"bindings" => []

"time" => 4.25

]

Example 3:-

<?php

namespace App\Http\Controllers;
use App\Models\User;
use DB;
class UserController extends Controller
{
    /**
     * Create a new controller instance.
     *
     * @return void
     */
    public function redirectToGoogle()
    {
        DB::enableQueryLog();
        $users = User::select("*")->get();
        $query = DB::getQueryLog();
        $query = end($query);
        dd($query);
    }
}

<?php

namespace App\Http\Controllers;

use App\Models\User;

use DB;

class UserController extends Controller

{

/**

* Create a new controller instance.

* @return void

public function redirectToGoogle()

{

DB::enableQueryLog();

$users = User::select("*")->get();

$query = DB::getQueryLog();

$query = end($query);

dd($query);

}

Output:-

array:3 [▼
  "query" => "select * from `users`"
  "bindings" => []
  "time" => 2.07
]

array:3 [▼

"query" => "select * from `users`"

"bindings" => []

"time" => 2.07

]

Laravel 8 Eloquent WHERE Like Query Example Tutorial

In this Laravel 8 Eloquent WHERE Like Query Example Tutorial I’ll show you how to use laravel like with where method with query builder in laravel. You also learn how to use like in where eloquent method in search query. I’ll also show you how to use laravel where like for multiple like condition. In this tutorial I’ll demonstrate you different use case of the laravel whereLike method with examples.

Laravel 8 Eloquent WHERE Like Query Example Tutorial

Laravel whereLike() method is simple implementation of MySQL Like keyword. In laravel you can use % wildcard character with whereLike condition in similar as you do in mysql like.

Like Query with WHERE Condition in Laravel with Query Builder

In this example I have demonstrated you how to use “LIKE” in where method with query builder.

<?php
namespace App\Http\Controllers;

use App\Http\Controllers\Controller;
use Illuminate\Support\Facades\DB;

class CountryController extends Controller
{

    public function index()
    {
        $term = 'France';
        $filterData = DB::table('countries')->where('name','LIKE','%'.$term.'%')
                      ->get();
                      
        print_r($filterData);
    }

}

<?php

namespace App\Http\Controllers;

use App\Http\Controllers\Controller;

use Illuminate\Support\Facades\DB;

class CountryController extends Controller

{

public function index()

{

$term = 'France';

$filterData = DB::table('countries')->where('name','LIKE','%'.$term.'%')

->get();

print_r($filterData);

}

Like Query with Laravel Model

In this example I have demonstrated you how to use “LIKE” in where method with laravel model.

<?php
namespace App\Http\Controllers;

use App\Http\Controllers\Controller;
use App\Country;

class CountryController extends Controller
{

    public function index()
    {
        $term = 'France';
        $filterData = Country::table('countries')->where('name','LIKE','%'.$term.'%')
                      ->get();

        print_r($filterData);
    }

}

<?php

namespace App\Http\Controllers;

use App\Http\Controllers\Controller;

use App\Country;

class CountryController extends Controller

{

public function index()

{

$term = 'France';

$filterData = Country::table('countries')->where('name','LIKE','%'.$term.'%')

->get();

print_r($filterData);

}

Laravel 8 Eloquent Multiple Where Clause Query Example

In this Laravel 8 Eloquent Multiple Where Clause Query Example tutorial, I’ll show you how to use multiple where clause in laravel eloquent query. In this tutorial you will learn to use or apply multiple where clause in laravel query. In this article I will share various example to use multiple where clause with laravel query builder and eloquent model. When you fetch data from database tables you come to situation when you need to pass multiple conditions in laravel query. In laravel eloquent queries this can be done by providing multiple where clause in laravel eloquent query.

Laravel 8 Eloquent Multiple Where Clause Query Example

Below is general syntax of where() condition.

->where('column_name', 'operator', 'value')

1	->where('column_name', 'operator', 'value')

Multiple Where Condition with Query Builder

In this example we will be using Multiple where conditions in laravel query builder:

<?php
namespace App\Http\Controllers;

use App\Http\Controllers\Controller;
use Illuminate\Support\Facades\DB;

class CountryController extends Controller
{

    public function index()
    {
        $words = DB::select('*')
        ->where('hey', '=', 1)
        ->where('hello', '=', 1)
        ->where('hey_there', '=', 1)
        ->where('hi_there', '=', 1)
        ->where('you_and_i', '=', 1)
        ->where('thunder_is_blunder', '=', 1)
        ->where('when_then', '=', 1)
        ->where('this_is_me', '=', 1)
        ->get();

        print_r($words);
    }

}

<?php

namespace App\Http\Controllers;

use App\Http\Controllers\Controller;

use Illuminate\Support\Facades\DB;

class CountryController extends Controller

{

public function index()

{

$words = DB::select('*')

->where('hey', '=', 1)

->where('hello', '=', 1)

->where('hey_there', '=', 1)

->where('hi_there', '=', 1)

->where('you_and_i', '=', 1)

->where('thunder_is_blunder', '=', 1)

->where('when_then', '=', 1)

->where('this_is_me', '=', 1)

->get();

print_r($words);

}

Laravel Multiple Where Clause with Eloquent Model

In this example we will be using Multiple where conditions in laravel model:

<?php
namespace App\Http\Controllers;

use App\Http\Controllers\Controller;
use App\Book;

class CountryController extends Controller
{

    public function index()
    {
        $book = Book::table('students')
        ->where('hey', '=', 1)
        ->where('hello', '=', 1)
        ->where('hey_there', '=', 1)
        ->where('hi_there', '=', 1)
        ->where('you_and_i', '=', 1)
        ->where('thunder_is_blunder', '=', 1)
        ->where('when_then', '=', 1)
        ->where('this_is_me', '=', 1)
        ->get();

        print_r($book);
    }

}

<?php

namespace App\Http\Controllers;

use App\Http\Controllers\Controller;

use App\Book;

class CountryController extends Controller

{

public function index()

{

$book = Book::table('students')

->where('hey', '=', 1)

->where('hello', '=', 1)

->where('hey_there', '=', 1)

->where('hi_there', '=', 1)

->where('you_and_i', '=', 1)

->where('thunder_is_blunder', '=', 1)

->where('when_then', '=', 1)

->where('this_is_me', '=', 1)

->get();

print_r($book);

}

How to Create Notification in Laravel 8

Install Laravel Project

Set Up Database Connection

Create Notification Database Table

Create Notification in Laravel 8

Define Notification Route

Create Notification Controller

Laravel 8 Multiple Authentication

Download Laravel Application

Configure Database Connection

Set Up Model and Run Migration

Generate Auth Scaffolding

Set Up Admin Middleware

Set Up Route

Configure Home Controller

Configure Blade View

Configure Login Controller

Seed Database with User Data

Run & Test The Laravel Multi Auth App

Paypal Payment Gateway

How to Integrate Paypal Payment Gateway in Laravel 8

Install New Laravel Project

Database Settings

Install Essential Composer Package

Inject PayPal Details

Define Routes

Create Controller By Artisan Command

Configure Blade View

What Is Laravel Traits?

Laravel 8 Traits Example: Create & Use Trait in Laravel

Laravel Traits Example

Install New Laravel Application

Configure Database Connection

Model and Migrations

Insert Fake Data

Create Traits in Laravel

Using Traits in Laravel

Start Application

Laravel 8 REST API with Passport Authentication Tutorial

Install New Laravel Project

Set Up Database

Install Passport Package

Configure Passport Module

Create Posts Model & Run Migration

Create a New Controller

Define API Routes

Test Laravel 8|7 Passport API

Register API:

Login Passport API:

Passport Post Create API:

Post List API:

Post Update API:

Post Delete API:

Laravel 8 Dynamic Autocomplete Search with Select2 Example

Install Laravel Application

Configure Database

Model & Migration

Create Routes

Create Autocomplete Search Controller

Create View

Run Development Server

How to Enable CORS in Laravel

Laravel 8 CORS Example

CORS Middleware Nitty-Gritty

Create API in Laravel

Make Http GET Request with AJAX

Installing CORS Package in Laravel

Registering CORS Middleware

Laravel WhereNotIn Database Query

Laravel WhereNotIn with Query Builder

Laravel WhereNotIn with Laravel Model

Laravel WhereIn Database Query

Laravel WhereIn Query with Laravel Query Builder

Laravel WhereIn Query with Laravel Model

Simple way to Print or Get Last Executed Query in Laravel 8

Laravel 8 Eloquent WHERE Like Query Example Tutorial

Like Query with WHERE Condition in Laravel with Query Builder

Like Query with Laravel Model

Laravel 8 Eloquent Multiple Where Clause Query Example

Multiple Where Condition with Query Builder