Category Archives: Laravel

Laravel Tutorials

Laravel 8 Yajra Datatables Example Tutorial

In this Laravel 8 Yajra Datatables Example Tutorial, I’ll show you how to install and use yajra DataTables in your laravel 8 application with example. In this tutorial you will learn to integrate yajra DataTables in your laravel 8 application. We will be using yajra datatable package for listing of records with pagination, sorting and filter (search) feature. Laravel Yajra datatables package comes with many built-in features for searching and sorting functionality.

Laravel 8 Yajra Datatables Example Tutorial

In this step by step Laravel 8 Yajra Datatables Example Tutorial I will demonstrate you how to install and use yajra DataTables in your laravel 8 application. I will also share example to use yajra DataTables in your laravel 8 application. Please follow the instruction given below:

Step 1: Install Laravel 8

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

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

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

Step 2 : Install Yajra Datatable

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,
]
.....

.....

'providers' => [

....

Yajra\DataTables\DataTablesServiceProvider::class,

]

.....

Step 3: Add Dummy Records

Now, we need to add some fake records in the database.

php artisan tinker
User::factory()->count(20)->create()

1 2	php artisan tinker User::factory()->count(20)->create()

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

<?php
  
use Illuminate\Support\Facades\Route;  
use App\Http\Controllers\UserController;  
/*
|--------------------------------------------------------------------------
| Web Routes
|--------------------------------------------------------------------------
|
| Here is where you can register web routes for your application. These
| routes are loaded by the RouteServiceProvider within a group which
| contains the "web" middleware group. Now create something great!
|
*/  
Route::get('users', [UserController::class, 'index'])->name('users.index');

<?php

use Illuminate\Support\Facades\Route;

use App\Http\Controllers\UserController;

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

| Web Routes

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

| Here is where you can register web routes for your application. These

| routes are loaded by the RouteServiceProvider within a group which

| contains the "web" middleware group. Now create something great!

Route::get('users', [UserController::class, 'index'])->name('users.index');

Step 5: Create Controller

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

app/Http/Controllers/UserController.php

<?php
  
namespace App\Http\Controllers;
  
use Illuminate\Http\Request;
use App\Models\User;
use DataTables;
  
class UserController extends Controller
{
    /**
     * Display a listing of the resource.
     *
     * @return \Illuminate\Http\Response
     */
    public function index(Request $request)
    {
        if ($request->ajax()) {
            $data = User::select('*');
            return Datatables::of($data)
                    ->addIndexColumn()
                    ->addColumn('action', function($row){
     
                           $btn = '<a href="javascript:void(0)" class="edit btn btn-primary btn-sm">View</a>';
    
                            return $btn;
                    })
                    ->rawColumns(['action'])
                    ->make(true);
        }
        
        return view('users');
    }
}

<?php

namespace App\Http\Controllers;

use Illuminate\Http\Request;

use App\Models\User;

use DataTables;

class UserController extends Controller

{

/**

* Display a listing of the resource.

* @return \Illuminate\Http\Response

public function index(Request $request)

{

if ($request->ajax()) {

$data = User::select('*');

return Datatables::of($data)

->addIndexColumn()

->addColumn('action', function($row){

$btn = '<a href="javascript:void(0)" class="edit btn btn-primary btn-sm">View</a>';

return $btn;

})

->rawColumns(['action'])

->make(true);

}

return view('users');

}

Step 6: Create View

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

resources/views/users.blade.php

<!DOCTYPE html>
<html>
<head>
    <title>Laravel 8 Datatables Tutorial</title>
    <meta name="csrf-token" content="{{ csrf_token() }}">
    <link rel="stylesheet" href="https://cdnjs.cloudflare.com/ajax/libs/twitter-bootstrap/4.1.3/css/bootstrap.min.css" />
    <link href="https://cdn.datatables.net/1.10.16/css/jquery.dataTables.min.css" rel="stylesheet">
    <link href="https://cdn.datatables.net/1.10.19/css/dataTables.bootstrap4.min.css" rel="stylesheet">
    <script src="https://ajax.googleapis.com/ajax/libs/jquery/1.9.1/jquery.js"></script>  
    <script src="https://cdnjs.cloudflare.com/ajax/libs/jquery-validate/1.19.0/jquery.validate.js"></script>
    <script src="https://cdn.datatables.net/1.10.16/js/jquery.dataTables.min.js"></script>
    <script src="https://stackpath.bootstrapcdn.com/bootstrap/4.1.3/js/bootstrap.min.js"></script>
    <script src="https://cdn.datatables.net/1.10.19/js/dataTables.bootstrap4.min.js"></script>
</head>
<body>
    
<div class="container">
    <h1>Laravel 8 Datatables Tutorial</h1>
    <table class="table table-bordered data-table">
        <thead>
            <tr>
                <th>No</th>
                <th>Name</th>
                <th>Email</th>
                <th width="100px">Action</th>
            </tr>
        </thead>
        <tbody>
        </tbody>
    </table>
</div>
   
</body>
   
<script type="text/javascript">
  $(function () {
    
    var table = $('.data-table').DataTable({
        processing: true,
        serverSide: true,
        ajax: "{{ route('users.index') }}",
        columns: [
            {data: 'id', name: 'id'},
            {data: 'name', name: 'name'},
            {data: 'email', name: 'email'},
            {data: 'action', name: 'action', orderable: false, searchable: false},
        ]
    });
    
  });
</script>
</html>

<!DOCTYPE html>

<html>

<head>

<title>Laravel 8 Datatables Tutorial</title>

</head>

<body>

<h1>Laravel 8 Datatables Tutorial</h1>

<thead>

<tr>

<th>Email</th>

<th width="100px">Action</th>

</tr>

</thead>

<tbody>

</tbody>

</table>

</div>

</body>

$(function () {

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

processing: true,

serverSide: true,

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

columns: [

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

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

{data: 'email', name: 'email'},

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

]

});

</script>

</html>

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/users

1	http://localhost:8000/users

Laravel 8 Ajax Form Validation Tutorial

In this Laravel 8 Ajax Form Validation Tutorial I’ll show you how to submit form using ajax and validate form data in laravel 8 application. In this laravel form validation tutorial you will learn to submit and validate form using ajax in laravel form with built in laravel validation available in laravel. In this Laravel 8 ajax form validation tutorial I’ll share various validation implementation and use case. In this laravel ajax form validation tutorial we will be learning about laravel server side validations using ajax form submit. In this tutorial, I’ll show you how to submit and validate form data using ajax and to display validation errors.

Laravel 8 Form Validation

Laravel 8 comes many built-in validation rules that can be easily implemented. In this example, we have used some of following validation rules –

required:- It set input field is required.
min:- Validate minimum character length.
max:- Validate maximum character length.
email: It set input must be a valid email address.
unique: It checks for unique value against a database column.
numeric: Input value must numeric.
same:- It validates two input fields value must be same.

Laravel 8 Ajax Form Validation

In this step by step tutorial I’ll demonstrate you how perform server side validations using ajax in laravel form submit. We will also create example to submit and validate form data using ajax in laravel 8. Please follow the instruction given below:

Step 1: Add Route

In this step we will define routes in “routes/web.php” file. Lets open “routes/web.php” file and add the following routes in it.

routes/web.php

<?php
  
use Illuminate\Support\Facades\Route;  
use App\Http\Controllers\HomeController;  
/*
|--------------------------------------------------------------------------
| Web Routes
|--------------------------------------------------------------------------
|
| Here is where you can register web routes for your application. These
| routes are loaded by the RouteServiceProvider within a group which
| contains the "web" middleware group. Now create something great!
|
*/  
Route::get('my-form', [HomeController::class, 'myform']);
Route::post('my-form', [HomeController::class, 'myformPost'])->name('my.form');

<?php

use Illuminate\Support\Facades\Route;

use App\Http\Controllers\HomeController;

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

| Web Routes

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

| Here is where you can register web routes for your application. These

| routes are loaded by the RouteServiceProvider within a group which

| contains the "web" middleware group. Now create something great!

Route::get('my-form', [HomeController::class, 'myform']);

Route::post('my-form', [HomeController::class, 'myformPost'])->name('my.form');

Step 2: Create Controller

Next, we have to create a controller to display form and to handle form validation and submit operations. Lets Create a controller named HomeController using command given below –

php artisan make:controller HomeController

1	php artisan make:controller HomeController

Open the HomeController.php file and put the following code in it.

app/Http/Controllers/HomeController.php

In the controller we have following method to display form and to submit and validate form data using ajax:

1)myform()

2)myformPost()

app/Http/Controllers/HomeController.php

<?php     
namespace App\Http\Controllers;     
use Illuminate\Http\Request;
use Validator;     
class HomeController extends Controller
{     
    /**
     * Display a listing of the myform.
     *
     * @return \Illuminate\Http\Response
     */
    public function myform()
    {
    	return view('myform');
    }    
    /**
     * Display a listing of the myformPost.
     *
     * @return \Illuminate\Http\Response
     */
    public function myformPost(Request $request)
    {
     
    	$validator = Validator::make($request->all(), [
            'first_name' => 'required',
            'last_name' => 'required',
            'email' => 'required|email',
            'address' => 'required',
        ]);     
        if ($validator->passes()) {
            return response()->json(['success'=>'Added new records.']);
        }     
        return response()->json(['error'=>$validator->errors()->all()]);
    }
}

<?php

namespace App\Http\Controllers;

use Illuminate\Http\Request;

use Validator;

class HomeController extends Controller

