Category Archives: Blog

Blog

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

Laravel 7/6 socialite Github Login Example

In this Login with Github in Laravel 7/6 example tutorial I’ll show you how to integrate Github login in laravel 7/6 using socialite package. Integrating Github 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 Github login with your laravel 7/6 application. Please follow the steps give below:

Install Laravel App
Configure Database Detail
Create Github App
Add Github App Detail
Install Socialite Package For Github Login
Add Fillable Property in Model
Add fields Into User Migration File
Run Table Migration Command
Create Auth Files By Artisan
Add Routes
Create Controller
Add Github Auth Button On Laravel View
Start Development Server
Laravel 7, 6 Socialite GitHub Login App Looks Like

Step 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

Step 2: Configure Database Detail

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 Github App

In this step we will create github App for github social login. Use the link provided to create twitter app.

https://github.com/settings/developers

1	https://github.com/settings/developers

Here you have to click New Auth APP button to Create your app. After this you need to register a new OAuth application page will open. So fill your app detail and submit it, Finally, you will see dashboard of your created github app. Now, copy your github app details.

Step 4: Add Github App Detail

In this step, add GitHub app details into service.php file. Go to config directory and open service.php file. Then add the client id and secret got from github app into service.php file:

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

'github' => [

'client_id' => 'xxxx',

'client_secret' => 'xxx',

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

Step 5: Add Fillable Property in Model

Now, go to app folder and open User.php Model file update fillable property like following:

app/User.php

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

protected $fillable = [

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

];

Step 6: Add fields Into User Migration File

In this step, go to database/migrations directory and open create_users_table.php file. Then add following code into create_users_table.php file to add some fields into users table

<?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');

}

Step 7: Run Table Migration Command

Now, Navigate to app/providers directory and inside this directory find AppServiceProvider.php file and open it in any text editor. Then add the following code in 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 8: Install 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 9: Create Auth Files 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 10: Add 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('/auth/redirect/{provider}', 'GithubSocialController@redirect');
 Route::get('/callback/{provider}', 'GithubSocialController');

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

Step 11: Create Controller

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

php artisan make:controller GithubSocialController

1	php artisan make:controller GithubSocialController

After that, go to app/http/controllers directory and open GithubSocialController.php file. Then put the following code into GithubSocialController.php file:

<?php
 
namespace App\Http\Controllers;
 
use Illuminate\Http\Request;
use Validator,Redirect,Response,File;
use Socialite;
use App\User;
class GithubSocialController 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 GithubSocialController 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;

}

Step 12: Add Github Auth Button On Laravel View

Now, go to resources/Views/Auth/ directory and open register.blade.php. After that, add the github login button into 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/github') }}" class="btn btn-primary"><i class="fa fa-github"></i> Github</a>
    </div>
</div>

<hr>

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

</div>

So, navigate to resources/Views/Auth/ directory and open login.blade.php in any text editor. After that, add the github login button into 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/github') }}" class="btn btn-primary"><i class="fa fa-github"></i> Github</a>
    </div>
</div>

<hr>

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

</div>

Step 13: 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

Laravel 7 Eloquent Join Example Tutorial

In this Laravel 7 eloquent join example tutorial I will show you how many types of join and subquery join in laravel you will also learn to use laravel join with eloquent queries. In this tutorial you will learn about various joins in laravel eloquent model. In this article I’ll demonstrate the use of various types of laravel joins.In this step by step laravel join tutorial I will share example of laravel eloquent join (join, left join, right join, cross join, and advance join) and subquery join.

Laravel 7 Eloquent Join Example Tutorial

In this Laravel 7 Eloquent Join Example Tutorial we will learn about following laravel eloquent join query with examples:

Laravel Join Eloquent
Laravel Left Join / Right Join Eloquent
Laravel Cross Join Eloquent
Laravel Advanced Join Eloquent
Sub-Query Joins

In laravel model when you want to fetch data from multiple table with associated relationship In that case you can fetch data using laravel joins. In laravel as per the need we have to use left join(), right join(), cross join() or to join two or multiple table.

1: Laravel Join Eloquent

In laravel if we join two tables it selects records if the given column values matching in both tables. It’s also known as laravel inner join eloquent. Let’s say you have two tables, users and posts. Both have ID columns, and there is a user_id in the post, which is a foreign key for the users’ table.’

$user = User::join('posts', 'posts.user_id', '=', 'users.id')
       ->select('users.*')
       ->get();

$user = User::join('posts', 'posts.user_id', '=', 'users.id')

->select('users.*')

->get();

2: Laravel Left Join / Right Join Eloquent

Left Join Eloquent

Laravel left join query returns all rows from the left table, even if there is no matches in the right table. When you are using laravel left join eloquent with a query builder laravel left join fetch data from the left table. Even if there is no match in the right table.

 User::leftJoin('posts', 'posts.user_id', '=', 'users.id')
       ->select('users.*')
       ->get();

User::leftJoin('posts', 'posts.user_id', '=', 'users.id')

