Category Archives: Laravel

Laravel Tutorials

Laravel 8 Joins Example Tutorial

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

Laravel 8 Eloquent Join Example Tutorial

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

Types of Joins In Laravel 8

Laravel Inner Join
Laravel Left Join
Laravel Right Join
Laravel Cross Join
Laravel Advanced Join
Laravel Sub-Query Joins

1: Laravel Join Eloquent

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

Example 1: Laravel Eloquent Join() with 2 Tables

 $users = User::join('posts', 'users.id', '=', 'posts.user_id')
                ->get(['users.*', 'posts.descrption']);

1 2	$users = User::join('posts', 'users.id', '=', 'posts.user_id') ->get(['users.*', 'posts.descrption']);

When you dump the above laravel join query, you will get the following SQL query:

select `users`.*, `posts`.`descrption` from `users` 
inner join `posts` on `users`.`id` = `posts`.`user_id`

1 2	select `users`.*, `posts`.`descrption` from `users` inner join `posts` on `users`.`id` = `posts`.`user_id`

Example 2: Laravel Eloquent Join() with 3 Tables

$users = User::join('posts', 'posts.user_id', '=', 'users.id')
              ->join('comments', 'comments.post_id', '=', 'posts.id')
              ->get(['users.*', 'posts.descrption']);

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

->join('comments', 'comments.post_id', '=', 'posts.id')

->get(['users.*', 'posts.descrption']);

When you dump the above laravel join 3 table query, you will get the following SQL query:

select `users`.*, `posts`.`descrption` from `users` 
inner join `posts` on `posts`.`user_id` = `users`.`id` 
inner join `comments` on `comments`.`post_id` = `posts`.`id`

select `users`.*, `posts`.`descrption` from `users`

inner join `posts` on `posts`.`user_id` = `users`.`id`

inner join `comments` on `comments`.`post_id` = `posts`.`id`

Example 3: Laravel Eloquent Join() with Multiple Conditions

$users = User::join('posts', 'posts.user_id', '=', 'users.id')
            ->where('users.status', 'active')
            ->where('posts.status','active')
            ->get(['users.*', 'posts.descrption']);

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

->where('users.status', 'active')

->where('posts.status','active')

->get(['users.*', 'posts.descrption']);

When you dump the above laravel join with multiple conditions query, you will get the following SQL query:

select `users`.*, `posts`.`descrption` from `users` 
inner join `posts` on `posts`.`user_id` = `users`.`id` 
where `users`.`status` = active and `posts`.`status` = active

select `users`.*, `posts`.`descrption` from `users`

inner join `posts` on `posts`.`user_id` = `users`.`id`

where `users`.`status` = active and `posts`.`status` = active

2 – Laravel Left Join

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

Example 1: Laravel Left Join Query

Author::leftJoin('posts', 'posts.author_id', '=', 'authors.id')
      ->select('authors.*')
      ->get();

Author::leftJoin('posts', 'posts.author_id', '=', 'authors.id')

->select('authors.*')

->get();

When you dump the above laravel left join query, you will get the following SQL query:

select `authors`.* from `authors` 
left join `posts` on `posts`.`author_id` = `authors`.`id`

1 2	select `authors`.* from `authors` left join `posts` on `posts`.`author_id` = `authors`.`id`

Example 2: Laravel Left Join with Multiple Condition

Author::leftJoin('posts', 'posts.author_id', '=', 'authors.id')
       ->select('authors.*')
       ->where('authors.status', 'active')
       ->where('authors.subscription', 'active')
       ->get();

Author::leftJoin('posts', 'posts.author_id', '=', 'authors.id')

->select('authors.*')

->where('authors.status', 'active')

->where('authors.subscription', 'active')

->get();

When you dump the above laravel left join with multiple conditions query, you will get the following SQL query:

select `authors`.* from `authors` 
left join `posts` on `posts`.`author_id` = `authors`.`id` 
where `authors`.`status` = active and `authors`.`subscription` = active

select `authors`.* from `authors`

left join `posts` on `posts`.`author_id` = `authors`.`id`

where `authors`.`status` = active and `authors`.`subscription` = active

3 – Laravel Right Join

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

Example 1: Laravel Right Join Query

User::rightJoin('city','city.user_id','=','users.id')
          ->select('users.name','city.city_name')
         ->get();

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

->select('users.name','city.city_name')

->get();

When you dump the above laravel right join query, you will get the following SQL query:

select `users`.`name`, `city`.`city_name` from `users` 
right join `city` on `city`.`user_id` = `users`.`id`

1 2	select `users`.`name`, `city`.`city_name` from `users` right join `city` on `city`.`user_id` = `users`.`id`

Example 2: Laravel Right Join with Multiple Condition

User::rightJoin('city','city.user_id','=','users.id')
          ->select('users.name','city.city_name')
          ->where('users.status', 'active')
          ->where('city.status', 'active')
         ->get();

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

->select('users.name','city.city_name')

->where('users.status', 'active')

->where('city.status', 'active')

->get();

When you dump the above laravel right join with multiple conditions query, you will get the following SQL query:

select `users`.`name`, `city`.`city_name` from `users` 
right join `city` on `city`.`user_id` = `users`.`id` where `users`.`status` = active and `city`.`status` = active

1 2	select `users`.`name`, `city`.`city_name` from `users` right join `city` on `city`.`user_id` = `users`.`id` where `users`.`status` = active and `city`.`status` = active

4 – Cross Join Clause

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

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

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

5 – Laravel Advanced Join

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

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

DB::table('users')

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

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

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

})

->get();

6 – Laravel Sub-Query Joins

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

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

DB::table('posts')

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

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

Laravel 8 Generate PDF with Graph Tutorial

In this Laravel 8 Generate PDF with Graph tutorial, I’ll show you how to generate pdf with graph in laravel 8 application. In this tutorial you will learn to generate pdf file with graph in laravel. In this article we will create example to Generate PDF with Graph. We will be using wkhtmltopdf Software to generate pdf file in this tutorial.

Laravel 8 Generate PDF with Graph Tutorial

In this Laravel 8 Generate PDF with Graph Tutorial I will guide you step by step how to generate pdf with graph in laravel 8 application.

Step 1 – Install wkhtmltopdf Software
Step 2 – Install Laravel 8 App
Step 3 – Install mikehaertl/phpwkhtmltopdf
Step 4 – Add Routes
Step 5 – Create Controller by Command
Step 6 – Create Blade View
Step 7 – Run Development Server
Step 8 – Test This App

Step 1 – Install wkhtmltopdf Software

For Ubuntu:

sudo apt install wkhtmltopdf

1	sudo apt install wkhtmltopdf

For Windows:

You have go the following link and download exe. Then install it:

https://wkhtmltopdf.org/

1	https://wkhtmltopdf.org/

Step 2 – Install Laravel 8 App

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

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

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

Step 3 – Install mikehaertl/phpwkhtmltopdf

In this step, we will install mikehaertl/phpwkhtmltopdf Package via the composer dependency manager. Use the following command to install mikehaertl/phpwkhtmltopdf Package.

composer require mikehaertl/phpwkhtmltopdf

1	composer require mikehaertl/phpwkhtmltopdf

Step 4 – Add Routes

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

routes/web.php

use App\Http\Controllers\GraphPdfController;

Route::get('graph', [GraphPdfController::class, 'index']);
Route::get('download', [GraphPdfController::class, 'dwn'])->name('download');

use App\Http\Controllers\GraphPdfController;

Route::get('graph', [GraphPdfController::class, 'index']);

Route::get('download', [GraphPdfController::class, 'dwn'])->name('download');

Step 5 – Create Controller by Command

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

php artisan make:controller GraphPdfController

1	php artisan make:controller GraphPdfController

The above command will create a controller file GraphPdfController.php in app/Http/Controllers folder. Now, go to app/Http/Controllers and open GraphPdfController.php. Then put the following code into your controller file:

<?php
   
namespace App\Http\Controllers;
   
use Illuminate\Http\Request;
use mikehaertl\wkhtmlto\Pdf;
   
class GraphPdfController extends Controller
{
    /**
     * Write code on Construct
     *
     * @return \Illuminate\Http\Response
     */
    public function index()
    {
        return view('graph');
    }
   
    /**
     * Write code on Construct
     *
     * @return \Illuminate\Http\Response
     */
    public function dwn()
    {
        $render = view('chart')->render();
   
        $pdf = new Pdf;
        $pdf->addPage($render);
        $pdf->setOptions(['javascript-delay' => 5000]);
        $pdf->saveAs(public_path('report.pdf'));
    
        return response()->download(public_path('report.pdf'));
    }
}

<?php

namespace App\Http\Controllers;

use Illuminate\Http\Request;

use mikehaertl\wkhtmlto\Pdf;

class GraphPdfController extends Controller