{

/**

* Display a listing of the myform.

* @return \Illuminate\Http\Response

public function myform()

{

return view('myform');

}

/**

* Display a listing of the myformPost.

* @return \Illuminate\Http\Response

public function myformPost(Request $request)

{

$validator = Validator::make($request->all(), [

'first_name' => 'required',

'last_name' => 'required',

'email' => 'required|email',

'address' => 'required',

]);

if ($validator->passes()) {

return response()->json(['success'=>'Added new records.']);

}

return response()->json(['error'=>$validator->errors()->all()]);

}

Step 3: Create View File

Now, create form blade view file to display form and submit to database. So, Go to resources/views and create resources/views/myform.blade.php and update the following code into it:

resources/views/myform.blade.php

<!DOCTYPE html>
<html>
<head>
    <title>Laravel 8 Ajax Validation Example</title>
    <link rel="stylesheet" href="https://cdnjs.cloudflare.com/ajax/libs/twitter-bootstrap/3.3.7/css/bootstrap.min.css" />
    <script src="https://cdnjs.cloudflare.com/ajax/libs/jquery/3.2.1/jquery.js"></script>
</head>
<body>       
<div class="container">
    <h2>Laravel 8 Ajax Validation</h2>       
    <div class="alert alert-danger print-error-msg" style="display:none">
        <ul></ul>
    </div>       
    <form>
        {{ csrf_field() }}
        <div class="form-group">
            <label>First Name:</label>
            <input type="text" name="first_name" class="form-control" placeholder="First Name">
        </div>       
        <div class="form-group">
            <label>Last Name:</label>
            <input type="text" name="last_name" class="form-control" placeholder="Last Name">
        </div>       
        <div class="form-group">
            <strong>Email:</strong>
            <input type="text" name="email" class="form-control" placeholder="Email">
        </div>       
        <div class="form-group">
            <strong>Address:</strong>
            <textarea class="form-control" name="address" placeholder="Address"></textarea>
        </div>       
        <div class="form-group">
            <button class="btn btn-success btn-submit">Submit</button>
        </div>
    </form>
</div>
       
<script type="text/javascript">
       
    $(document).ready(function() {
        $(".btn-submit").click(function(e){
            e.preventDefault();
       
            var _token = $("input[name='_token']").val();
            var first_name = $("input[name='first_name']").val();
            var last_name = $("input[name='last_name']").val();
            var email = $("input[name='email']").val();
            var address = $("textarea[name='address']").val();       
            $.ajax({
                url: "{{ route('my.form') }}",
                type:'POST',
                data: {_token:_token, first_name:first_name, last_name:last_name, email:email, address:address},
                success: function(data) {
                    if($.isEmptyObject(data.error)){
                        alert(data.success);
                    }else{
                        printErrorMsg(data.error);
                    }
                }
            });
       
        });        
        function printErrorMsg (msg) {
            $(".print-error-msg").find("ul").html('');
            $(".print-error-msg").css('display','block');
            $.each( msg, function( key, value ) {
                $(".print-error-msg").find("ul").append('<li>'+value+'</li>');
            });
        }
    });
</script>
</body>
</html>

<!DOCTYPE html>

<html>

<head>

<title>Laravel 8 Ajax Validation Example</title>

</head>

<body>

<h2>Laravel 8 Ajax Validation</h2>

</div>

<form>

<label>First Name:</label>

</div>

</div>

<strong>Email:</strong>

</div>

<strong>Address:</strong>

</div>

<button class="btn btn-success btn-submit">Submit</button>

</div>

</form>

</div>

$(document).ready(function() {

$(".btn-submit").click(function(e){

e.preventDefault();

var _token = $("input[name='_token']").val();

var first_name = $("input[name='first_name']").val();

var last_name = $("input[name='last_name']").val();

var email = $("input[name='email']").val();

var address = $("textarea[name='address']").val();

$.ajax({

url: "{{ route('my.form') }}",

type:'POST',

data: {_token:_token, first_name:first_name, last_name:last_name, email:email, address:address},

success: function(data) {

if($.isEmptyObject(data.error)){

alert(data.success);

}else{

printErrorMsg(data.error);

}

});

function printErrorMsg (msg) {

$(".print-error-msg").find("ul").html('');

$(".print-error-msg").css('display','block');

$.each( msg, function( key, value ) {

$(".print-error-msg").find("ul").append('<li>'+value+'</li>');

});

}

});

</script>

</body>

</html>

Step 4: 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/my-form

1	http://localhost:8000/my-form

Laravel 8 Send Mail using Queue Example

In this tutorial Laravel 8 Send Mail using Queue Example I will show you how to send mail using queue in laravel 8. In this tutorial you will learn to send mails using queue job In laravel application. In Laravel 8 you can use mailtrap, smtp, Mailgun, Postmark, Amazon SES, and sendmail for sending emails.

When we want to send mails in bulk it takes enough time to send all mails. Sending mails in bulk result time consuming process and may not guarantee all mails being sent. In laravel we can use queue job for sending mail in bulk. In this example we will create a queue job with database driver for sending emails.

Laravel 8 Send Mail using Queue Example

In this step by step tutorial I will demonstrate you how to send mail using queue job In laravel application. Please follow instructions given below:

Step 1 – Install Laravel 8 App
Step 2 – Configuration SMTP & Database
Step 3 – Create Mailable Class
Step 4 – Add Email Send Route
Step 5 – Create Directory And Mail Blade View
Step 6 – Configuration Mail Queue
Step 7 – Build Queue Job For Sending Mail
Step 8 – Run Development Server

Step 1 – Install Laravel 8 App

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

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

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

Step 2 – Configuration SMTP & Database

In this step we will be setting smtp detail for mail configuration in Laravel, We will be using following Gmail SMTP details such as username, password inside the .envfile.

DB_CONNECTION=mysql
DB_HOST=127.0.0.1
DB_PORT=3306
DB_DATABASE=db name
DB_USERNAME=db user name
DB_PASSWORD=db password

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

DB_CONNECTION=mysql

DB_HOST=127.0.0.1

DB_PORT=3306

DB_DATABASE=db name

DB_USERNAME=db user name

DB_PASSWORD=db password

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

Step 3 – Create Mailable Class

The mailable class in Laravel used for sending emails. Now, lets create a new laravel mailable class using following artisan command:

php artisan make:mail NotifyMail

1	php artisan make:mail NotifyMail

Once the above command executed, it will create a new laravel mailable class NotifyMail.php in app/Mail/ directory. Open the NotifyMail.php file and put the following code in it.

<?php
 
namespace App\Mail;
 
use Illuminate\Bus\Queueable;
use Illuminate\Contracts\Queue\ShouldQueue;
use Illuminate\Mail\Mailable;
use Illuminate\Queue\SerializesModels;
 
class NotifyMail extends Mailable
{
    use Queueable, SerializesModels;
 
    /**
     * Create a new message instance.
     *
     * @return void
     */
    public function __construct()
    {
        //
    }
 
    /**
     * Build the message.
     *
     * @return $this
     */
    public function build()
    {
        return $this->view('view.name');
    }
}

<?php

namespace App\Mail;

use Illuminate\Bus\Queueable;

use Illuminate\Contracts\Queue\ShouldQueue;

use Illuminate\Mail\Mailable;

use Illuminate\Queue\SerializesModels;

class NotifyMail extends Mailable

{

use Queueable, SerializesModels;

/**

* Create a new message instance.

* @return void

public function __construct()

{

}

/**

* Build the message.

* @return $this

public function build()

{

return $this->view('view.name');

}

Now add email template name in build class of the above created notifymail class.

return $this->view('view.name');
to
return $this->view('emails.demoMail');

return $this->view('view.name');

return $this->view('emails.demoMail');

In next step, Create email template named demoMail.blade.php inside resources/views/emails directory. That’s why have added view name email.

Step 4 – Add Send Email 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('email-test', function(){

$details['email'] = 'your_email@gmail.com';

dispatch(new App\Jobs\SendEmailJob($details));

dd('done');
});

Route::get('email-test', function(){

$details['email'] = 'your_email@gmail.com';

dispatch(new App\Jobs\SendEmailJob($details));

dd('done');

});

Step 5 – Create Directory And Mail Blade View

In this step, create directory name emails inside resources/views directory. Then create an demoMail.blade.php blade view file inside resources/views/emails directory. And update the following code into it:

<!DOCTYPE html>
<html>
<head>
 <title>Laravel 8 Send Email Example</title>
</head>
<body>
 
 <h1>This is test mail</h1>
 <p>Laravel 8 send email example</p>
 
</body>
</html>

<!DOCTYPE html>

<html>

<head>

<title>Laravel 8 Send Email Example</title>

</head>

<body>

<p>Laravel 8 send email example</p>

</body>

</html>

Step 6 – Configuration Mail Queue

QUEUE_CONNECTION=database

1	QUEUE_CONNECTION=database

Then open the terminal and run following command for queue database tables:

php artisan queue:table

1	php artisan queue:table

Next, migrate tables into database:

php artisan migrate

1	php artisan migrate

Step 7 – Build Queue Job For Sending Mail

Now we will create a queue job to send emails using following artisan command:

php artisan make:job SendEmailJob

1	php artisan make:job SendEmailJob

Then open SendEmailJob.php file which is placed on “app/Jobs” directory. And update the following mail queue code into it:

<?php
   
namespace App\Jobs;
   
use Illuminate\Bus\Queueable;
use Illuminate\Contracts\Queue\ShouldQueue;
use Illuminate\Foundation\Bus\Dispatchable;
use Illuminate\Queue\InteractsWithQueue;
use Illuminate\Queue\SerializesModels;
use App\Mail\SendEmailTest;
use Mail;
   
class SendEmailJob implements ShouldQueue
{
    use Dispatchable, InteractsWithQueue, Queueable, SerializesModels;
   
    protected $details;
   
    /**
     * Create a new job instance.
     *
     * @return void
     */
    public function __construct($details)
    {
        $this->details = $details;
    }
   
    /**
     * Execute the job.
     *
     * @return void
     */
    public function handle()
    {
        $email = new SendEmailTest();
        Mail::to($this->details['email'])->send($email);
    }
}

<?php

namespace App\Jobs;

use Illuminate\Bus\Queueable;

use Illuminate\Contracts\Queue\ShouldQueue;

use Illuminate\Foundation\Bus\Dispatchable;

use Illuminate\Queue\InteractsWithQueue;

use Illuminate\Queue\SerializesModels;

use App\Mail\SendEmailTest;

use Mail;

class SendEmailJob implements ShouldQueue