->select('users.*')

->get();

Right Join Eloquent

Laravel right join query returns all rows from the right table, even if there is no matches in the left table. When you are using laravel right join eloquent with a query builder laravel right join fetch data from the right table. Even if there is no match in the left table.

 User::rightJoin('posts', 'posts.user_id', '=', 'users.id')
       ->select('users.*')
       ->get();

User::rightJoin('posts', 'posts.user_id', '=', 'users.id')

->select('users.*')

->get();

3: Laravel Cross Join Eloquent

In laravel, the cross join selects every row from the first table with every row from the second table.

Size::crossJoin('colours')
     ->get();

1 2	Size::crossJoin('colours') ->get();

4: Laravel Advanced Join Eloquent

If in join query add some addition criteria with where clause it termed as advance join query.

DB::table('users')
        ->join('contacts', function ($join) {
            $join->on('users.id', '=', 'contacts.user_id')
                 ->where('contacts.user_id', '>', 5);
        })
        ->get();

DB::table('users')

->join('contacts', function ($join) {

$join->on('users.id', '=', 'contacts.user_id')

->where('contacts.user_id', '>', 5);

})

->get();

5: Laravel Sub-Query Eloquent

In this laravel join example we are using join query in sub query.

DB::table('posts')
->select('user_id', DB::raw('MAX(created_at) as last_post_created_at'))
->where('is_published', true)->groupBy('user_id');

DB::table('posts')

->select('user_id', DB::raw('MAX(created_at) as last_post_created_at'))

->where('is_published', true)->groupBy('user_id');

Laravel 7/6 Instamojo Payment Gateway Integration Example

In this Laravel 7/6 Instamojo Payment Gateway Integration Example tutorial I will show you How to Integrate Instamojo Payment Gateway in Laravel 7/6. In this tutorial, we will learn how to integrate the instamojo payment gateway in the php laravel application via the instamojo PHP package.

In this step by step tutorial I will demonstrate you to integrate instamojo payment gateway in the laravel app without using curl APIs. We will simply install instamojo PHP package and integrate into our lastest laravel based application.

Instamojo Payment Gateway

Instamojo is one of the popular payment gateway, that allows us to accept payment from your customer. Instamojo is very simple, hassle free and easy to integrate payment gateway. Integrating Instamojo payment gateway in laravel 7 is a breeze. Instamojo processes refund payments, collect a payment, create payment are very easy and simple.

Laravel 7/6 Instamojo Payment Gateway Integration Example

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

Install Laravel Fresh Setup
Install Instamojo PHP package
Configuration .env file
Create Controller
Make Route
Create Blade View file
Start Development Server

Step 1: 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

Step 2: Install Instamojo PHP package

In this step, we will install Instamojo PHP package via the composer dependency manager. Use the following command to install Instamojo PHP package.

composer require instamojo/instamojo-php

1	composer require instamojo/instamojo-php

Step 3: Configuration in .env

Now, we will put following configuration detail in .env file:

IM_API_KEY=test_d883b3a8d2bc1adc7a535506713
 IM_AUTH_TOKEN=test_dc229039d2232a260a2df3f7502
 IM_URL=https://test.instamojo.com/api/1.1/

IM_API_KEY=test_d883b3a8d2bc1adc7a535506713

IM_AUTH_TOKEN=test_dc229039d2232a260a2df3f7502

IM_URL=https://test.instamojo.com/api/1.1/

Next, Go to the app/config/services.php and put the below code here.

'instamojo' => [

    'api_key'       => env('IM_API_KEY'),

    'auth_token'    => env('IM_AUTH_TOKEN'),

    'url'           => env('IM_URL'),

],