{

/**

* Write code on Construct

* @return \Illuminate\Http\Response

public function index()

{

return view('graph');

}

/**

* Write code on Construct

* @return \Illuminate\Http\Response

public function dwn()

{

$render = view('chart')->render();

$pdf = new Pdf;

$pdf->addPage($render);

$pdf->setOptions(['javascript-delay' => 5000]);

$pdf->saveAs(public_path('report.pdf'));

return response()->download(public_path('report.pdf'));

}

Step 6 – Create View File

Go to resources/views/ folder and create a new blade view file that name graph.blade.php file. After that, update the following code into your graph.blade.php file:

<!DOCTYPE html>
<html>
<head>
    <meta charset="utf-8">
    <script src="https://www.google.com/jsapi"></script>
    <style>
        .pie-chart {
            width: 600px;
            height: 400px;
            margin: 0 auto;
        }
        .text-center{
            text-align: center;
        }
    </style>
</head>
<body>
  
<h2 class="text-center">Laravel 8 Generate PDF with Chart</h2>
  
<div id="chartDiv" class="pie-chart"></div>
  
<div class="text-center">
    <a href="{{ route('download') }}">Download PDF File</a>
    <h2>w3adda.com.com</h2>
</div>
  
<script type="text/javascript">
    window.onload = function() {
        google.load("visualization", "1.1", {
            packages: ["corechart"],
            callback: 'drawChart'
        });
    };
  
    function drawChart() {
        var data = new google.visualization.DataTable();
        data.addColumn('string', 'Pizza');
        data.addColumn('number', 'Populartiy');
        data.addRows([
            ['Laravel', 33],
            ['Codeigniter', 26],
            ['Symfony', 22],
            ['CakePHP', 10],
            ['Slim', 9]
        ]);
  
        var options = {
            title: 'Popularity of Types of Framework',
            sliceVisibilityThreshold: .2
        };
  
        var chart = new google.visualization.PieChart(document.getElementById('chartDiv'));
        chart.draw(data, options);
    }
</script>
  
</body>
</html>

<!DOCTYPE html>

<html>

<head>

<style>

.pie-chart {

width: 600px;

height: 400px;

margin: 0 auto;

}

.text-center{

text-align: center;

}

</style>

</head>

<body>

<h2 class="text-center">Laravel 8 Generate PDF with Chart</h2>

<a href="{{ route('download') }}">Download PDF File</a>

</div>

window.onload = function() {

google.load("visualization", "1.1", {

packages: ["corechart"],

callback: 'drawChart'

});

};

function drawChart() {

var data = new google.visualization.DataTable();

data.addColumn('string', 'Pizza');

data.addColumn('number', 'Populartiy');

data.addRows([

['Laravel', 33],

['Codeigniter', 26],

['Symfony', 22],

['CakePHP', 10],

['Slim', 9]

]);

var options = {

title: 'Popularity of Types of Framework',

sliceVisibilityThreshold: .2

};

var chart = new google.visualization.PieChart(document.getElementById('chartDiv'));

chart.draw(data, options);

}

</script>

</body>

</html>

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://127.0.0.1:8000/graph

1	http://127.0.0.1:8000/graph

Laravel 8 Fetch Data using Ajax Tutorial Example

In this Laravel 8 Fetch Data using Ajax Tutorial Example tutorial I will show you how to fetch data from database using ajax in laravel 8 applications. In this tutorial you will learn to use ajax in laravel 8. In this article I will demonstrate you how to fetch records from database using ajax in laravel. Using ajax you can fetch data from database without reloading page in laravel 8. In this step by step guide you will understand laravel ajax request implementation.

Laravel 8 Fetch Data using Ajax Tutorial Example

In this step by step tutorial I will demonstrate you with example how to fetch data using ajax in laravel 8 application. Please follow instruction given below:

Step 1 – Install Laravel 8 App
Step 2 – Connecting App to Database
Step 3 – Execute Database Migration Command
Step 4 – Add Routes
Step 5 – Create Controller Using Artisan Command
Step 6 – Create Blade Views
Step 7 – Start Development Server
Step 8 – Test This App

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 – Connecting App to Database

Now, lets create a MySQL database and connect it with laravel application. After creating database we need to set database credential in application’s .env file.

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

DB_CONNECTION=mysql

DB_HOST=127.0.0.1

DB_PORT=3306

DB_DATABASE=here your database name here

DB_USERNAME=here database username here

DB_PASSWORD=here database password here

Step 3 – Execute Database Migration Command

Now, run following command to migrate database schema.

php artisan migrate

1	php artisan migrate

Step 4 – Add Routes

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

routes/web.php

use App\Http\Controllers\AjaxController;

Route::get('list', [AjaxController::class, 'list']);
Route::get('show-user', [AjaxController::class, 'show']);

use App\Http\Controllers\AjaxController;

Route::get('list', [AjaxController::class, 'list']);

Route::get('show-user', [AjaxController::class, 'show']);

Step 5 – Create Controller Using Artisan Command

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

php artisan make:controller AjaxController

1	php artisan make:controller AjaxController

Now, open this controller file located inside app/http/controllers directory:

<?php
   
namespace App\Http\Controllers;
   
use Illuminate\Http\Request;
 
use Redirect,Response;
 
use App\Models\User;
   
class AjaxController extends Controller
{
    /**
     * Display a listing of the resource.
     *
     * @return \Illuminate\Http\Response
     */
    public function index()
    {
        $data['users'] = User::orderBy('id','desc')->paginate(8);
   
        return view('list',$data);
    }
    
   
    public function show($id)
    {   
        $where = array('id' => $id);
        $user  = User::where($where)->first();
 
        return Response::json($user);
    }
 
}

<?php

namespace App\Http\Controllers;

use Illuminate\Http\Request;

use Redirect,Response;

use App\Models\User;

class AjaxController extends Controller

{

/**

* Display a listing of the resource.

* @return \Illuminate\Http\Response

public function index()

{

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

return view('list',$data);

}

public function show($id)

{

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

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

return Response::json($user);

}

Step 6 – Create Blade Views

In this step we will create a blade view file named list.blade.php file. So, go to the resources/views directory and create list.blade.php file. Then put the following code into the list.blade.php file:

<!DOCTYPE html>
<html>
<head>
  <meta charset="UTF-8">
  <meta name="viewport" content="width=device-width, initial-scale=1.0">
  <meta http-equiv="X-UA-Compatible" content="ie=edge">
  <meta name="csrf-token" content="{{ csrf_token() }}">
  <title>laravel 8 Get Data From Database using Ajax</title>
  <link rel="stylesheet" href="https://cdnjs.cloudflare.com/ajax/libs/twitter-bootstrap/4.1.3/css/bootstrap.min.css" />
<script src="https://code.jquery.com/jquery-3.3.1.min.js"></script>
<script src="https://cdnjs.cloudflare.com/ajax/libs/jquery-validate/1.19.0/jquery.validate.js"></script>
  <script src="https://cdnjs.cloudflare.com/ajax/libs/popper.js/1.14.3/umd/popper.min.js"></script>
  <script src="https://stackpath.bootstrapcdn.com/bootstrap/4.1.3/js/bootstrap.min.js"></script>
 
 <style>
   .container{
    padding: 0.5%;
   } 
</style>
</head>
<body>
 
<div class="container">
    <h2 style="margin-top: 12px;" class="alert alert-success">laravel 8 Get Data From Database Using Ajax</h2><br>
    <div class="row">
        <div class="col-12">
          <table class="table table-bordered" id="">
           <thead>
              <tr>
                 <th>Id</th>
                 <th>Name</th>
                 <th>Email</th>
                 <td colspan="2">Action</td>
              </tr>
           </thead>
           <tbody id="users-crud">
              @foreach($users as $u_info)
              <tr id="user_id_{{ $u_info->id }}">
                 <td>{{ $u_info->id  }}</td>
                 <td>{{ $u_info->name }}</td>
                 <td>{{ $u_info->email }}</td>
                 <td><a href="javascript:void(0)" id="show-user" data-id="{{ $u_info->id }}" class="btn btn-info">Show</a></td>
              </tr>
              @endforeach
           </tbody>
          </table>
          {{ $users->links() }}
       </div> 
    </div>
</div>
 
</body>
</html>

<!DOCTYPE html>

<html>

<head>

<title>laravel 8 Get Data From Database using Ajax</title>

<style>

.container{

padding: 0.5%;

}

</style>

</head>

<body>

<h2 style="margin-top: 12px;" class="alert alert-success">laravel 8 Get Data From Database Using Ajax</h2><br>

<thead>

<tr>

<th>Email</th>

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

</tr>

</thead>

@foreach($users as $u_info)

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

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

</tr>

@endforeach

</tbody>

</table>

</div>

</body>

</html>

After that, create one modal for display data on it using ajax. So add the following code into list.blade.php file:

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

</div>

</div>

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

</div>

</form>

</div>

Now, add the following javascript code into list.blade.php file for display data on modals using ajax in laravel 8 app:

<script>
  $(document).ready(function () {
    $.ajaxSetup({
        headers: {
            'X-CSRF-TOKEN': $('meta[name="csrf-token"]').attr('content')
        }
    });
 
   /* When click show user */
    $('body').on('click', '#show-user', function () {
      var user_id = $(this).data('id');
      $.get('ajax-crud/' + user_id +'/edit', function (data) {
         $('#userShowModal').html("User Details");
          $('#ajax-modal').modal('show');
          $('#user_id').val(data.id);
          $('#name').val(data.name);
          $('#email').val(data.email);
      })
   });
   
  });
   
  
</script>

$(document).ready(function () {

$.ajaxSetup({

headers: {

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

}

});

/* When click show user */

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

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

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

$('#userShowModal').html("User Details");

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

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

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

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

})

});

</script>

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://127.0.0.1:8000/list

1	http://127.0.0.1:8000/list

Laravel 8 Create Unique Slug Tutorial Example

In this Laravel 8 Create Unique Slug Tutorial Example I will show you how to generate unique slug for blog posts title in laravel application. In this tutorial you will learn to generate unique slug for post title in laravel 8. In this example I will demonstrate you to generate unique slug or seo friendly slug url for post title in laravel 8. We will be using cviebrock eloquent sluggable laravel package for generating seo friendly url in laravel 8.

Laravel 8 Create Unique Slug Tutorial Example

In this step by step tutorial I will demonstrate you how to generate unique slug in laravel application. Please follow instruction given below:

Step 1 – Install Laravel 8 App
Step 2 – Connecting App to Database
Step 3 – Install Eloquent Sluggable Package
Step 4 – Build Model and Migration
Step 5 – Add Routes
Step 6 – Create Controller using Artisan Command
Step 7 – Create the blade view
Step 8 – Start Development Server

Step 1 – Install Laravel 8 App

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

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

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

Step 2 – Connecting App to Database

Now, lets create a MySQL database and connect it with laravel application. After creating database we need to set database credential in application’s .env file.

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

DB_CONNECTION=mysql

DB_HOST=127.0.0.1

DB_PORT=3306

DB_DATABASE=here your database name here

DB_USERNAME=here database username here

DB_PASSWORD=here database password here

Step 3 – Install Eloquent Sluggable Package

In this step, we will install Eloquent Sluggable Package via the composer dependency manager. Use the following command to install Eloquent Sluggable Package.

composer require cviebrock/eloquent-sluggable

1	composer require cviebrock/eloquent-sluggable

After installing eloquent sluggable package, run the following command:

php artisan vendor:publish --provider="Cviebrock\EloquentSluggable\ServiceProvider"

1	php artisan vendor:publish --provider="Cviebrock\EloquentSluggable\ServiceProvider"

Step 4 – Build Model and Migration

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

php artisan make:model Post -m

1	php artisan make:model Post -m

The above command will create a model name Post and also create a migration file for the post table. Now put the following code in it:

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

<?php

use Illuminate\Support\Facades\Schema;

use Illuminate\Database\Schema\Blueprint;

use Illuminate\Database\Migrations\Migration;

class CreatePostsTable extends Migration