{

use Dispatchable, InteractsWithQueue, Queueable, SerializesModels;

protected $details;

/**

* Create a new job instance.

* @return void

public function __construct($details)

{

$this->details = $details;

}

/**

* Execute the job.

* @return void

public function handle()

{

$email = new SendEmailTest();

Mail::to($this->details['email'])->send($email);

}

Step 8 – 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/email-test

1	http://127.0.0.1:8000/email-test

Laravel 8 Queue Job Tutorial Example

n this Laravel 8 Queue Job Tutorial Example I will show you how to configure, create and use queue jobs in laravel 8 application. In this tutorial you will learn to about creating queue jobs and its application in laravel. In this article I will share example to configure queued jobs for various time consuming tasks in laravel. For example when we want to send mails in bulk it takes enough time to send all mails. Sending mails in bulk result time consuming process and may not guarantee all mails being sent. In laravel we can create a queue job for sending mail in bulk.

Laravel Queue Job

Laravel queue job allows you to process time intensive tasks in background. It results in faster speed and better user experience. With laravel queue jobs you can delay a time-consuming task until a later time. Delaying the time consuming task will speeds up web requests and improve the performance of the applications. For example sending email in bulk is a time-consuming task. We can create a queue job to send email to the user in the background. Laravel queues provide a unified API across various queue backends, such as Amazon SQS, Beanstalk, Redis, or even a relational database.

Laravel 8 Queue Job Tutorial Example

In this step by step tutorial I will demonstrate you with example how to create and use laravel queue jobs in laravel. In this tutorial I will share a simple example to create a queue job with database driver to send email. Please follow the steps given below:

Step 1 – Install Laravel 8 App

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

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

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

Step 2 – Configuration SMTP & Database

In this step we will be setting smtp detail for mail configuration in Laravel, We will be using following Gmail SMTP details such as username, password inside the .env file.

DB_CONNECTION=mysql
DB_HOST=127.0.0.1
DB_PORT=3306
DB_DATABASE=db name
DB_USERNAME=db user name
DB_PASSWORD=db password

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

DB_CONNECTION=mysql

DB_HOST=127.0.0.1

DB_PORT=3306

DB_DATABASE=db name

DB_USERNAME=db user name

DB_PASSWORD=db password

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

Step 3 – Create Mailable Class

Now, lets create a new laravel mailable class using following artisan command:

php artisan make:mail SendEmailTest

1	php artisan make:mail SendEmailTest

Open SendEmailTest.php file and copy bellow code and post on that file.

app/Mail/SendEmailTest.php

<?php
namespace App\Mail;  
use Illuminate\Bus\Queueable;
use Illuminate\Contracts\Queue\ShouldQueue;
use Illuminate\Mail\Mailable;
use Illuminate\Queue\SerializesModels;
  class SendEmailTest extends Mailable
{
    use Queueable, SerializesModels;  
    /**
     * Create a new message instance.
     *
     * @return void
     */
    public function __construct()
    {   
    }
  
    /**
     * Build the message.
     *
     * @return $this
     */
    public function build()
    {
        return $this->view('emails.test');
    }
}

<?php

namespace App\Mail;

use Illuminate\Bus\Queueable;

use Illuminate\Contracts\Queue\ShouldQueue;

use Illuminate\Mail\Mailable;

use Illuminate\Queue\SerializesModels;

class SendEmailTest extends Mailable

{

use Queueable, SerializesModels;

/**

* Create a new message instance.

* @return void

public function __construct()

{

}

/**

* Build the message.

* @return $this

public function build()

{

return $this->view('emails.test');

}

Ok, now create email view using blade file.

resources/views/emails/test.blade.php

<!DOCTYPE html>
<html>
<head>
    <title>How to send mail using queue in Laravel 8</title>
</head>
<body>
   
<center>
<h2 style="padding: 23px;background: #b3deb8a1;border-bottom: 6px green solid;">
</h2>
</center>
  
<p>Hi, Sir</p>
<p>Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod
tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam,
quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo
consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse
cillum dolore eu fugiat nulla pariatur. Excepteur sint occaecat cupidatat non
proident, sunt in culpa qui officia deserunt mollit anim id est laborum.</p>
  
<strong>Thank you Sir. :)</strong>  
</body>
</html>

<!DOCTYPE html>

<html>

<head>

<title>How to send mail using queue in Laravel 8</title>

</head>

<body>

</h2>

</center>

<p>Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod

tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam,

quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo

consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse

cillum dolore eu fugiat nulla pariatur. Excepteur sint occaecat cupidatat non

proident, sunt in culpa qui officia deserunt mollit anim id est laborum.</p>

<strong>Thank you Sir. :)</strong>

</body>

</html>

Step 4: Configuration of Queue

QUEUE_CONNECTION=database

1	QUEUE_CONNECTION=database

After that generate migration and create tables for queue. So run command for queue database tables:

Create Migration:

php artisan queue:table

1	php artisan queue:table

Run Migration:

php artisan migrate

1	php artisan migrate

Step 5: Create Queue Job for Sending Email

Now we will create a queue job to send emails using following artisan command:

php artisan make:job SendEmailJob

1	php artisan make:job SendEmailJob

Now, open SendEmailJob.php file and put bellow code on that file.

app/Jobs/SendEmailJob.php

<?php
  
namespace App\Jobs;
  
use Illuminate\Bus\Queueable;
use Illuminate\Contracts\Queue\ShouldQueue;
use Illuminate\Foundation\Bus\Dispatchable;
use Illuminate\Queue\InteractsWithQueue;
use Illuminate\Queue\SerializesModels;
use App\Mail\SendEmailTest;
use Mail;  
class SendEmailJob implements ShouldQueue
{
    use Dispatchable, InteractsWithQueue, Queueable, SerializesModels;
  
    protected $details;  
    /**
     * Create a new job instance.
     *
     * @return void
     */
    public function __construct($details)
    {
        $this->details = $details;
    }
  
    /**
     * Execute the job.
     *
     * @return void
     */
    public function handle()
    {
        $email = new SendEmailTest();
        Mail::to($this->details['email'])->send($email);
    }
}

<?php

namespace App\Jobs;

use Illuminate\Bus\Queueable;

use Illuminate\Contracts\Queue\ShouldQueue;

use Illuminate\Foundation\Bus\Dispatchable;

use Illuminate\Queue\InteractsWithQueue;

use Illuminate\Queue\SerializesModels;

use App\Mail\SendEmailTest;

use Mail;

class SendEmailJob implements ShouldQueue

