Category Archives: Laravel

Laravel Tutorials

Laravel 7/6 Autocomplete Search using Jquery UI

In this Laravel 7/6 Autocomplete Search using Jquery UI tutorial I will show you how to create autocomplete input or search box using jquery ui in laravel. In this tutorial you will learn to create autocomplete input box using jquery ui in laravel.

In this example we will be using autocomplete jquery ui plugin. The jquery autocomplete plugin is used to create dynamic autocomplete input with several options. In this example you will learn how to implement jquery autocomplete in laravel.

Laravel 7/6 Autocomplete Search using Jquery UI

In this article, I will show you to create a dynamic database driven ajax jquery autocomplete in Laravel. You will also learn to create a dynamic search dropdown autocomplete which will fetch options from database table using jquery autocomplete.

Install Laravel App
Setup Database
Generate Fake Records
Make Routes
Create Controller & Methods
Create Blade View
Conclusion

1: Install Laravel App

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

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

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

2: Setup 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=here your database name here
 DB_USERNAME=here database username here
 DB_PASSWORD=here database password here

DB_CONNECTION=mysql

DB_HOST=127.0.0.1

DB_PORT=3306

DB_DATABASE=here your database name here

DB_USERNAME=here database username here

DB_PASSWORD=here database password here

3: Generate Fake Records

In this step we will add some dummy data into database.

php artisan migrate

1	php artisan migrate

Use following command to add 100 fake records in database :

php artisan migrate

php artisan tinker 

factory(App\User::class, 100)->create();

php artisan migrate

php artisan tinker

factory(App\User::class, 100)->create();

4: Make Routes

After this, we need to define routes in “routes/web.php” file. Lets open “routes/web.php” file and add the following routes in it.

routes/web.php

Route::get('search', 'AutoCompleteController@index');
 Route::get('autocomplete', 'AutoCompleteController@search');

1 2	Route::get('search', 'AutoCompleteController@index'); Route::get('autocomplete', 'AutoCompleteController@search');

5: Create Controller

Now, lets create a controller named AutoCompleteController using command given below –

php artisan make:controller AutoCompleteController

1	php artisan make:controller AutoCompleteController

Now, go to app/controllers/AutoCompleteController.php and put the below code :

<?php
 
namespace App\Http\Controllers;
 
use Illuminate\Http\Request;
use App\User;
 
class AutoCompleteController extends Controller
{
 
    public function index()
    {
        return view('search');
    }
 
    public function search(Request $request)
    {
          $search = $request->get('term');
      
          $result = User::where('name', 'LIKE', '%'. $search. '%')->get();
 
          return response()->json($result);
            
    } 
}

<?php

namespace App\Http\Controllers;

use Illuminate\Http\Request;

use App\User;

class AutoCompleteController extends Controller