{

/**

* Run the migrations.

* @return void

public function up()

{

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

$table->increments('id');

$table->string('title');

$table->string('slug');

$table->text('description');

$table->timestamps();

});

}

/**

* Reverse the migrations.

* @return void

public function down()

{

Schema::dropIfExists('posts');

}

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

php artisan migrate

1	php artisan migrate

Now, add the fillable property in Post.php file, which is placed inside app/models directory:

<?php
 
namespace App\Models;
 
use Illuminate\Database\Eloquent\Factories\HasFactory;
use Illuminate\Database\Eloquent\Model;
 
class Post extends Model
{
    use HasFactory;
 
     protected $fillable = [
     'title',
     'slug',
     'description',
    ];
    public function sluggable()
    {
        return [
            'slug' => [
                'source' => 'title'
            ]
        ];
    }
}

<?php

namespace App\Models;

use Illuminate\Database\Eloquent\Factories\HasFactory;

use Illuminate\Database\Eloquent\Model;

class Post extends Model

{

use HasFactory;

protected $fillable = [

'title',

'slug',

'description',

];

public function sluggable()

{

return [

'slug' => [

'source' => 'title'

]

];

}

Step 5 – Add Routes

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

routes/web.php

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

<?php

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

return view('welcome');

});

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

Step 6 – Create Controller using Artisan Command

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

php artisan make:controller PostController

1	php artisan make:controller PostController

Now, go to app/HTTP/Controller directory and open PostController.php file. And put the following code into it:

<?php
   
namespace App\Http\Controllers;
   
use App\Models\Post;
 
use Illuminate\Http\Request;
 
use Redirect;
 
use Cviebrock\EloquentSluggable\Services\SlugService;
   
class PostController extends Controller
{
    /**
     * Display a listing of the resource.
     *
     * @return \Illuminate\Http\Response
     */
    public function index()
    {
        $data['post'] = Post::orderBy('id','desc')->paginate(10);
   
        return view('post.list',$data);
    }
    
    /**
     * Show the form for creating a new resource.
     *
     * @return \Illuminate\Http\Response
     */
    public function create()
    {
        return view('post.create');
    }
   
    /**
     * Store a newly created resource in storage.
     *
     * @param  \Illuminate\Http\Request  $request
     * @return \Illuminate\Http\Response
     */
    public function store(Request $request)
    {
        $request->validate([
            'title' => 'required',
            'description' => 'required',
        ]);
 
        $insert = [
            'slug' => SlugService::createSlug(Post::class, 'slug', $request->title),
            'title' => $request->title,
            'description' => $request->description,
        ];
   
        Post::insertGetId($insert);
    
        return Redirect::to('posts')
       ->with('success','Greate! posts created successfully.');
    }
    
    /**
     * Display the specified resource.
     *
     * @param  \App\Post $post
     * @return \Illuminate\Http\Response
     */
    public function show(Request $request)
    {
         
    }
    
    /**
     * Show the form for editing the specified resource.
     *
     * @param  \App\Post $post
     * @return \Illuminate\Http\Response
     */
    public function edit($id)
    {   
 
    }
   
    /**
     * Update the specified resource in storage.
     *
     * @param  \Illuminate\Http\Request  $request
     * @param  \App\Post $post
     * @return \Illuminate\Http\Response
     */
    public function update(Request $request, $id)
    {
 
    }
   
    /**
     * Remove the specified resource from storage.
     *
     * @param  \App\Post  $post
     * @return \Illuminate\Http\Response
     */
    public function destroy($id)
    {
 
    }
     
}

100

101

102

103

104

105

106

107

<?php

namespace App\Http\Controllers;

use App\Models\Post;

use Illuminate\Http\Request;

use Redirect;

use Cviebrock\EloquentSluggable\Services\SlugService;

class PostController extends Controller