{

use Dispatchable, InteractsWithQueue, Queueable, SerializesModels;

protected $details;

/**

* Create a new job instance.

* @return void

public function __construct($details)

{

$this->details = $details;

}

/**

* Execute the job.

* @return void

public function handle()

{

$email = new SendEmailTest();

Mail::to($this->details['email'])->send($email);

}

Step 6: Create Route for Queue Job

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('email-test', function(){
  
    $details['email'] = 'your_email@gmail.com';
  
    dispatch(new App\Jobs\SendEmailJob($details));
  
    dd('done');
});

Route::get('email-test', function(){

$details['email'] = 'your_email@gmail.com';

dispatch(new App\Jobs\SendEmailJob($details));

dd('done');

});

process laravel queue command.

php artisan queue:listen

1	php artisan queue:listen

let see the code changes we made

See configuration.

php artisan config:clear

1	php artisan config:clear

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/email-test

1	http://localhost:8000/email-test

Laravel 8 Custom Flash Message Tutorial Example

In this Laravel 8 Custom Flash Message Tutorial Example I will show you how to create and use flash message in laravel 8 application. In this tutorial you will learn to create and use flash message in laravel. While working with laravel application we come to situations where we want to show/display various flash success and error messages. In this article I will share various example to create and use various types of flash messages in laravel 8.

Laravel 8 Custom Flash Message Tutorial Example

In this Laravel 8 Custom Flash Message Tutorial you will learn how to create Custom Flash Message in laravel .In this step by step tutorial you will understand how to customize Flash message with example. Please follow the instruction given below:

Step 1: Create Global File For Flash Message

In this step we will create a global flash message file and add following alert in it:

1)success
2)error
3)warning
4)info
5)validation error
Let’s create flash-message.blade.php file and put bellow code on that file.

resources/views/flash-message.blade.php

@if ($message = Session::get('success'))
<div class="alert alert-success alert-block">
    <button type="button" class="close" data-dismiss="alert">×</button>    
    <strong>{{ $message }}</strong>
</div>
@endif
  
@if ($message = Session::get('error'))
<div class="alert alert-danger alert-block">
    <button type="button" class="close" data-dismiss="alert">×</button>    
    <strong>{{ $message }}</strong>
</div>
@endif
   
@if ($message = Session::get('warning'))
<div class="alert alert-warning alert-block">
    <button type="button" class="close" data-dismiss="alert">×</button>    
    <strong>{{ $message }}</strong>
</div>
@endif
   
@if ($message = Session::get('info'))
<div class="alert alert-info alert-block">
    <button type="button" class="close" data-dismiss="alert">×</button>    
    <strong>{{ $message }}</strong>
</div>
@endif
  
@if ($errors->any())
<div class="alert alert-danger">
    <button type="button" class="close" data-dismiss="alert">×</button>    
    Please check the form below for errors
</div>
@endif

@if ($message = Session::get('success'))

<strong>{{ $message }}</strong>

</div>

@endif

@if ($message = Session::get('error'))

<strong>{{ $message }}</strong>

</div>

@endif

@if ($message = Session::get('warning'))

<strong>{{ $message }}</strong>

</div>

@endif

@if ($message = Session::get('info'))

<strong>{{ $message }}</strong>

</div>

@endif

@if ($errors->any())

Please check the form below for errors

</div>

@endif

Step 2: Use Flash Message in Theme

Now we will include global flash message file in app layout as following:

@include('flash-message')

1	@include('flash-message')

resources/views/layouts/app.blade.php

<!DOCTYPE html>
<html lang="en">
<head>
    <meta charset="utf-8">
    <meta http-equiv="X-UA-Compatible" content="IE=edge">
    <meta name="viewport" content="width=device-width, initial-scale=1">
    <!-- Styles -->
    <link href="/css/app.css" rel="stylesheet">
</head>
<body>
    <div id="app">
       @include('flash-message')
       @yield('content')
    </div>
    <!-- Scripts -->
    <script src="/js/app.js"></script>
</body>
</html>

<!DOCTYPE html>

<head>

</head>

<body>

@include('flash-message')

@yield('content')

</div>

</body>

</html>

Step 3: Use Flash Messages with Redirect

we will learn here how to show message when you redirect one by one:

1. Redirect with success message

Below is example to simple redirect with success flash message.

public function create(Request $request)
{
	$this->validate($request,[
        'title' => 'required',
        'details' => 'required'
        ]);
	$items = Item::create($request->all());
	return back()->with('success','Item created successfully!');
}

public function create(Request $request)

{

$this->validate($request,[

'title' => 'required',

'details' => 'required'

]);

$items = Item::create($request->all());

return back()->with('success','Item created successfully!');

}

2. Redirect with error message

Below is example to simple redirect with error flash message.

public function create(Request $request)
{
    return redirect()->route('home')
        ->with('error','You have no permission for this page!');
}

public function create(Request $request)

{

return redirect()->route('home')

->with('error','You have no permission for this page!');

}

3. Redirect with warning message

Below is example to simple redirect with warning flash message.

public function create(Request $request)
{
    return redirect()->route('home')
            ->with('warning',"Don't Open this link");
}

public function create(Request $request)

{

return redirect()->route('home')

->with('warning',"Don't Open this link");

}

4. Redirect with info message

Below is example to simple redirect with info flash message.

public function create(Request $request)
{
    $this->validate($request,[
        'title' => 'required',
        'details' => 'required'
        ]);


    $items = Item::create($request->all());


    return back()->with('info','You added new items, follow next step!');
}

public function create(Request $request)

{

$this->validate($request,[

'title' => 'required',

'details' => 'required'

]);

$items = Item::create($request->all());

return back()->with('info','You added new items, follow next step!');

}

5. Validation Error

public function create(Request $request)
{
    $this->validate($request,[
        'title' => 'required',
        'details' => 'required'
        ]);
    .....
}

public function create(Request $request)

{

$this->validate($request,[

'title' => 'required',

'details' => 'required'

]);

.....

}

Laravel 8 Change Date Format Examples

In this Laravel 8 Change Date Format Examples tutorial I will show you how to change date format in laravel. In this tutorial you will learn to change date format using laravel format function in laravel. In this article I will share various example to change date format in laravel. We will also use carbon createFromFormat function to change date format in laravel.

Laravel 8 Change Date Format Examples

In this step by step tutorial I will demonstrate you with example how to change date format in laravel using laravel format function or using carbon createFromFormat function. Please follow the instruction given below:

Laravel 8 Change Date Format Examples

Here, I am sharing various example to change date format using laravel format function:

Example 1:-

public function getPost($id)
{
    $post = Post::find($id)
    $newDate = $post->created_at->format('d-m-Y');
    dd($newDate);
}

public function getPost($id)

{

$post = Post::find($id)

$newDate = $post->created_at->format('d-m-Y');

dd($newDate);

}

Output:-

"22-02-2020"

1	"22-02-2020"

Example 2:-

public function create()
{
    $date = date('Y-m-d H:i:s');
    $newDate = \Carbon\Carbon::createFromFormat('Y-m-d H:i:s', $date)
                    ->format('d-m-Y');
  
    dd($newDate);
}

public function create()

{

$date = date('Y-m-d H:i:s');

$newDate = \Carbon\Carbon::createFromFormat('Y-m-d H:i:s', $date)

->format('d-m-Y');

dd($newDate);

}

Output:-

"22-02-2020"

1	"22-02-2020"

Example 3 :- Laravel change date format to Y-m-d to m/d/Y

public function create()
{
    $date = "2020-02-22";
    $newDate = \Carbon\Carbon::createFromFormat('Y-m-d', $date)
                    ->format('m/d/Y');
    dd($newDate);
}

public function create()

{

$date = "2020-02-22";

$newDate = \Carbon\Carbon::createFromFormat('Y-m-d', $date)

->format('m/d/Y');

dd($newDate);

}

output:-

"02/22/2020"

1	"02/22/2020"

Example 4:- Laravel change date format to m/d/Y to Y-m-d

public function create()
{
    $date = "02/22/2020";
    $newDate = \Carbon\Carbon::createFromFormat('m/d/Y', $date)
                    ->format('Y-m-d');
    dd($newDate);
}

public function create()

{

$date = "02/22/2020";

$newDate = \Carbon\Carbon::createFromFormat('m/d/Y', $date)

->format('Y-m-d');

dd($newDate);

}

output:-

"2020-02-22"

1	"2020-02-22"

Example 5:- Laravel change date to Y-m-d to d/m/Y

public function create()
{
    $date = "2020-02-22";
    $newDate = \Carbon\Carbon::createFromFormat('Y-m-d', $date)
                    ->format('d/m/Y');
    dd($newDate);
}

public function create()

{

$date = "2020-02-22";

$newDate = \Carbon\Carbon::createFromFormat('Y-m-d', $date)

->format('d/m/Y');

dd($newDate);

}

output:-

"22/02/2020"

1	"22/02/2020"

Laravel 8 Inertia JS CRUD with Jetstream & Tailwind CSS

In this Laravel 8 Inertia JS CRUD with Jetstream Tailwind CSS tutorial I will show you how to create simple authentication and crud application with using Inertia JS with jetstream and tailwind css In laravel. In this tutorial you will learn what is Laravel 8 Inertia JS CRUD with Jetstream & Tailwind CSS. In this tutorial you will learn to create basic CRUD application with authentication using Inertia JS with jetstream package in laravel.

Laravel 8 Livewire CRUD with Jetstream Tailwind CSS

In this step by step guide, we will be creating a simple crud operation application with validation using JetStream with Inertia JS package in laravel 8. In this example you will learn how to insert, read, update and delete data from database using JetStream with Inertia JS package in laravel 8. Please follow the instruction given below:

Step 1: Install Laravel 8

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

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

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

Step 2: Create Auth with Jetstream Inertia JS

In this step, we will install Inertia Js and Jetstream Package via the composer dependency manager. Use the following command to install Inertia Js and Jetstream Package.

composer require laravel/jetstream

1	composer require laravel/jetstream

Now, lets create authentication using Inertia Js. Please use the following command:

php artisan jetstream:install inertia 
OR    
php artisan jetstream:install inertia --teams

php artisan jetstream:install inertia

php artisan jetstream:install inertia --teams

Install node js package:

npm install

1	npm install

Run package:

npm run dev

1	npm run dev

Run the migration command to create database table:

php artisan migrate

1	php artisan migrate

Step 3: Create Migration and Model

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

php artisan make:migration create_posts_table

1	php artisan make:migration create_posts_table

Migration:

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

<?php

use Illuminate\Database\Migrations\Migration;

use Illuminate\Database\Schema\Blueprint;

use Illuminate\Support\Facades\Schema;

class CreatePostsTable extends Migration

{

/**

* Run the migrations.

* @return void

public function up()

{

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

$table->id();

$table->string('title');

$table->text('body');

$table->timestamps();

});

}

/**

* Reverse the migrations.

* @return void

public function down()

{

Schema::dropIfExists('posts');

}

php artisan migrate

1	php artisan migrate

Create Post model using following command:

php artisan make:model Post

1	php artisan make:model Post

App/Models/Post.php

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

<?php

namespace App\Models;

use Illuminate\Database\Eloquent\Factories\HasFactory;

use Illuminate\Database\Eloquent\Model;

class Post extends Model

{

use HasFactory;

/**

* The attributes that are mass assignable.

* @var array

protected $fillable = [

'title', 'body'

];

}

Step 4: Create Route

Now, 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
   
use Illuminate\Support\Facades\Route;
   
use App\Http\Controllers\PostController;
  
/*
|--------------------------------------------------------------------------
| Web Routes
|--------------------------------------------------------------------------
|
| Here is where you can register web routes for your application. These
| routes are loaded by the RouteServiceProvider within a group which
| contains the "web" middleware group. Now create something great!
|
*/
   
Route::resource('posts', PostController::class);

<?php

use Illuminate\Support\Facades\Route;

use App\Http\Controllers\PostController;

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

| Web Routes

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

| Here is where you can register web routes for your application. These

| routes are loaded by the RouteServiceProvider within a group which

| contains the "web" middleware group. Now create something great!

Route::resource('posts', PostController::class);

Step 5: Create Controller

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

app/Http/Controllers/PostController.php

<?php
  
namespace App\Http\Controllers;
  
use Illuminate\Http\Request;
use Inertia\Inertia;
use App\Models\Post;
use Illuminate\Support\Facades\Validator;
  
class PostController extends Controller
{
    /**
     * Show the form for creating a new resource.
     *
     * @return Response
     */
    public function index()
    {
        $data = Post::all();
        return Inertia::render('posts', ['data' => $data]);
    }
  
    /**
     * Show the form for creating a new resource.
     *
     * @return Response
     */
    public function store(Request $request)
    {
        Validator::make($request->all(), [
            'title' => ['required'],
            'body' => ['required'],
        ])->validate();
  
        Post::create($request->all());
  
        return redirect()->back()
                    ->with('message', 'Post Created Successfully.');
    }
  
    /**
     * Show the form for creating a new resource.
     *
     * @return Response
     */
    public function update(Request $request)
    {
        Validator::make($request->all(), [
            'title' => ['required'],
            'body' => ['required'],
        ])->validate();
  
        if ($request->has('id')) {
            Post::find($request->input('id'))->update($request->all());
            return redirect()->back()
                    ->with('message', 'Post Updated Successfully.');
        }
    }
  