{

public function index()

{

return view('search');

}

public function search(Request $request)

{

$search = $request->get('term');

$result = User::where('name', 'LIKE', '%'. $search. '%')->get();

return response()->json($result);

}

6: Create Blade view

In this step we will create a blade file. Go to app/resources/views and create one file name search.blade.php .

<!DOCTYPE html>
<html>
<head>
  <meta charset="UTF-8">
  <meta name="viewport" content="width=device-width, initial-scale=1.0">
  <meta http-equiv="X-UA-Compatible" content="ie=edge">
  <meta name="csrf-token" content="{{ csrf_token() }}">
  <title>Auto Complete Search Using Jquery UI</title>
  <link rel="stylesheet" href="//code.jquery.com/ui/1.12.1/themes/base/jquery-ui.css">
  <link href="//maxcdn.bootstrapcdn.com/bootstrap/4.1.1/css/bootstrap.min.css" rel="stylesheet" id="bootstrap-css">
  <script src="https://code.jquery.com/jquery-1.12.4.js"></script>
  <script src="https://code.jquery.com/ui/1.12.1/jquery-ui.js"></script>
 <style>
    .container{
    padding: 10%;
    text-align: center;
   } 
 </style>
</head>
<body>
 
<div class="container">
    <div class="row">
        <div class="col-12"><h2>laravel 6 Auto Complete Search Using Jquery UI</h2></div>
        <div class="col-12">
            <div id="custom-search-input">
                <div class="input-group">
                    <input id="search" name="search" type="text" class="form-control" placeholder="Search" />
                </div>
            </div>
        </div>
    </div>
</div>
<script>
 $(document).ready(function() {
    $( "#search" ).autocomplete({
 
        source: function(request, response) {
            $.ajax({
            url: "{{url('autocomplete')}}",
            data: {
                    term : request.term
             },
            dataType: "json",
            success: function(data){
               var resp = $.map(data,function(obj){
                    //console.log(obj.city_name);
                    return obj.name;
               }); 
 
               response(resp);
            }
        });
    },
    minLength: 1
 });
});
 
</script>   
</body>
</html>

<!DOCTYPE html>

<html>

<head>

<title>Auto Complete Search Using Jquery UI</title>

<style>

.container{

padding: 10%;

text-align: center;

}

</style>

</head>

<body>

<div class="col-12"><h2>laravel 6 Auto Complete Search Using Jquery UI</h2></div>

</div>

$(document).ready(function() {

$( "#search" ).autocomplete({

source: function(request, response) {

$.ajax({

url: "{{url('autocomplete')}}",

data: {

term : request.term

dataType: "json",

success: function(data){

var resp = $.map(data,function(obj){

//console.log(obj.city_name);

return obj.name;

});

response(resp);

}

});

minLength: 1

});

</script>

</body>

</html>

7: Start Development Server

Now we are ready to run our example so lets start the development server using following artisan command –

php artisan serve

1	php artisan serve

Now, open the following URL in browser to see the output –

 http://localhost:8000/search

1	http://localhost:8000/search

Laravel 7/6 Cron Job Scheduling

In this Laravel 7/6 Cron Job Scheduling tutorial I will show you how to schedule or create cron job in laravel. In this tutorial you will learn to create or schedule cron job in laravel.

In this tutorial we will learn about laravel custom cron job scheduling, laravel run cron job manually, sey cron job in cpanel, laravel run cron job manually, laravel scheduler every second, how to run cron job in laravel.

Laravel 7/6 Cron Job Scheduling

Create Command Class
Implement Logic
Register Command
Test in Localhost
Laravel Set CronJob Live Server

Step 1: Create Command Class

cd your project name

1	cd your project name

Next, We need to create command class run by below command in command prompt :

Step 2: Implement Logic

After run this above command, it will create a new class name TodayUsers.php in app/Console/Commands/ folder. So go to app/Console/Commands/TodayUsers.php and implement your logic here :

<?php
 
namespace App\Console\Commands;
 
use Illuminate\Console\Command;
 
class TodayUsers extends Command
{
    /**
     * The name and signature of the console command.
     *
     * @var string
     */
    protected $signature = 'TodayUsers:check';
 
    /**
     * The console command description.
     *
     * @var string
     */
    protected $description = 'This laravel cronjob is used to check how many users registered today';
 
    /**
     * Create a new command instance.
     *
     * @return void
     */
    public function __construct()
    {
        parent::__construct();
    }
 
    /**
     * Execute the console command.
     *
     * @return mixed
     */
    public function handle()
    {
            $count = \DB::table('users')
            ->whereDate('created_at', '=', date('Y-m-d'))
            ->count();
 
            echo "Today $count users registered";
    }
}

<?php

namespace App\Console\Commands;

use Illuminate\Console\Command;

class TodayUsers extends Command

{

/**

* The name and signature of the console command.

* @var string

protected $signature = 'TodayUsers:check';

/**

* The console command description.

* @var string

protected $description = 'This laravel cronjob is used to check how many users registered today';

/**

* Create a new command instance.

* @return void

public function __construct()

{

parent::__construct();

}

/**

* Execute the console command.

* @return mixed

public function handle()

{

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

->whereDate('created_at', '=', date('Y-m-d'))

->count();

echo "Today $count users registered";

}

Step 3: Register Command

After creating your logic in TodayUsers.php file. Now we need to register command in kernel.php file with task scheduling. Open app/Console/Kernel.php/ and schedule the task.

<?php
 
namespace App\Console;
 
use Illuminate\Console\Scheduling\Schedule;
use Illuminate\Foundation\Console\Kernel as ConsoleKernel;
 
class Kernel extends ConsoleKernel
{
    /**
     * The Artisan commands provided by your application.
     *
     * @var array
     */
    protected $commands = [
        Commands\TodayUsers::class,
    ];
 
    /**
     * Define the application's command schedule.
     *
     * @param  \Illuminate\Console\Scheduling\Schedule  $schedule
     * @return void
     */
    protected function schedule(Schedule $schedule)
    {
                $schedule->command('TodayUsers:check')
                 ->everyMinute();
    }
 
    /**
     * Register the commands for the application.
     *
     * @return void
     */
    protected function commands()
    {
        $this->load(__DIR__.'/Commands');
 
        require base_path('routes/console.php');
    }
}

<?php

namespace App\Console;

use Illuminate\Console\Scheduling\Schedule;

use Illuminate\Foundation\Console\Kernel as ConsoleKernel;

class Kernel extends ConsoleKernel

{

/**

* The Artisan commands provided by your application.

* @var array

protected $commands = [

Commands\TodayUsers::class,

];

/**

* Define the application's command schedule.

* @param \Illuminate\Console\Scheduling\Schedule $schedule

* @return void

protected function schedule(Schedule $schedule)

{

$schedule->command('TodayUsers:check')

->everyMinute();

}

/**

* Register the commands for the application.

* @return void

protected function commands()

{

$this->load(__DIR__.'/Commands');

require base_path('routes/console.php');

}

In Kernel.php file we will schedule the task to be done, when this command excute(run). In this example we will schedule the task excute for every minute.

Step 4: Test in Localhost

php artisan TodayUsers:check

1	php artisan TodayUsers:check

Step 5: Laravel Set CronJob on live server

* * * * php /path-to-your-project/artisan schedule:run >> /dev/null 2>&1

1	* * * * php /path-to-your-project/artisan schedule:run >> /dev/null 2>&1

In Laravel More Cronjob Schedule Options are available.
->cron(‘* * * * * *’); – Run the task on a custom Cron schedule

->everyMinute(); – Run the task every minute

->everyFiveMinutes(); – Run the task every five minutes

->hourly(); – Run the task every hour

->daily(); – Run the task every day at midnight

->dailyAt(’13:00′); – Run the task every day at midnight

->twiceDaily(1, 13); – Run the task daily at 1:00 & 13:00

->weekly(); – Run the task weekly

->monthly(); -Run the task every month

->monthlyOn(4, ’15:00′) – Run the task every month on the 4th at 15:00

->quarterly(); – Run the task every quarter

->yearly(); – Run the task every year

->timezone(‘America/New_York’); – Set the timezone Addiitional schedule constraints are listed below,

->weekdays(); – Limit the task to weekdays

->sundays(); – Limit the task to Sunday

->mondays(); – Limit the task to Monday

->tuesdays(); – Limit the task to Tuesday

->wednesdays(); – Limit the task to Wednesday

->thursdays(); – Limit the task to Thursday

->fridays(); – Limit the task to Friday

->saturdays(); – Limit the task to Saturday

Laravel 7/6 Email Verification Tutorial Example

In this Laravel 7/6 Email Verification Tutorial I will show you how to implement email verification for newly registered users in laravel. In this tutorial you will learn to enable email verification for account activation in laravel.

Laravel provides built-in email verification system for newly registered user. Using this, newly registered user will get an email with an account activation link. This activation link is used for account verification. When activation link is clicked, this will make user account verified and active for the application. Once user account is activated then it will be allowed to access protected routes; which can be accessible only by verified accounts.

Laravel 7/6 Email Verification Tutorial Example

In this step by step tutorial, we’ll show you how to setup email verification system for newly registered user in laravel.

Install Laravel Fresh Setup
Setup Database and SMTP Detail
Create Auth Scaffolding
Migrate Database
Add Route
Add Middleware In Controller
Run Development Server
Conclusion

1. Install Laravel Fresh Setup

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

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

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

2. Setup 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=here your database name here
 DB_USERNAME=here database username here
 DB_PASSWORD=here database password here

DB_CONNECTION=mysql

DB_HOST=127.0.0.1

DB_PORT=3306

DB_DATABASE=here your database name here

DB_USERNAME=here database username here

DB_PASSWORD=here database password here

Now we will setup SMTP credential in .env to send emails. We are using mailtrap SMTP credential in this example.

MAIL_DRIVER=smtp
 MAIL_HOST=smtp.mailtrap.io
 MAIL_PORT=2525
 MAIL_USERNAME=your_mailtrap_user_name
 MAIL_PASSWORD=your_mailtrap_user_password
 MAIL_ENCRYPTION=tls

MAIL_DRIVER=smtp

MAIL_HOST=smtp.mailtrap.io

MAIL_PORT=2525

MAIL_USERNAME=your_mailtrap_user_name

MAIL_PASSWORD=your_mailtrap_user_password

MAIL_ENCRYPTION=tls

3. Create Auth Scaffolding

Now we need to enable authentication scaffolding in laravel.

4. Migrate Database

Now, go to app/providers/AppServiceProvider.php and put the below code :

use Illuminate\Support\Facades\Schema;

 function boot()
 {
     Schema::defaultStringLength(191);
 }

use Illuminate\Support\Facades\Schema;

function boot()

{

Schema::defaultStringLength(191);

}

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

php artisan migrate

1	php artisan migrate

After migrating the database tables we need to add the MustVerifyEmail Contracts in App/User.php. Open the App/User.php file add the constructor like

<?php
 
namespace App;
 
use Illuminate\Notifications\Notifiable;
use Illuminate\Contracts\Auth\MustVerifyEmail;
use Illuminate\Foundation\Auth\User as Authenticatable;
 
class User extends Authenticatable implements MustVerifyEmail
{
    use Notifiable;
 
    /**
     * 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',
    ];
}

<?php

namespace App;

use Illuminate\Notifications\Notifiable;

use Illuminate\Contracts\Auth\MustVerifyEmail;

use Illuminate\Foundation\Auth\User as Authenticatable;

class User extends Authenticatable implements MustVerifyEmail

{

use Notifiable;

/**

* 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',

];

}

5. Add Route

After this, we need to define routes in “routes/web.php” file. Lets open “routes/web.php” file and add the following routes in it.

routes/web.php

Route::get('/', function () {
     return view('welcome');
 });
 
 //first 
 Auth::routes();
 
 //after
 Auth::routes(['verify' => true]);

Route::get('/', function () {

return view('welcome');

});

//first

Auth::routes();

//after

Auth::routes(['verify' => true]);

6. Add Middleware In Controller

We need to add Middleware in the controller constructor. Go to app/controllers/HomeController
and put this line $this->middleware([‘auth’, ‘verified’]); inside of constructor :

<?php
 
namespace App\Http\Controllers;
 
use Illuminate\Http\Request;
 
class HomeController extends Controller
{
    /**
     * Create a new controller instance.
     *
     * @return void
     */
    public function __construct()
    {
        $this->middleware(['auth', 'verified']);
    }
 
    /**
     * Show the application dashboard.
     *
     * @return \Illuminate\Http\Response
     */
    public function index()
    {
        return view('home');
    }
}

<?php

namespace App\Http\Controllers;

use Illuminate\Http\Request;

class HomeController extends Controller

{

/**

* Create a new controller instance.

* @return void

public function __construct()

{

$this->middleware(['auth', 'verified']);

}

/**

* Show the application dashboard.

* @return \Illuminate\Http\Response

public function index()

{

return view('home');

}

7. Run Development Server

Now we are ready to run our example so lets start the development server using following artisan command –

php artisan serve

1	php artisan serve

Now, open the following URL in browser to see the output –

 http://localhost:8000/

1	http://localhost:8000/

Laravel 7/6 Send Email Tutorial Example

In this Laravel 7/6 Send Email Tutorial I will show you how to send email in laravel. In this tutorial you will learn how to send email in laravel using SMTP driver. Laravel comes with built-in api and driver support for SMTP, SendMail, Mailgun, Sendgrid, Mandrill, Amazon SES, SpartPost etc. In this article I will share example of sending an email in laravel application.

Laravel 7/6 Send Email Tutorial Example

In this step by step tutorial you will understand how to send emails in Laravel using SMTP driver.

Install Laravel Setup
Configuration SMTP in .env
Create Route & Blade View
Create Controller & Method
Run Development Server

1. Install Laravel Fresh Setup

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

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

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

2. Configuration SMTP in .env

In this step we will configure smtp settings in .env file as following:

MAIL_DRIVER=smtp
MAIL_HOST=smtp.gmail.com 
MAIL_PORT=587 
MAIL_USERNAME=Add your user name here
MAIL_PASSWORD=Add your password here
MAIL_ENCRYPTION=tls

MAIL_DRIVER=smtp

MAIL_HOST=smtp.gmail.com

MAIL_PORT=587

MAIL_USERNAME=Add your user name here

MAIL_PASSWORD=Add your password here

MAIL_ENCRYPTION=tls

3. Create Route & Blade View

After this, we need to define routes in “routes/web.php” file. Lets open “routes/web.php” file and add the following routes in it.

routes/web.php

 Route::get('laravel-send-email', 'EmailController@sendEmail');

1	Route::get('laravel-send-email', 'EmailController@sendEmail');

Next, we will create email blade view file in view folder of view. Go to the resources/views/ and create a view file name email.blade.php. Put bellow code:

<h1>{{ $title }}</h1>
<p>This is my first Email using Laravel Application</p>

1 2	<h1>{{ $title }}</h1> <p>This is my first Email using Laravel Application</p>

4. Create Controller & Method

Now, lets create a controller named EmailController using command given below –

php artisan make:controller EmailController

1	php artisan make:controller EmailController

Now open the controller let’s go to app/Http/Controllers/EmailController.php. Put the following code in it:

<?php
 
namespace App\Http\Controllers;
 
use Illuminate\Http\Request;
use Redirect,Response,DB,Config;
use Mail;
class EmailController extends Controller
{
    public function sendEmail()
    {
        $data['title'] = "This is Test Mail";
 
        Mail::send('emails.email', $data, function($message) {
 
            $message->to('yoursite@gmail.com', 'Receiver Name')
 
                    ->subject('Test Mail');
        });
 
        if (Mail::failures()) {
           return response()->Fail('Sorry! Please try again latter');
         }else{
           return response()->success('Great! Successfully send in your mail');
         }
    }
}

<?php

namespace App\Http\Controllers;

use Illuminate\Http\Request;

use Redirect,Response,DB,Config;

use Mail;

class EmailController extends Controller

{

public function sendEmail()

{

$data['title'] = "This is Test Mail";

Mail::send('emails.email', $data, function($message) {

$message->to('yoursite@gmail.com', 'Receiver Name')

->subject('Test Mail');

});

if (Mail::failures()) {

return response()->Fail('Sorry! Please try again latter');

}else{

return response()->success('Great! Successfully send in your mail');

}

5. Run Development Server

Now we are ready to run our example so lets start the development server using following artisan command –

php artisan serve

1	php artisan serve

Now, open the following URL in browser to see the output –

http://localhost:8000/laravel-send-email

1	http://localhost:8000/laravel-send-email

Laravel 7/6 Ajax CRUD Example

In this Laravel 7/6 Ajax CRUD operation example tutorial I’ll show you how to create a simple ajax crud application in laravel 7/6. In this example we will learn how to create a simple ajax crud operation application in laravel 7/6. In this laravel 7/6 ajax crud application we will be using jQuery and ajax to delete data from datatable crud app and MySQL database in laravel 7/6 app.

In this tutorial, you will learn to implement ajax based CRUD (Create, Read, Update and Delete) operations in laravel.

Laravel 7/6 DataTable Ajax CRUD Example Tutorial

In this step by step guide, we will be creating a simple laravel 7/6 application to demonstrate you how to implement ajax based CRUD operations in laravel.

Laravel 7/6 Ajax CRUD Example

First Install New Laravel Setup
Configure .env file
Create One Model and Migration
Make Route
Generate(create) Controller
Create Blade View
Start Development Server
Conclusion

1). First Install New Laravel Setup

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

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

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

2). Configure .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.

DB_CONNECTION=mysql 
 DB_HOST=127.0.0.1 
 DB_PORT=3306 
 DB_DATABASE=here your database name here
 DB_USERNAME=here database username here
 DB_PASSWORD=here database password here

DB_CONNECTION=mysql

DB_HOST=127.0.0.1

DB_PORT=3306

DB_DATABASE=here your database name here

DB_USERNAME=here database username here

DB_PASSWORD=here database password here

Next go to app/datatabase/migrations and open users migration file and put the below code here

public function up()
 {
     Schema::create('users', function (Blueprint $table) {
         $table->increments('id');
         $table->string('name')->nullable();
         $table->string('email')->nullable();
         $table->timestamps();
     });
 }

public function up()

{

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

$table->increments('id');

$table->string('name')->nullable();

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

$table->timestamps();

});

}

Now, go to app/providers/AppServiceProvider.php and put the below code :

...
use Illuminate\Support\Facades\Schema;
 
....
function boot()
{
    Schema::defaultStringLength(191);
}
...

...

use Illuminate\Support\Facades\Schema;

....

function boot()

{

Schema::defaultStringLength(191);

}

...

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

php artisan migrate

1	php artisan migrate

3). Make Route

After this, we need to define routes in “routes/web.php” file. Lets open “routes/web.php” file and add the following routes in it.

routes/web.php

Route::resource('ajax-crud', 'AjaxController');

1	Route::resource('ajax-crud', 'AjaxController');

4). Generate (Create) Controller

In this step we will create a resource controller named AjaxController for crud operations using following command:

php artisan make:controller AjaxController --resource

1	php artisan make:controller AjaxController --resource

Next open your controller and replace crud methods as following:

<?php
   
namespace App\Http\Controllers;
   
use App\User;
use Illuminate\Http\Request;
use Redirect,Response;
   
class AjaxController extends Controller
{
    /**
     * Display a listing of the resource.
     *
     * @return \Illuminate\Http\Response
     */
    public function index()
    {
        $data['users'] = User::orderBy('id','desc')->paginate(8);
   
        return view('ajax-crud',$data);
    }
    
   
    /**
     * Store a newly created resource in storage.
     *
     * @param  \Illuminate\Http\Request  $request
     * @return \Illuminate\Http\Response
     */
    public function store(Request $request)
    {  
        $userId = $request->user_id;
        $user   =   User::updateOrCreate(['id' => $userId],
                    ['name' => $request->name, 'email' => $request->email]);
    
        return Response::json($user);
    }
    
    
    /**
     * Show the form for editing the specified resource.
     *
     * @param  \App\Product  $product
     * @return \Illuminate\Http\Response
     */
    public function edit($id)
    {   
        $where = array('id' => $id);
        $user  = User::where($where)->first();
 
        return Response::json($user);
    }
 
   
    /**
     * Remove the specified resource from storage.
     *
     * @param  \App\Product  $product
     * @return \Illuminate\Http\Response
     */
    public function destroy($id)
    {
        $user = User::where('id',$id)->delete();
   
        return Response::json($user);
    }
}

<?php

namespace App\Http\Controllers;

use App\User;

use Illuminate\Http\Request;

use Redirect,Response;

class AjaxController extends Controller

{

/**

* Display a listing of the resource.

* @return \Illuminate\Http\Response

public function index()

{

$data['users'] = User::orderBy('id','desc')->paginate(8);

return view('ajax-crud',$data);

}

/**

* Store a newly created resource in storage.

* @param \Illuminate\Http\Request $request

* @return \Illuminate\Http\Response

public function store(Request $request)

{

$userId = $request->user_id;

$user = User::updateOrCreate(['id' => $userId],

['name' => $request->name, 'email' => $request->email]);

return Response::json($user);

}

/**

* Show the form for editing the specified resource.

* @param \App\Product $product

* @return \Illuminate\Http\Response

public function edit($id)

{

$where = array('id' => $id);

$user = User::where($where)->first();

return Response::json($user);

}

/**

* Remove the specified resource from storage.

* @param \App\Product $product

* @return \Illuminate\Http\Response

public function destroy($id)

{

$user = User::where('id',$id)->delete();

return Response::json($user);

}

5). Create blade view :

In this step, we will create one blade file name ajax-crud.blade.php.

<!DOCTYPE html>
<html>
<head>
<meta charset="UTF-8">
<meta name="viewport" content="width=device-width, initial-scale=1.0">
<meta http-equiv="X-UA-Compatible" content="ie=edge">
<meta name="csrf-token" content="{{ csrf_token() }}">
<title>laravel 6 First Ajax CRUD Application</title>
<link rel="stylesheet" href="https://cdnjs.cloudflare.com/ajax/libs/twitter-bootstrap/4.1.3/css/bootstrap.min.css" />
<script src="https://code.jquery.com/jquery-3.3.1.min.js"></script>
<script src="https://cdnjs.cloudflare.com/ajax/libs/jquery-validate/1.19.0/jquery.validate.js"></script>
<script src="https://cdnjs.cloudflare.com/ajax/libs/popper.js/1.14.3/umd/popper.min.js"></script>
<script src="https://stackpath.bootstrapcdn.com/bootstrap/4.1.3/js/bootstrap.min.js"></script>
<style>
.container{
padding: 0.5%;
} 
</style>
</head>
<body>
<div class="container">
<h2 style="margin-top: 12px;" class="alert alert-success">laravel 6 First Ajax CRUD Application</h2><br>
<div class="row">
<div class="col-12">
<a href="javascript:void(0)" class="btn btn-success mb-2" id="create-new-user">Add User</a> 
<a href="https://www.w3adda.com/jquery-submit-form-ajax-php-laravel-5-7-without-page-load/" class="btn btn-secondary mb-2 float-right">Back to Post</a>
<table class="table table-bordered" id="laravel_crud">
<thead>
<tr>
<th>Id</th>
<th>Name</th>
<th>Email</th>
<td colspan="2">Action</td>
</tr>
</thead>
<tbody id="users-crud">
@foreach($users as $u_info)
<tr id="user_id_{{ $u_info->id }}">
<td>{{ $u_info->id  }}</td>
<td>{{ $u_info->name }}</td>
<td>{{ $u_info->email }}</td>
<td><a href="javascript:void(0)" id="edit-user" data-id="{{ $u_info->id }}" class="btn btn-info">Edit</a></td>
<td>
<a href="javascript:void(0)" id="delete-user" data-id="{{ $u_info->id }}" class="btn btn-danger delete-user">Delete</a></td>
</tr>
@endforeach
</tbody>
</table>
{{ $users->links() }}
</div> 
</div>
</div>
</body>
</html>

<!DOCTYPE html>

<html>

<head>

<title>laravel 6 First Ajax CRUD Application</title>

<style>

.container{

padding: 0.5%;

}

</style>

</head>

<body>

<h2 style="margin-top: 12px;" class="alert alert-success">laravel 6 First Ajax CRUD Application</h2><br>

<thead>

<tr>

<th>Email</th>

<td colspan="2">Action</td>

</tr>

</thead>

@foreach($users as $u_info)

<td>{{ $u_info->email }}</td>

<td><a href="javascript:void(0)" id="edit-user" data-id="{{ $u_info->id }}" class="btn btn-info">Edit</a></td>

<td>

<a href="javascript:void(0)" id="delete-user" data-id="{{ $u_info->id }}" class="btn btn-danger delete-user">Delete</a></td>

</tr>

@endforeach

</tbody>

</table>

</div>

</body>

</html>

Next step, we will create one modal. After create a modal it put closing of last div tag :

<div class="modal fade" id="ajax-crud-modal" aria-hidden="true">
<div class="modal-dialog">
<div class="modal-content">
<div class="modal-header">
<h4 class="modal-title" id="userCrudModal"></h4>
</div>
<div class="modal-body">
<form id="userForm" name="userForm" class="form-horizontal">
<input type="hidden" name="user_id" id="user_id">
<div class="form-group">
<label for="name" class="col-sm-2 control-label">Name</label>
<div class="col-sm-12">
<input type="text" class="form-control" id="name" name="name" placeholder="Enter Name" value="" maxlength="50" required="">
</div>
</div>
<div class="form-group">
<label class="col-sm-2 control-label">Email</label>
<div class="col-sm-12">
<input type="email" class="form-control" id="email" name="email" placeholder="Enter Email" value="" required="">
</div>
</div>
</form>
</div>
<div class="modal-footer">
<button type="button" class="btn btn-primary" id="btn-save" value="create">Save changes
</button>
</div>
</div>
</div>
</div>

</div>

</div>

<label class="col-sm-2 control-label">Email</label>

</div>

</form>

</div>

<button type="button" class="btn btn-primary" id="btn-save" value="create">Save changes

</button>

</div>

Next we will implement the ajax crud logic inside the script. Open your ajax-crud blade view file and put the below code after closing of body tag

<script>
$(document).ready(function () {
$.ajaxSetup({
headers: {
'X-CSRF-TOKEN': $('meta[name="csrf-token"]').attr('content')
}
});
/*  When user click add user button */
$('#create-new-user').click(function () {
$('#btn-save').val("create-user");
$('#userForm').trigger("reset");
$('#userCrudModal').html("Add New User");
$('#ajax-crud-modal').modal('show');
});
/* When click edit user */
$('body').on('click', '#edit-user', function () {
var user_id = $(this).data('id');
$.get('ajax-crud/' + user_id +'/edit', function (data) {
$('#userCrudModal').html("Edit User");
$('#btn-save').val("edit-user");
$('#ajax-crud-modal').modal('show');
$('#user_id').val(data.id);
$('#name').val(data.name);
$('#email').val(data.email);
})
});
//delete user login
$('body').on('click', '.delete-user', function () {
var user_id = $(this).data("id");
confirm("Are You sure want to delete !");
$.ajax({
type: "DELETE",
url: "{{ url('ajax-crud')}}"+'/'+user_id,
success: function (data) {
$("#user_id_" + user_id).remove();
},
error: function (data) {
console.log('Error:', data);
}
});
});   
});
if ($("#userForm").length > 0) {
$("#userForm").validate({
submitHandler: function(form) {
var actionType = $('#btn-save').val();
$('#btn-save').html('Sending..');
$.ajax({
data: $('#userForm').serialize(),
url: "https://www.w3adda.com/laravel-example/ajax-crud/store",
type: "POST",
dataType: 'json',
success: function (data) {
var user = '<tr id="user_id_' + data.id + '"><td>' + data.id + '</td><td>' + data.name + '</td><td>' + data.email + '</td>';
user += '<td><a href="javascript:void(0)" id="edit-user" data-id="' + data.id + '" class="btn btn-info">Edit</a></td>';
user += '<td><a href="javascript:void(0)" id="delete-user" data-id="' + data.id + '" class="btn btn-danger delete-user">Delete</a></td></tr>';
if (actionType == "create-user") {
$('#users-crud').prepend(user);
} else {
$("#user_id_" + data.id).replaceWith(user);
}
$('#userForm').trigger("reset");
$('#ajax-crud-modal').modal('hide');
$('#btn-save').html('Save Changes');
},
error: function (data) {
console.log('Error:', data);
$('#btn-save').html('Save Changes');
}
});
}
})
}
</script>

$(document).ready(function () {

$.ajaxSetup({

headers: {

'X-CSRF-TOKEN': $('meta[name="csrf-token"]').attr('content')

}

});

/* When user click add user button */

$('#create-new-user').click(function () {

$('#btn-save').val("create-user");

$('#userForm').trigger("reset");

$('#userCrudModal').html("Add New User");

$('#ajax-crud-modal').modal('show');

});

/* When click edit user */

$('body').on('click', '#edit-user', function () {

var user_id = $(this).data('id');

$.get('ajax-crud/' + user_id +'/edit', function (data) {

$('#userCrudModal').html("Edit User");

$('#btn-save').val("edit-user");

$('#ajax-crud-modal').modal('show');

$('#user_id').val(data.id);

$('#name').val(data.name);

$('#email').val(data.email);

})

});

//delete user login

$('body').on('click', '.delete-user', function () {

var user_id = $(this).data("id");

confirm("Are You sure want to delete !");

$.ajax({

type: "DELETE",

url: "{{ url('ajax-crud')}}"+'/'+user_id,

success: function (data) {

$("#user_id_" + user_id).remove();

error: function (data) {

console.log('Error:', data);

}

});

if ($("#userForm").length > 0) {

$("#userForm").validate({

submitHandler: function(form) {

var actionType = $('#btn-save').val();

$('#btn-save').html('Sending..');

$.ajax({

data: $('#userForm').serialize(),

url: "https://www.w3adda.com/laravel-example/ajax-crud/store",

type: "POST",

dataType: 'json',

success: function (data) {

var user = '<tr id="user_id_' + data.id + '"><td>' + data.id + '</td><td>' + data.name + '</td><td>' + data.email + '</td>';

user += '<td><a href="javascript:void(0)" id="edit-user" data-id="' + data.id + '" class="btn btn-info">Edit</a></td>';

user += '<td><a href="javascript:void(0)" id="delete-user" data-id="' + data.id + '" class="btn btn-danger delete-user">Delete</a></td></tr>';

if (actionType == "create-user") {

$('#users-crud').prepend(user);

} else {

$("#user_id_" + data.id).replaceWith(user);

}

$('#userForm').trigger("reset");

$('#ajax-crud-modal').modal('hide');

$('#btn-save').html('Save Changes');

error: function (data) {

console.log('Error:', data);

$('#btn-save').html('Save Changes');

}

});

}

})

}

</script>

6). Run Development Server

Now we are ready to run our example so lets start the development server using following artisan command –

php artisan serve

1	php artisan serve

Now, open the following URL in browser to see the output –

http://127.0.0.1:8000/ajax-crud

1	http://127.0.0.1:8000/ajax-crud

Laravel 7/6 Generate PDF Example

In this Laravel 7/6 Generate PDF Example tutorial, I will show you how to generate pdf from html blade view file in laravel. In this tutorial you will learn to generate, convert and download pdf file from html blade view file in laravel. While working with web application we come to situations where we need to generate or download pdf file for various purpose such as generate invoices, acknowledgment or tickets printing etc. In this tutorial we will be using laravel dom-pdf package to generate/create and download pdf.

Laravel 7/6 Generate PDF Example

In this step by step guide I will demonstrate you how to create or download pdf from laravel html blade view file in the laravel 7/6 Application.

Install Laravel App
Setup Database
Install laravel-dompdf Package
Make PDF Route
Create GeneratePDF Controller
Create Blade view for Generate Pdf
Start Development Server

1. Install Laravel App

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

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

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

2. Setup 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=here your database name here
 DB_USERNAME=here database username here
 DB_PASSWORD=here database password here

DB_CONNECTION=mysql

DB_HOST=127.0.0.1

DB_PORT=3306

DB_DATABASE=here your database name here

DB_USERNAME=here database username here

DB_PASSWORD=here database password here

3. Install laravel-dompdf Package

In this step, we will install laravel-dompdf Package via the composer dependency manager. Use the following command to install laravel-dompdf Package.

composer require barryvdh/laravel-dompdf

1	composer require barryvdh/laravel-dompdf

After successfully installing laravel dompdf package, we need to add service provider and alias in config/app.php file as following.

'providers' => [
 
 Barryvdh\DomPDF\ServiceProvider::class,
 ],
 
'aliases' => [
 
 'PDF' => Barryvdh\DomPDF\Facade::class,
 ]

'providers' => [

Barryvdh\DomPDF\ServiceProvider::class,

'aliases' => [

'PDF' => Barryvdh\DomPDF\Facade::class,

]

4. Make PDF Route

After this, we need to define routes in “routes/web.php” file. Lets open “routes/web.php” file and add the following routes in it.

routes/web.php

Route::get('pdf_form', 'GeneratePdfController@pdfForm');
 Route::get('pdf_download', 'GeneratePdfController@pdfDownload');

1 2	Route::get('pdf_form', 'GeneratePdfController@pdfForm'); Route::get('pdf_download', 'GeneratePdfController@pdfDownload');

5. Create GeneratePDF Controller

Now, lets create a controller named GeneratePdfController using command given below –

php artisan make:controller GeneratePdfController

1	php artisan make:controller GeneratePdfController

After creating controller go to app/controllers/GeneratePdfController.php and put the following code in it:

<?php
   
namespace App\Http\Controllers;
 
use Illuminate\Http\Request;
use Redirect;
use PDF;
   
class GeneratePdfController extends Controller
{
   
    public function pdfForm()
    {
        return view('pdf_form');
    }
 
    public function pdfDownload(){
 
       request()->validate([
        'name' => 'required',
        'email' => 'required|email',
        'message' => 'required'
        ]);
      
         $data = 
         [
            'name' => $request->name,
            'email' => $request->email,
            'message' => $request->message
         ];
       $pdf = PDF::loadView('pdf_download', $data);
   
       return $pdf->download('w3adda.pdf');
    }
    
 
}

<?php

namespace App\Http\Controllers;

use Illuminate\Http\Request;

use Redirect;

use PDF;

class GeneratePdfController extends Controller

{

public function pdfForm()

{

return view('pdf_form');

}

public function pdfDownload(){

request()->validate([

'name' => 'required',

'email' => 'required|email',

'message' => 'required'

]);

$data =

[

'name' => $request->name,

'email' => $request->email,

'message' => $request->message

];

$pdf = PDF::loadView('pdf_download', $data);

return $pdf->download('w3adda.pdf');

}

6. Create Blade view for Generate Pdf

Now, we need to create blade view file. Go to app/resources/views and create one file name pdf_form.blade.php :

<html>
<head>
<title>Laravel Generate & Download Pdf Tutorial</title>
<link href="//maxcdn.bootstrapcdn.com/bootstrap/4.1.1/css/bootstrap.min.css" rel="stylesheet" id="bootstrap-css">
<script src="//maxcdn.bootstrapcdn.com/bootstrap/4.1.1/js/bootstrap.min.js"></script>
</head>
<style type="text/css">
body{
background-color: #f1f1f1;
}
</style>
<body>
<div class="container contact">
<br><br><br>
<div class="row">
<div class="col-md-8 offset-md-2">
<form action="{{ url('pdf_download') }}" method="post" accept-charset="utf-8">
@csrf
<div class="contact-form">
<div class="form-group">
<label class="control-label col-sm-2" for="fname">First Name:</label>
<div class="col-sm-10">
   <input type="text" class="form-control" id="name" placeholder="Enter Name" name="name">
   <span class="text-danger">{{ $errors->first('name') }}</span>
</div>
</div>
<div class="form-group">
<label class="control-label col-sm-2" for="email">Email:</label>
<div class="col-sm-10">
   <input type="email" class="form-control" id="email" placeholder="Enter email" name="email">
   <span class="text-danger">{{ $errors->first('email') }}</span>
</div>
</div>
<div class="form-group">
<label class="control-label col-sm-2" for="comment">Comment:</label>
<div class="col-sm-10">
   <textarea class="form-control" rows="5" name="message" id="message"></textarea>
   <span class="text-danger">{{ $errors->first('message') }}</span>
</div>
</div>
<div class="form-group">
<div class="col-sm-offset-2 col-sm-10">
   <button type="submit" class="btn btn-default">Submit</button>
</div>
</div>
</div>
</form>
</div>
</div>
<br><br><br><br>
</div>
</body>
</html>

<html>

<head>

<title>Laravel Generate & Download Pdf Tutorial</title>

</head>

body{

background-color: #f1f1f1;

}

</style>

<body>

@csrf

<label class="control-label col-sm-2" for="fname">First Name:</label>

<span class="text-danger">{{ $errors->first('name') }}</span>

</div>

<label class="control-label col-sm-2" for="email">Email:</label>

<span class="text-danger">{{ $errors->first('email') }}</span>

</div>

<label class="control-label col-sm-2" for="comment">Comment:</label>

<span class="text-danger">{{ $errors->first('message') }}</span>

</div>

<button type="submit" class="btn btn-default">Submit</button>

</div>

</form>

</div>

</div>

</body>

</html>

Now we create a one more blade view file name pdf_download.blade.php. Go to app/resources/views create file. This blade view file will download as pdf file. so put the below code here

<body>
  <div id="content">
    <h2>Hello <b> <span style="color:red">{{ ucfirst($name) }}</span> </b></h2> 
    <p>
        {{ $message }}
    </p>
  </div>
</body>

<body>

<h2>Hello <b> <span style="color:red">{{ ucfirst($name) }}</span> </b></h2>

<p>

</p>

</div>

</body>

7. Run Development Server

Now we are ready to run our example so lets start the development server using following artisan command –

php artisan serve

1	php artisan serve

Now, open the following URL in browser to see the output –

http://localhost:8000/pdf

1	http://localhost:8000/pdf

Laravel 7/6 Simple CRUD Application Example Tutorial

In this Laravel 7/6 Simple CRUD Application Example Tutorial I’ll show you how to create a simple crud application in laravel 7/6. In this example we will learn how to create a simple crud operation application in laravel 7/6. In this laravel 7/6 crud application we will be using jQuery and ajax to delete data from datatable crud app and MySQL database in laravel 7/6 app. In this article, you will learn how to create fully functional CRUD (Create, Read, Update and Delete) Application In laravel.

Laravel 7/6 Simple CRUD Application Example Tutorial

Step 1: Install Laravel New Setup
Step 2: Setup Database Credentials
Step 3: Generate Model and Migration
Step 4: Add Routes for CRUD Operation
Step 5: Create Resource CRUD Controller
Step 6: Create the blade view
Step 7: Start Development Server

Step 1: Install Laravel New Setup

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

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

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

Step 2: Setup Database Credentials

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=here your database name here
DB_USERNAME=here database username here
DB_PASSWORD=here database password here

DB_CONNECTION=mysql

DB_HOST=127.0.0.1

DB_PORT=3306

DB_DATABASE=here your database name here

DB_USERNAME=here database username here

DB_PASSWORD=here database password here

Step 3: Generate Model and Migration

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

php artisan make:model Product-m

1	php artisan make:model Product-m

The above command will create one model name Product and also create one migration file for Product table. Now, go to database/migrations file and put the below here :

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

<?php

use Illuminate\Support\Facades\Schema;

use Illuminate\Database\Schema\Blueprint;

use Illuminate\Database\Migrations\Migration;

class CreateProductsTable extends Migration

{

/**

* Run the migrations.

* @return void

public function up()

{

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

$table->increments('id');

$table->string('title');

$table->string('product_code');

$table->text('description');

$table->timestamps();

});

}

/**

* Reverse the migrations.

* @return void

public function down()

{

Schema::dropIfExists('products');

}

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

php artisan migrate

1	php artisan migrate

If you found any query builder error in command prompt go to => app\Providers\AppServiceProvider.php and put the below code here :

use Illuminate\Support\Facades\Schema;
  
 public function boot()
 {
     Schema::defaultStringLength(191);
 }

use Illuminate\Support\Facades\Schema;

public function boot()

{

Schema::defaultStringLength(191);

}

And then run this below command :

 php artisan migrate:fresh

1	php artisan migrate:fresh

Now, add the fillable property inside Product.php file.

<?php
 namespace App;
 use Illuminate\Database\Eloquent\Model;
 class Product extends Model
 {
     protected $fillable = [
     'title',
     'product_code',
     'description',
    ];
 }

<?php

namespace App;

use Illuminate\Database\Eloquent\Model;

class Product extends Model

{

protected $fillable = [

'title',

'product_code',

'description',

];

}

Step 4: Add Routes For CRUD Operation

After this, we need to define routes in “routes/web.php” file. Lets open “routes/web.php” file and add the following routes in it.

routes/web.php

<?php 
 
 Route::get('/', function () {
     return view('welcome');
 });
  
Route::resource('products', 'ProductController');

<?php

Route::get('/', function () {

return view('welcome');

});

Route::resource('products', 'ProductController');

Step 5: Create Resource CRUD Controller

In this step we will create a resource controller using following artisan command:

php artisan make:controller ProductController  --resource

1	php artisan make:controller ProductController --resource

The above command will create a contoller name ProductController and also inside by default seven methods like index, store, create, update, destroy, show, edit.

Next open controller, Go to app/HTTP/Controller/ProductController and update the below code into your controller file:

<?php
namespace App\Http\Controllers;
use App\Product;
use Illuminate\Http\Request;
use Redirect;
use PDF;
class ProductController extends Controller
{
/**
* Display a listing of the resource.
*
* @return \Illuminate\Http\Response
*/
public function index()
{
$data['products'] = Product::orderBy('id','desc')->paginate(10);
return view('product.list',$data);
}
/**
* Show the form for creating a new resource.
*
* @return \Illuminate\Http\Response
*/
public function create()
{
return view('product.create');
}
/**
* Store a newly created resource in storage.
*
* @param  \Illuminate\Http\Request  $request
* @return \Illuminate\Http\Response
*/
public function store(Request $request)
{
$request->validate([
'title' => 'required',
'product_code' => 'required',
'description' => 'required',
]);
Product::create($request->all());
return Redirect::to('products')
->with('success','Greate! Product created successfully.');
}
/**
* Display the specified resource.
*
* @param  \App\Product  $product
* @return \Illuminate\Http\Response
*/
public function show(Request $request)
{
}
/**
* Show the form for editing the specified resource.
*
* @param  \App\Product  $product
* @return \Illuminate\Http\Response
*/
public function edit($id)
{   
$where = array('id' => $id);
$data['product_info'] = Product::where($where)->first();
return view('product.edit', $data);
}
/**
* Update the specified resource in storage.
*
* @param  \Illuminate\Http\Request  $request
* @param  \App\Product  $product
* @return \Illuminate\Http\Response
*/
public function update(Request $request, $id)
{
$request->validate([
'title' => 'required',
'product_code' => 'required',
'description' => 'required',
]);
$update = ['title' => $request->title, 'description' => $request->description];
Product::where('id',$id)->update($update);
return Redirect::to('products')
->with('success','Great! Product updated successfully');
}
/**
* Remove the specified resource from storage.
*
* @param  \App\Product  $product
* @return \Illuminate\Http\Response
*/
public function destroy($id)
{
Product::where('id',$id)->delete();
return Redirect::to('products')->with('success','Product deleted successfully');
}
}

<?php

namespace App\Http\Controllers;

use App\Product;

use Illuminate\Http\Request;

use Redirect;

use PDF;

class ProductController extends Controller

{

/**

* Display a listing of the resource.

* @return \Illuminate\Http\Response

public function index()

{

$data['products'] = Product::orderBy('id','desc')->paginate(10);

return view('product.list',$data);

}

/**

* Show the form for creating a new resource.

* @return \Illuminate\Http\Response

public function create()

{

return view('product.create');

}

/**

* Store a newly created resource in storage.

* @param \Illuminate\Http\Request $request

* @return \Illuminate\Http\Response

public function store(Request $request)

{

$request->validate([

'title' => 'required',

'product_code' => 'required',

'description' => 'required',

]);

Product::create($request->all());

return Redirect::to('products')

->with('success','Greate! Product created successfully.');

}

/**

* Display the specified resource.

* @param \App\Product $product

* @return \Illuminate\Http\Response

public function show(Request $request)

{

}

/**

* Show the form for editing the specified resource.

* @param \App\Product $product

* @return \Illuminate\Http\Response

public function edit($id)

{

$where = array('id' => $id);

$data['product_info'] = Product::where($where)->first();

return view('product.edit', $data);

}

/**

* Update the specified resource in storage.

* @param \Illuminate\Http\Request $request

* @param \App\Product $product

* @return \Illuminate\Http\Response

public function update(Request $request, $id)

{

$request->validate([

'title' => 'required',

'product_code' => 'required',

'description' => 'required',

]);

$update = ['title' => $request->title, 'description' => $request->description];

Product::where('id',$id)->update($update);

return Redirect::to('products')

->with('success','Great! Product updated successfully');

}

/**

* Remove the specified resource from storage.

* @param \App\Product $product

* @return \Illuminate\Http\Response

public function destroy($id)

{

Product::where('id',$id)->delete();

return Redirect::to('products')->with('success','Product deleted successfully');

}

Step 6: Create the blade view

Create the product folder. After successfully create product folder , we will create following blade files for CRUD (Create, Retrieve, Update, Delete) operations.

Layout.blade.php
List.blade.php
Create.blade.php
Edit.blade.php

Layout.blade.php

<!DOCTYPE html>
<html>
<head>
<meta charset="UTF-8">
<meta name="viewport" content="width=device-width, initial-scale=1.0">
<meta http-equiv="X-UA-Compatible" content="ie=edge">
<meta name="csrf-token" content="{{ csrf_token() }}">
<title>Laravel CRUD Tutorial With Example</title>
<link href="//maxcdn.bootstrapcdn.com/bootstrap/4.1.1/css/bootstrap.min.css" rel="stylesheet" id="bootstrap-css">
<style>
body{
background-color: #25274d;
}
.container{
background: #ff9b00;
padding: 4%;
border-top-left-radius: 0.5rem;
border-bottom-left-radius: 0.5rem;
}
</style>
</head>
<body>
<div class="container">
<br><br><br>
@yield('content')
</div>
</body>
</html>

<!DOCTYPE html>

<html>

<head>

<title>Laravel CRUD Tutorial With Example</title>

<style>

body{

background-color: #25274d;

}

.container{

background: #ff9b00;

padding: 4%;

border-top-left-radius: 0.5rem;

border-bottom-left-radius: 0.5rem;

}

</style>

</head>

<body>

@yield('content')

</div>

</body>

</html>

List.blade.php

@extends('product.layout')
@section('content')
<a href="{{ route('products.create') }}" class="btn btn-success mb-2">Add</a> 
<br>
<div class="row">
<div class="col-12">
<table class="table table-bordered" id="laravel_crud">
<thead>
<tr>
<th>Id</th>
<th>Title</th>
<th>Product Code</th>
<th>Description</th>
<th>Created at</th>
<td colspan="2">Action</td>
</tr>
</thead>
<tbody>
@foreach($products as $product)
<tr>
<td>{{ $product->id }}</td>
<td>{{ $product->title }}</td>
<td>{{ $product->product_code }}</td>
<td>{{ $product->description }}</td>
<td>{{ date('Y-m-d', strtotime($product->created_at)) }}</td>
<td><a href="{{ route('products.edit',$product->id)}}" class="btn btn-primary">Edit</a></td>
<td>
<form action="{{ route('products.destroy', $product->id)}}" method="post">
{{ csrf_field() }}
@method('DELETE')
<button class="btn btn-danger" type="submit">Delete</button>
</form>
</td>
</tr>
@endforeach
</tbody>
</table>
{!! $products->links() !!}
</div> 
</div>
@endsection

@extends('product.layout')

@section('content')

<br>

<thead>

<tr>

<th>Title</th>

<th>Product Code</th>

<th>Description</th>

<th>Created at</th>

<td colspan="2">Action</td>

</tr>

</thead>

<tbody>

@foreach($products as $product)

<tr>

<td>{{ $product->id }}</td>

<td>{{ $product->title }}</td>

<td>{{ $product->product_code }}</td>

<td>{{ $product->description }}</td>

<td>{{ date('Y-m-d', strtotime($product->created_at)) }}</td>

<td><a href="{{ route('products.edit',$product->id)}}" class="btn btn-primary">Edit</a></td>

<td>

<form action="{{ route('products.destroy', $product->id)}}" method="post">

@method('DELETE')

<button class="btn btn-danger" type="submit">Delete</button>

</form>

</td>

</tr>

@endforeach

</tbody>

</table>

{!! $products->links() !!}

</div>

@endsection

Create.blade.php

@extends('product.layout')
@section('content')
<h2 style="margin-top: 12px;" class="text-center">Add Product</a></h2>
<br>
<form action="{{ route('products.store') }}" method="POST" name="add_product">
{{ csrf_field() }}
<div class="row">
<div class="col-md-12">
<div class="form-group">
<strong>Title</strong>
<input type="text" name="title" class="form-control" placeholder="Enter Title">
<span class="text-danger">{{ $errors->first('title') }}</span>
</div>
</div>
<div class="col-md-12">
<div class="form-group">
<strong>Product Code</strong>
<input type="text" name="product_code" class="form-control" placeholder="Enter Product Code">
<span class="text-danger">{{ $errors->first('product_code') }}</span>
</div>
</div>
<div class="col-md-12">
<div class="form-group">
<strong>Description</strong>
<textarea class="form-control" col="4" name="description" placeholder="Enter Description"></textarea>
<span class="text-danger">{{ $errors->first('description') }}</span>
</div>
</div>
<div class="col-md-12">
<button type="submit" class="btn btn-primary">Submit</button>
</div>
</div>
</form>
@endsection

@extends('product.layout')

@section('content')

<h2 style="margin-top: 12px;" class="text-center">Add Product</a></h2>

<br>

<strong>Title</strong>

<span class="text-danger">{{ $errors->first('title') }}</span>

</div>

<strong>Product Code</strong>

<span class="text-danger">{{ $errors->first('product_code') }}</span>

</div>

<strong>Description</strong>

<span class="text-danger">{{ $errors->first('description') }}</span>

</div>

<button type="submit" class="btn btn-primary">Submit</button>

</div>

</form>

@endsection

Edit.blade.php

@extends('product.layout')
@section('content')
<h2 style="margin-top: 12px;" class="text-center">Edit Product</a></h2>
<br>
<form action="{{ route('products.update', $product_info->id) }}" method="POST" name="update_product">
{{ csrf_field() }}
@method('PATCH')
<div class="row">
<div class="col-md-12">
<div class="form-group">
<strong>Title</strong>
<input type="text" name="title" class="form-control" placeholder="Enter Title" value="{{ $product_info->title }}">
<span class="text-danger">{{ $errors->first('title') }}</span>
</div>
</div>
<div class="col-md-12">
<div class="form-group">
<strong>Product Code</strong>
<input type="text" name="product_code" class="form-control" placeholder="Enter Product Code" value="{{ $product_info->product_code }}">
<span class="text-danger">{{ $errors->first('product_code') }}</span>
</div>
</div>
<div class="col-md-12">
<div class="form-group">
<strong>Description</strong>
<textarea class="form-control" col="4" name="description" placeholder="Enter Description" >{{ $product_info->description }}</textarea>
<span class="text-danger">{{ $errors->first('description') }}</span>
</div>
</div>
<div class="col-md-12">
<button type="submit" class="btn btn-primary">Submit</button>
</div>
</div>
</form>
@endsection

@extends('product.layout')

@section('content')

<h2 style="margin-top: 12px;" class="text-center">Edit Product</a></h2>

<br>

<form action="{{ route('products.update', $product_info->id) }}" method="POST" name="update_product">

@method('PATCH')

<strong>Title</strong>

<input type="text" name="title" class="form-control" placeholder="Enter Title" value="{{ $product_info->title }}">

<span class="text-danger">{{ $errors->first('title') }}</span>

</div>

<strong>Product Code</strong>

<input type="text" name="product_code" class="form-control" placeholder="Enter Product Code" value="{{ $product_info->product_code }}">

<span class="text-danger">{{ $errors->first('product_code') }}</span>

</div>

<strong>Description</strong>

<textarea class="form-control" col="4" name="description" placeholder="Enter Description" >{{ $product_info->description }}</textarea>

<span class="text-danger">{{ $errors->first('description') }}</span>

</div>

<button type="submit" class="btn btn-primary">Submit</button>

</div>

</form>

@endsection

Step 7: Run Development Server

Now we are ready to run our example so lets start the development server using following artisan command –

php artisan serve

1	php artisan serve

Now, open the following URL in browser to see the output –

http://localhost:8000/products

1	http://localhost:8000/products

Laravel 7/6 DataTable Ajax CRUD Example Tutorial

In this Laravel 7/6 Datatables CRUD operation example tutorial I’ll show you how to create a simple crud application using yajra Datatables in laravel 7/6. In this example we will learn how to create a simple crud operation application using Datatables in laravel 7/6. In this laravel 7/6 crud application we will be using jQuery and ajax to delete data from datatable crud app and MySQL database in laravel 7/6 app.

In this tutorial, you will learn to implement ajax based CRUD (Create, Read, Update and Delete) operations using datatable js. In this tutorial, we will be using yajra datatable package for listing of records with pagination, sorting and filter (search) feature.

Laravel 7/6 DataTable Ajax CRUD Example Tutorial

In this step by step guide, we will be creating a simple laravel 7/6 application to demonstrate you how to install yajra datatable package and implement ajax based CRUD operations with datatable js.

Step 1: Install Fresh laravel Setup
Step 2: Set database Credentials
Step 3: Create Migration And Model
Step 4: Install Yajra DataTables in App
Step 5: Create Route, Controller & Blade View
Step 6: Run Development Server
Step 7: Live Demo

Step 1: Install Fresh Laravel Setup

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

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

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

Step 2: Set database Credentials

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=here your database name here
 DB_USERNAME=here database username here
 DB_PASSWORD=here database password here

DB_CONNECTION=mysql

DB_HOST=127.0.0.1

DB_PORT=3306

DB_DATABASE=here your database name here

DB_USERNAME=here database username here

DB_PASSWORD=here database password here

Step 3: Create Migration And Model

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

php artisan nake:modal Product -m

1	php artisan nake:modal Product -m

Now go to database/migrations/ and open create_products_table.php file. Then put the following code into this file:

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

<?php

use Illuminate\Database\Migrations\Migration;

use Illuminate\Database\Schema\Blueprint;

use Illuminate\Support\Facades\Schema;

class CreateProductsTable extends Migration

{

/**

* Run the migrations.

* @return void

public function up()

{

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

$table->id();

$table->string('title');

$table->string('product_code');

$table->text('description');

$table->timestamps();

});

}

/**

* Reverse the migrations.

* @return void

public function down()

{

Schema::dropIfExists('products');

}

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

php artisan migrate

1	php artisan migrate

The above command will create tables in your database. Now, go to App directory and open Product.php file and then update the following code to into Product.php file as follow

app\Product.php

<?php
 
namespace App;
 
use Illuminate\Database\Eloquent\Model;
 
class Product extends Model
{
   protected $fillable = ['title','product_code','description','image'];
 
}

<?php

namespace App;

use Illuminate\Database\Eloquent\Model;

class Product extends Model

{

protected $fillable = ['title','product_code','description','image'];

}

Step 4: Install Yajra Datatables Package in Laravel

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' => [
 
 
 Yajra\Datatables\DatatablesServiceProvider::class,
 ],
 
 
 'aliases' => [
 
 
 'Datatables' => Yajra\Datatables\Facades\Datatables::class,
 ]

'providers' => [

Yajra\Datatables\DatatablesServiceProvider::class,

'aliases' => [

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

]

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

Step 5: Create (Controller, Route, Blade)

After this, we need to define routes in “routes/web.php” file. Lets open “routes/web.php” file and add the following routes in it.

routes/web.php

Route::get('product-list', 'ProductController@index');
 Route::get('product-list/{id}/edit', 'ProductController@edit');
 Route::post('product-list/store', 'ProductController@store');
 Route::get('product-list/delete/{id}', 'ProductController@destroy');

Route::get('product-list', 'ProductController@index');

Route::get('product-list/{id}/edit', 'ProductController@edit');

Route::post('product-list/store', 'ProductController@store');

Route::get('product-list/delete/{id}', 'ProductController@destroy');

2: Create Controller

Now, lets create a controller named ProductController using command given below –

php artisan make:controller ProductController

1	php artisan make:controller ProductController

Now, open app/Http/Controllers/ProductController.php and create some methods to add products, edit product and delete the product. In Product Controller, we need to create some methods:

Index()
Store()
Edit()
Destroy()

Index() method

public function index()
{
    if(request()->ajax()) {
        return datatables()->of(Product::select('*'))
        ->addColumn('action', 'action')
        ->rawColumns(['action'])
        ->addIndexColumn()
        ->make(true);
    }
    return view('list');
}

public function index()

{

if(request()->ajax()) {

return datatables()->of(Product::select('*'))

->addColumn('action', 'action')

->rawColumns(['action'])

->addIndexColumn()

->make(true);

}

return view('list');

}

Store() Method

public function store(Request $request)
{  
    $productId = $request->product_id;
    $product   =   Product::updateOrCreate(['id' => $productId],
                ['title' => $request->title, 'product_code' => $request->product_code, 'description' => $request->description]);        
    return Response::json($product);
}

public function store(Request $request)

{

$productId = $request->product_id;

$product = Product::updateOrCreate(['id' => $productId],

['title' => $request->title, 'product_code' => $request->product_code, 'description' => $request->description]);

return Response::json($product);

}

Edit() Method

public function edit($id)
{   
    $where = array('id' => $id);
    $product  = Product::where($where)->first();
  
    return Response::json($product);
}

public function edit($id)

{

$where = array('id' => $id);

$product = Product::where($where)->first();

return Response::json($product);

}

Delete() Method

public function destroy($id)
{
    $product = Product::where('id',$id)->delete();
  
    return Response::json($product);
}

public function destroy($id)

{

$product = Product::where('id',$id)->delete();

return Response::json($product);

}

Now, update all methods into your ProductController.php file as follow:

<?php
  
namespace App\Http\Controllers;
  
use App\Product;
use Illuminate\Http\Request;
use Redirect,Response;
  
class ProductController extends Controller
{
/**
 * Display a listing of the resource.
 *
 * @return \Illuminate\Http\Response
 */
public function index()
{
    if(request()->ajax()) {
        return datatables()->of(Product::select('*'))
        ->addColumn('action', 'action')
        ->rawColumns(['action'])
        ->addIndexColumn()
        ->make(true);
    }
    return view('list');
}
  
  
/**
 * Store a newly created resource in storage.
 *
 * @param  \Illuminate\Http\Request  $request
 * @return \Illuminate\Http\Response
 */
public function store(Request $request)
{  
    $productId = $request->product_id;
    $product   =   Product::updateOrCreate(['id' => $productId],
                ['title' => $request->title, 'product_code' => $request->product_code, 'description' => $request->description]);        
    return Response::json($product);
}
  
  
/**
 * Show the form for editing the specified resource.
 *
 * @param  \App\Product  $product
 * @return \Illuminate\Http\Response
 */
public function edit($id)
{   
    $where = array('id' => $id);
    $product  = Product::where($where)->first();
  
    return Response::json($product);
}
  
  
/**
 * Remove the specified resource from storage.
 *
 * @param  \App\Product  $product
 * @return \Illuminate\Http\Response
 */
public function destroy($id)
{
    $product = Product::where('id',$id)->delete();
  
    return Response::json($product);
}
}

<?php

namespace App\Http\Controllers;

use App\Product;

use Illuminate\Http\Request;

use Redirect,Response;

class ProductController extends Controller

{

/**

* Display a listing of the resource.

* @return \Illuminate\Http\Response

public function index()

{

if(request()->ajax()) {

return datatables()->of(Product::select('*'))

->addColumn('action', 'action')

->rawColumns(['action'])

->addIndexColumn()

->make(true);

}

return view('list');

}

/**

* Store a newly created resource in storage.

* @param \Illuminate\Http\Request $request

* @return \Illuminate\Http\Response

public function store(Request $request)

{

$productId = $request->product_id;

$product = Product::updateOrCreate(['id' => $productId],

['title' => $request->title, 'product_code' => $request->product_code, 'description' => $request->description]);

return Response::json($product);

}

/**

* Show the form for editing the specified resource.

* @param \App\Product $product

* @return \Illuminate\Http\Response

public function edit($id)

{

$where = array('id' => $id);

$product = Product::where($where)->first();

return Response::json($product);

}

/**

* Remove the specified resource from storage.

* @param \App\Product $product

* @return \Illuminate\Http\Response

public function destroy($id)

{

$product = Product::where('id',$id)->delete();

return Response::json($product);

}

3: Create Blade View

Create a Button view

Now, we will create action.blade.php file. This file contains a two-button name edit and delete. So you can update the below code in your action button file.

<a href="javascript:void(0)" data-toggle="tooltip"  data-id="{{ $id }}" data-original-title="Edit" class="edit btn btn-success edit-product">
    Edit
</a>
<a href="javascript:void(0);" id="delete-product" data-toggle="tooltip" data-original-title="Delete" data-id="{{ $id }}" class="delete btn btn-danger">
    Delete
</a>

Edit

</a>

Delete

</a>

Next, create a list.blade.php file in resources/views/ folder and update the below code in your product list file.

<!DOCTYPE html>
<html lang="en">
<head>
<!-- CSRF Token -->
<meta name="csrf-token" content="{{ csrf_token() }}">
<title>Laravel DataTable Ajax Crud 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">
<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>
</head>
<body>
<div class="container">
<h2>Laravel DataTable Ajax Crud Tutorial</h2>
<br>
<a href="https://www.yoursite.com/how-to-install-yajra-datatables-in-laravel/" class="btn btn-secondary">Back to Post</a>
<a href="javascript:void(0)" class="btn btn-info ml-3" id="create-new-product">Add New</a>
<br><br>
<table class="table table-bordered table-striped" id="laravel_datatable">
<thead>
<tr>
<th>ID</th>
<th>S. No</th>
<th>Title</th>
<th>Product Code</th>
<th>Description</th>
<th>Created at</th>
<th>Action</th>
</tr>
</thead>
</table>
</div>
<div class="modal fade" id="ajax-product-modal" aria-hidden="true">
<div class="modal-dialog">
<div class="modal-content">
<div class="modal-header">
<h4 class="modal-title" id="productCrudModal"></h4>
</div>
<div class="modal-body">
<form id="productForm" name="productForm" class="form-horizontal">
<input type="hidden" name="product_id" id="product_id">
<div class="form-group">
<label for="name" class="col-sm-2 control-label">Title</label>
<div class="col-sm-12">
<input type="text" class="form-control" id="title" name="title" placeholder="Enter Tilte" value="" maxlength="50" required="">
</div>
</div> 
<div class="form-group">
<label for="name" class="col-sm-2 control-label">Product Code</label>
<div class="col-sm-12">
<input type="text" class="form-control" id="product_code" name="product_code" placeholder="Enter Tilte" value="" maxlength="50" required="">
</div>
</div>
<div class="form-group">
<label class="col-sm-2 control-label">Description</label>
<div class="col-sm-12">
<input type="text" class="form-control" id="description" name="description" placeholder="Enter Description" value="" required="">
</div>
</div>
<div class="col-sm-offset-2 col-sm-10">
<button type="submit" class="btn btn-primary" id="btn-save" value="create">Save changes
</button>
</div>
</form>
</div>
<div class="modal-footer">
</div>
</div>
</div>
</div>
</body>
</html>

<!DOCTYPE html>

<head>

<title>Laravel DataTable Ajax Crud Tutorial</title>

</head>

<body>

<h2>Laravel DataTable Ajax Crud Tutorial</h2>

<br>

<thead>

<tr>

<th>Title</th>

<th>Product Code</th>

<th>Description</th>

<th>Created at</th>

<th>Action</th>

</tr>

</thead>

</table>

</div>

</div>

<label for="name" class="col-sm-2 control-label">Title</label>

</div>

<label for="name" class="col-sm-2 control-label">Product Code</label>

</div>

<label class="col-sm-2 control-label">Description</label>

</div>

<button type="submit" class="btn btn-primary" id="btn-save" value="create">Save changes

</button>

</div>

</form>

</div>

</div>

</body>

</html>

Script Code

<script>
var SITEURL = '{{URL::to('/')}}';
$(document).ready( function () {
$.ajaxSetup({
headers: {
'X-CSRF-TOKEN': $('meta[name="csrf-token"]').attr('content')
}
});
$('#laravel_datatable').DataTable({
processing: true,
serverSide: true,
ajax: {
url: SITEURL + "product-list",
type: 'GET',
},
columns: [
{data: 'id', name: 'id', 'visible': false},
{data: 'DT_RowIndex', name: 'DT_RowIndex', orderable: false,searchable: false},
{ data: 'title', name: 'title' },
{ data: 'product_code', name: 'product_code' },
{ data: 'description', name: 'description' },
{ data: 'created_at', name: 'created_at' },
{data: 'action', name: 'action', orderable: false},
],
order: [[0, 'desc']]
});
/*  When user click add user button */
$('#create-new-product').click(function () {
$('#btn-save').val("create-product");
$('#product_id').val('');
$('#productForm').trigger("reset");
$('#productCrudModal').html("Add New Product");
$('#ajax-product-modal').modal('show');
});
/* When click edit user */
$('body').on('click', '.edit-product', function () {
var product_id = $(this).data('id');
$.get('product-list/' + product_id +'/edit', function (data) {
$('#title-error').hide();
$('#product_code-error').hide();
$('#description-error').hide();
$('#productCrudModal').html("Edit Product");
$('#btn-save').val("edit-product");
$('#ajax-product-modal').modal('show');
$('#product_id').val(data.id);
$('#title').val(data.title);
$('#product_code').val(data.product_code);
$('#description').val(data.description);
})
});
$('body').on('click', '#delete-product', function () {
var product_id = $(this).data("id");
if(confirm("Are You sure want to delete !")){
$.ajax({
type: "get",
url: SITEURL + "product-list/delete/"+product_id,
success: function (data) {
var oTable = $('#laravel_datatable').dataTable(); 
oTable.fnDraw(false);
},
error: function (data) {
console.log('Error:', data);
}
});
}
}); 
});
if ($("#productForm").length > 0) {
$("#productForm").validate({
submitHandler: function(form) {
var actionType = $('#btn-save').val();
$('#btn-save').html('Sending..');
$.ajax({
data: $('#productForm').serialize(),
url: SITEURL + "product-list/store",
type: "POST",
dataType: 'json',
success: function (data) {
$('#productForm').trigger("reset");
$('#ajax-product-modal').modal('hide');
$('#btn-save').html('Save Changes');
var oTable = $('#laravel_datatable').dataTable();
oTable.fnDraw(false);
},
error: function (data) {
console.log('Error:', data);
$('#btn-save').html('Save Changes');
}
});
}
})
}
</script>

var SITEURL = '{{URL::to('/')}}';

$(document).ready( function () {

$.ajaxSetup({

headers: {

'X-CSRF-TOKEN': $('meta[name="csrf-token"]').attr('content')

}

});

$('#laravel_datatable').DataTable({

processing: true,

serverSide: true,

ajax: {

url: SITEURL + "product-list",

type: 'GET',

columns: [

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

{data: 'DT_RowIndex', name: 'DT_RowIndex', orderable: false,searchable: false},

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

{ data: 'product_code', name: 'product_code' },

{ data: 'description', name: 'description' },

{ data: 'created_at', name: 'created_at' },

{data: 'action', name: 'action', orderable: false},

order: [[0, 'desc']]

});

/* When user click add user button */

$('#create-new-product').click(function () {

$('#btn-save').val("create-product");

$('#product_id').val('');

$('#productForm').trigger("reset");

$('#productCrudModal').html("Add New Product");

$('#ajax-product-modal').modal('show');

});

/* When click edit user */

$('body').on('click', '.edit-product', function () {

var product_id = $(this).data('id');

$.get('product-list/' + product_id +'/edit', function (data) {

$('#title-error').hide();

$('#product_code-error').hide();

$('#description-error').hide();

$('#productCrudModal').html("Edit Product");

$('#btn-save').val("edit-product");

$('#ajax-product-modal').modal('show');

$('#product_id').val(data.id);

$('#title').val(data.title);

$('#product_code').val(data.product_code);

$('#description').val(data.description);

})

});

$('body').on('click', '#delete-product', function () {

var product_id = $(this).data("id");

if(confirm("Are You sure want to delete !")){

$.ajax({

type: "get",

url: SITEURL + "product-list/delete/"+product_id,

success: function (data) {

var oTable = $('#laravel_datatable').dataTable();

oTable.fnDraw(false);

error: function (data) {

console.log('Error:', data);

}

});

}

});

if ($("#productForm").length > 0) {

$("#productForm").validate({

submitHandler: function(form) {

var actionType = $('#btn-save').val();

$('#btn-save').html('Sending..');

$.ajax({

data: $('#productForm').serialize(),

url: SITEURL + "product-list/store",

type: "POST",

dataType: 'json',

success: function (data) {

$('#productForm').trigger("reset");

$('#ajax-product-modal').modal('hide');

$('#btn-save').html('Save Changes');

var oTable = $('#laravel_datatable').dataTable();

oTable.fnDraw(false);

error: function (data) {

console.log('Error:', data);

$('#btn-save').html('Save Changes');

}

});

}

})

}

</script>

Step 6: Run Development Server

Now we are ready to run our example so lets start the development server using following artisan command –

php artisan serve

1	php artisan serve

Now, open the following URL in browser to see the output –

http://localhost:8000/product-list

1	http://localhost:8000/product-list

Laravel 7/6 Paytm Payment Gateway Integration

In this Laravel 7/6 Paytm Payment Gateway Integration Example tutorial, I’ll show you how to integrate Paytm payment gateway in laravel 7/6. In this tutorial you will learn to integrate Paytm in laravel 7/6. In this step by step tutorial I’ll share laravel 7/6 Paytm integration example.

Paytm Payment Gateway

Paytm is one of the popular payment gateway, that allows us to accept payment from your customer. Paytm is very simple, hassle free and easy to integrate payment gateway. Integrating Paytm payment gateway in laravel 7/6 is a breeze.

Laravel 7/6 Paytm Payment Gateway Integration

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

Install laravel fresh Setup
Configuration .env file
Install Anandsiddharth paytm package
Generate Migration and Create Model
Make Route
Create Controller
Create Blade View file
Start Development Server
Conclusion

Install laravel Fresh Project

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

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

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

Configuration in .env

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=your database name here
 DB_USERNAME=database username here
 DB_PASSWORD=database password here

DB_CONNECTION=mysql

DB_HOST=127.0.0.1

DB_PORT=3306

DB_DATABASE=your database name here

DB_USERNAME=database username here

DB_PASSWORD=database password here

Install Anandsiddharth paytm package

Now, we need to install Anandsiddharth paytm package in our project. Open your terminal and switch to project directory and use the following composer command to install Anandsiddharth paytm package.

composer require anandsiddharth/laravel-paytm-wallet

1	composer require anandsiddharth/laravel-paytm-wallet

After installing the package, we need to register the provider and alias. Go to the app/config/app.php and put the below lines here :

'providers' => [
     // Other service providers…
     Anand\LaravelPaytmWallet\PaytmWalletServiceProvider::class,
 ],
 'aliases' => [
     // Other aliases
     'PaytmWallet' => Anand\LaravelPaytmWallet\Facades\PaytmWallet::class,
 ],

'providers' => [

// Other service providers…

Anand\LaravelPaytmWallet\PaytmWalletServiceProvider::class,

'aliases' => [

// Other aliases

'PaytmWallet' => Anand\LaravelPaytmWallet\Facades\PaytmWallet::class,

Now we need to set a paytm credential as following. Go to the app/config/services.php and set the paytm credential

'paytm-wallet' => [
     'env' => 'production', // values : (local | production)
     'merchant_id' => 'YOUR_MERCHANT_ID',
     'merchant_key' => 'YOUR_MERCHANT_KEY',
     'merchant_website' => 'YOUR_WEBSITE',
     'channel' => 'YOUR_CHANNEL',
     'industry_type' => 'YOUR_INDUSTRY_TYPE',
 ],

'paytm-wallet' => [

'env' => 'production', // values : (local | production)

'merchant_id' => 'YOUR_MERCHANT_ID',

'merchant_key' => 'YOUR_MERCHANT_KEY',

'merchant_website' => 'YOUR_WEBSITE',

'channel' => 'YOUR_CHANNEL',

'industry_type' => 'YOUR_INDUSTRY_TYPE',

Generate Migration and Create Model

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

php artisan make:model Event -m

1	php artisan make:model Event -m

The above command will create a model name Event and also create a migration file for the events table. After that go to database/migrations file and put the below here :

<?php 
   
use Illuminate\Support\Facades\Schema; 
use Illuminate\Database\Schema\Blueprint; 
use Illuminate\Database\Migrations\Migration; 
    
class CreateEventsTable extends Migration 
{ 
    /** 
     * Run the migrations. 
     * 
     * @return void 
     */
    public function up() 
    { 
        Schema::create('products', function (Blueprint $table) { 
            $table->increments('id'); 
            $table->string('name');
            $table->string('mobile_number');
            $table->integer('amount');
            $table->string('order_id');
            $table->string('status')->default('pending');
            $table->string('transaction_id')->default(0);
            $table->timestamps(); 
        }); 
    } 
    
    /** 
     * Reverse the migrations. 
     * 
     * @return void 
     */
    public function down() 
    { 
        Schema::dropIfExists('events'); 
    } 
}

<?php

use Illuminate\Support\Facades\Schema;

use Illuminate\Database\Schema\Blueprint;

use Illuminate\Database\Migrations\Migration;

class CreateEventsTable extends Migration

{

/**

* Run the migrations.

* @return void

public function up()

{

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

$table->increments('id');

$table->string('name');

$table->string('mobile_number');

$table->integer('amount');

$table->string('order_id');

$table->string('status')->default('pending');

$table->string('transaction_id')->default(0);

$table->timestamps();

});

}

/**

* Reverse the migrations.

* @return void

public function down()

{

Schema::dropIfExists('events');

}

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

php artisan migrate

1	php artisan migrate

Now, add the fillable property inside the Event.php file.

<?php
  
namespace App;
  
use Illuminate\Database\Eloquent\Model;
  
class Note extends Model
{
  protected $fillable = ['name','mobile_number',
                         'amount','status',
                       'order_id','transaction_id'];
}

<?php

namespace App;

use Illuminate\Database\Eloquent\Model;

class Note extends Model

{

protected $fillable = ['name','mobile_number',

'amount','status',

'order_id','transaction_id'];

}

Make Route

After this, we need to define routes in “routes/web.php” file. Lets open “routes/web.php” file and add the following routes in it.

routes/web.php

<?php 
 
Route::get('event', 'EventController@bookEvent');
Route::post('payment', 'EventController@eventOrderGen');
Route::post('payment/status', 'EventController@paymentCallback');

<?php

Route::get('event', 'EventController@bookEvent');

Route::post('payment', 'EventController@eventOrderGen');

Route::post('payment/status', 'EventController@paymentCallback');

Create Controller

Now, lets create a controller named EventController using command given below –

php artisan make:controller EventController

1	php artisan make:controller EventController

Go to app/HTTP/Controller/EventController and put the below code :

<?php
 
 
namespace App\Http\Controllers;
 
use Illuminate\Http\Request;
use App\Event;
use PaytmWallet;
 
 
class EventController extends Controller
{
 
 
    /**
     * Redirect the user to the Payment Gateway.
     *
     * @return Response
     */
    public function bookEvent()
    {
        return view('book_event');
    }
 
 
    /**
     * Redirect the user to the Payment Gateway.
     *
     * @return Response
     */
    public function eventOrderGen(Request $request)
    {
     $this->validate($request, [
          'name' => 'required',
          'mobile_no' =>'required|numeric|digits:10|unique:events,mobile_number',
        ]);
 
        $input = $request->all();
        $input['order_id'] = rand(1111,9999);
        $input['amount'] = 50;
 
        Event::insert($input);
 
        $payment = PaytmWallet::with('receive');
        $payment->prepare([
          'order' => $input['order_id'],
          'user' => 'user id',
          'mobile_number' => $request->mobile_number,
          'email' => $request->email,
          'amount' => $input['amount'],
          'callback_url' => url('payment/status')
        ]);
        return $payment->receive();
    }
 
    /**
     * Obtain the payment information.
     *
     * @return Object
     */
    public function paymentCallback()
    {
        $transaction = PaytmWallet::with('receive');
 
        $response = $transaction->response();
 
        if($transaction->isSuccessful()){
          Event::where('order_id',$response['ORDERID'])->update(['status'=>'success', 'payment_id'=>$response['TXNID']]);
 
          dd('Payment Successfully Credited.');
 
        }else if($transaction->isFailed()){
          Event::where('order_id',$order_id)->update(['status'=>'failed', 'payment_id'=>$response['TXNID']]);
          dd('Payment Failed. Try again lator');
        }
    }    
}

<?php

namespace App\Http\Controllers;

use Illuminate\Http\Request;

use App\Event;

use PaytmWallet;

class EventController extends Controller

{

/**

* Redirect the user to the Payment Gateway.

* @return Response

public function bookEvent()

{

return view('book_event');

}

/**

* Redirect the user to the Payment Gateway.

* @return Response

public function eventOrderGen(Request $request)

{

$this->validate($request, [

'name' => 'required',

'mobile_no' =>'required|numeric|digits:10|unique:events,mobile_number',

]);

$input = $request->all();

$input['order_id'] = rand(1111,9999);

$input['amount'] = 50;

Event::insert($input);

$payment = PaytmWallet::with('receive');

$payment->prepare([

'order' => $input['order_id'],

'user' => 'user id',

'mobile_number' => $request->mobile_number,

'email' => $request->email,

'amount' => $input['amount'],

'callback_url' => url('payment/status')

]);

return $payment->receive();

}

/**

* Obtain the payment information.

* @return Object

public function paymentCallback()

{

$transaction = PaytmWallet::with('receive');

$response = $transaction->response();

if($transaction->isSuccessful()){

Event::where('order_id',$response['ORDERID'])->update(['status'=>'success', 'payment_id'=>$response['TXNID']]);

dd('Payment Successfully Credited.');

}else if($transaction->isFailed()){

Event::where('order_id',$order_id)->update(['status'=>'failed', 'payment_id'=>$response['TXNID']]);

dd('Payment Failed. Try again lator');

}

Create Blade View file

Now, we need to create blade views file, Go to app/resources/views/ and create one file name event.blade.php :

<!DOCTYPE html>
<html>
<head>
<meta charset="UTF-8">
<meta name="viewport" content="width=device-width, initial-scale=1.0">
<meta http-equiv="X-UA-Compatible" content="ie=edge">
<meta name="csrf-token" content="{{ csrf_token() }}">
<title>Paytm Payment Gateway Integrate</title>
<link href="https://cdnjs.cloudflare.com/ajax/libs/twitter-bootstrap/4.0.0-alpha/css/bootstrap.css" rel="stylesheet">
<style>
.mt40{
margin-top: 40px;
}
</style>
</head>
<body>
<div class="container">
<div class="row">
<div class="col-lg-12 mt40">
<div class="card-header" style="background: #0275D8;">
<h2>Register for Event</h2>
</div>
</div>
</div>
@if ($errors->any())
<div class="alert alert-danger">
<strong>Whoops!</strong> Something went wrong<br>
<ul>
@foreach ($errors->all() as $error)
<li>{{ $error }}</li>
@endforeach
</ul>
</div>
@endif
<form action="{{ url('payment') }}" method="POST" name="paytm">
{{ csrf_field() }}
<div class="row">
<div class="col-md-12">
<div class="form-group">
<strong>Name</strong>
<input type="text" name="name" class="form-control" placeholder="Enter Name">
</div>
</div>
<div class="col-md-12">
<div class="form-group">
<strong>Mobile Number</strong>
<input type="text" name="mobile_number" class="form-control" placeholder="Enter Mobile Number">
</div>
</div>
<div class="col-md-12">
<div class="form-group">
<strong>Email Id</strong>
<input type="text" name="email" class="form-control" placeholder="Enter Email id">
</div>
</div>
<div class="col-md-12">
<div class="form-group">
<strong>Event Fees</strong>
<input type="text" name="amount" class="form-control" placeholder="" value="100" readonly="">
</div>
</div>
<div class="col-md-12">
<button type="submit" class="btn btn-primary">Submit</button>
</div>
</div>
</form>
</div>
</body>
</html>

<!DOCTYPE html>

<html>

<head>

<title>Paytm Payment Gateway Integrate</title>

<style>

.mt40{

margin-top: 40px;

}

</style>

</head>

<body>

<h2>Register for Event</h2>

</div>

@if ($errors->any())

<strong>Whoops!</strong> Something went wrong<br>

<ul>

@foreach ($errors->all() as $error)

<li>{{ $error }}</li>

@endforeach

</ul>

</div>

@endif

</div>

<strong>Mobile Number</strong>

</div>

<strong>Email Id</strong>

</div>

<strong>Event Fees</strong>

</div>

<button type="submit" class="btn btn-primary">Submit</button>

</div>

</form>

</div>

</body>

</html>

Start Development Server

Now we are ready to run our example so lets start the development server using following artisan command –

php artisan serve

1	php artisan serve

Now, open the following URL in browser to see the output –

http://localhost:8000/event

Or direct hit in your browser

http://localhost/blog/public/event

Or direct hit in your browser

http://localhost/blog/public/event

Testing Card Credential

Card No : 4242424242424242
 Month : any future month
 Year : any future Year
 CVV : 123
 Password : 123123

Card No : 4242424242424242

Month : any future month

Year : any future Year

CVV : 123

Password : 123123

Laravel 7/6 Generate Fake Data Using Faker Example

In this Laravel 7/6 Generate Fake Data Using Faker Example tutorial, I will show you how to generate fake data using laravel faker. In this tutorial you will learn to generate fake or dummy data in a database table using faker in laravel project. While working with any web application using laravel we come situations where we need some dummy or test data to available in database. Laravel faker makes this job much easier using laravel faker we can generate fake data into the database table.

Laravel 7/6 Generate Fake Data Using Faker Example

In this tutorial, you will learn how to generate fake data into the database tables using laravel faker. Please follow the instruction give below:

Step 1: Download Fresh Laravel Setup
Step 2: Setup Database Credential
Step 3: Run Migration Command
Step 4: Create a Model & Migration File
Step 5: Create New Factory File
Step 6: Generate Fake Data Using Tinker
Step 7: Generate Fake Data Using Seeder

Step 1: Download Fresh Laravel Setup

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

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

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

Step 2: Setup Database Credential

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=here your database name here
 DB_USERNAME=here database username here
 DB_PASSWORD=here database password here

DB_CONNECTION=mysql

DB_HOST=127.0.0.1

DB_PORT=3306

DB_DATABASE=here your database name here

DB_USERNAME=here database username here

DB_PASSWORD=here database password here

Step 3: Run Migration Command

In this step we will run following command to migrate database schema.

php artisan migrate

1	php artisan migrate

Step 4: Create a Model & Migration File

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

 php artisan make:model Notes -m

1	php artisan make:model Notes -m

Let’s go to the app/Notes.php and put the below code in your files.

<?php
namespace App;
use Illuminate\Database\Eloquent\Model;
class Note extends Model
{
    /**
     * The attributes that are mass assignable.
     *
     * @var array
     */
    protected $fillable = [
        'title', 'description',
    ];
}

<?php

namespace App;

use Illuminate\Database\Eloquent\Model;

class Note extends Model

{

/**

* The attributes that are mass assignable.

* @var array

protected $fillable = [

'title', 'description',

];

}

Next, go to database/migrations/2019_02_19_012129_create_notes_table.php and replace the below code into your file.

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

<?php

use Illuminate\Support\Facades\Schema;

use Illuminate\Database\Schema\Blueprint;

use Illuminate\Database\Migrations\Migration;

class CreateNotesTable extends Migration

{

/**

* Run the migrations.

* @return void

public function up()

{

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

$table->bigIncrements('id');

$table->string('title');

$table->text('description');

$table->timestamps();

});

}

/**

* Reverse the migrations.

* @return void

public function down()

{

Schema::dropIfExists('notes');

}

Step 5: Create New Factory File

In this step, we will create a factory file. Go to app/database/factories and inside this folder, we need to create a new file name NoteFactory.php and put the below code into your file.

<?php

/** @var \Illuminate\Database\Eloquent\Factory $factory */
use App\Note;
use Illuminate\Support\Str;
use Faker\Generator as Faker;

/*
|--------------------------------------------------------------------------
| Model Factories
|--------------------------------------------------------------------------
|
| This directory should contain each of the model factory definitions for
| your application. Factories provide a convenient way to generate new
| model instances for testing / seeding your application's database.
|
*/

$factory->define(Note::class, function (Faker $faker) {
    return [
        'title' => $faker->sentence($nbWords = 6, $variableNbWords = true),  // Random task title
        'description' => $faker->text(), // Random task description
    ];
});

<?php

/** @var \Illuminate\Database\Eloquent\Factory $factory */

use App\Note;

use Illuminate\Support\Str;

use Faker\Generator as Faker;

|--------------------------------------------------------------------------

| Model Factories

|--------------------------------------------------------------------------

| This directory should contain each of the model factory definitions for

| your application. Factories provide a convenient way to generate new

| model instances for testing / seeding your application's database.

$factory->define(Note::class, function (Faker $faker) {

return [

'title' => $faker->sentence($nbWords = 6, $variableNbWords = true), // Random task title

'description' => $faker->text(), // Random task description

];

});

Step 6: Generate Fake Data Using Tinker

Please use the following command to generate fake data using tinker:

php artisan tinker

1	php artisan tinker

Now, run following command to generate 100 rows of random Notes.

factory(App\Note::class,100)->create();

1	factory(App\Note::class,100)->create();

Step 7: Generate Fake Data Using Seeder

Let’s create seeder for Note using below artisan command.

php artisan make:seeder NoteTableSeeder

1	php artisan make:seeder NoteTableSeeder

The above command will generate NoteTableSeeder.php file in the database/seeds directory. Open NoteTableSeeder.php and update code shown as below.

<?php
use Illuminate\Database\Seeder;
class NoteTableSeeder extends Seeder
{
    /**
     * Run the database seeds.
     *
     * @return void
     */
    public function run()
    {
        factory(App\Note::class, 100)->create();
    }
}

<?php

use Illuminate\Database\Seeder;

class NoteTableSeeder extends Seeder

{

/**

* Run the database seeds.

* @return void

public function run()

{

factory(App\Note::class, 100)->create();

}

Next step, we will declare NoteTableSeeder inside the DatabaseSeeder. The file is DatabaseSeeder located app/database/seeds.

DatabaseSeeder.php

<?php

use Illuminate\Database\Seeder;

class DatabaseSeeder extends Seeder
{
    /**
     * Seed the application's database.
     *
     * @return void
     */
    public function run()
    {
        $this->call(NoteTableSeeder::class);
    }
}

<?php

use Illuminate\Database\Seeder;

class DatabaseSeeder extends Seeder

{

/**

* Seed the application's database.

* @return void

public function run()

{

$this->call(NoteTableSeeder::class);

}

Now, run the following command to generate 100 fake rows in the Note table.

php artisan db:seed

1	php artisan db:seed

Please check the database now for test data.

Laravel 7/6 Socialite Google Login Example

In this Login with google in Laravel 7/6 example tutorial I’ll show you how to integrate google login in laravel 7/6 using socialite package. Integrating google login in Laravel 7/6 using socialite package is much easier. Allowing users to login with their social media accounts makes registration/login process much easier, it also encourages more users to register for your application.

In this step by step tutorial, you will learn to integrate google login with your laravel 7/6 application. Please follow the steps give below:

Install laravel App
Add Database Details
Install Socialite Package For Google Login
Create Google App
Set Google App Details
Add Routes
Generate Auth Files By Artisan
Create Controller
Add Socialite Google Login Button In Blade Views
Run Development Server

Step1: Install laravel App

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

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

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

Step 2: Add Database Details

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=here your database name here
 DB_USERNAME=here database username here
 DB_PASSWORD=here database password here

DB_CONNECTION=mysql

DB_HOST=127.0.0.1

DB_PORT=3306

DB_DATABASE=here your database name here

DB_USERNAME=here database username here

DB_PASSWORD=here database password here

In this step we will Install Socialite Package via Composer using following command:

composer require laravel/socialite

1	composer require laravel/socialite

Now, Navigate to config directory and open app.php file. Then add aliese and provider app.php:

'providers' => [
     // Other service providers…
 Laravel\Socialite\SocialiteServiceProvider::class,
],

'aliases' => [
// Other aliases…
'Socialite' => Laravel\Socialite\Facades\Socialite::class,
],

'providers' => [

// Other service providers…

Laravel\Socialite\SocialiteServiceProvider::class,

'aliases' => [

// Other aliases…

'Socialite' => Laravel\Socialite\Facades\Socialite::class,

Step 4: Create Google App

Step 1:-
Visit Google Developer Console. And create a new project
Step 2:-
Please fill up the required information.
Step 3:-
After creating new project you need to select the created projects on the top menu. Then click on OAuth consent screen and select the given option according to your requirement:
Step 4:-
Next, you need to provide your website URL, privacy policy URL, etc.
Step 5:-
Click on left side menu credentials then select OAuth client ID.
Step 6:-
After that, the below form will be apper. Please select Web application from application type options. Once you have select Web application option, then one form will appear on web page. Here you have to define Name and you have also define Authorized redirect URIs field and lastly click on Create button.
Step 7:-
Once you have click on the create button, then you can get your Client ID and your client secret key.

Step 5: Add Google App Details

Now, we need to add google app details with redirect url. So, go to the config directory and open service.php file. And add the google client id, secret and redirect url in service.php file:

 'google' => [
    'client_id' => 'xxxx',
    'client_secret' => 'xxx',
    'redirect' => 'http://127.0.0.1:8000/callback/google',
  ],

'google' => [

'client_id' => 'xxxx',

'client_secret' => 'xxx',

'redirect' => 'http://127.0.0.1:8000/callback/google',

After that, open User.php model and add the following properties into User.php model file:

protected $fillable = [
         'name', 'email', 'password', 'provider', 'provider_id'
     ];

protected $fillable = [

'name', 'email', 'password', 'provider', 'provider_id'

];

Now, go to app/database folder and open create_users_table.php. And add the following code into your create_users_table.php file:

public function up()
{
Schema::create('users', function (Blueprint $table) {
    $table->increments('id');
    $table->string('name');
    $table->string('email')->unique()->nullable();
    $table->string('provider');
    $table->string('provider_id');
    $table->timestamp('email_verified_at')->nullable();
    $table->string('password')->nullable();
    $table->rememberToken()->nullable();
    $table->timestamps();
});
}

public function up()

{

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

$table->increments('id');

$table->string('name');

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

$table->string('provider');

$table->string('provider_id');

$table->timestamp('email_verified_at')->nullable();

$table->string('password')->nullable();

$table->rememberToken()->nullable();

$table->timestamps();

});

}

Before you run PHP artisan migrate command, Navigate to go to app/providers folder and open AppServiceProvider.php file. And add the following code into your AppServiceProvider.php file:

...
use Illuminate\Support\Facades\Schema;
 
....
function boot()
{
    Schema::defaultStringLength(191);
}
...

...

use Illuminate\Support\Facades\Schema;

....

function boot()

{

Schema::defaultStringLength(191);

}

...

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

php artisan migrate

1	php artisan migrate

Step 6: Generate Auth File By Artisan

Install Laravel UI

composer require laravel/ui

1	composer require laravel/ui

Create Auth

php artisan ui bootstrap --auth

1	php artisan ui bootstrap --auth

NPM Install

npm install

1	npm install

Step 7: Add Routes

Now, you need to add routes in the web.php file. So navigate to routes folder and open web.php file. Then add the following routes into web.php file:

 Route::get('/auth/redirect/{provider}', 'GoogleLoginController@redirect');
 Route::get('/callback/{provider}', 'GoogleLoginController@callback');

1 2	Route::get('/auth/redirect/{provider}', 'GoogleLoginController@redirect'); Route::get('/callback/{provider}', 'GoogleLoginController@callback');

Step 8: Create Controller

Now, lets create a controller named GoogleLoginController using command given below –

php artisan make:controller GoogleLoginController

1	php artisan make:controller GoogleLoginController

Then go to app/controllers folder and open GoogleLoginController.php. And put the following code into your GoogleLoginController.php file:

<?php
 
namespace App\Http\Controllers;
 
use Illuminate\Http\Request;
use Validator,Redirect,Response,File;
use Socialite;
use App\User;
 
class GoogleLoginController extends Controller
{
 
public function redirect($provider)
{
    return Socialite::driver($provider)->redirect();
}
 
public function callback($provider)
{
           
    $getInfo = Socialite::driver($provider)->user();
     
    $user = $this->createUser($getInfo,$provider);
 
    auth()->login($user);
 
    return redirect()->to('/home');
 
}
function createUser($getInfo,$provider){
 
 $user = User::where('provider_id', $getInfo->id)->first();
 
 if (!$user) {
     $user = User::create([
        'name'     => $getInfo->name,
        'email'    => $getInfo->email,
        'provider' => $provider,
        'provider_id' => $getInfo->id
    ]);
  }
  return $user;
}
}

<?php

namespace App\Http\Controllers;

use Illuminate\Http\Request;

use Validator,Redirect,Response,File;

use Socialite;

use App\User;

class GoogleLoginController extends Controller

{

public function redirect($provider)

{

return Socialite::driver($provider)->redirect();

}

public function callback($provider)

{

$getInfo = Socialite::driver($provider)->user();

$user = $this->createUser($getInfo,$provider);

auth()->login($user);

return redirect()->to('/home');

}

function createUser($getInfo,$provider){

$user = User::where('provider_id', $getInfo->id)->first();

if (!$user) {

$user = User::create([

'name' => $getInfo->name,

'email' => $getInfo->email,

'provider' => $provider,

'provider_id' => $getInfo->id

]);

}

return $user;

}

Go to Resources/Views/Auth folder and open register.blade.php. Then add a laravel socialite google login button in register.blade.php file:

<hr>
<div class="form-group row mb-0">
<div class="col-md-8 offset-md-4">
<a href="{{ url('/auth/redirect/google') }}" class="btn btn-primary"><i class="fa fa-google"></i> Google</a>
</div>
</div>

<hr>

<a href="{{ url('/auth/redirect/google') }}" class="btn btn-primary"><i class="fa fa-google"></i> Google</a>

</div>

Next, go to Resources/Views/Auth folder and open login.blade.php. Then add a laravel socialite google login button in login.blade.php file:

<hr>
<div class="form-group row mb-0">
<div class="col-md-8 offset-md-4">
<a href="{{ url('/auth/redirect/google') }}" class="btn btn-primary"><i class="fa fa-google"></i> Google</a>
</div>
</div>

<hr>

<a href="{{ url('/auth/redirect/google') }}" class="btn btn-primary"><i class="fa fa-google"></i> Google</a>

</div>

Step 10: Run Development Server

Now we are ready to run our example so lets start the development server using following artisan command –

php artisan serve

1	php artisan serve

Now, open the following URL in browser to see the output –

http://127.0.0.1:8000/login

 Or direct hit in your browser

 http://localhost/blog/public/login

http://127.0.0.1:8000/login

Or direct hit in your browser

http://localhost/blog/public/login

Login with Facebook In Laravel 7/6 Example

In this Login with facebook in Laravel 7/6 example tutorial I’ll show you how to integrate facebook login in laravel 7/6 using socialite package. Integrating Facebook login in Laravel 7/6 using socialite package is much easier. Allowing users to login with their social media accounts makes registration/login process much easier, it also encourages more users to register for your application.

In this step by step tutorial, you will learn to integrate Facebook login with your laravel 7/6 application. Please follow the steps give below:

Step 1: Install Laravel New App
Step 2: Connect App to Database
Step 3: Download Socialite Package
Step 4: Create Facebook App
Step 5: Create Auth Scaffolding
Step 6: Add Route
Step 7: Create Controller By Artisan Command
Step 8: Add Facebook Login Button On Blade View
Step 9: Run Development Server

Step 1: Install Laravel New App

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

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

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

Step 2: Connect App to 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=here your database name here
  DB_USERNAME=here database username here
  DB_PASSWORD=here database password here

DB_CONNECTION=mysql

DB_HOST=127.0.0.1

DB_PORT=3306

DB_DATABASE=here your database name here

DB_USERNAME=here database username here

DB_PASSWORD=here database password here

Step 3: Download Socialite Package

In this step we will Install Socialite Package via Composer using following command:

composer require laravel/socialite

1	composer require laravel/socialite

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

config/app.php

'providers' => [
      // Other service providers…
  Laravel\Socialite\SocialiteServiceProvider::class,
 ],

'aliases' => [
 // Other aliases…
 'Socialite' => Laravel\Socialite\Facades\Socialite::class,
 ],

'providers' => [

// Other service providers…

Laravel\Socialite\SocialiteServiceProvider::class,

'aliases' => [

// Other aliases…

'Socialite' => Laravel\Socialite\Facades\Socialite::class,

Step 4: Create Facebook App

Step 1:-
Go to Facebook’s developers site https://developers.facebook.com/ and log in with your Facebook account. There in Facebook developers Dashboard you have option to Create App. Lets create a Facebook Login App simply providing App Name and Contact Email.

Step 2:-
After creating the facebook app, go to setting->advanced and set redirect url

Step 3:-
Then, go to Facebook Login -> Settings and scroll down to “Valid OAuth Redirect URL” and set your callback URL

Step 4:-
After creating app, go to Settings -> Basic and get your newly created App ID and App Secret. Now, go to config directory and open service.php file and add the client id, secret and callback url:

'facebook' => [
     'client_id' => 'xxxx',
     'client_secret' => 'xxx',
     'redirect' => 'http://127.0.0.1:8000/callback/facebook',
   ],

'facebook' => [

'client_id' => 'xxxx',

'client_secret' => 'xxx',

'redirect' => 'http://127.0.0.1:8000/callback/facebook',

Now, go to User.php model and add fillable property like below:

protected $fillable = [

         'name', 'email', 'password', 'provider', 'provider_id'

     ];

protected $fillable = [

'name', 'email', 'password', 'provider', 'provider_id'

];

Now, go to database/migrations directory and open create_users_table.php. Then put the following code into it:

<?php
 use Illuminate\Support\Facades\Schema;
 use Illuminate\Database\Schema\Blueprint;
 use Illuminate\Database\Migrations\Migration;
 class CreateUsersTable extends Migration
 {
 /**
 Run the migrations.
 *
 @return void
 */
 public function up()
 {
 Schema::create('users', function (Blueprint $table) {
     $table->increments('id');
     $table->string('name');
     $table->string('email')->unique()->nullable();
     $table->string('provider');
     $table->string('provider_id');
     $table->timestamp('email_verified_at')->nullable();
     $table->string('password')->nullable();
     $table->rememberToken()->nullable();
     $table->timestamps();
 });
 } 
 /**
 Reverse the migrations.
 *
 @return void
 */
 public function down()
 {
 Schema::dropIfExists('users');
 }
 }

<?php

use Illuminate\Support\Facades\Schema;

use Illuminate\Database\Schema\Blueprint;

use Illuminate\Database\Migrations\Migration;

class CreateUsersTable extends Migration

{

/**

Run the migrations.

@return void

public function up()

{

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

$table->increments('id');

$table->string('name');

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

$table->string('provider');

$table->string('provider_id');

$table->timestamp('email_verified_at')->nullable();

$table->string('password')->nullable();

$table->rememberToken()->nullable();

$table->timestamps();

});

}

/**

Reverse the migrations.

@return void

public function down()

{

Schema::dropIfExists('users');

}

Before you run PHP artisan migrate command. Navigate to app/providers/ directory and open AppServiceProvider.php. Then add the following code into it:

…
 use Illuminate\Support\Facades\Schema; 
….
 function boot()
 {
     Schema::defaultStringLength(191);
 }
 …

…

use Illuminate\Support\Facades\Schema;

….

function boot()

{

Schema::defaultStringLength(191);

}

…

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

php artisan migrate

1	php artisan migrate

Step 5: Create Auth Scaffolding

Install Laravel UI

composer require laravel/ui

1	composer require laravel/ui

Create Auth

php artisan ui bootstrap --auth

1	php artisan ui bootstrap --auth

NPM Install

npm install

1	npm install

Step 6: Add Route

After this, we need to define routes in “routes/web.php” file. Lets open “routes/web.php” file and add the following routes in it.

routes/web.php

Route::get('/auth/redirect/{provider}', 'SocialController@redirect');
  Route::get('/callback/{provider}', 'SocialController@callback');

1 2	Route::get('/auth/redirect/{provider}', 'SocialController@redirect'); Route::get('/callback/{provider}', 'SocialController@callback');

Step 7: Create Controller By Artisan Command

Now, lets create a controller named SocialController using command given below –

php artisan make:controller SocialController

1	php artisan make:controller SocialController

Now, go to app/http/controllers/ directory and open SocialController.php. Then put the following code into your SocialController.php file

<?php
 namespace App\Http\Controllers;
 use Illuminate\Http\Request;
 use Validator,Redirect,Response,File;
 use Socialite;
 use App\User;
 class SocialController extends Controller
 {
 public function redirect($provider)
 {
     return Socialite::driver($provider)->redirect();
 }
 public function callback($provider)
 {
   $getInfo = Socialite::driver($provider)->user(); 
   $user = $this->createUser($getInfo,$provider); 
   auth()->login($user); 
   return redirect()->to('/home');
 }
 function createUser($getInfo,$provider){
 $user = User::where('provider_id', $getInfo->id)->first();
 if (!$user) {
      $user = User::create([
         'name'     => $getInfo->name,
         'email'    => $getInfo->email,
         'provider' => $provider,
         'provider_id' => $getInfo->id
     ]);
   }
   return $user;
 }
 }

<?php

namespace App\Http\Controllers;

use Illuminate\Http\Request;

use Validator,Redirect,Response,File;

use Socialite;

use App\User;

class SocialController extends Controller

{

public function redirect($provider)

{

return Socialite::driver($provider)->redirect();

}

public function callback($provider)

{

$getInfo = Socialite::driver($provider)->user();

$user = $this->createUser($getInfo,$provider);

auth()->login($user);

return redirect()->to('/home');

}

function createUser($getInfo,$provider){

$user = User::where('provider_id', $getInfo->id)->first();

if (!$user) {

$user = User::create([

'name' => $getInfo->name,

'email' => $getInfo->email,

'provider' => $provider,

'provider_id' => $getInfo->id

]);

}

return $user;

}

In this step, you need to add Facebook login button in blade views file. Now, go to resources/views/Auth directory and open login.blade.php. Then put Facebook social login button in login.blade.php file

<hr>
<div class="form-group row mb-0">
 <div class="col-md-8 offset-md-4">
    <a href="{{ url('/auth/redirect/facebook') }}" class="btn btn-primary"><i class="fa fa-facebook"></i> Facebook</a>
</div>
</div>

<hr>

<a href="{{ url('/auth/redirect/facebook') }}" class="btn btn-primary"><i class="fa fa-facebook"></i> Facebook</a>

</div>

Now, go to resources/views/Auth directory and open register.blade.php. Then add Facebook social login button in register.blade.php file:

<hr>
<div class="form-group row mb-0">
 <div class="col-md-8 offset-md-4">
    <a href="{{ url('/auth/redirect/facebook') }}" class="btn btn-primary"><i class="fa fa-facebook"></i> Facebook</a>
</div>
</div>

<hr>

<a href="{{ url('/auth/redirect/facebook') }}" class="btn btn-primary"><i class="fa fa-facebook"></i> Facebook</a>

</div>

Step 9: Run Development Server

Now we are ready to run our example so lets start the development server using following artisan command –

php artisan serve

1	php artisan serve

Now, open the following URL in browser to see the output –

http://127.0.0.1:8000/login

 Or direct hit in your browser

 http://localhost/blog/public/login

http://127.0.0.1:8000/login

Or direct hit in your browser

http://localhost/blog/public/login