{

/**

* Display a listing of the resource.

* @return \Illuminate\Http\Response

public function index()

{

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

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

}

/**

* Show the form for creating a new resource.

* @return \Illuminate\Http\Response

public function create()

{

return view('post.create');

}

/**

* Store a newly created resource in storage.

* @param \Illuminate\Http\Request $request

* @return \Illuminate\Http\Response

public function store(Request $request)

{

$request->validate([

'title' => 'required',

'description' => 'required',

]);

$insert = [

'slug' => SlugService::createSlug(Post::class, 'slug', $request->title),

'title' => $request->title,

'description' => $request->description,

];

Post::insertGetId($insert);

return Redirect::to('posts')

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

}

/**

* Display the specified resource.

* @param \App\Post $post

* @return \Illuminate\Http\Response

public function show(Request $request)

{

}

/**

* Show the form for editing the specified resource.

* @param \App\Post $post

* @return \Illuminate\Http\Response

public function edit($id)

{

}

/**

* Update the specified resource in storage.

* @param \Illuminate\Http\Request $request

* @param \App\Post $post

* @return \Illuminate\Http\Response

public function update(Request $request, $id)

{

}

/**

* Remove the specified resource from storage.

* @param \App\Post $post

* @return \Illuminate\Http\Response

public function destroy($id)

{

}

Step 7 – Create the blade view

Now we will create following blade files:

List.blade.php
Create.blade.php

List.blade.php

<!DOCTYPE html>
<html>
  <head>
    <meta charset="UTF-8">
    <meta name="viewport" content="width=device-width, initial-scale=1.0">
    <meta http-equiv="X-UA-Compatible" content="ie=edge">
    <meta name="csrf-token" content="{{ csrf_token() }}">
    <title>Laravel 8 Generate Unique Slug For Post With Example</title>
    <link href="//maxcdn.bootstrapcdn.com/bootstrap/4.1.1/css/bootstrap.min.css" rel="stylesheet" id="bootstrap-css">
    <style>
    body{
    background-color: #25274d;
    }
    .container{
    background: #ff9b00;
    padding: 4%;
    border-top-left-radius: 0.5rem;
    border-bottom-left-radius: 0.5rem;
    }
    </style>
  </head>
  <body>
    <div class="container">
      <a href="{{ route('posts.create') }}" class="btn btn-success mb-2">Add Post</a> <br>
      <div class="row">
            <div class="col-12">
              
              <table class="table table-bordered" id="laravel_unique_slug_table">
               <thead>
                  <tr>
                     <th>Id</th>
                     <th>Title</th>
                     <th>Slug</th>
                     <th>Description</th>
                  </tr>
               </thead>
               <tbody>
                  @foreach($posts as $post)
                  <tr>
                     <td>{{ $post->id }}</td>
                     <td>{{ $post->title }}</td>
                     <td>{{ $post->slug }}</td>
                     <td>{{ $post->description }}</td>
                  </tr>
                  @endforeach
               </tbody>
              </table>
              {!! $posts->links() !!}
           </div> 
      </div>
    </div>
  </body>
</html>

<!DOCTYPE html>

<html>

<head>

<title>Laravel 8 Generate Unique Slug For Post With Example</title>

<style>

body{

background-color: #25274d;

}

.container{

background: #ff9b00;

padding: 4%;

border-top-left-radius: 0.5rem;

border-bottom-left-radius: 0.5rem;

}

</style>

</head>

<body>

<thead>

<tr>

<th>Title</th>

<th>Description</th>

</tr>

</thead>

<tbody>

@foreach($posts as $post)

<tr>

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

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

</tr>

@endforeach

</tbody>

</table>

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

</div>

</body>

</html>

Create.blade.php

<!DOCTYPE html>
<html>
  <head>
    <meta charset="UTF-8">
    <meta name="viewport" content="width=device-width, initial-scale=1.0">
    <meta http-equiv="X-UA-Compatible" content="ie=edge">
    <meta name="csrf-token" content="{{ csrf_token() }}">
    <title>Laravel 8 Create Post With Unique Slug</title>
    <link href="//maxcdn.bootstrapcdn.com/bootstrap/4.1.1/css/bootstrap.min.css" rel="stylesheet" id="bootstrap-css">
    <style>
    body{
    background-color: #25274d;
    }
    .container{
    background: #ff9b00;
    padding: 4%;
    border-top-left-radius: 0.5rem;
    border-bottom-left-radius: 0.5rem;
    }
    </style>
  </head>
  <body>
    <div class="container">
 
      <form action="{{ route('posts.store') }}" method="POST" name="add_post">
        {{ csrf_field() }}
 
        <div class="row">
            <div class="col-md-12">
                <div class="form-group">
                    <strong>Title</strong>
                    <input type="text" name="title" class="form-control" placeholder="Enter Title">
                    <span class="text-danger">{{ $errors->first('title') }}</span>
                </div>
            </div>
            <div class="col-md-12">
                <div class="form-group">
                    <strong>Description</strong>
                    <textarea class="form-control" col="4" name="description" placeholder="Enter Description"></textarea>
                    <span class="text-danger">{{ $errors->first('description') }}</span>
                </div>
            </div>
            <div class="col-md-12">
                <button type="submit" class="btn btn-primary">Submit</button>
            </div>
        </div>
 
      </form>
 
    </div>
  </body>
</html>

<!DOCTYPE html>

<html>

<head>

<title>Laravel 8 Create Post With Unique Slug</title>

<style>

body{

background-color: #25274d;

}

.container{

background: #ff9b00;

padding: 4%;

border-top-left-radius: 0.5rem;

border-bottom-left-radius: 0.5rem;

}

</style>

</head>

<body>

<strong>Title</strong>

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

</div>

<strong>Description</strong>

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

</div>

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

</div>

</form>

</div>

</body>

</html>

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://localhost:8000/posts

1	http://localhost:8000/posts

Laravel 8 FullCalendar Ajax Tutorial with Example

In this Laravel 8 FullCalendar Ajax Tutorial I’ll show you how to display events on the calendar using fullcalendar components in laravel 8 application. In this tutorial you will learn to display events on the calendar using fullcalendar in laravel 8. This tutorial you will also learn to show dynamic event data on calendar using fullcalendar components in laravel 8.

Laravel 8 FullCalendar Ajax Tutorial with Example

In this step by step tutorial I will demonstrate you how to show dynamic event data on calendar using fullcalendar components in laravel 8. Please follow instruction given below:

Step 1 – Install Laravel App
Step 2 – Connecting App to Database
Step 3 – Build Migration & Model
Step 4 – Add Routes
Step 5 – Create Controller Using Artisan Command
Step 6 – Create Blade View
Step 7 – Run Development Server
Step 8 – Test This App

Step 1 – Install Laravel 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 – Connecting App to Database

Now, lets create a MySQL database and connect it with laravel application. After creating database we need to set database credential in application’s .env file.

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

DB_CONNECTION=mysql

DB_HOST=127.0.0.1

DB_PORT=3306

DB_DATABASE=here your database name here

DB_USERNAME=here database username here

DB_PASSWORD=here database password here

Step 3 – Build Migration & Model

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

php artisan make:model Event -m

1	php artisan make:model Event -m

The above command will create a model name Event and also create a migration file for the Events table.Now go to database/migrations folder and open create_events_table.php file. Then put the following code into create_events_table.php file, as follow:

<?php

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

class CreateEventsTable extends Migration
{
    /**
     * Run the migrations.
     *
     * @return void
     */
    public function up()
    {
        Schema::create('events', function (Blueprint $table) {
            $table->increments('id');
            $table->string('title');
            $table->dateTime('start');
            $table->dateTime('end');
            $table->timestamps();
        });
    }

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

<?php

use Illuminate\Support\Facades\Schema;

use Illuminate\Database\Schema\Blueprint;

use Illuminate\Database\Migrations\Migration;

class CreateEventsTable extends Migration

{

/**

* Run the migrations.

* @return void

public function up()

{

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

$table->increments('id');

$table->string('title');

$table->dateTime('start');

$table->dateTime('end');

$table->timestamps();

});

}

/**

* Reverse the migrations.

* @return void

public function down()

{

Schema::dropIfExists('events');

}

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

php artisan migrate

1	php artisan migrate

Step 4 – Add Routes

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

routes/web.php

use App\Http\Controllers\FullCalendarController;
 
 
Route::get('ckeditor', [FullCalendarController::class, 'index']);
Route::post('fullcalendar/create', [FullCalendarController::class, 'create']);
Route::post('fullcalendar/update', [FullCalendarController::class, 'update']);
Route::post('fullcalendar/delete', [FullCalendarController::class, 'destroy']);

use App\Http\Controllers\FullCalendarController;

Route::get('ckeditor', [FullCalendarController::class, 'index']);

Route::post('fullcalendar/create', [FullCalendarController::class, 'create']);

Route::post('fullcalendar/update', [FullCalendarController::class, 'update']);

Route::post('fullcalendar/delete', [FullCalendarController::class, 'destroy']);

Step 5 – Create Controller Using Artisan Command

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

php artisan make:controller FullCalendarController

1	php artisan make:controller FullCalendarController

After successfully create controller go to app/controllers/FullCalendarController.php and update the below code :

<?php
   
namespace App\Http\Controllers;
   
use App\Models\Event;
use Illuminate\Http\Request;
use Redirect,Response;
   
class FullCalenderController extends Controller
{
 
    public function index()
    {
        if(request()->ajax()) 
        {
 
         $start = (!empty($_GET["start"])) ? ($_GET["start"]) : ('');
         $end = (!empty($_GET["end"])) ? ($_GET["end"]) : ('');
 
         $data = Event::whereDate('start', '>=', $start)->whereDate('end',   '<=', $end)->get(['id','title','start', 'end']);
         return Response::json($data);
        }
        return view('fullcalendar');
    }
    
   
    public function create(Request $request)
    {  
        $insertArr = [ 'title' => $request->title,
                       'start' => $request->start,
                       'end' => $request->end
                    ];
        $event = Event::insert($insertArr);   
        return Response::json($event);
    }
     
 
    public function update(Request $request)
    {   
        $where = array('id' => $request->id);
        $updateArr = ['title' => $request->title,'start' => $request->start, 'end' => $request->end];
        $event  = Event::where($where)->update($updateArr);
 
        return Response::json($event);
    } 
 
 
    public function destroy(Request $request)
    {
        $event = Event::where('id',$request->id)->delete();
   
        return Response::json($event);
    }    
 
 
}

<?php

namespace App\Http\Controllers;

use App\Models\Event;

use Illuminate\Http\Request;

use Redirect,Response;

class FullCalenderController extends Controller

{

public function index()

{

if(request()->ajax())

{

$start = (!empty($_GET["start"])) ? ($_GET["start"]) : ('');

$end = (!empty($_GET["end"])) ? ($_GET["end"]) : ('');

$data = Event::whereDate('start', '>=', $start)->whereDate('end', '<=', $end)->get(['id','title','start', 'end']);

return Response::json($data);

}

return view('fullcalendar');

}

public function create(Request $request)

{

$insertArr = [ 'title' => $request->title,

'start' => $request->start,

'end' => $request->end

];

$event = Event::insert($insertArr);

return Response::json($event);

}

public function update(Request $request)

{

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

$updateArr = ['title' => $request->title,'start' => $request->start, 'end' => $request->end];

$event = Event::where($where)->update($updateArr);

return Response::json($event);

}

public function destroy(Request $request)

{

$event = Event::where('id',$request->id)->delete();

return Response::json($event);

}

Step 6 – Create Blade view

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

<!DOCTYPE html>
<html>
<head>
  <title>Laravel Fullcalender Add/Update/Delete Event Example Tutorial</title>
  <meta name="csrf-token" content="{{ csrf_token() }}">
</head>
<link rel="stylesheet" href="https://stackpath.bootstrapcdn.com/bootstrap/4.3.1/css/bootstrap.min.css" />
 
<script src="https://code.jquery.com/jquery-3.5.1.min.js" integrity="sha256-9/aliU8dGd2tb6OSsuzixeV4y/faTqgFtohetphbbj0=" crossorigin="anonymous"></script>
 
<link rel="stylesheet" href="https://cdn.jsdelivr.net/npm/fullcalendar@3.9.0/dist/fullcalendar.min.css" />
 
<script src="https://cdn.jsdelivr.net/npm/moment@2.27.0/moment.min.js"></script>
 
<script src="https://cdn.jsdelivr.net/npm/fullcalendar@3.9.0/dist/fullcalendar.min.js"></script>
<body>
 
  <div class="container">
      <div class="response"></div>
      <div id='calendar'></div>  
  </div>
 
 
</body>
</html>

<!DOCTYPE html>

<html>

<head>

<title>Laravel Fullcalender Add/Update/Delete Event Example Tutorial</title>

</head>

<body>

</div>

</body>

</html>

Put the script on fullcalendar.blade.php, after the closing of the body tag

<script>
$(document).ready(function () {
var SITEURL = "{{url('/')}}";
$.ajaxSetup({
headers: {
'X-CSRF-TOKEN': $('meta[name="csrf-token"]').attr('content')
}
});
var calendar = $('#calendar').fullCalendar({
editable: true,
events: SITEURL + "fullcalendar",
displayEventTime: true,
editable: true,
eventRender: function (event, element, view) {
if (event.allDay === 'true') {
event.allDay = true;
} else {
event.allDay = false;
}
},
selectable: true,
selectHelper: true,
select: function (start, end, allDay) {
var title = prompt('Event Title:');
if (title) {
var start = $.fullCalendar.formatDate(start, "Y-MM-DD HH:mm:ss");
var end = $.fullCalendar.formatDate(end, "Y-MM-DD HH:mm:ss");
$.ajax({
url: SITEURL + "fullcalendar/create",
data: 'title=' + title + '&start=' + start + '&end=' + end,
type: "POST",
success: function (data) {
displayMessage("Added Successfully");
}
});
calendar.fullCalendar('renderEvent',
{
title: title,
start: start,
end: end,
allDay: allDay
},
true
);
}
calendar.fullCalendar('unselect');
},
eventDrop: function (event, delta) {
var start = $.fullCalendar.formatDate(event.start, "Y-MM-DD HH:mm:ss");
var end = $.fullCalendar.formatDate(event.end, "Y-MM-DD HH:mm:ss");
$.ajax({
url: SITEURL + 'fullcalendar/update',
data: 'title=' + event.title + '&start=' + start + '&end=' + end + '&id=' + event.id,
type: "POST",
success: function (response) {
displayMessage("Updated Successfully");
}
});
},
eventClick: function (event) {
var deleteMsg = confirm("Do you really want to delete?");
if (deleteMsg) {
$.ajax({
type: "POST",
url: SITEURL + 'fullcalendar/delete',
data: "&id=" + event.id,
success: function (response) {
if(parseInt(response) > 0) {
$('#calendar').fullCalendar('removeEvents', event.id);
displayMessage("Deleted Successfully");
}
}
});
}
}
});
});
function displayMessage(message) {
$(".response").html("<div class='success'>"+message+"</div>");
setInterval(function() { $(".success").fadeOut(); }, 1000);
}
</script>

$(document).ready(function () {

var SITEURL = "{{url('/')}}";

$.ajaxSetup({

headers: {

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

}

});

var calendar = $('#calendar').fullCalendar({

editable: true,

events: SITEURL + "fullcalendar",

displayEventTime: true,

editable: true,

eventRender: function (event, element, view) {

if (event.allDay === 'true') {

event.allDay = true;

} else {

event.allDay = false;

}

selectable: true,

selectHelper: true,

select: function (start, end, allDay) {

var title = prompt('Event Title:');

if (title) {

var start = $.fullCalendar.formatDate(start, "Y-MM-DD HH:mm:ss");

var end = $.fullCalendar.formatDate(end, "Y-MM-DD HH:mm:ss");

$.ajax({

url: SITEURL + "fullcalendar/create",

data: 'title=' + title + '&start=' + start + '&end=' + end,

type: "POST",

success: function (data) {

displayMessage("Added Successfully");

}

});

calendar.fullCalendar('renderEvent',

{

title: title,

start: start,

end: end,

allDay: allDay

true

);

}

calendar.fullCalendar('unselect');

eventDrop: function (event, delta) {

var start = $.fullCalendar.formatDate(event.start, "Y-MM-DD HH:mm:ss");

var end = $.fullCalendar.formatDate(event.end, "Y-MM-DD HH:mm:ss");

$.ajax({

url: SITEURL + 'fullcalendar/update',

data: 'title=' + event.title + '&start=' + start + '&end=' + end + '&id=' + event.id,

type: "POST",

success: function (response) {

displayMessage("Updated Successfully");

}

});

eventClick: function (event) {

var deleteMsg = confirm("Do you really want to delete?");

if (deleteMsg) {

$.ajax({

type: "POST",

url: SITEURL + 'fullcalendar/delete',

data: "&id=" + event.id,

success: function (response) {

if(parseInt(response) > 0) {

$('#calendar').fullCalendar('removeEvents', event.id);

displayMessage("Deleted Successfully");

}

});

}

});

function displayMessage(message) {

$(".response").html("<div class='success'>"+message+"</div>");

setInterval(function() { $(".success").fadeOut(); }, 1000);

}

</script>

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

1	http://localhost:8000/fullcalendar

Laravel 8 Image Crop & Upload using jQuery and Ajax Example

In this Laravel 8 Image Crop & Upload using jQuery and Ajax Example tutorial I’ll show you how to upload and crop image using jquery ajax in laravel 8. In this tutorial you will learn to upload and crop image before upload using jquery ajax in laravel. In this step by step guide I will demonstrate you to upload and crop image in laravel 8 using jquery ajax.

Laravel 8 Image Crop & Upload using jQuery and Ajax Example

In this step by step tutorial I will demonstrate you how to upload and crop image using jQuery in laravel 8. Please follow the instruction given below:

Step 1 – Install Laravel 8 App
Step 2 – Connecting App to Database
Step 3 – Create Crop Image Migration & Model
Step 4 – Add Routes For Crop Image Upload
Step 5 – Create Crop Image Controller Using Command
Step 6 – Create Crop Image Upload Blade View
Step 7 – Make Upload Folder
Step 8 – Run Development Server
Step 9 – Test This App

Step 1 – Install Laravel 8 App

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

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

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

Step 2 – Connecting App to Database

Now, lets create a MySQL database and connect it with laravel application. After creating database we need to set database credential in application’s .env file.

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

DB_CONNECTION=mysql

DB_HOST=127.0.0.1

DB_PORT=3306

DB_DATABASE=here your database name here

DB_USERNAME=here database username here

DB_PASSWORD=here database password here

Step 3 – Create Crop Image Migration & Model

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

php artisan make:model Image -m

1	php artisan make:model Image -m

Now, go to database/migrations folder and open create_images_table.php. Then put the following code into create_images_table.php:

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

<?php

use Illuminate\Support\Facades\Schema;

use Illuminate\Database\Schema\Blueprint;

use Illuminate\Database\Migrations\Migration;

class CreateGalleriesTable extends Migration

{

/**

* Run the migrations.

* @return void

public function up()

{

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

$table->increments('id');

$table->string('title');

$table->timestamps();

});

}

/**

* Reverse the migrations.

* @return void

public function down()

{

Schema::dropIfExists('images');

}

Now run the following command to migrate the table into your select database:

php artisan migrate

1	php artisan migrate

Step 4 – Add Routes For Crop Image Upload

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('image-crop', 'CropImageUploadController@index');
 
Route::post('save-crop-image', 'CropImageUploadController@store');

Route::get('image-crop', 'CropImageUploadController@index');

Route::post('save-crop-image', 'CropImageUploadController@store');

Step 5 – Create Crop Image Controller Using Command

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

php artisan make:controller CropImageUploadController

1	php artisan make:controller CropImageUploadController

Now go to app/http/controllers/ folder and open CropImageUploadController.php. Then put the following file uploading methods into your CropImageUploadController.php file:

<?php
 
namespace App\Http\Controllers;
 
use Illuminate\Http\Request;
 
use App\Models\Image;
 
class CropImageUploadController extends Controller
{
    public function index()
    {
     return view('image-crop');
    }
 
    public function store(Request $request)
    {
        $folderPath = public_path('upload/');
 
        $image_parts = explode(";base64,", $request->image);
        $image_type_aux = explode("image/", $image_parts[0]);
        $image_type = $image_type_aux[1];
        $image_base64 = base64_decode($image_parts[1]);
 
        $imageName = uniqid() . '.png';
 
        $imageFullPath = $folderPath.$imageName;
 
        file_put_contents($imageFullPath, $image_base64);
 
         $saveFile = new Image;
         $saveFile->title = $imageName;
         $saveFile->save();
    
        return response()->json(['success'=>'Crop Image Saved/Uploaded Successfully using jQuery and Ajax In Laravel']);
    }
}

<?php

namespace App\Http\Controllers;

use Illuminate\Http\Request;

use App\Models\Image;

class CropImageUploadController extends Controller

{

public function index()

{

return view('image-crop');

}

public function store(Request $request)

{

$folderPath = public_path('upload/');

$image_parts = explode(";base64,", $request->image);

$image_type_aux = explode("image/", $image_parts[0]);

$image_type = $image_type_aux[1];

$image_base64 = base64_decode($image_parts[1]);

$imageName = uniqid() . '.png';

$imageFullPath = $folderPath.$imageName;

file_put_contents($imageFullPath, $image_base64);

$saveFile = new Image;

$saveFile->title = $imageName;

$saveFile->save();

return response()->json(['success'=>'Crop Image Saved/Uploaded Successfully using jQuery and Ajax In Laravel']);

}

Step 6 – Create Crop Image Upload Blade View

In this step, create a blade view file named image-crop.blade.php. Go to /resources/views and create one file name image-crop.blade.php. Then put the following code into your image-crop.blade.php file:

<html>  
<head>  
<title>Crop Image Using jQuery Croppie with Ajax in Laravel</title>  
<meta name="csrf-token" content="{{ csrf_token() }}">
<link rel="stylesheet" href="https://stackpath.bootstrapcdn.com/bootstrap/4.5.2/css/bootstrap.min.css">
<script src="https://code.jquery.com/jquery-3.5.1.slim.min.js"></script
>
<script src="https://code.jquery.com/jquery-3.5.1.min.js" integrity="sha256-9/aliU8dGd2tb6OSsuzixeV4y/faTqgFtohetphbbj0=" crossorigin="anonymous"></script>
<script src="https://cdn.jsdelivr.net/npm/popper.js@1.16.1/dist/umd/popper.min.js"></script>
<script src="https://stackpath.bootstrapcdn.com/bootstrap/4.5.2/js/bootstrap.min.js"></script>
<script src="https://cdnjs.cloudflare.com/ajax/libs/croppie/2.6.5/croppie.min.js"></script>
<link rel="stylesheet" href="https://cdnjs.cloudflare.com/ajax/libs/croppie/2.6.5/croppie.css" />
</head>  
<body>  
<div class="container mt-5">
<div class="card">
<div class="card-header">
Crop Image Using jQuery Croppie with Ajax in Laravel
</div>
<div class="card-body">
<input type="file" name="before_crop_image" id="before_crop_image" accept="image/*" />
</div>
</div>
</div>
</body>  
</html>
<div id="imageModel" class="modal fade bd-example-modal-lg" role="dialog">
<div class="modal-dialog modal-lg">
<div class="modal-content">
<div class="modal-header">
<button type="button" class="close" data-dismiss="modal">×</button>
<h4 class="modal-title">Crop & Resize Upload Image in PHP with Ajax</h4>
</div>
<div class="modal-body">
<div class="row">
<div class="col-md-8 text-center">
<div id="image_demo" style="width:350px; margin-top:30px"></div>
</div>
<div class="col-md-4" style="padding-top:30px;">
<br />
<br />
<br/>
<button class="btn btn-success crop_image">Save</button>
</div>
</div>
</div>
<div class="modal-footer">
<button type="button" class="btn btn-default" data-dismiss="modal">Close</button>
</div>
</div>
</div>
</div>
<script>  
$(document).ready(function(){
$image_crop = $('#image_demo').croppie({
enableExif: true,
viewport: {
width:200,
height:200,
type:'square' //circle
},
boundary:{
width:300,
height:300
}    
});
$('#before_crop_image').on('change', function(){
var reader = new FileReader();
reader.onload = function (event) {
$image_crop.croppie('bind', {
url: event.target.result
}).then(function(){
console.log('jQuery bind complete');
});
}
reader.readAsDataURL(this.files[0]);
$('#imageModel').modal('show');
});
$('.crop_image').click(function(event){
$image_crop.croppie('result', {
type: 'canvas',
size: 'viewport'
}).then(function(response){
$.ajax({
url:"{{url('save-crop-image')}}",  
type:'POST',
data: {'_token': $('meta[name="csrf-token"]').attr('content'), 'image': response},
success:function(data){
$('#imageModel').modal('hide');
alert('Crop image has been uploaded');
}
})
});
});
});  
</script>

<html>

<head>

<title>Crop Image Using jQuery Croppie with Ajax in Laravel</title>

</head>

<body>

Crop Image Using jQuery Croppie with Ajax in Laravel

</div>

</div>

</body>

</html>

<h4 class="modal-title">Crop & Resize Upload Image in PHP with Ajax</h4>

</div>

</div>

<br />

<br/>

</div>

<button type="button" class="btn btn-default" data-dismiss="modal">Close</button>

</div>

$(document).ready(function(){

$image_crop = $('#image_demo').croppie({

enableExif: true,

viewport: {

width:200,

height:200,

type:'square' //circle

boundary:{

width:300,

height:300

}

});

$('#before_crop_image').on('change', function(){

var reader = new FileReader();

reader.onload = function (event) {

$image_crop.croppie('bind', {

url: event.target.result

}).then(function(){

console.log('jQuery bind complete');

});

}

reader.readAsDataURL(this.files[0]);

$('#imageModel').modal('show');

});

$('.crop_image').click(function(event){

$image_crop.croppie('result', {

type: 'canvas',

size: 'viewport'

}).then(function(response){

$.ajax({

url:"{{url('save-crop-image')}}",

type:'POST',

data: {'_token': $('meta[name="csrf-token"]').attr('content'), 'image': response},

success:function(data){

$('#imageModel').modal('hide');

alert('Crop image has been uploaded');

}

})

});

</script>

Step 7 – Make Upload Folder

Now, create one folder name upload inside public directory.

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://localhost:8000/image-crop

1	http://localhost:8000/image-crop

Currency Converter in Laravel 8

In this Laravel 8 Currency Converter tutorial I will show you how to create live Currency Converter in laravel. In this tutorial you will learn to integrate or implement live Currency Converter in laravel. In this tutorial, we will learn how to create Currency Converter in laravel applications without using any package with examples.

Currency Converter in Laravel 8

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

Step 1 – Install Laravel 8 App
Step 2 – Signup and Get API KEY
Step 3 – Create Route
Step 4 – Create Controller Using Artisan Command
Step 5 – Create the blade view
Step 6 – Start Development Server
Step 7 – Test This App

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 lara-currency

1	composer create-project --prefer-dist laravel/laravel lara-currency

Now visit the link given below to obtain API Key from there.:

https://free.currencyconverterapi.com/

1	https://free.currencyconverterapi.com/

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

Route::get('currency','CurrencyController@index');
 Route::post('currency','CurrencyController@exchangeCurrency');

1 2	Route::get('currency','CurrencyController@index'); Route::post('currency','CurrencyController@exchangeCurrency');

Step 4 – Create Controller using Artisan Command

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

php artisan make:controller CurrencyController

1	php artisan make:controller CurrencyController

The above command will create a controller name CurrencyController. Now, open CurrencyController.php file and put the following code into it.

<?php
 
namespace App\Http\Controllers;
 
use Illuminate\Http\Request;
 
use AshAllenDesign\LaravelExchangeRates\ExchangeRate;
 
use Guzzle\Http\Exception\ClientErrorResponseException;
 
use carbon\Carbon;
 
class CurrencyController extends Controller
{
    //
 
    public function index() {
 
     return view('currency');
    }    
 
    public function exchangeCurrency(Request $request) {
         
      $amount = ($request->amount)?($request->amount):(1);
 
      $apikey = 'd1ded944220ca6b0c442';
 
      $from_Currency = urlencode($request->from_currency);
      $to_Currency = urlencode($request->to_currency);
      $query =  "{$from_Currency}_{$to_Currency}";
 
      // change to the free URL if you're using the free version
      $json = file_get_contents("http://free.currencyconverterapi.com/api/v5/convert?q={$query}&compact=y&apiKey={$apikey}");
 
      $obj = json_decode($json, true);
       
      $val = $obj["$query"];
 
      $total = $val['val'] * 1;
 
      $formatValue = number_format($total, 2, '.', '');
       
      $data = "$amount $from_Currency = $to_Currency $formatValue";
 
      echo $data; die;
 
 
     
   }
 
}

<?php

namespace App\Http\Controllers;

use Illuminate\Http\Request;

use AshAllenDesign\LaravelExchangeRates\ExchangeRate;

use Guzzle\Http\Exception\ClientErrorResponseException;

use carbon\Carbon;

class CurrencyController extends Controller

{

public function index() {

return view('currency');

}

public function exchangeCurrency(Request $request) {

$amount = ($request->amount)?($request->amount):(1);

$apikey = 'd1ded944220ca6b0c442';

$from_Currency = urlencode($request->from_currency);

$to_Currency = urlencode($request->to_currency);

$query = "{$from_Currency}_{$to_Currency}";

// change to the free URL if you're using the free version

$json = file_get_contents("http://free.currencyconverterapi.com/api/v5/convert?q={$query}&compact=y&apiKey={$apikey}");

$obj = json_decode($json, true);

$val = $obj["$query"];

$total = $val['val'] * 1;

$formatValue = number_format($total, 2, '.', '');

$data = "$amount $from_Currency = $to_Currency $formatValue";

echo $data; die;

}

Step 5 – Create the blade view

In this step we will create a blade files, Go to app/resources/views/ and create one blade view name currency.blade.php. After successfully create the blade view file, update the below-given code into your currency.blade.php file:

currency.blade.php

<!DOCTYPE html>
<html>
<head>
<title>Laravel Currency Exchange Rate Calculator</title> 
<meta name="csrf-token" content="{{ csrf_token() }}">
<link rel="stylesheet" href="https://stackpath.bootstrapcdn.com/bootstrap/4.4.1/css/bootstrap.min.css">
<script src="https://code.jquery.com/jquery-3.4.1.js"></script> 
</head>
<body>
<div class="container mt-5">
<div class="card">
<div class="card-header">
Laravel Currency Exchange Rate Calculator
</div>
<div class="card-body">
<form id="currency-exchange-rate" action="#" method="post" class="form-group">
<div class="row mb-3">
<div class="col-md-4">
<input type="text" name="amount" class="form-control" value="1">  
</div>
<div class="col-md-4">
<select name="from_currency" class="form-control"> 
<option value='AUD'>AUD</option>
<option value='BGN'>BGN</option>
<option value='BRL'>BRL</option>
<option value='CAD'>CAD</option>
<option value='CHF'>CHF</option>
<option value='CNY'>CNY</option>
<option value='CZK'>CZK</option>
<option value='DKK'>DKK</option>
<option value='EUR'>EUR</option>
<option value='GBP'>GBP</option>
<option value='HKD'>HKD</option>
<option value='HRK'>HRK</option>
<option value='HUF'>HUF</option>
<option value='IDR'>IDR</option>
<option value='ILS'>ILS</option>
<option value='INR'>INR</option>
<option value='ISK'>ISK</option>
<option value='JPY'>JPY</option>
<option value='KRW'>KRW</option>
<option value='MXN'>MXN</option>
<option value='MYR'>MYR</option>
<option value='NOK'>NOK</option>
<option value='NZD'>NZD</option>
<option value='PHP'>PHP</option>
<option value='PLN'>PLN</option>
<option value='RON'>RON</option>
<option value='RUB'>RUB</option>
<option value='SEK'>SEK</option>
<option value='SGD'>SGD</option>
<option value='THB'>THB</option>
<option value='TRY'>TRY</option>
<option value='USD'>USD</option>
<option value='ZAR'>ZAR</option>
</select>
</div>
<div class="col-md-4">
<select name="to_currency" class="form-control">
<option value='AUD'>AUD</option>
<option value='BGN'>BGN</option>
<option value='BRL'>BRL</option>
<option value='CAD'>CAD</option>
<option value='CHF'>CHF</option>
<option value='CNY'>CNY</option>
<option value='CZK'>CZK</option>
<option value='DKK'>DKK</option>
<option value='EUR'>EUR</option>
<option value='GBP'>GBP</option>
<option value='HKD'>HKD</option>
<option value='HRK'>HRK</option>
<option value='HUF'>HUF</option>
<option value='IDR'>IDR</option>
<option value='ILS'>ILS</option>
<option value='INR'>INR</option>
<option value='ISK'>ISK</option>
<option value='JPY'>JPY</option>
<option value='KRW'>KRW</option>
<option value='MXN'>MXN</option>
<option value='MYR'>MYR</option>
<option value='NOK'>NOK</option>
<option value='NZD'>NZD</option>
<option value='PHP'>PHP</option>
<option value='PLN'>PLN</option>
<option value='RON'>RON</option>
<option value='RUB'>RUB</option>
<option value='SEK'>SEK</option>
<option value='SGD'>SGD</option>
<option value='THB'>THB</option>
<option value='TRY'>TRY</option>
<option value='USD'>USD</option>
<option value='ZAR'>ZAR</option>
</select>
</div>
</div>  
<div class="row">
<div class="col-md-4">
<input type="submit" name="submit" id="btnSubmit" class="btn btn-primary " value="Click To Exchange Rate">
</div>
</div>
</form> 
</div>
<div class="card-footer">
<span id="output"></span>
</div>
</div>
</div>
<script>
$(document).ready(function () {
$.ajaxSetup({
headers: {
'X-CSRF-TOKEN': $('meta[name="csrf-token"]').attr('content')
}
});
$("#btnSubmit").click(function (event) {
//stop submit the form, we will post it manually.
event.preventDefault();
// Get form
var form = $('#currency-exchange-rate')[0];
// Create an FormData object 
var data = new FormData(form);
// disabled the submit button
$("#btnSubmit").prop("disabled", true);
$.ajax({
type: "POST",
url: "{{ url('currency') }}",
data: data,
processData: false,
contentType: false,
cache: false,
timeout: 800000,
success: function (data) {
$("#output").html(data);
$("#btnSubmit").prop("disabled", false);
},
error: function (e) {
$("#output").html(e.responseText);
console.log("ERROR : ", e);
$("#btnSubmit").prop("disabled", false);
}
});
});
});
</script>
</body>
</html>

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

<!DOCTYPE html>

<html>

<head>

<title>Laravel Currency Exchange Rate Calculator</title>

</head>

<body>

Laravel Currency Exchange Rate Calculator

</div>

</div>

</select>

</div>

</select>

</div>

</div>

</form>

</div>

</div>

$(document).ready(function () {

$.ajaxSetup({

headers: {

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

}

});

$("#btnSubmit").click(function (event) {

//stop submit the form, we will post it manually.

event.preventDefault();

// Get form

var form = $('#currency-exchange-rate')[0];

// Create an FormData object

var data = new FormData(form);

// disabled the submit button

$("#btnSubmit").prop("disabled", true);

$.ajax({

type: "POST",

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

data: data,

processData: false,

contentType: false,

cache: false,

timeout: 800000,

success: function (data) {

$("#output").html(data);

$("#btnSubmit").prop("disabled", false);

error: function (e) {

$("#output").html(e.responseText);

console.log("ERROR : ", e);

$("#btnSubmit").prop("disabled", false);

}

});

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

1	http://localhost:8000/currency

How to Check User Login Online Status & Last Seen in Laravel 8?

In this How to Check User Login Online Status and Last Seen in Laravel 8 tutorial I’ll show you how to check User Online, last seen and Not online in Laravel 8 using custom middleware. In this tutorial you will learn to check user is online or not in laravel. In this step by step guide we will be creating a custom middleware to check User Online, Not online and last seen.

In this step by step tutorial I will demonstrate you with example How to Check User Login Online Status and Last Seen in Laravel 8. Please follow the instruction given below:

Step 1: Install Laravel 8 App
Step 2: Connecting App to Database
Step 3: Generate Auth Scaffolding
Step 4: Add Column in User Table
Step 5: Create a Middleware
Step 6: Register Middleware in Kernel
Step 7: Create Controller by Artisan
Step 8: Check Online Status in Blade File
Step 9: 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: Connecting App to Database

Now, lets create a MySQL database and connect it with laravel application. After creating database we need to set database credential in application’s .env file.

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

DB_CONNECTION=mysql

DB_HOST=127.0.0.1

DB_PORT=3306

DB_DATABASE=here your database name here

DB_USERNAME=here database username here

DB_PASSWORD=here database password here

Step 3: Generate Auth Scaffolding

In this step we will be generating laravel’s auth scaffolding using following command:

# install laravel ui
composer require laravel/ui --dev
# auth scaffolding
php artisan ui vue --auth
# finally run
npm i && npm run dev

# install laravel ui

composer require laravel/ui --dev

# auth scaffolding

php artisan ui vue --auth

# finally run

npm i && npm run dev

Step 4: Add Column in User Table

You need to add one column in the users table called last_seen. So, navigate database>migrations folder and open create_users_table file. Then update the last_seen column in this file as follow:

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

public function up()

{

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

$table->bigIncrements('id');

$table->string('name');

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

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

$table->string('password');

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

$table->rememberToken();

$table->timestamps();

});

}

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

php artisan migrate

1	php artisan migrate

Step 5: Create a Middleware

In this step we will creating custom middleware using following command:

php artisan make:middleware ActivityByUser

1	php artisan make:middleware ActivityByUser

Now, go to app>Http>Middleware and open ActivityByUser.php middleware. Then put the following code into your middleware file:

<?php
namespace App\Http\Middleware;
use App\Models\User;
use Closure;
use Auth;
use Cache;
use Carbon\Carbon;
class ActivityByUser
{
    public function handle($request, Closure $next)
    {
        if (Auth::check()) {
            $expiresAt = Carbon::now()->addMinutes(1); // keep online for 1 min
            Cache::put('user-is-online-' . Auth::user()->id, true, $expiresAt);
            // last seen
            User::where('id', Auth::user()->id)->update(['last_seen' => (new \DateTime())->format("Y-m-d H:i:s")]);
        }
        return $next($request);
    }
}

<?php

namespace App\Http\Middleware;

use App\Models\User;

use Closure;

use Auth;

use Cache;

use Carbon\Carbon;

class ActivityByUser

{

public function handle($request, Closure $next)

{

if (Auth::check()) {

$expiresAt = Carbon::now()->addMinutes(1); // keep online for 1 min

Cache::put('user-is-online-' . Auth::user()->id, true, $expiresAt);

// last seen

User::where('id', Auth::user()->id)->update(['last_seen' => (new \DateTime())->format("Y-m-d H:i:s")]);

}

return $next($request);

}

Step 6: Register Middleware in Kernel

In this step, navigate app>Http and open Kernel.php. And register ActivityByUser.php middleware in the kernal.php file. You can see as follow:

protected $middlewareGroups = [
    'web' => [
        \App\Http\Middleware\EncryptCookies::class,
        \Illuminate\Cookie\Middleware\AddQueuedCookiesToResponse::class,
        \Illuminate\Session\Middleware\StartSession::class,
        // \Illuminate\Session\Middleware\AuthenticateSession::class,
        \Illuminate\View\Middleware\ShareErrorsFromSession::class,
        \App\Http\Middleware\VerifyCsrfToken::class,
        \Illuminate\Routing\Middleware\SubstituteBindings::class,
        \App\Http\Middleware\ActivityByUser::class,
    ],
    'api' => [
        'throttle:60,1',
        \Illuminate\Routing\Middleware\SubstituteBindings::class,
    ],
];

protected $middlewareGroups = [

'web' => [

\App\Http\Middleware\EncryptCookies::class,

\Illuminate\Cookie\Middleware\AddQueuedCookiesToResponse::class,

\Illuminate\Session\Middleware\StartSession::class,

// \Illuminate\Session\Middleware\AuthenticateSession::class,

\Illuminate\View\Middleware\ShareErrorsFromSession::class,

\App\Http\Middleware\VerifyCsrfToken::class,

\Illuminate\Routing\Middleware\SubstituteBindings::class,

\App\Http\Middleware\ActivityByUser::class,

'api' => [

'throttle:60,1',

\Illuminate\Routing\Middleware\SubstituteBindings::class,

];

Step 7: Create Controller by Artisan

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

php artisan make:controller UserController

1	php artisan make:controller UserController

Now, go to app>Http>Controllers and open UserController.php file. Then update the following method into your UserController.php file:

<?php
namespace App\Http\Controllers;
use App\Models\User;
use Carbon\Carbon;
use Illuminate\Http\Request;
use Cache;
class UserController extends Controller
{
    /**
     * Show user online status.
     */
    public function userOnlineStatus()
    {
        $users = User::all();
        foreach ($users as $user) {
            if (Cache::has('user-is-online-' . $user->id))
                echo $user->name . " is online. Last seen: " . Carbon::parse($user->last_seen)->diffForHumans() . " <br>";
            else
                echo $user->name . " is offline. Last seen: " . Carbon::parse($user->last_seen)->diffForHumans() . " <br>";
        }
    }
}

<?php

namespace App\Http\Controllers;

use App\Models\User;

use Carbon\Carbon;

use Illuminate\Http\Request;

use Cache;

class UserController extends Controller

{

/**

* Show user online status.

public function userOnlineStatus()

{

$users = User::all();

foreach ($users as $user) {

if (Cache::has('user-is-online-' . $user->id))

echo $user->name . " is online. Last seen: " . Carbon::parse($user->last_seen)->diffForHumans() . " <br>";

else

echo $user->name . " is offline. Last seen: " . Carbon::parse($user->last_seen)->diffForHumans() . " <br>";

}

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

use App\Http\Controllers\UserController;
 
 
Route::get('status', [UserController::class, 'userOnlineStatus']);

use App\Http\Controllers\UserController;

Route::get('status', [UserController::class, 'userOnlineStatus']);

Step 8: Check Online Status in Blade File

@if(Cache::has('user-is-online-' . $user->id))
    <span class="text-success">Online</span>
@else
    <span class="text-secondary">Offline</span>
@endif

@if(Cache::has('user-is-online-' . $user->id))

<span class="text-success">Online</span>

@else

<span class="text-secondary">Offline</span>

@endif

Go to resources>views and open home.blade.php. Then update the following code into home.blade.php.

@extends('layouts.app')
@section('content')
    <div class="container">
        <div class="row justify-content-center">
            <div class="col-md-8">
                <div class="card">
                    <div class="card-header">Users</div>
                    <div class="card-body">
                        @php $users = DB::table('users')->get(); @endphp
                        <div class="container">
                            <table class="table table-bordered">
                                <thead>
                                <tr>
                                    <th>Name</th>
                                    <th>Email</th>
                                    <th>Status</th>
                                    <th>Last Seen</th>
                                </tr>
                                </thead>
                                <tbody>
                                @foreach($users as $user)
                                    <tr>
                                        <td>{{$user->name}}</td>
                                        <td>{{$user->email}}</td>
                                        <td>
                                            @if(Cache::has('user-is-online-' . $user->id))
                                                <span class="text-success">Online</span>
                                            @else
                                                <span class="text-secondary">Offline</span>
                                            @endif
                                        </td>
                                        <td>{{ \Carbon\Carbon::parse($user->last_seen)->diffForHumans() }}</td>
                                    </tr>
                                @endforeach
                                </tbody>
                            </table>
                        </div>
                    </div>
                </div>
            </div>
        </div>
    </div>
@endsection

@extends('layouts.app')

@section('content')

<div class="card-header">Users</div>

@php $users = DB::table('users')->get(); @endphp

<thead>

<tr>

<th>Email</th>

<th>Status</th>

</tr>

</thead>

<tbody>

@foreach($users as $user)

<tr>

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

<td>

@if(Cache::has('user-is-online-' . $user->id))

<span class="text-success">Online</span>

@else

<span class="text-secondary">Offline</span>

@endif

</td>

<td>{{ \Carbon\Carbon::parse($user->last_seen)->diffForHumans() }}</td>

</tr>

@endforeach

</tbody>

</table>

</div>

@endsection

Step 9: Run Development Server

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

php artisan serve

1	php artisan serve

Laravel 8 Typeahead JS Autocomplete Search Example

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

The Typeahead JS is a jquery plugin, it is used to create dynamic autocomplete input with several options. In this example you will learn how to implement typeahead autocomplete in laravel.

Laravel 8 Typeahead JS Autocomplete Search Example

In this step by step tutorial I will demonstrate how to create a dynamic database driven ajax jquery autocomplete using typeahead js in Laravel. Please follow the instruction given below:

Step 1 – Install Laravel 8 App
Step 2 – Connecting App to Database
Step 3 – Generate Fake Records
Step 4 – Add Routes
Step 5 – Create Controller & Methods
Step 6 – Create Blade View
Step 7 – Start Development Server
Step 8 – Test This App

Step 1 – Install Laravel 8 App

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

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

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

Step 2 – Connecting App to Database

Now, lets create a MySQL database and connect it with laravel application. After creating database we need to set database credential in application’s .env file.

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

DB_CONNECTION=mysql

DB_HOST=127.0.0.1

DB_PORT=3306

DB_DATABASE=here your database name here

DB_USERNAME=here database username here

DB_PASSWORD=here database password here

Step 3 – Generate Fake Records

In this step we will insert dummy data into database

php artisan migrate

1	php artisan migrate

Now we will add fake records in our database. use the below command and add 100 fake records in database :

php artisan tinker 

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

php artisan tinker

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

Step 4 – Add Routes

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

routes/web.php

use App\Http\Controllers\AutoCompleteController;

Route::get('search', [AutoCompleteController::class, 'index']);
Route::get('autocomplete', [AutoCompleteController::class, 'search']);

use App\Http\Controllers\AutoCompleteController;

Route::get('search', [AutoCompleteController::class, 'index']);

Route::get('autocomplete', [AutoCompleteController::class, 'search']);

Step 5 – Create Controller & Methods

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

php artisan make:controller AutoCompleteController

1	php artisan make:controller AutoCompleteController

After successfully create controller go to app/controllers/AutoCompleteController.php and put the below code :

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

<?php

namespace App\Http\Controllers;

use Illuminate\Http\Request;

use App\User;

class AutoCompleteController extends Controller

{

public function index()

{

return view('search');

}

public function search(Request $request)

{

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

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

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

}

Step 6 – Create Blade View

In this step we need to create blade view file. Go to app/resources/views and create one file name search.blade.php . After create blade file put the below html code here with jquery ui and css library file :

<!DOCTYPE html>
<html>
<head>
  <meta charset="UTF-8">
  <meta name="viewport" content="width=device-width, initial-scale=1.0">
  <meta http-equiv="X-UA-Compatible" content="ie=edge">
  <meta name="csrf-token" content="{{ csrf_token() }}">
  <title>Autocomplete Search Using Typeahead JS</title>
  <link rel="stylesheet" href="https://cdnjs.cloudflare.com/ajax/libs/twitter-bootstrap/4.1.3/css/bootstrap.min.css" />
  <script src="//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>
 <style>
    .container{
    padding: 10%;
    text-align: center;
   } 
 </style>
</head>
<body>
 
<div class="container">
    <div class="row">
        <div class="col-12"><h2>Laravel AutoComplete Search Using Typeahead JS</h2></div>
        <div class="col-12">
            <div id="custom-search-input">
                <div class="input-group">
                    <input id="search" name="search" type="text" class="form-control" placeholder="Search" />
                </div>
            </div>
        </div>
    </div>
</div>
 
<script type="text/javascript">
    var route = "{{ url('autocomplete') }}";
    $('#search').typeahead({
        source:  function (term, process) {
        return $.get(route, { term: term }, function (data) {
                return process(data);
            });
        }
    });
</script>
   
</body>
</html>

<!DOCTYPE html>

<html>

<head>

<title>Autocomplete Search Using Typeahead JS</title>

<style>

.container{

padding: 10%;

text-align: center;

}

</style>

</head>

<body>

<div class="col-12"><h2>Laravel AutoComplete Search Using Typeahead JS</h2></div>

</div>

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

$('#search').typeahead({

source: function (term, process) {

return $.get(route, { term: term }, function (data) {

return process(data);

});

}

});

</script>

</body>

</html>

Step 7 – Start Development Server

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

php artisan serve

1	php artisan serve

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

Http://localhost:8000/search

1	Http://localhost:8000/search

Laravel 8 Query Scope Example

In this Laravel 8 Query Scope Example Tutorial I will show you how to use query scopes in laravel eloquent model. In this tutorial you will learn to implement and use query scopes in laravel eloquent model. I will Also show you how to create and use dynamic query scope in laravel applications.

Laravel 8 Query Scope Example

In this step by step guide I will demonstrate you to create and use dynamic query scope in laravel applications.

Create Basic Scope in Model

Here we will first create a basic scope. Go to app/Post.php and create a scope here:

app/Post.php

<?php

namespace App\Models;

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

class Post extends Model
{
	public $table = "posts";
      
    /**
     * The attributes that are mass assignable.
     *
     * @var array
     */
    protected $fillable = [
        'id', 'title', 'body', 'status'
    ];
    /**
     * Scope a query to only include popular users.
     *
     * @param \Illuminate\Database\Eloquent\Builder $query
     * @return \Illuminate\Database\Eloquent\Builder
     */