    /**
     * Show the form for creating a new resource.
     *
     * @return Response
     */
    public function destroy(Request $request)
    {
        if ($request->has('id')) {
            Post::find($request->input('id'))->delete();
            return redirect()->back();
        }
    }
}

<?php

namespace App\Http\Controllers;

use Illuminate\Http\Request;

use Inertia\Inertia;

use App\Models\Post;

use Illuminate\Support\Facades\Validator;

class PostController extends Controller

{

/**

* Show the form for creating a new resource.

* @return Response

public function index()

{

$data = Post::all();

return Inertia::render('posts', ['data' => $data]);

}

/**

* Show the form for creating a new resource.

* @return Response

public function store(Request $request)

{

Validator::make($request->all(), [

'title' => ['required'],

'body' => ['required'],

])->validate();

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

return redirect()->back()

->with('message', 'Post Created Successfully.');

}

/**

* Show the form for creating a new resource.

* @return Response

public function update(Request $request)

{

Validator::make($request->all(), [

'title' => ['required'],

'body' => ['required'],

])->validate();

if ($request->has('id')) {

Post::find($request->input('id'))->update($request->all());

return redirect()->back()

->with('message', 'Post Updated Successfully.');

}

/**

* Show the form for creating a new resource.

* @return Response

public function destroy(Request $request)

{

if ($request->has('id')) {

Post::find($request->input('id'))->delete();

return redirect()->back();

}

In this step we will share ‘message’ and ‘errors’ variable for success message and validation error. Lets share this variables on appservices provider as following:

app/Providers/AppServiceProvider.php

<?php
   
namespace App\Providers;
  
use Illuminate\Support\ServiceProvider;
use Illuminate\Support\Facades\Session;
use Inertia\Inertia;
  
class AppServiceProvider extends ServiceProvider
{
    /**
     * Register any application services.
     *
     * @return void
     */
    public function register()
    {
    }
  