'instamojo' => [

'api_key' => env('IM_API_KEY'),

'auth_token' => env('IM_AUTH_TOKEN'),

'url' => env('IM_URL'),

Step 4: Create Controller

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

php artisan make:controller PayController

1	php artisan make:controller PayController

Go to app/Http/Controller/PayController and put the below code :

<?php
 
namespace App\Http\Controllers;
 
use Illuminate\Http\Request;
 
class PayController extends Controller
{
   
   public function index()
   {
        return view('event');
   }
   public function pay(Request $request){
 
     $api = new \Instamojo\Instamojo(
            config('services.instamojo.api_key'),
            config('services.instamojo.auth_token'),
            config('services.instamojo.url')
        );
 
    try {
        $response = $api->paymentRequestCreate(array(
            "purpose" => "FIFA 16",
            "amount" => $request->amount,
            "buyer_name" => "$request->name",
            "send_email" => true,
            "email" => "$request->email",
            "phone" => "$request->mobile_number",
            "redirect_url" => "http://127.0.0.1:8000/pay-success"
            ));
             
            header('Location: ' . $response['longurl']);
            exit();
    }catch (Exception $e) {
        print('Error: ' . $e->getMessage());
    }
 }
 
 public function success(Request $request){
     try {
 
        $api = new \Instamojo\Instamojo(
            config('services.instamojo.api_key'),
            config('services.instamojo.auth_token'),
            config('services.instamojo.url')
        );
 
        $response = $api->paymentRequestStatus(request('payment_request_id'));
 
        if( !isset($response['payments'][0]['status']) ) {
           dd('payment failed');
        } else if($response['payments'][0]['status'] != 'Credit') {
             dd('payment failed');
        } 
      }catch (\Exception $e) {
         dd('payment failed');
     }
    dd($response);
  }
}

<?php

namespace App\Http\Controllers;

use Illuminate\Http\Request;

class PayController extends Controller

{

public function index()

{

return view('event');

}

public function pay(Request $request){

$api = new \Instamojo\Instamojo(

config('services.instamojo.api_key'),

config('services.instamojo.auth_token'),

config('services.instamojo.url')

);

try {

$response = $api->paymentRequestCreate(array(

"purpose" => "FIFA 16",

"amount" => $request->amount,

"buyer_name" => "$request->name",

"send_email" => true,

"email" => "$request->email",

"phone" => "$request->mobile_number",

"redirect_url" => "http://127.0.0.1:8000/pay-success"

));

header('Location: ' . $response['longurl']);

exit();

}catch (Exception $e) {

print('Error: ' . $e->getMessage());

}

public function success(Request $request){

try {

$api = new \Instamojo\Instamojo(

config('services.instamojo.api_key'),

config('services.instamojo.auth_token'),

config('services.instamojo.url')

);

$response = $api->paymentRequestStatus(request('payment_request_id'));

if( !isset($response['payments'][0]['status']) ) {

dd('payment failed');

} else if($response['payments'][0]['status'] != 'Credit') {

dd('payment failed');

}

}catch (\Exception $e) {

dd('payment failed');

}

dd($response);

}

Step 5: 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', 'PayController@index');
 Route::post('pay', 'PayController@pay');
 Route::get('pay-success', 'PayController@success');

<?php

Route::get('event', 'PayController@index');

Route::post('pay', 'PayController@pay');

Route::get('pay-success', 'PayController@success');

Step 6: Create Blade View file

Now, we will 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>Instamojo 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>Opps!</strong> Something went wrong<br>
<ul>
@foreach ($errors->all() as $error)
<li>{{ $error }}</li>
@endforeach
</ul>
</div>
@endif
<form action="{{ url('pay') }}" method="POST" name="laravel_instamojo">
{{ 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" required>
</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" required>
</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" required>
</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>Instamojo Payment Gateway Integrate</title>

<style>

.mt40{

margin-top: 40px;

}

</style>

</head>

<body>

<h2>Register for Event</h2>

</div>

@if ($errors->any())

<strong>Opps!</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>

Step 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/event
Or direct hit in your browser
http://localhost/blog/public/event

http://localhost:8000/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 : 111
 Password : 1221

Card No : 4242424242424242

Month : any future month

Year : any future Year

CVV : 111

Password : 1221

Laravel 7/6 Send Email Tutorial Example

1. Install Laravel Fresh Setup

2. Configuration SMTP in .env

3. Create Route & Blade View

4. Create Controller & Method

5. Run Development Server

Laravel 7/6 DataTable Ajax CRUD Example Tutorial

Laravel 7/6 Ajax CRUD Example

1). First Install New Laravel Setup

2). Configure .env file

3). Make Route

4). Generate (Create) Controller

5). Create blade view :

6). Run Development Server

Laravel 7/6 Generate PDF Example

1. Install Laravel App

2. Setup Database

3. Install laravel-dompdf Package

4. Make PDF Route

5. Create GeneratePDF Controller

6. Create Blade view for Generate Pdf

7. Run Development Server

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

Layout.blade.php

List.blade.php

Create.blade.php

Edit.blade.php

Step 7: Run Development Server

Laravel 7/6 DataTable Ajax CRUD Example Tutorial

Step 1: Install Fresh Laravel Setup

Step 2: Set database Credentials

Step 3: Create Migration And Model

Step 4: Install Yajra Datatables Package in Laravel

Step 5: Create (Controller, Route, Blade)

2: Create Controller

Index() method

Store() Method

Edit() Method

Delete() Method

3: Create Blade View

Create a Button view

Script Code

Step 6: Run Development Server

Paytm Payment Gateway

Laravel 7/6 Paytm Payment Gateway Integration

Install laravel Fresh Project

Configuration in .env

Install Anandsiddharth paytm package

Generate Migration and Create Model

Make Route

Create Controller

Create Blade View file

Start Development Server

Testing Card Credential

Laravel 7/6 Generate Fake Data Using Faker Example

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

Laravel 7/6 Socialite Google Login Example

Step1: Install laravel App

Step 2: Add Database Details

Step 3: Install Socialite Package For Google Login

Step 4: Create Google App

Step 5: Add Google App Details

Step 6: Generate Auth File By Artisan

Install Laravel UI

Create Auth

NPM Install

Step 7: Add Routes

Step 8: Create Controller