    public function scopeStatus($query)
    {
        return $query->whereDate('status', 1);
    }
}

<?php

namespace App\Models;

use Illuminate\Database\Eloquent\Factories\HasFactory;

use Illuminate\Database\Eloquent\Model;

class Post extends Model

{

public $table = "posts";

/**

* The attributes that are mass assignable.

* @var array

protected $fillable = [

'id', 'title', 'body', 'status'

];

/**

* Scope a query to only include popular users.

* @param \Illuminate\Database\Eloquent\Builder $query

* @return \Illuminate\Database\Eloquent\Builder

public function scopeStatus($query)

{

return $query->whereDate('status', 1);

}

Use Basic Query Scope on Controller:

We can use basic query scope as following:

Post::status()->get(['id','title']);

1	Post::status()->get(['id','title']);

Laravel 8 Create Dynamic Scope in Model

Now we are creating a dynamic query scope in laravel model as following:

<?php

namespace App\Models;

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

class Post extends Model
{
	public $table = "posts";
      
    /**
     * The attributes that are mass assignable.
     *
     * @var array
     */
    protected $fillable = [
        'id', 'title', 'body', 'status'
    ];
    /**
     * Scope a query to only include popular users.
     *
     * @param \Illuminate\Database\Eloquent\Builder $query
     * @return \Illuminate\Database\Eloquent\Builder
     */
    public function scopeStatus($query, $type)
    {
        return $query->where('status', $type);
    }
}

<?php

namespace App\Models;

use Illuminate\Database\Eloquent\Factories\HasFactory;

use Illuminate\Database\Eloquent\Model;

class Post extends Model

{

public $table = "posts";

/**

* The attributes that are mass assignable.

* @var array

protected $fillable = [

'id', 'title', 'body', 'status'

];

/**

* Scope a query to only include popular users.

* @param \Illuminate\Database\Eloquent\Builder $query

* @return \Illuminate\Database\Eloquent\Builder

public function scopeStatus($query, $type)

{

return $query->where('status', $type);

}

Dynamic Scope Query On Controller

We can use dynamic scope in laravel as following:

Post::status(1)->get(['id',title']);

1	Post::status(1)->get(['id',title']);

Laravel 8 Apply Scope with Relationship

Here, you will learn how to use query scopes with laravel relationship. Go to your App/Category.php and create a relationship between Categories and Posts Tables:

class Category extends \Eloquent

{

    public function posts()

    {

        return $this->HasMany('Post');

    }

}

class Category extends \Eloquent

{

public function posts()

{

return $this->HasMany('Post');

}

Go to your App/Post.php and create a relationship between Posts and Categories Tables:

class Post extends \Eloquent
 {
    public function category()
    {
        return $this->belongsTo('Category');
    }
 public function scopePublished($query)
    {
        return $query->where('published', 1);
    }
 }

class Post extends \Eloquent

{

public function category()

{

return $this->belongsTo('Category');

}

public function scopePublished($query)

{

return $query->where('published', 1);

}

Query scope with relationship

Here we can use query scope with relationship as following:

$categories = Category::with(['posts' => function ($q) {

  $q->published();

}])->get();

$categories = Category::with(['posts' => function ($q) {

$q->published();

}])->get();

Laravel 8 Try Catch in Controller Tutorial Example

In this How to Use try catch In laravel Example TutorialI will show you How to Use try catch In laravel.In this tutorial you will learn to use try catch exception handling in laravel framework. While working or developing application with Laravel framework, you may encounter many errors. It is very important to handle these errors properly in order to build safe and error free laravel application. In laravel you can use try catch statement for proper error handling in laravel.

Laravel 8 Try Catch in Controller Tutorial Example

Below is the syntax that represents the try..catch statement:

try {
    // run your code here
}
catch (exception $e) {
    //code to handle the exception
}

try {

// run your code here

}

catch (exception $e) {

//code to handle the exception

}

The try…catch statement is used to handle the errors.

Find Product By Title

Let’s take a look example of laravel try catch. Here you have product table and find the product with it’s title. So you have the following method in controller to find product by it’s title:

public function search(Request $request)
{
    try {
        $product = Product::where('title',$request->get('title'));
    } catch (ModelNotFoundException $exception) {
        return back()->withError($exception->getMessage())->withInput();
    }
    return view('product.search', compact('product'));
}

public function search(Request $request)

{

try {

$product = Product::where('title',$request->get('title'));

} catch (ModelNotFoundException $exception) {

return back()->withError($exception->getMessage())->withInput();

}

return view('product.search', compact('product'));

}

With try…catch we have implemented error handling in the above example code. Now if there is no error we can directly pass product data to blade file. But if there is error we can pass errors to blade file. If you want to display an error in Blade file, you can do look like:

<h3 class="page-title text-center">Search by proudct title</h3>
 
@if (session('error'))
<div class="alert alert-danger">{{ session('error') }}</div>
@endif
 
<form action="{{ route('product.search') }}" method="POST">...</form>

<h3 class="page-title text-center">Search by proudct title</h3>

@if (session('error'))

<div class="alert alert-danger">{{ session('error') }}</div>

@endif

Note:- DO remember to set APP_DEBUG=false in .env file.

Laravel 8 Link Storage Folder Example

In this Laravel 8 Link Storage Folder Example tutorial, I will show you how to link storage folder and access file from there in laravel 8. In this tutorial you will learn to link storage folder and access files from storage folder in laravel 8 application. In this Laravel 8 link storage folder example will cover the following topics:

laravel link storage folder

laravel storage:link not working

laravel storage_path

laravel link storage to public_html

laravel link storage to public

laravel storage link permission denied

laravel storage link command

Laravel 8 Link Storage Folder Example

Use the following command to link storage folder in laravel:

php artisan storage:link

1	php artisan storage:link

The above command creates a symbolic link from public/storage to storage/app/public for you. Now any file in /storage/app/public can be accessed via a link like:

http://yourdomain.com/storage/image.jpg

1	http://yourdomain.com/storage/image.jpg

Now, If you get laravel storage link permission denied error then you need to give permission for linking public storage directory in laravel 8. You may also missing a view directories in laravel_root/storage/. In order to fix this, follow given commands:

cd {laravel_root}/storage
mkdir -pv framework/views app framework/sessions framework/cache
cd ..
chmod 777 -R storage
chown -R www-data:www-data storage

cd {laravel_root}/storage

mkdir -pv framework/views app framework/sessions framework/cache

cd ..

chmod 777 -R storage

chown -R www-data:www-data storage

If you cannot create symbolic links there is an option to have a special route One who reads and provides the image.

Route::get('storage/{filename}', function ($filename)
{
    $path = storage_path('public/' . $filename);
 
    if (!File::exists($path)) {
        abort(404);
    }
 
    $file = File::get($path);
    $type = File::mimeType($path);
 
    $response = Response::make($file, 200);
    $response->header("Content-Type", $type);
 
    return $response;
});

Route::get('storage/{filename}', function ($filename)

{

$path = storage_path('public/' . $filename);

if (!File::exists($path)) {

abort(404);

}

$file = File::get($path);

$type = File::mimeType($path);

$response = Response::make($file, 200);

$response->header("Content-Type", $type);

return $response;

});

Route::post('process', function (Request $request) {
    // cache the file
    $file = $request->file('photo');
 
    // generate a new filename. getClientOriginalExtension() for the file extension
    $filename = 'profile-photo-' . time() . '.' . $file->getClientOriginalExtension();
 
    // save to storage/app/photos as the new $filename
    $path = $file->storeAs('photos', $filename);
 
    dd($path);
});

Route::post('process', function (Request $request) {

// cache the file

$file = $request->file('photo');

// generate a new filename. getClientOriginalExtension() for the file extension

$filename = 'profile-photo-' . time() . '.' . $file->getClientOriginalExtension();

// save to storage/app/photos as the new $filename

$path = $file->storeAs('photos', $filename);

dd($path);

});

Now you can access your files the same way you do a symlink:

Route::get('storage/{filename}', function ($filename)
{
    return Image::make(storage_path('public/' . $filename))->response();
});

Route::get('storage/{filename}', function ($filename)

{

return Image::make(storage_path('public/' . $filename))->response();

});

Laravel 8 Eloquent Join Example Tutorial

Types of Joins In Laravel 8

1: Laravel Join Eloquent

Example 1: Laravel Eloquent Join() with 2 Tables

Example 2: Laravel Eloquent Join() with 3 Tables

Example 3: Laravel Eloquent Join() with Multiple Conditions

2 – Laravel Left Join

Example 1: Laravel Left Join Query

Example 2: Laravel Left Join with Multiple Condition

3 – Laravel Right Join

Example 1: Laravel Right Join Query

Example 2: Laravel Right Join with Multiple Condition

4 – Cross Join Clause

5 – Laravel Advanced Join

6 – Laravel Sub-Query Joins

Laravel 8 Generate PDF with Graph Tutorial

Step 1 – Install wkhtmltopdf Software

Step 2 – Install Laravel 8 App

Step 3 – Install mikehaertl/phpwkhtmltopdf

Step 4 – Add Routes

Step 5 – Create Controller by Command

Step 6 – Create View File

Step 7 – Run Development Server

Laravel 8 Fetch Data using Ajax Tutorial Example

Step 1 – Install Laravel 8 App

Step 2 – Connecting App to Database

Step 3 – Execute Database Migration Command

Step 4 – Add Routes

Step 5 – Create Controller Using Artisan Command

Step 6 – Create Blade Views

Step 7 – Run Development Server

Laravel 8 Create Unique Slug Tutorial Example

Step 1 – Install Laravel 8 App

Step 2 – Connecting App to Database

Step 3 – Install Eloquent Sluggable Package

Step 4 – Build Model and Migration

Step 5 – Add Routes

Step 6 – Create Controller using Artisan Command

Step 7 – Create the blade view

Create.blade.php

Step 8 – Run Development Server

Laravel 8 FullCalendar Ajax Tutorial with Example

Step 1 – Install Laravel App

Step 2 – Connecting App to Database

Step 3 – Build Migration & Model

Step 4 – Add Routes

Step 5 – Create Controller Using Artisan Command

Step 6 – Create Blade view

Put the script on fullcalendar.blade.php, after the closing of the body tag

Step 7 – Run Development Server

Laravel 8 Image Crop & Upload using jQuery and Ajax Example

Step 1 – Install Laravel 8 App

Step 2 – Connecting App to Database

Step 3 – Create Crop Image Migration & Model

Step 4 – Add Routes For Crop Image Upload

Step 5 – Create Crop Image Controller Using Command

Step 6 – Create Crop Image Upload Blade View

Step 7 – Make Upload Folder

Step 8 – Run Development Server

Currency Converter in Laravel 8

Step 1 – Install Laravel 8 app

Step 2 – SignUp and Get API KEY

Step 3 – Create Route

Step 4 – Create Controller using Artisan Command

Step 5 – Create the blade view

Step 6 – Run Development Server

How to Check User Login Online Status & Last Seen in Laravel 8?

Step 1: Install Laravel 8 App

Step 2: Connecting App to Database

Step 3: Generate Auth Scaffolding

Step 4: Add Column in User Table

Step 5: Create a Middleware

Step 6: Register Middleware in Kernel

Step 7: Create Controller by Artisan

Step 8: Check Online Status in Blade File

Step 9: Run Development Server

Laravel 8 Typeahead JS Autocomplete Search Example

Step 1 – Install Laravel 8 App

Step 2 – Connecting App to Database

Step 3 – Generate Fake Records