    /**
     * Bootstrap any application services.
     *
     * @return void
     */
    public function boot()
    {
        Inertia::share([
            'errors' => function () {
                return Session::get('errors')
                    ? Session::get('errors')->getBag('default')->getMessages()
                    : (object) [];
            },
        ]);
  
        Inertia::share('flash', function () {
            return [
                'message' => Session::get('message'),
            ];
        });
    }
}

<?php

namespace App\Providers;

use Illuminate\Support\ServiceProvider;

use Illuminate\Support\Facades\Session;

use Inertia\Inertia;

class AppServiceProvider extends ServiceProvider

{

/**

* Register any application services.

* @return void

public function register()

{

}

/**

* Bootstrap any application services.

* @return void

public function boot()

{

Inertia::share([

'errors' => function () {

return Session::get('errors')

? Session::get('errors')->getBag('default')->getMessages()

: (object) [];

]);

Inertia::share('flash', function () {

return [

'message' => Session::get('message'),

];

});

}

Step 7: Create Vue Page

Now, create posts page vue file to list posts and create and update. so, let’s create it and add bellow code on it.

resources/js/Pages/posts.vue

<template>
    <app-layout>
        <template #header>
            <h2 class="font-semibold text-xl text-gray-800 leading-tight">
                Manage Post - (Laravel 8 Inertia JS CRUD with Jetstream & Tailwind CSS)
            </h2>
        </template>
        <div class="py-12">
            <div class="max-w-7xl mx-auto sm:px-6 lg:px-8">
                <div class="bg-white overflow-hidden shadow-xl sm:rounded-lg px-4 py-4">
                    <div class="bg-teal-100 border-t-4 border-teal-500 rounded-b text-teal-900 px-4 py-3 shadow-md my-3" role="alert" v-if="$page.flash.message">
                      <div class="flex">
                        <div>
                          <p class="text-sm">{{ $page.flash.message }}</p>
                        </div>
                      </div>
                    </div>
                    <button @click="openModal()" class="bg-blue-500 hover:bg-blue-700 text-white font-bold py-2 px-4 rounded my-3">Create New Post</button>
                    <table class="table-fixed w-full">
                        <thead>
                            <tr class="bg-gray-100">
                                <th class="px-4 py-2 w-20">No.</th>
                                <th class="px-4 py-2">Title</th>
                                <th class="px-4 py-2">Body</th>
                                <th class="px-4 py-2">Action</th>
                            </tr>
                        </thead>
                        <tbody>
                            <tr v-for="row in data">
                                <td class="border px-4 py-2">{{ row.id }}</td>
                                <td class="border px-4 py-2">{{ row.title }}</td>
                                <td class="border px-4 py-2">{{ row.body }}</td>
                                <td class="border px-4 py-2">
                                    <button @click="edit(row)" class="bg-blue-500 hover:bg-blue-700 text-white font-bold py-2 px-4 rounded">Edit</button>
                                    <button @click="deleteRow(row)" class="bg-red-500 hover:bg-red-700 text-white font-bold py-2 px-4 rounded">Delete</button>
                                </td>
                            </tr>
                        </tbody>
                    </table>
                    <div class="fixed z-10 inset-0 overflow-y-auto ease-out duration-400" v-if="isOpen">
                      <div class="flex items-end justify-center min-h-screen pt-4 px-4 pb-20 text-center sm:block sm:p-0">
                        
                        <div class="fixed inset-0 transition-opacity">
                          <div class="absolute inset-0 bg-gray-500 opacity-75"></div>
                        </div>
                        <!-- This element is to trick the browser into centering the modal contents. -->
                        <span class="hidden sm:inline-block sm:align-middle sm:h-screen"></span>
                        <div class="inline-block align-bottom bg-white rounded-lg text-left overflow-hidden shadow-xl transform transition-all sm:my-8 sm:align-middle sm:max-w-lg sm:w-full" role="dialog" aria-modal="true" aria-labelledby="modal-headline">
                          <form>
                          <div class="bg-white px-4 pt-5 pb-4 sm:p-6 sm:pb-4">
                            <div class="">
                                  <div class="mb-4">
                                      <label for="exampleFormControlInput1" class="block text-gray-700 text-sm font-bold mb-2">Title:</label>
                                      <input type="text" class="shadow appearance-none border rounded w-full py-2 px-3 text-gray-700 leading-tight focus:outline-none focus:shadow-outline" id="exampleFormControlInput1" placeholder="Enter Title" v-model="form.title">
                                      <div v-if="$page.errors.title" class="text-red-500">{{ $page.errors.title[0] }}</div>
                                  </div>
                                  <div class="mb-4">
                                      <label for="exampleFormControlInput2" class="block text-gray-700 text-sm font-bold mb-2">Body:</label>
                                      <textarea class="shadow appearance-none border rounded w-full py-2 px-3 text-gray-700 leading-tight focus:outline-none focus:shadow-outline" id="exampleFormControlInput2" v-model="form.body" placeholder="Enter Body"></textarea>
                                      <div v-if="$page.errors.body" class="text-red-500">{{ $page.errors.body[0] }}</div>
                                  </div>
                            </div>
                          </div>
                          <div class="bg-gray-50 px-4 py-3 sm:px-6 sm:flex sm:flex-row-reverse">
                            <span class="flex w-full rounded-md shadow-sm sm:ml-3 sm:w-auto">
                              <button wire:click.prevent="store()" type="button" class="inline-flex justify-center w-full rounded-md border border-transparent px-4 py-2 bg-green-600 text-base leading-6 font-medium text-white shadow-sm hover:bg-green-500 focus:outline-none focus:border-green-700 focus:shadow-outline-green transition ease-in-out duration-150 sm:text-sm sm:leading-5" v-show="!editMode" @click="save(form)">
                                Save
                              </button>
                            </span>
                            <span class="flex w-full rounded-md shadow-sm sm:ml-3 sm:w-auto">
                              <button wire:click.prevent="store()" type="button" class="inline-flex justify-center w-full rounded-md border border-transparent px-4 py-2 bg-green-600 text-base leading-6 font-medium text-white shadow-sm hover:bg-green-500 focus:outline-none focus:border-green-700 focus:shadow-outline-green transition ease-in-out duration-150 sm:text-sm sm:leading-5" v-show="editMode" @click="update(form)">
                                Update
                              </button>
                            </span>
                            <span class="mt-3 flex w-full rounded-md shadow-sm sm:mt-0 sm:w-auto">
                              
                              <button @click="closeModal()" type="button" class="inline-flex justify-center w-full rounded-md border border-gray-300 px-4 py-2 bg-white text-base leading-6 font-medium text-gray-700 shadow-sm hover:text-gray-500 focus:outline-none focus:border-blue-300 focus:shadow-outline-blue transition ease-in-out duration-150 sm:text-sm sm:leading-5">
                                Cancel
                              </button>
                            </span>
                          </div>
                          </form>
                          
                        </div>
                      </div>
                    </div>
                </div>
            </div>
        </div>
    </app-layout>
</template>
<script>
    import AppLayout from './../Layouts/AppLayout'
    import Welcome from './../Jetstream/Welcome'
    export default {
        components: {
            AppLayout,
            Welcome,
        },
        props: ['data', 'errors'],
        data() {
            return {
                editMode: false,
                isOpen: false,
                form: {
                    title: null,
                    body: null,
                },
            }
        },
        methods: {
            openModal: function () {
                this.isOpen = true;
            },
            closeModal: function () {
                this.isOpen = false;
                this.reset();
                this.editMode=false;
            },
            reset: function () {
                this.form = {
                    title: null,
                    body: null,
                }
            },
            save: function (data) {
                this.$inertia.post('/posts', data)
                this.reset();
                this.closeModal();
                this.editMode = false;
            },
            edit: function (data) {
                this.form = Object.assign({}, data);
                this.editMode = true;
                this.openModal();
            },
            update: function (data) {
                data._method = 'PUT';
                this.$inertia.post('/posts/' + data.id, data)
                this.reset();
                this.closeModal();
            },
            deleteRow: function (data) {
                if (!confirm('Are you sure want to remove?')) return;
                data._method = 'DELETE';
                this.$inertia.post('/posts/' + data.id, data)
                this.reset();
                this.closeModal();
            }
        }
    }
</script>

100

101

102

103

104

105

106

107

108

109

110

111

112

113

114

115

116

117

118

119

120

121

122

123

124

125

126

127

128

129

130

131

132

133

134

135

136

137

138

139

140

141

142

143

144

145

146

147

148

149

150

151

152

<app-layout>

Manage Post - (Laravel 8 Inertia JS CRUD with Jetstream & Tailwind CSS)

</h2>

</template>

<div>

<p class="text-sm">{{ $page.flash.message }}</p>

</div>

<button @click="openModal()" class="bg-blue-500 hover:bg-blue-700 text-white font-bold py-2 px-4 rounded my-3">Create New Post</button>

<thead>

<th class="px-4 py-2">Title</th>

<th class="px-4 py-2">Action</th>

</tr>

</thead>

<tbody>

<td class="border px-4 py-2">{{ row.title }}</td>

<button @click="deleteRow(row)" class="bg-red-500 hover:bg-red-700 text-white font-bold py-2 px-4 rounded">Delete</button>

</td>

</tr>

</tbody>

</table>

</div>

<form>

<label for="exampleFormControlInput1" class="block text-gray-700 text-sm font-bold mb-2">Title:</label>

<div v-if="$page.errors.title" class="text-red-500">{{ $page.errors.title[0] }}</div>

</div>

<div v-if="$page.errors.body" class="text-red-500">{{ $page.errors.body[0] }}</div>

</div>

Save

</button>

</span>

Update

</button>

</span>

Cancel

</button>

</span>

</div>

</form>

</div>

</app-layout>

</template>

import AppLayout from './../Layouts/AppLayout'

import Welcome from './../Jetstream/Welcome'

export default {

components: {

AppLayout,

Welcome,

props: ['data', 'errors'],

data() {

return {

editMode: false,

isOpen: false,

form: {

title: null,

body: null,

}

methods: {

openModal: function () {

this.isOpen = true;

closeModal: function () {

this.isOpen = false;

this.reset();

this.editMode=false;

reset: function () {

this.form = {

title: null,

body: null,

}

save: function (data) {

this.$inertia.post('/posts', data)

this.reset();

this.closeModal();

this.editMode = false;

edit: function (data) {

this.form = Object.assign({}, data);

this.editMode = true;

this.openModal();

update: function (data) {

data._method = 'PUT';

this.$inertia.post('/posts/' + data.id, data)

this.reset();

this.closeModal();

deleteRow: function (data) {

if (!confirm('Are you sure want to remove?')) return;

data._method = 'DELETE';

this.$inertia.post('/posts/' + data.id, data)

this.reset();

this.closeModal();

}

</script>

Run npm watch command

npm run watch

1	npm run watch

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 –

//localhost:8000/post

1	//localhost:8000/post

Laravel 8 Autocomplete Search from Database Example

In this Laravel 8 Autocomplete Search from Database Example tutorial, I will show you how to create a dynamic database driven ajax jquery autocomplete search in Laravel. In this tutorial we will create a dynamic search autocomplete which will fetch options from database table using bootstrap jquery.

Laravel 8 Autocomplete Search from Database Example

In this step by step tutorial I will demonstrate you with example creating a autocomplete search input which will fetch options from database. Please follow the instruction given below:

Step 1 : Download and Laravel 8

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

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

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

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=lara8blog
DB_USERNAME=root
DB_PASSWORD

DB_CONNECTION=mysql

DB_HOST=127.0.0.1

DB_PORT=3306

DB_DATABASE=lara8blog

DB_USERNAME=root

DB_PASSWORD

Step 2: Create Migration and Model

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

php artisan make:migration create_items_table

1	php artisan make:migration create_items_table

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

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

<?php

use Illuminate\Support\Facades\Schema;

use Illuminate\Database\Schema\Blueprint;

use Illuminate\Database\Migrations\Migration;

class CreateItemsTable extends Migration

{

/**

* Run the migrations.

* @return void

public function up()

{

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

$table->id();

$table->string('name');

$table->timestamps();

});

}

/**

* Reverse the migrations.

* @return void

public function down()

{

Schema::dropIfExists('items');

}

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

php artisan migrate

1	php artisan migrate

Create model file “app/Models/Item.php” and put following code in item.php file:

app/Models/Item.php

<?php  
namespace App\Models;  
use Illuminate\Database\Eloquent\Factories\HasFactory;
use Illuminate\Database\Eloquent\Model;
  
class Item extends Model
{
    use HasFactory;
  
    protected $fillable = [
        'name'
    ];
}

<?php

namespace App\Models;

use Illuminate\Database\Eloquent\Factories\HasFactory;

use Illuminate\Database\Eloquent\Model;

class Item extends Model

{

use HasFactory;

protected $fillable = [

'name'

];

}

Step 3: Create 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
  use Illuminate\Support\Facades\Route;  
use App\Http\Controllers\SearchController;  
/*
|--------------------------------------------------------------------------
| Web Routes
|--------------------------------------------------------------------------
|
| Here is where you can register web routes for your application. These
| routes are loaded by the RouteServiceProvider within a group which
| contains the "web" middleware group. Now create something great!
|
*/  
Route::get('search', [SearchController::class, 'index'])->name('search');
Route::get('autocomplete', [SearchController::class, 'autocomplete'])->name('autocomplete');

<?php

use Illuminate\Support\Facades\Route;

use App\Http\Controllers\SearchController;

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

| Web Routes

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

| Here is where you can register web routes for your application. These

| routes are loaded by the RouteServiceProvider within a group which

| contains the "web" middleware group. Now create something great!

Route::get('search', [SearchController::class, 'index'])->name('search');

Route::get('autocomplete', [SearchController::class, 'autocomplete'])->name('autocomplete');

Step 4: Create Controller

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

php artisan make:controller SearchController

1	php artisan make:controller SearchController

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

app/Http/Controllers/SearchController.php

<?php  
namespace App\Http\Controllers;  
use Illuminate\Http\Request;
use App\Models\Item;  
class SearchController extends Controller
{
    /**
     * Display a listing of the resource.
     *
     * @return \Illuminate\Http\Response
     */
    public function index()
    {
        return view('search');
    }  
    /**
     * Show the form for creating a new resource.
     *
     * @return \Illuminate\Http\Response
     */
    public function autocomplete(Request $request)
    {
        $data = Item::select("name")
                ->where("name","LIKE","%{$request->query}%")
                ->get();
   
        return response()->json($data);
    }
}

<?php

namespace App\Http\Controllers;

use Illuminate\Http\Request;

use App\Models\Item;

class SearchController extends Controller

{

/**

* Display a listing of the resource.

* @return \Illuminate\Http\Response

public function index()

{

return view('search');

}

/**

* Show the form for creating a new resource.

* @return \Illuminate\Http\Response

public function autocomplete(Request $request)

{

$data = Item::select("name")

->where("name","LIKE","%{$request->query}%")

->get();

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

}

Step 5: Create View File

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

resources/views/search.blade.php

<!DOCTYPE html>
<html>
<head>
    <title>Laravel 8 Autocomplete Search using Bootstrap Typeahead JS</title>
    <link rel="stylesheet" href="https://cdnjs.cloudflare.com/ajax/libs/twitter-bootstrap/4.1.3/css/bootstrap.min.css" />
    <script src="http://ajax.googleapis.com/ajax/libs/jquery/1.9.1/jquery.js"></script>
    <script src="https://cdnjs.cloudflare.com/ajax/libs/bootstrap-3-typeahead/4.0.1/bootstrap3-typeahead.min.js"></script>
</head>
<body>
   
<div class="container">
    <h1>Laravel 8 Autocomplete Search using Bootstrap Typeahead JS</h1>   
    <input class="typeahead form-control" type="text">
</div>
   
<script type="text/javascript">
    var path = "{{ route('autocomplete') }}";
    $('input.typeahead').typeahead({
        source:  function (query, process) {
        return $.get(path, { query: query }, function (data) {
                return process(data);
            });
        }
    });
</script>
   
</body>
</html>

<!DOCTYPE html>

<html>

<head>

<title>Laravel 8 Autocomplete Search using Bootstrap Typeahead JS</title>

</head>

<body>

<h1>Laravel 8 Autocomplete Search using Bootstrap Typeahead JS</h1>

</div>

var path = "{{ route('autocomplete') }}";

$('input.typeahead').typeahead({

source: function (query, process) {

return $.get(path, { query: query }, function (data) {

return process(data);

});

}

});

</script>

</body>

</html>

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/search

1	http://localhost:8000/search

Laravel 8 Ajax Image Upload Example

In this Laravel 8 Ajax Image Upload Example tutorial I will show you how to upload image using ajax in laravel application. In this tutorial you will learn to upload image file using ajax in laravel 8. You will also learn to upload and save image in laravel 8 using ajax. In this laravel ajax image upload example, I’ll show you how to validate upload image into folder and then save it into database using ajax. Before saving image into database we will validate image and then save it into directory using. Before uploading the image we will perform server side validation. After successfully image upload into the database and folder we will display uploaded image on the screen.

Laravel 8 Ajax Image Upload Example

In this step by step tutorial I will demonstrate you with an example to upload image using ajax in laravel application. Please follow the instruction given below:

Step 1 : Install Laravel 8 Application

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

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

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

Step 2 : Database Configuration

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_HOST=localhost
DB_DATABASE=homestead
DB_USERNAME=homestead
DB_PASSWORD=secret

DB_HOST=localhost

DB_DATABASE=homestead

DB_USERNAME=homestead

DB_PASSWORD=secret

Step 3: Create ajax_images Table and Model

Now, we have to define table schema for ajax_image table. Open terminal and let’s run the following command to generate a migration along with model file to create ajax_image table in our database.

php artisan make:migration create_ajax_image_tabel

1	php artisan make:migration create_ajax_image_tabel

Once this command is executed you will find a migration file created under “database/migrations”. lets open migration file and put following code in it –

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

<?php

use Illuminate\Support\Facades\Schema;

use Illuminate\Database\Schema\Blueprint;

use Illuminate\Database\Migrations\Migration;

class CreateAjaxImageTabel extends Migration

{

/**

* Run the migrations.

* @return void

public function up()

{

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

$table->id();

$table->string('title');

$table->string('image');

$table->timestamps();

});

}

/**

* Reverse the migrations.

* @return void

public function down()

{

Schema::drop("ajax_images");

}

Now, run following command to migrate database schema.

php artisan migrate

1	php artisan migrate

After creating “ajax_images” table ,create AjaxImage model for Categories.

php artisan make:model AjaxImage

1	php artisan make:model AjaxImage

Now, in this step we will create model file app/Models/AjaxImage.php and put the following code in item.php file:

app/Models/AjaxImage.php

<?php
  
namespace App\Models;
  
use Illuminate\Database\Eloquent\Factories\HasFactory;
use Illuminate\Database\Eloquent\Model;
  
class AjaxImage extends Model
{
    use HasFactory;
  
    protected $fillable = [
        'title', 'image'
    ];
}

<?php

namespace App\Models;

use Illuminate\Database\Eloquent\Factories\HasFactory;

use Illuminate\Database\Eloquent\Model;

class AjaxImage extends Model

{

use HasFactory;

protected $fillable = [

'title', 'image'

];

}

Step 4: Create Route

Now, 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
  
use Illuminate\Support\Facades\Route;
  
use App\Http\Controllers\AjaxImageUploadController;
  
/*
|--------------------------------------------------------------------------
| Web Routes
|--------------------------------------------------------------------------
|
| Here is where you can register web routes for your application. These
| routes are loaded by the RouteServiceProvider within a group which
| contains the "web" middleware group. Now create something great!
|
*/
  
Route::get('ajaxImageUpload', [AjaxImageUploadController::class, 'ajaxImageUpload']);
Route::post('ajaxImageUpload', [AjaxImageUploadController::class, 'ajaxImageUploadPost'])->name('ajaxImageUpload');

<?php

use Illuminate\Support\Facades\Route;

use App\Http\Controllers\AjaxImageUploadController;

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

| Web Routes

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

| Here is where you can register web routes for your application. These

| routes are loaded by the RouteServiceProvider within a group which

| contains the "web" middleware group. Now create something great!

Route::get('ajaxImageUpload', [AjaxImageUploadController::class, 'ajaxImageUpload']);

Route::post('ajaxImageUpload', [AjaxImageUploadController::class, 'ajaxImageUploadPost'])->name('ajaxImageUpload');

Step 5: Create Controller

Now create new controller as AjaxImageUploadController in this path app/Http/Controllers/AjaxImageUploadController.php.

php artisan make:controller AjaxImageUploadController

1	php artisan make:controller AjaxImageUploadController

app/Http/Controllers/AjaxImageUploadController.php

<?php
namespace App\Http\Controllers;
use Illuminate\Http\Request;
use Validator;
use App\Models\AjaxImage;
class AjaxImageUploadController extends Controller
{
    /**
     * Show the application ajaxImageUpload.
     *
     * @return \Illuminate\Http\Response
     */
    public function ajaxImageUpload()
    {
        return view('ajaxImageUpload');
    }
    /**
     * Show the application ajaxImageUploadPost.
     *
     * @return \Illuminate\Http\Response
     */
    public function ajaxImageUploadPost(Request $request)
    {
      $validator = Validator::make($request->all(), [
        'title' => 'required',
        'image' => 'required|image|mimes:jpeg,png,jpg,gif,svg|max:2048',
      ]);
      if ($validator->passes()) {

        $input = $request->all();
        $input['image'] = time().'.'.$request->image->extension();
        $request->image->move(public_path('images'), $input['image']);
        AjaxImage::create($input);
       return response()->json(['success'=>'done']);
      }
      return response()->json(['error'=>$validator->errors()->all()]);
    }
}

<?php

namespace App\Http\Controllers;

use Illuminate\Http\Request;

use Validator;

use App\Models\AjaxImage;

class AjaxImageUploadController extends Controller

{

/**

* Show the application ajaxImageUpload.

* @return \Illuminate\Http\Response

public function ajaxImageUpload()

{

return view('ajaxImageUpload');

}

/**

* Show the application ajaxImageUploadPost.

* @return \Illuminate\Http\Response

public function ajaxImageUploadPost(Request $request)

{

$validator = Validator::make($request->all(), [

'title' => 'required',

'image' => 'required|image|mimes:jpeg,png,jpg,gif,svg|max:2048',

]);

if ($validator->passes()) {

$input = $request->all();

$input['image'] = time().'.'.$request->image->extension();

$request->image->move(public_path('images'), $input['image']);

AjaxImage::create($input);

return response()->json(['success'=>'done']);

}

return response()->json(['error'=>$validator->errors()->all()]);

}

Step 6: Create View

Now create ajaxImageUpload.blade.php(resources/views/ajaxImageUpload.blade.php) for layout design code and form for ajax image upload.

resources/views/ajaxImageUpload.blade.php

<!DOCTYPE html>
<html>
<head>
    <title>Laravel 8 - Ajax Image Uploading Tutorial</title>
    <link rel="stylesheet" type="text/css" href="https://maxcdn.bootstrapcdn.com/bootstrap/3.3.7/css/bootstrap.min.css">
    <script src="http://ajax.googleapis.com/ajax/libs/jquery/1.11.2/jquery.min.js"></script>
    <script src="http://malsup.github.com/jquery.form.js"></script>
</head>
<body>
<div class="container">
  <h1>Laravel 8 - Ajax Image Uploading Tutorial</h1>
  <form action="{{ route('ajaxImageUpload') }}" enctype="multipart/form-data" method="POST">
    <div class="alert alert-danger print-error-msg" style="display:none">
        <ul></ul>
    </div>
    <input type="hidden" name="_token" value="{{ csrf_token() }}">
    <div class="form-group">
      <label>Alt Title:</label>
      <input type="text" name="title" class="form-control" placeholder="Add Title">
    </div>
    <div class="form-group">
      <label>Image:</label>
      <input type="file" name="image" class="form-control">
    </div>
    <div class="form-group">
      <button class="btn btn-success upload-image" type="submit">Upload Image</button>
    </div>
  </form>
</div>
<script type="text/javascript">
  $("body").on("click",".upload-image",function(e){
    $(this).parents("form").ajaxForm(options);
  });
  var options = { 
    complete: function(response) 
    {
        if($.isEmptyObject(response.responseJSON.error)){
            $("input[name='title']").val('');
            alert('Image Upload Successfully.');
        }else{
            printErrorMsg(response.responseJSON.error);
        }
    }
  };
  function printErrorMsg (msg) {
    $(".print-error-msg").find("ul").html('');
    $(".print-error-msg").css('display','block');
    $.each( msg, function( key, value ) {
        $(".print-error-msg").find("ul").append('<li>'+value+'</li>');
    });
  }
</script>
</body>
</html>

<!DOCTYPE html>

<html>

<head>

<title>Laravel 8 - Ajax Image Uploading Tutorial</title>

</head>

<body>

<h1>Laravel 8 - Ajax Image Uploading Tutorial</h1>

</div>

<label>Alt Title:</label>

</div>

<label>Image:</label>

</div>

<button class="btn btn-success upload-image" type="submit">Upload Image</button>

</div>

</form>

</div>

$("body").on("click",".upload-image",function(e){

$(this).parents("form").ajaxForm(options);

});

var options = {

complete: function(response)

{

if($.isEmptyObject(response.responseJSON.error)){

$("input[name='title']").val('');

alert('Image Upload Successfully.');

}else{

printErrorMsg(response.responseJSON.error);

}

};

function printErrorMsg (msg) {

$(".print-error-msg").find("ul").html('');

$(".print-error-msg").css('display','block');

$.each( msg, function( key, value ) {

$(".print-error-msg").find("ul").append('<li>'+value+'</li>');

});

}

</script>

</body>

</html>

Note:- Do remember to create “images” folder in public directory.

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/ajaxImageUpload

1	http://localhost:8000/ajaxImageUpload

How to Get Last Executed Query in Laravel 8

In this How to Get Last Executed Query in Laravel 8 tutorial I will show you how to get or print last executed query in laravel application. In this tutorial you will learn to display or print last executed query in your laravel 8 application. In this article I will share various example to display or print last executed sql query in laravel. In this examples we will be using toSql(), DB::enableQueryLog() and DB::getQueryLog() to output of print sql query. These examples we will help us to debug last executed sql query in laravel.

How to Get Last Executed Query in Laravel 8

In this step by step tutorial I will demonstrate you with example to print or output last executed query in laravel application. We will use sql query in laravel 8 using toSql(), DB::enableQueryLog() and DB::getQueryLog(). Please follow the instruction given below:

Example 1:-

Please put the following code in your controller code:

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

<?php

namespace App\Http\Controllers;

use App\Models\User;

class UserController extends Controller

{

/**

* Create a new controller instance.

* @return void

public function redirectToGoogle()

{

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

dd($query);

}

Output:-

select * from `users`

1	select * from `users`

Example 2:-

Please put the following code in your controller code:

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

<?php

namespace App\Http\Controllers;

use App\Models\User;

use DB;

class UserController extends Controller

{

/**

* Create a new controller instance.

* @return void

public function redirectToGoogle()

{

DB::enableQueryLog();

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

$quries = DB::getQueryLog();

dd($quries);

}

Output:-

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

array:1 [▼

0 => array:3 [▼

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

"bindings" => []

"time" => 4.25

]

Example 3:-

Please put the following code in your controller code:

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

<?php

namespace App\Http\Controllers;

use App\Models\User;

use DB;

class UserController extends Controller

{

/**

* Create a new controller instance.

* @return void

public function redirectToGoogle()

{

DB::enableQueryLog();

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

$query = DB::getQueryLog();

$query = end($query);

dd($query);

}

Output:-

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

array:3 [▼

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

"bindings" => []

"time" => 2.07

]

Laravel 8 Get Current Logged in User Data Example

In this Laravel 8 Get Current Logged in User Data Example tutorial I will show you how to get current logged in user information in laravel 8 application. In this tutorial you will learn to get current logged in user data in laravel. In this article I will share various example to get user data like name, id, email, address etc. I will also show you how to get user data in laravel controller or blade files. We will use auth() helper and Auth facade class to get current user data.

Laravel 8 Get Current Logged in User Data Example

In this step by step tutorial I will demonstrate you how to get current logged in user data using auth helper or Auth facade.

Laravel Get Current User Data Using Auth Helper:

In this example I will show you how to get current user data using auth() helper:

$user = auth()->user();  
  var_dump($user->id);  
var_dump($user->name);  
var_dump($user->email);

$user = auth()->user();

var_dump($user->id);

var_dump($user->name);

var_dump($user->email);

Output:-

10
Steve
steve@yoursite.com

Steve

steve@yoursite.com

Laravel Get Current User Data Using Auth Facade:

In this example I will show you how to get current user data using auth() facade:

$user = Auth::user();  
var_dump($user->id);  
var_dump($user->name);  
var_dump($user->email);

$user = Auth::user();

var_dump($user->id);

var_dump($user->name);

var_dump($user->email);

Output:-

10
Steve
steve@yoursite.com

Steve

steve@yoursite.com

Laravel 8 Multiple Database Connection Example

In this Laravel 8 Multiple Database Connection Example tutorial I will show you how to connect or use multiple database in single laravel project. In this tutorial you will learn to connect or use multiple database in single laravel project. Sometimes we may need to connect multiple databases in our Laravel application. In this article I will share with you how to connect single or multiple databases using a laravel application.

Laravel 8 Multiple Database Connection Example

In this step by step tutorial I will demonstrate you how to connect multiple database in one laravel application. Please follow the instruction given below:

Set ENV Variable:-

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

DB_CONNECTION_SECOND=mysql
DB_HOST_SECOND=127.0.0.1
DB_PORT_SECOND=3306
DB_DATABASE_SECOND=mydatabase2
DB_USERNAME_SECOND=root
DB_PASSWORD_SECOND=root

DB_CONNECTION=mysql

DB_HOST=127.0.0.1

DB_PORT=3306

DB_DATABASE=mydatabase

DB_USERNAME=root

DB_PASSWORD=root

DB_CONNECTION_SECOND=mysql

DB_HOST_SECOND=127.0.0.1

DB_PORT_SECOND=3306

DB_DATABASE_SECOND=mydatabase2

DB_USERNAME_SECOND=root

DB_PASSWORD_SECOND=root

Use ENV Variable:-

Open database.php file and add new connections key as shown

config/database.php

<?php
use Illuminate\Support\Str;

return [

    'default' => env('DB_CONNECTION', 'mysql'),  

    'connections' => [
        .....  

        'mysql' => [
            'driver' => 'mysql',
            'url' => env('DATABASE_URL'),
            'host' => env('DB_HOST', '127.0.0.1'),
            'port' => env('DB_PORT', '3306'),
            'database' => env('DB_DATABASE', 'forge'),
            'username' => env('DB_USERNAME', 'forge'),
            'password' => env('DB_PASSWORD', ''),
            'unix_socket' => env('DB_SOCKET', ''),
            'charset' => 'utf8mb4',
            'collation' => 'utf8mb4_unicode_ci',
            'prefix' => '',
            'prefix_indexes' => true,
            'strict' => true,
            'engine' => null,
            'options' => extension_loaded('pdo_mysql') ? array_filter([
                PDO::MYSQL_ATTR_SSL_CA => env('MYSQL_ATTR_SSL_CA'),
            ]) : [],
        ],

        'mysql2' => [
            'driver' => env('DB_CONNECTION_SECOND'),
            'host' => env('DB_HOST_SECOND', '127.0.0.1'),
            'port' => env('DB_PORT_SECOND', '3306'),
            'database' => env('DB_DATABASE_SECOND', 'forge'),
            'username' => env('DB_USERNAME_SECOND', 'forge'),
            'password' => env('DB_PASSWORD_SECOND', ''),
            'unix_socket' => '',
            'charset' => 'utf8mb4',
            'collation' => 'utf8mb4_unicode_ci',
            'prefix' => '',
            'prefix_indexes' => true,
            'strict' => true,
            'engine' => null,
        ],

.....

<?php

use Illuminate\Support\Str;

return [

'default' => env('DB_CONNECTION', 'mysql'),

'connections' => [

.....

'mysql' => [

'driver' => 'mysql',

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

'host' => env('DB_HOST', '127.0.0.1'),

'port' => env('DB_PORT', '3306'),

'database' => env('DB_DATABASE', 'forge'),

'username' => env('DB_USERNAME', 'forge'),

'password' => env('DB_PASSWORD', ''),

'unix_socket' => env('DB_SOCKET', ''),

'charset' => 'utf8mb4',

'collation' => 'utf8mb4_unicode_ci',

'prefix' => '',

'prefix_indexes' => true,

'strict' => true,

'engine' => null,

'options' => extension_loaded('pdo_mysql') ? array_filter([

PDO::MYSQL_ATTR_SSL_CA => env('MYSQL_ATTR_SSL_CA'),

]) : [],

'mysql2' => [

'driver' => env('DB_CONNECTION_SECOND'),

'host' => env('DB_HOST_SECOND', '127.0.0.1'),

'port' => env('DB_PORT_SECOND', '3306'),

'database' => env('DB_DATABASE_SECOND', 'forge'),

'username' => env('DB_USERNAME_SECOND', 'forge'),

'password' => env('DB_PASSWORD_SECOND', ''),

'unix_socket' => '',

'charset' => 'utf8mb4',

'collation' => 'utf8mb4_unicode_ci',

'prefix' => '',

'prefix_indexes' => true,

'strict' => true,

'engine' => null,

.....

How to use Multiple Database Connection

In this example I will show you how to use multiple database connection in your laravel application:

Laravel Database Connection In migration

Default:-

<?php
.....
public function up()
{
    Schema::create('blog', function (Blueprint $table) {
        $table->increments('id');
        $table->string('title');
        $table->string('body')->nullable();
        $table->timestamps();
    });
}
.....

<?php

.....

public function up()

{

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

$table->increments('id');

$table->string('title');

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

$table->timestamps();

});

}

.....

You can modify above snippet with connection specific as following:

<?php
.....
public function up{

    Schema::connection('mysql2')->create('blog', function (Blueprint $table) {

        $table->increments('id');
        $table->string('title');
        $table->string('body')->nullable();
        $table->timestamps();
    });
}
.....

<?php

.....

public function up{

Schema::connection('mysql2')->create('blog', function (Blueprint $table) {

$table->increments('id');

$table->string('title');

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

$table->timestamps();

});

}

.....

Laravel Database Connection In model

Default:

<?php  

namespace App; 

use Illuminate\Database\Eloquent\Model;  

class Blog extends Model
{
}

<?php

namespace App;

use Illuminate\Database\Eloquent\Model;

class Blog extends Model

{

}

You can specify database connection in model file as following:

<?php  

namespace App; 

use Illuminate\Database\Eloquent\Model;   

class Blog extends Model{

    protected $connection = 'mysql2';
}

<?php

namespace App;

use Illuminate\Database\Eloquent\Model;

class Blog extends Model{

protected $connection = 'mysql2';

}

Laravel Database Connection In Controller

Default:

<?php 

class BlogController extends BaseController
{
    public function getRecord()
    {
        $blogModel = new Blog;
        $find = $blogModel->find(1);
        return $find;
    }
}

<?php

class BlogController extends BaseController

{

public function getRecord()

{

$blogModel = new Blog;

$find = $blogModel->find(1);

return $find;

}

You can specify database connection in controller file as following:

<?php 

class BlogController extends BaseController
{
    public function getRecord()
    {
        $blogModel = new Blog;
        $blogModel->setConnection('mysql2');
        $find = $blogModel->find(1);
        return $find;
    }
}

<?php

class BlogController extends BaseController

{

public function getRecord()

{

$blogModel = new Blog;

$blogModel->setConnection('mysql2');

$find = $blogModel->find(1);

return $find;

}

Laravel Database Connection In Query Builder

Default:

$blogs = DB::table("blog")->get();
print_r($blogs);

1 2	$blogs = DB::table("blog")->get(); print_r($blogs);

You can specify database connection in query as following:

$blogs = DB::connection('mysql2')->table("blog")->get();
print_r($blogs);

1 2	$blogs = DB::connection('mysql2')->table("blog")->get(); print_r($blogs);

Laravel 8 Yajra Datatables Example Tutorial

Step 1: Install Laravel 8

Step 2 : Install Yajra Datatable

Step 3: Add Dummy Records

Step 4: Add Route

Step 5: Create Controller

Step 6: Create View

Run Development Server

Laravel 8 Form Validation

Laravel 8 Ajax Form Validation

Step 1: Add Route

Step 2: Create Controller

Step 4: Run Development Server

Laravel 8 Send Mail using Queue Example

Step 1 – Install Laravel 8 App

Step 2 – Configuration SMTP & Database

Step 3 – Create Mailable Class

Step 4 – Add Send Email Route

Step 5 – Create Directory And Mail Blade View

Step 6 – Configuration Mail Queue

Step 7 – Build Queue Job For Sending Mail

Step 8 – Run Development Server

Laravel Queue Job

Laravel 8 Queue Job Tutorial Example

Step 1 – Install Laravel 8 App

Step 2 – Configuration SMTP & Database

Step 3 – Create Mailable Class

Step 4: Configuration of Queue

Step 5: Create Queue Job for Sending Email

Step 7 – Run Development Server

Laravel 8 Custom Flash Message Tutorial Example

Step 1: Create Global File For Flash Message

1. Redirect with success message

2. Redirect with error message

3. Redirect with warning message

4. Redirect with info message

5. Validation Error

Laravel 8 Change Date Format Examples

Laravel 8 Change Date Format Examples

Example 3 :- Laravel change date format to Y-m-d to m/d/Y

Example 4:- Laravel change date format to m/d/Y to Y-m-d

Example 5:- Laravel change date to Y-m-d to d/m/Y

Laravel 8 Livewire CRUD with Jetstream Tailwind CSS

Step 1: Install Laravel 8

Step 3: Create Migration and Model

Step 4: Create Route

Step 5: Create Controller

Step 6: Share Inertia Var

Step 7: Create Vue Page

Run Development Server

Laravel 8 Autocomplete Search from Database Example

Step 1 : Download and Laravel 8

Step 2: Create Migration and Model

Step 3: Create Route

Step 4: Create Controller

Step 5: Create View File

Step 6: Run Development Server

Laravel 8 Ajax Image Upload Example

Step 1 : Install Laravel 8 Application

Step 2 : Database Configuration

Step 3: Create ajax_images Table and Model

Step 4: Create Route

Step 5: Create Controller

Step 6: Create View

Run Development Server

How to Get Last Executed Query in Laravel 8

Laravel 8 Get Current Logged in User Data Example

Laravel Get Current User Data Using Auth Helper:

Laravel Get Current User Data Using Auth Facade:

Laravel 8 Multiple Database Connection Example

How to use Multiple Database Connection

Laravel Database Connection In migration

Laravel Database Connection In model

Laravel Database Connection In Controller

Laravel Database Connection In Query Builder