Category Archives: Blog

Blog

Laravel 9 Create Custom Helper Functions Example

In this Laravel 9 Create Custom Helper Functions Example tutorial I will show you how to create custom helper in laravel 9. In this tutorial you will learn to create custom helper file in laravel 9 application . With custom helper file you can define functions that you can reuse in your laravel 9 application.

What Is Laravel 9 Custom Helper

In laravel 9, custom helper file helps you to reduce the re-writing the same code again and again. With custom helper file you can define the custom helper functions that you can use anywhere in your laravel 9 project.

How to Create Custom Helper In Laravel 9

In this step by step tutorial I demonstrate you how to create custom helper file in laravel project. I will also show you how to define custom helper function and to call them in laravel application:

Create helpers.php File

In custom helper file you can define your own functions and call anywhere in your laravel project. Go to App directory and create a new file helpers.php like this app/helpers.php.

<?php
  
  function random_code(){
 
    return rand(1111, 9999);
  }
 
 
  function doUpper($str){
    return strtoupper($str);
  }

<?php

function random_code(){

return rand(1111, 9999);

}

function doUpper($str){

return strtoupper($str);

}

Add custom helper File Path In composer.json File

In this step, we will add custom helper file path in composer.json file. Go to root directory and open composer.json file and put the following code into the file:

composer.json

"autoload": {
    "psr-4": {
        "App\\": "app/",
        "Database\\Factories\\": "database/factories/",
        "Database\\Seeders\\": "database/seeders/"
    },
       "files": [
 
        "app/helpers.php"
 
    ]
},

"autoload": {

"psr-4": {

"App\\": "app/",

"Database\\Factories\\": "database/factories/",

"Database\\Seeders\\": "database/seeders/"

"files": [

"app/helpers.php"

]

Run Command for autoloading custom helper file

Now, go to command prompt and type the given command:

composer dump-autoload

1	composer dump-autoload

How to use custom helper function in laravel 9

Now, you will learn how to call or use custom helper function in laravel 9:

1 – How to call custom helper function in laravel blade

<h2><?php echo doUpper('hello world') ?></h2>

1	<h2><?php echo doUpper('hello world') ?></h2>

2 – How to call custom helper function in laravel controller

public function index()
{   
    $data['title'] = doUpper('hello world');
    return view('view', $data);
}

public function index()

{

$data['title'] = doUpper('hello world');

return view('view', $data);

}

Laravel 9 Auto Load More Data on Page Scroll with jQuery AJAX

In this Laravel 9 Auto Load More Data on Page Scroll with jQuery AJAX tutorial I’ll show you how to implement infinity scroll or dynamix ajax auto load more pagination on page scroll in laravel 9 using ajax. In this tutorial you will learn to implement dynamic auto load more pagination in laravel using ajax in laravel 9. In this step by step guide I’ll share example of ajax auto load more or infinity scroll in laravel 9 application.

Laravel 9 Auto Load More Data on Page Scroll with jQuery AJAX

In this step by step tutorial I will demonstrate you with example to create dynamix ajax load more pagination on page scroll in laravel. Please follow the instruction given below:

Install Laravel 9
Connecting App to Database
Create One Model and Migration
Add Route
Create Controller by Command
Create Blade View
Run Development Server
Test This App

Install Laravel 9

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

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

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

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

Create 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

Now, go to app/database/migrations and open posts migration file and add following fields:

<?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('contacts', function (Blueprint $table) {
            $table->increments('id');
            $table->string('title');
            $table->text('description');
            $table->timestamps();
        });
    }
    /**
     * Reverse the migrations.
     *
     * @return void
     */
    public function down()
    {
        Schema::dropIfExists('contacts');
    }
}

<?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('contacts', function (Blueprint $table) {

$table->increments('id');

$table->string('title');

$table->text('description');

$table->timestamps();

});

}

/**

* Reverse the migrations.

* @return void

public function down()

{

Schema::dropIfExists('contacts');

}

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

php artisan migrate

1	php artisan migrate

Add Route

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

routes/web.php

use App\Http\Controllers\PostController;

Route::get('posts', [PostController::class, 'index']);

use App\Http\Controllers\PostController;

Route::get('posts', [PostController::class, 'index']);

Create Controller by Command

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

php artisan make:controller PostController

1	php artisan make:controller PostController

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

app/Http/Controllers/PostController.php

<?php
 
namespace App\Http\Controllers;
 
use Illuminate\Http\Request;
 
use Validator,Redirect,Response;
 
use App\Models\Post;
 
class PostController extends Controller
{
    public function index(Request $request)
    {
        $posts = Post::paginate(8);
        $data = '';
        if ($request->ajax()) {
            foreach ($posts as $post) {
                $data.='<li>'.$post->id.' <strong>'.$post->title.'</strong> : '.$post->description.'</li>';
            }
            return $data;
        }
        return view('posts');
    }
}

<?php

namespace App\Http\Controllers;

use Illuminate\Http\Request;

use Validator,Redirect,Response;

use App\Models\Post;

class PostController extends Controller

{

public function index(Request $request)

{

$posts = Post::paginate(8);

$data = '';

if ($request->ajax()) {

foreach ($posts as $post) {

$data.='<li>'.$post->id.' <strong>'.$post->title.'</strong> : '.$post->description.'</li>';

}

return $data;

}

return view('posts');

}

Create a blade view

In this step we will create blade view file. Lets create a blade file posts.blade.php. And put the below HTML code into your posts.blade.php file:

<!doctype html>
<html lang="en">
  <head>
  <meta charset="utf-8">
  <meta name="viewport" content="width=device-width, initial-scale=1, shrink-to-fit=no">
  <meta name="csrf-token" content="{{ csrf_token() }}">
  <title>Laravel 9 load more page scroll</title>
  <link rel="stylesheet" href="https://cdnjs.cloudflare.com/ajax/libs/twitter-bootstrap/4.1.3/css/bootstrap.min.css" />
   
  <script src="https://cdnjs.cloudflare.com/ajax/libs/jquery/3.4.1/jquery.min.js"></script>
<style>
   .wrapper > ul#results li {
     margin-bottom: 2px;
     background: #e2e2e2;
     padding: 20px;
     width: 97%;
     list-style: none;
   }
   .ajax-loading{
     text-align: center;
   }
</style>
</head>
  
<body>
  
  <div class="container">
   <div class="wrapper">
    <ul id="results"><!-- results appear here --></ul>
     <div class="ajax-loading"><img src="{{ asset('images/loading.gif') }}" /></div>
   </div>
  </div>
</body>
</html>

<!doctype html>

<head>

<title>Laravel 9 load more page scroll</title>

<style>

.wrapper > ul#results li {

margin-bottom: 2px;

background: #e2e2e2;

padding: 20px;

width: 97%;

list-style: none;

}

.ajax-loading{

text-align: center;

}

</style>

</head>

<body>

</div>

</body>

</html>

The blade view file will list all your blog posts when you scroll the page down. Next, update the following script into your blade view file:

<script>
   var SITEURL = "{{ url('/') }}";
   var page = 1; //track user scroll as page number, right now page number is 1
   load_more(page); //initial content load
   $(window).scroll(function() { //detect page scroll
      if($(window).scrollTop() + $(window).height() >= $(document).height()) { //if user scrolled from top to bottom of the page
      page++; //page number increment
      load_more(page); //load content   
      }
    });     
    function load_more(page){
        $.ajax({
           url: SITEURL + "posts?page=" + page,
           type: "get",
           datatype: "html",
           beforeSend: function()
           {
              $('.ajax-loading').show();
            }
        })
        .done(function(data)
        {
            if(data.length == 0){
            console.log(data.length);
            //notify user if nothing to load
            $('.ajax-loading').html("No more records!");
            return;
          }
          $('.ajax-loading').hide(); //hide loading animation once data is received
          $("#results").append(data); //append data into #results element          
           console.log('data.length');
       })
       .fail(function(jqXHR, ajaxOptions, thrownError)
       {
          alert('No response from server');
       });
    }
</script>

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

var page = 1; //track user scroll as page number, right now page number is 1

load_more(page); //initial content load

$(window).scroll(function() { //detect page scroll

if($(window).scrollTop() + $(window).height() >= $(document).height()) { //if user scrolled from top to bottom of the page

page++; //page number increment

load_more(page); //load content

}

});

function load_more(page){

$.ajax({

url: SITEURL + "posts?page=" + page,

type: "get",

datatype: "html",

beforeSend: function()

{

$('.ajax-loading').show();

}

})

.done(function(data)

{

if(data.length == 0){

console.log(data.length);

//notify user if nothing to load

$('.ajax-loading').html("No more records!");

return;

}

$('.ajax-loading').hide(); //hide loading animation once data is received

$("#results").append(data); //append data into #results element

console.log('data.length');

})

.fail(function(jqXHR, ajaxOptions, thrownError)

{

alert('No response from server');

});

}

</script>

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

1	http://127.0.0.1:8000/posts

Laravel 9 Google Line Chart Tutorial Example

In this Laravel 9 Google Line Chart Example Tutorial I’ll will show how to use google line chart in laravel 9 application. In this tutorial you will learn to implement google line char in laravel 9 project. With Google Charts we can visualize data in your laravel web application. In this tutorialI’ll share example to demonstrate use of google line graph chart in laravel 9.

Laravel 9 Google Line Chart Tutorial Example

Install Laravel App
Add Database Details
Add Route
Create Controller
Create Blade File
Run Development Server

Install Laravel App

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

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

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

Add Database Detail

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

DB_CONNECTION=mysql
DB_HOST=127.0.0.1
DB_PORT=3306
DB_DATABASE=Enter_Your_Database_Name
DB_USERNAME=Enter_Your_Database_Username
DB_PASSWORD=Enter_Your_Database_Password

DB_CONNECTION=mysql

DB_HOST=127.0.0.1

DB_PORT=3306

DB_DATABASE=Enter_Your_Database_Name

DB_USERNAME=Enter_Your_Database_Username

DB_PASSWORD=Enter_Your_Database_Password

Add Route

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

routes/web.php

Route::get("laravel-google-line-chart", "GoogleLineController@index");

1	Route::get("laravel-google-line-chart", "GoogleLineController@index");

Create Controller

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

php artisan make:controller GoogleLineController

1	php artisan make:controller GoogleLineController

Now, go to app/http/controller folder and open GoogleLineController.php. And put the following code into your GoogleLineController.php file:

<?php
   
namespace App\Http\Controllers;
 
use App\User;
 
use Illuminate\Http\Request;
 
use Redirect,Response;
 
Use DB;
 
use Carbon\Carbon;
 
class GoogleLineController extends Controller
{
    /**
     * Display a listing of the resource.
     *
     * @return \Illuminate\Http\Response
     */
    public function index()
    {
 
     $data['lineChart'] = User::select(\DB::raw("COUNT(*) as count"), \DB::raw("MONTHNAME(created_at) as month_name"),\DB::raw('max(created_at) as createdAt'))
        ->whereYear('created_at', date('Y'))
        ->groupBy('month_name')
        ->orderBy('createdAt')
        ->get();
 
        return view('google-line-chart', $data);
    }
 
}

<?php

namespace App\Http\Controllers;

use App\User;

use Illuminate\Http\Request;

use Redirect,Response;

Use DB;

use Carbon\Carbon;

class GoogleLineController extends Controller

{

/**

* Display a listing of the resource.

* @return \Illuminate\Http\Response

public function index()

{

$data['lineChart'] = User::select(\DB::raw("COUNT(*) as count"), \DB::raw("MONTHNAME(created_at) as month_name"),\DB::raw('max(created_at) as createdAt'))

->whereYear('created_at', date('Y'))

->groupBy('month_name')

->orderBy('createdAt')

->get();

return view('google-line-chart', $data);

}

Create Blade File

In this step, we will go to /resources/views/ folder and create a blade file name google-line-chart.blade.php. And put the following code into your google-line-chart.blade.php file:

<!doctype html>
<html lang="en">
  <head>
    <title>Laravel Google Line Graph Chart</title>
    <meta charset="utf-8">
    <meta name="viewport" content="width=device-width, initial-scale=1, shrink-to-fit=no">
    <link rel="stylesheet" href="https://stackpath.bootstrapcdn.com/bootstrap/4.3.1/css/bootstrap.min.css">
  </head>
  <body>
 
    <div class="container p-5">
        <h5>Laravel Google Line Chart</h5>
 
        <div id="google-line-chart" style="width: 900px; height: 500px"></div>
 
    </div>
 
    <script type="text/javascript" src="https://www.gstatic.com/charts/loader.js"></script>
    <script type="text/javascript">
        google.charts.load('current', {'packages':['corechart']});
        google.charts.setOnLoadCallback(drawChart);
 
        function drawChart() {
 
        var data = google.visualization.arrayToDataTable([
            ['Month Name', 'Register Users Count'],
 
                @php
                foreach($lineChart as $d) {
                    echo "['".$d->month_name."', ".$d->count."],";
                }
                @endphp
        ]);
 
        var options = {
          title: 'Register Users Month Wise',
          curveType: 'function',
          legend: { position: 'bottom' }
        };
 
          var chart = new google.visualization.LineChart(document.getElementById('google-line-chart'));
 
          chart.draw(data, options);
        }
    </script>
</body>
</html>

<!doctype html>

<head>

<title>Laravel Google Line Graph Chart</title>

</head>

<body>

<h5>Laravel Google Line Chart</h5>

</div>

google.charts.load('current', {'packages':['corechart']});

google.charts.setOnLoadCallback(drawChart);

function drawChart() {

var data = google.visualization.arrayToDataTable([

['Month Name', 'Register Users Count'],

@php

foreach($lineChart as $d) {

echo "['".$d->month_name."', ".$d->count."],";

}

@endphp

]);

var options = {

title: 'Register Users Month Wise',

curveType: 'function',

legend: { position: 'bottom' }

};

var chart = new google.visualization.LineChart(document.getElementById('google-line-chart'));

chart.draw(data, options);

}

</script>

</body>

</html>

Run Development Server

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

php artisan serve

If you want to run the project diffrent port so use this below command 

php artisan serve --port=8080

php artisan serve

If you want to run the project diffrent port so use this below command

php artisan serve --port=8080

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

http://localhost:8000/laravel-google-line-chart

1	http://localhost:8000/laravel-google-line-chart

Laravel 9 Google Bar Chart Tutorial Example

In this Laravel 9 Google Bar Chart Tutorial Example I’ll will show how to use google Bar chart in laravel 9 application. In this tutorial you will learn to implement google Bar char in laravel 9 project. With Google Charts we can visualize data in your laravel web application. In this tutorialI’ll share example to demonstrate use of google Bar chart in laravel 9.

Laravel 9 Google Bar Chart Tutorial Example

In this step by step tutorial I will demonstrate you how to create google Bar char in laravel 9 application. Please follow instruction given below:

Install Laravel 9
Add Database Details
Generate Migration & Model File
Add Route
Create Controller
Create Blade File
Run Development Server

Install Laravel App

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

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

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

Add Database Configuration

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

DB_CONNECTION=mysql
DB_HOST=127.0.0.1
DB_PORT=3306
DB_DATABASE=Enter_Your_Database_Name
DB_USERNAME=Enter_Your_Database_Username
DB_PASSWORD=Enter_Your_Database_Password

DB_CONNECTION=mysql

DB_HOST=127.0.0.1

DB_PORT=3306

DB_DATABASE=Enter_Your_Database_Name

DB_USERNAME=Enter_Your_Database_Username

DB_PASSWORD=Enter_Your_Database_Password

Generate Migration & Model File

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

php artisan make:model Order -fm

1	php artisan make:model Order -fm

Now, go to app directory and open Order.php file. And put the following code into your Order.php file:

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

<?php

namespace App\Models;

use Illuminate\Database\Eloquent\Factories\HasFactory;

use Illuminate\Database\Eloquent\Model;

class Order extends Model

{

protected $guarded = [];

}

Now, go to database/migrations/ and open create_orders_table.php file and update the following code:

Schema::create('orders', function (Blueprint $table) {
    $table->id();
    $table->string("product_name")->nullable();
    $table->string("product_id")->nullable();
    $table->string("price")->nullable();
    $table->timestamps();
});

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

$table->id();

$table->string("product_name")->nullable();

$table->string("product_id")->nullable();

$table->string("price")->nullable();

$table->timestamps();

});

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

php artisan migrate

1	php artisan migrate

Add Route

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

routes/web.php

use App\Http\Controllers\OrderController;

Route::get('google-bar-chart', [OrderController::class, 'index']);

use App\Http\Controllers\OrderController;

Route::get('google-bar-chart', [OrderController::class, 'index']);

Create Controller

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

php artisan make:controller OrderController

1	php artisan make:controller OrderController

Then go to app/http/controller folder and open OrderController.php. And put the following code into your OrderController.php file:

<?php
 
namespace App\Http\Controllers;
 
use Illuminate\Http\Request;
 
use App\Models\Order;
 
class OrderController extends Controller
{
    public function index()
    {
       $orders = Order::all();
       return view('google-bar-chart',['orders' => $orders]);   
    }
}

<?php

namespace App\Http\Controllers;

use Illuminate\Http\Request;

use App\Models\Order;

class OrderController extends Controller

{

public function index()

{

$orders = Order::all();

return view('google-bar-chart',['orders' => $orders]);

}

Create Blade File

In this step we will create blade file. Go to /resources/views/ folder and create one blade view file name google-bar-chart.blade.php. And add the following code into your google-bar-chart.blade.php file:

<!doctype html>
<html lang="en">
  <head>
    <title>Laravel 9 Google Bar Chart Example Tutorial</title>
    <meta charset="utf-8">
    <meta name="viewport" content="width=device-width, initial-scale=1, shrink-to-fit=no">
    <link rel="stylesheet" href="https://stackpath.bootstrapcdn.com/bootstrap/4.3.1/css/bootstrap.min.css">
 
    <script src="https://code.jquery.com/jquery-3.3.1.slim.min.js"></script>
 
    <script src="https://cdnjs.cloudflare.com/ajax/libs/popper.js/1.14.7/umd/popper.min.js"></script>
 
    <script src="https://stackpath.bootstrapcdn.com/bootstrap/4.3.1/js/bootstrap.min.js"></script>
 
    <script type="text/javascript" src="https://www.gstatic.com/charts/loader.js"></script>
 
</head>
  <body>
    <h2 style="text-align: center;">Laravel 9 Google Bar Charts Example Tutorial</h2>
    <div class="container-fluid p-5">
    <div id="barchart_material" style="width: 100%; height: 500px;"></div>
    </div>
 
    <script type="text/javascript">
 
      google.charts.load('current', {'packages':['bar']});
      google.charts.setOnLoadCallback(drawChart);
 
      function drawChart() {
        var data = google.visualization.arrayToDataTable([
            ['Order Id', 'Price', 'Product Name'],
 
            @php
              foreach($orders as $order) {
                  echo "['".$order->id."', ".$order->price.", ".$order->Product_name."],";
              }
            @endphp
        ]);
 
        var options = {
          chart: {
            title: 'Bar Graph | Price',
            subtitle: 'Price, and Product Name: @php echo $orders[0]->created_at @endphp',
          },
          bars: 'vertical'
        };
        var chart = new google.charts.Bar(document.getElementById('barchart_material'));
        chart.draw(data, google.charts.Bar.convertOptions(options));
      }
    </script>
 
</body>
</html>

<!doctype html>

<head>

<title>Laravel 9 Google Bar Chart Example Tutorial</title>

</head>

<body>

<h2 style="text-align: center;">Laravel 9 Google Bar Charts Example Tutorial</h2>

</div>

google.charts.load('current', {'packages':['bar']});

google.charts.setOnLoadCallback(drawChart);

function drawChart() {

var data = google.visualization.arrayToDataTable([

['Order Id', 'Price', 'Product Name'],

@php

foreach($orders as $order) {

echo "['".$order->id."', ".$order->price.", ".$order->Product_name."],";

}

@endphp

]);

var options = {

chart: {

title: 'Bar Graph | Price',

subtitle: 'Price, and Product Name: @php echo $orders[0]->created_at @endphp',

bars: 'vertical'

};

var chart = new google.charts.Bar(document.getElementById('barchart_material'));

chart.draw(data, google.charts.Bar.convertOptions(options));

}

</script>

</body>

</html>

Run Development Server

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

php artisan serve

1	php artisan serve

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

http://localhost:8000/google-bar-chart

1	http://localhost:8000/google-bar-chart

Laravel 9 Google Pie Chart Tutorial Example

In this Laravel 9 Google Pie Chart Tutorial Example I’ll will show how to use google Pie chart in laravel 9 application. In this tutorial you will learn to implement google Pie chart in laravel 9 application. With Google Charts we can visualize data in your laravel application. In this tutorialI’ll share example to demonstrate use of google Pie chart in laravel 9.

Laravel 9 Google Pie Chart Tutorial Example

Install Laravel 9
Add Database Details
Add Route
Create Controller
Create Blade File
Add Google Chart Library
Run Development Server

Install Laravel App

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

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

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

Add Database Detail

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

DB_CONNECTION=mysql
DB_HOST=127.0.0.1
DB_PORT=3306
DB_DATABASE=Enter_Your_Database_Name
DB_USERNAME=Enter_Your_Database_Username
DB_PASSWORD=Enter_Your_Database_Password

DB_CONNECTION=mysql

DB_HOST=127.0.0.1

DB_PORT=3306

DB_DATABASE=Enter_Your_Database_Name

DB_USERNAME=Enter_Your_Database_Username

DB_PASSWORD=Enter_Your_Database_Password

Add Route

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

routes/web.php

Route::get("laravel-google-pie-chart", "GooglePieController@index");

1	Route::get("laravel-google-pie-chart", "GooglePieController@index");

Create Controller

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

php artisan make:controller GooglePieController

1	php artisan make:controller GooglePieController

Then go to app/http/controller folder and open GooglePieController.php. And put the following code into your GooglePieController.php file:

<?php
   
namespace App\Http\Controllers;
 
use App\User;
 
use Illuminate\Http\Request;
 
use Redirect,Response;
 
Use DB;
 
use Carbon\Carbon;
 
class GooglePieController extends Controller
{
    /**
     * Display a listing of the resource.
     *
     * @return \Illuminate\Http\Response
     */
    public function index()
    {
 
          $data['pieChart'] = User::select(\DB::raw("COUNT(*) as count"), \DB::raw("MONTHNAME(created_at) as month_name"))
        ->whereYear('created_at', date('Y'))
        ->groupBy('month_name')
        ->orderBy('count')
        ->get();
    }
 
}

<?php

namespace App\Http\Controllers;

use App\User;

use Illuminate\Http\Request;

use Redirect,Response;

Use DB;

use Carbon\Carbon;

class GooglePieController extends Controller

{

/**

* Display a listing of the resource.

* @return \Illuminate\Http\Response

public function index()

{

$data['pieChart'] = User::select(\DB::raw("COUNT(*) as count"), \DB::raw("MONTHNAME(created_at) as month_name"))

->whereYear('created_at', date('Y'))

->groupBy('month_name')

->orderBy('count')

->get();

}

Create Blade File

In this step, go to /resources/views/ folder and create a blade file name google-pie-chart.blade.php. And put the following code into your google-pie-chart.blade.php file:

<!doctype html>
<html lang="en">
  <head>
    <title>Laravel Google Pie Chart</title>
    <meta charset="utf-8">
    <meta name="viewport" content="width=device-width, initial-scale=1, shrink-to-fit=no">
    <link rel="stylesheet" href="https://stackpath.bootstrapcdn.com/bootstrap/4.3.1/css/bootstrap.min.css">
  </head>
  <body>
 
    <div class="container p-5">
        <h5>Laravel Google Pie Chart</h5>
 
        <div id="piechart" style="width: 900px; height: 500px;"></div>
    </div>
 
    <script type="text/javascript" src="https://www.gstatic.com/charts/loader.js"></script>
    <script type="text/javascript">
        google.charts.load('current', {'packages':['corechart']});
        google.charts.setOnLoadCallback(drawChart);
 
        function drawChart() {
 
        var data = google.visualization.arrayToDataTable([
            ['Month Name', 'Registered User Count'],
 
                @php
                foreach($pieChart as $d) {
                    echo "['".$d->month_name."', ".$d->count."],";
                }
                @endphp
        ]);
 
          var options = {
            title: 'Users Detail',
            is3D: false,
          };
 
          var chart = new google.visualization.PieChart(document.getElementById('piechart'));
 
          chart.draw(data, options);
        }
      </script>
</body>
</html>

<!doctype html>

<head>

<title>Laravel Google Pie Chart</title>

</head>

<body>

<h5>Laravel Google Pie Chart</h5>

</div>

google.charts.load('current', {'packages':['corechart']});

google.charts.setOnLoadCallback(drawChart);

function drawChart() {

var data = google.visualization.arrayToDataTable([

['Month Name', 'Registered User Count'],

@php

foreach($pieChart as $d) {

echo "['".$d->month_name."', ".$d->count."],";

}

@endphp

]);

var options = {

title: 'Users Detail',

is3D: false,

};

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

chart.draw(data, options);

}

</script>

</body>

</html>

Add Google Chart Library

<script type="text/javascript" src="https://www.gstatic.com/charts/loader.js"></script>

1	<script type="text/javascript" src="https://www.gstatic.com/charts/loader.js"></script>

Run Development Server

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

php artisan serve

If you want to run the project diffrent port so use this below command 

php artisan serve --port=8080

php artisan serve

If you want to run the project diffrent port so use this below command

php artisan serve --port=8080

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

http://localhost:8000/laravel-google-pie-chart

1	http://localhost:8000/laravel-google-pie-chart

Laravel 9 Highcharts Example Tutorial

In this Laravel 9 Highcharts Example Tutorial I will show you how to implement highchart in laravel 9 application. You will learn to implement highchart in laravel 9. In this article I will demonstrate the use of highchart in laravel application. In this example we will fetch month wise data and display month wise data in highcharts for analytics on laravel 9 application.

Laravel 9 Highcharts Example Tutorial

In this step by step tutorial I will demonstrate you how to implement Highcharts in Laravel 9 application. Please follow the instruction given below.

Install Laravel 9

First of all we need to install a fresh laravel project. Download and install Laravel 9 using the below command

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

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

Setup Database

Now, create a MySQL database and connect it with your 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

Create web routes

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

routes/web.php

<?php

use Illuminate\Support\Facades\Route;

use App\Http\Controllers\HighChartController;

/*
|--------------------------------------------------------------------------
| Web Routes
|--------------------------------------------------------------------------
|
| Here is where you can register web routes for your application. These
| routes are loaded by the RouteServiceProvider within a group which
| contains the "web" middleware group. Now create something great!
|
*/

Route::get('highchart', [HighChartController::class, 'index']);

<?php

use Illuminate\Support\Facades\Route;

use App\Http\Controllers\HighChartController;

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

| Web Routes

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

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

| routes are loaded by the RouteServiceProvider within a group which

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

Route::get('highchart', [HighChartController::class, 'index']);

Create Controller

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

php artisan make:controller HighChartController

1	php artisan make:controller HighChartController

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

app/Http/Controllers/HighChartController.php

<?php
   
namespace App\Http\Controllers;
   
use Illuminate\Http\Request;
use App\Models\User;
   
class HighChartController extends Controller
{
    /**
     * The attributes that are mass assignable.
     *
     * @var array
     */
    public function index()
    {
        $users = User::select(\DB::raw("COUNT(*) as count"))
                    ->whereYear('created_at', date('Y'))
                    ->groupBy(\DB::raw("Month(created_at)"))
                    ->pluck('count');
           
        return view('highchart', compact('users'));
    }
}

<?php

namespace App\Http\Controllers;

use Illuminate\Http\Request;

use App\Models\User;

class HighChartController extends Controller

{

/**

* The attributes that are mass assignable.

* @var array

public function index()

{

$users = User::select(\DB::raw("COUNT(*) as count"))

->whereYear('created_at', date('Y'))

->groupBy(\DB::raw("Month(created_at)"))

->pluck('count');

return view('highchart', compact('users'));

}

Create Blade File

Now, we will create a blade view file. Go to the resources/views/highchart.blade.php and put the below javascript and HTML code for displaying the highchart. So go to the resources/views/ and update the below javascript and HTML code for displaying the highchart:

<!DOCTYPE html>
<html>
<head>
    <title>Laravel 8 Highcharts Example</title>
</head>
    
<body>
<h1>Laravel 8 Highcharts Example</h1>
<div id="container"></div>
</body>
   
<script src="https://code.highcharts.com/highcharts.js"></script>
<script type="text/javascript">
    var users =  <?php echo json_encode($users) ?>;
    
    Highcharts.chart('container', {
        title: {
            text: 'New User Growth, 2019'
        },
        subtitle: {
            text: 'Source: Tutsmake.com'
        },
         xAxis: {
            categories: ['Jan', 'Feb', 'Mar', 'Apr', 'May', 'Jun', 'Jul', 'Aug', 'Sep', 'Oct', 'Nov', 'Dec']
        },
        yAxis: {
            title: {
                text: 'Number of New Users'
            }
        },
        legend: {
            layout: 'vertical',
            align: 'right',
            verticalAlign: 'middle'
        },
        plotOptions: {
            series: {
                allowPointSelect: true
            }
        },
        series: [{
            name: 'New Users',
            data: users
        }],
        responsive: {
            rules: [{
                condition: {
                    maxWidth: 500
                },
                chartOptions: {
                    legend: {
                        layout: 'horizontal',
                        align: 'center',
                        verticalAlign: 'bottom'
                    }
                }
            }]
        }
});
</script>
</html>

<!DOCTYPE html>

<html>

<head>

<title>Laravel 8 Highcharts Example</title>

</head>

<body>

<h1>Laravel 8 Highcharts Example</h1>

</body>

var users = <?php echo json_encode($users) ?>;

Highcharts.chart('container', {

title: {

text: 'New User Growth, 2019'

subtitle: {

text: 'Source: Tutsmake.com'

xAxis: {

categories: ['Jan', 'Feb', 'Mar', 'Apr', 'May', 'Jun', 'Jul', 'Aug', 'Sep', 'Oct', 'Nov', 'Dec']

yAxis: {

title: {

text: 'Number of New Users'

}

legend: {

align: 'right',

verticalAlign: 'middle'

plotOptions: {

series: {

allowPointSelect: true

}

series: [{

data: users

}],

responsive: {

rules: [{

condition: {

maxWidth: 500

chartOptions: {

legend: {

align: 'center',

verticalAlign: 'bottom'

}

}]

}

});

</script>

</html>

Remember to include highchart js libraries on your blade file:

<script src="https://code.highcharts.com/highcharts.js"></script>
<script src="https://code.highcharts.com/modules/exporting.js"></script>
<script src="https://code.highcharts.com/modules/export-data.js"></script>
<script src="https://code.highcharts.com/modules/accessibility.js"></script>

Use below javascript as per requirement :

<script type="text/javascript">
   let chart =  JSON.parse(`<?php echo $chart ?>`);
    
    Highcharts.chart('container', {
        title: {
            text: 'New User Growth, 2019'
        },
        subtitle: {
            text: 'Source: tutsmake.com'
        },
         xAxis: {
            categories: ['Jan', 'Feb', 'Mar', 'Apr', 'May', 'Jun', 'Jul', 'Aug', 'Sep', 'Oct', 'Nov', 'Dec']
        },
        yAxis: {
            title: {
                text: 'Number of New Users'
            }
        },
        legend: {
            layout: 'vertical',
            align: 'right',
            verticalAlign: 'middle'
        },
        plotOptions: {
            series: {
                allowPointSelect: true
            }
        },
        series: [{
            name: 'New Users',
            data: chart
        }],
        responsive: {
            rules: [{
                condition: {
                    maxWidth: 500
                },
                chartOptions: {
                    legend: {
                        layout: 'horizontal',
                        align: 'center',
                        verticalAlign: 'bottom'
                    }
                }
            }]
        }
});
</script>

let chart = JSON.parse(`<?php echo $chart ?>`);

Highcharts.chart('container', {

title: {

text: 'New User Growth, 2019'

subtitle: {

text: 'Source: tutsmake.com'

xAxis: {

categories: ['Jan', 'Feb', 'Mar', 'Apr', 'May', 'Jun', 'Jul', 'Aug', 'Sep', 'Oct', 'Nov', 'Dec']

yAxis: {

title: {

text: 'Number of New Users'

}

legend: {

align: 'right',

verticalAlign: 'middle'

plotOptions: {

series: {

allowPointSelect: true

}

series: [{

data: chart

}],

responsive: {

rules: [{

condition: {

maxWidth: 500

chartOptions: {

legend: {

align: 'center',

verticalAlign: 'bottom'

}

}]

}

});

</script>

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

1	http://127.0.0.1:8000/highchart

Laravel 9 Charts JS Chart Example Tutorial

In this Laravel 9 Charts JS Example Tutorial I will show you how to implement Charts JS in laravel 9 application. In this tutorial you will learn to implement Charts JS in laravel 9. In this example I will demonstrate the use of Charts JS in laravel application. In this example we will create pie chart using a chart js in laravel 9 application.

Laravel 9 Charts JS

ChartJS is easy to use and simple HTML5 based JavaScript charts library. With Chart js we can create animated, interactive graphs in our laravel 9 application.

Laravel 9 Charts JS Example Tutorial

In this step by step tutorial I will demonstrate you to fetch the last 7 days data and display it on pie chart using charts js in laravel. Please follow the instruction given below:

Install Laravel 9
Setup Database Credentials
Create a route
Create Controller
Create Blade View File and Integrate Chart js Library
Start Development Server

Install Laravel 9

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

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

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

Make sure you have composer installed.

Setup Database Credentials

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

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

DB_CONNECTION=mysql

DB_HOST=127.0.0.1

DB_PORT=3306

DB_DATABASE=lara9blog

DB_USERNAME=root

DB_PASSWORD=

Create a route

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

routes/web.php

<?php

use Illuminate\Support\Facades\Route;

use App\Http\Controllers\ChartJSController;

/*
|--------------------------------------------------------------------------
| Web Routes
|--------------------------------------------------------------------------
|
| Here is where you can register web routes for your application. These
| routes are loaded by the RouteServiceProvider within a group which
| contains the "web" middleware group. Now create something great!
|
*/

Route::get('chart-js', [ChartJSController::class, 'index']);

<?php

use Illuminate\Support\Facades\Route;

use App\Http\Controllers\ChartJSController;

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

| Web Routes

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

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

| routes are loaded by the RouteServiceProvider within a group which

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

Route::get('chart-js', [ChartJSController::class, 'index']);

Create Controller

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

php artisan make:controller ChartJSController

1	php artisan make:controller ChartJSController

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

app/Http/Controllers/ChartJSController.php

<?php
   
namespace App\Http\Controllers;
 
use App\Models\User;
use Illuminate\Http\Request;
use Redirect,Response;
Use DB;
use Carbon\Carbon;
 
class ChartJSController extends Controller
{
    /**
     * Display a listing of the resource.
     *
     * @return \Illuminate\Http\Response
     */
    public function index()
    {
 
 $record = User::select(\DB::raw("COUNT(*) as count"), \DB::raw("DAYNAME(created_at) as day_name"), \DB::raw("DAY(created_at) as day"))
    ->where('created_at', '>', Carbon::today()->subDay(6))
    ->groupBy('day_name','day')
    ->orderBy('day')
    ->get();
  
     $data = [];
 
     foreach($record as $row) {
        $data['label'][] = $row->day_name;
        $data['data'][] = (int) $row->count;
      }
 
    $data['chart_data'] = json_encode($data);
    return view('chart-js', $data);
    }
 
}

<?php

namespace App\Http\Controllers;

use App\Models\User;

use Illuminate\Http\Request;

use Redirect,Response;

Use DB;

use Carbon\Carbon;

class ChartJSController extends Controller

{

/**

* Display a listing of the resource.

* @return \Illuminate\Http\Response

public function index()

{

$record = User::select(\DB::raw("COUNT(*) as count"), \DB::raw("DAYNAME(created_at) as day_name"), \DB::raw("DAY(created_at) as day"))

->where('created_at', '>', Carbon::today()->subDay(6))

->groupBy('day_name','day')

->orderBy('day')

->get();

$data = [];

foreach($record as $row) {

$data['label'][] = $row->day_name;

$data['data'][] = (int) $row->count;

}

$data['chart_data'] = json_encode($data);

return view('chart-js', $data);

}

Create Blade View File and Integrate Chart js Library

Now, we will create a blade view file. Go to the resources/views/chart-js.blade.php and put the below javascript and HTML code for displaying the chart. So go to the resources/views/ and update the below javascript and HTML code for displaying the chart using chart js library:

<!DOCTYPE html>
<html>
<head>
  <title>Laravel 9 Chart JS Example Tutorial</title>
  <!-- Latest CSS -->
 <link rel="stylesheet" href="https://stackpath.bootstrapcdn.com/bootstrap/4.3.1/css/bootstrap.min.css">
 <script src="https://cdnjs.cloudflare.com/ajax/libs/Chart.js/2.8.0/Chart.js"></script>
 <script src="https://code.jquery.com/jquery-3.3.1.min.js"></script> 
</head>
<body>
  <div class="chart-container">
    <div class="pie-chart-container">
      <canvas id="pie-chart"></canvas>
    </div>
  </div>
 
  <!-- javascript -->
 
   <script>
  $(function(){
      //get the pie chart canvas
      var cData = JSON.parse(`<?php echo $chart_data; ?>`);
      var ctx = $("#pie-chart");
 
      //pie chart data
      var data = {
        labels: cData.label,
        datasets: [
          {
            label: "Users Count",
            data: cData.data,
            backgroundColor: [
              "#DEB887",
              "#A9A9A9",
              "#DC143C",
              "#F4A460",
              "#2E8B57",
              "#1D7A46",
              "#CDA776",
            ],
            borderColor: [
              "#CDA776",
              "#989898",
              "#CB252B",
              "#E39371",
              "#1D7A46",
              "#F4A460",
              "#CDA776",
            ],
            borderWidth: [1, 1, 1, 1, 1,1,1]
          }
        ]
      };
 
      //options
      var options = {
        responsive: true,
        title: {
          display: true,
          position: "top",
          text: "Last Week Registered Users -  Day Wise Count",
          fontSize: 18,
          fontColor: "#111"
        },
        legend: {
          display: true,
          position: "bottom",
          labels: {
            fontColor: "#333",
            fontSize: 16
          }
        }
      };
 
      //create Pie Chart class object
      var chart1 = new Chart(ctx, {
        type: "pie",
        data: data,
        options: options
      });
 
  });
</script>
</body>
</html>

<!DOCTYPE html>

<html>

<head>

<title>Laravel 9 Chart JS Example Tutorial</title>

</head>

<body>

</div>

$(function(){

//get the pie chart canvas

var cData = JSON.parse(`<?php echo $chart_data; ?>`);

var ctx = $("#pie-chart");

//pie chart data

var data = {

labels: cData.label,

datasets: [

{

label: "Users Count",

data: cData.data,

backgroundColor: [

"#DEB887",

"#A9A9A9",

"#DC143C",

"#F4A460",

"#2E8B57",

"#1D7A46",

"#CDA776",

borderColor: [

"#CDA776",

"#989898",

"#CB252B",

"#E39371",

"#1D7A46",

"#F4A460",

"#CDA776",

borderWidth: [1, 1, 1, 1, 1,1,1]

}

]

};

//options

var options = {

responsive: true,

title: {

display: true,

position: "top",

text: "Last Week Registered Users - Day Wise Count",

fontSize: 18,

fontColor: "#111"

legend: {

display: true,

position: "bottom",

labels: {

fontColor: "#333",

fontSize: 16

}

};

//create Pie Chart class object

var chart1 = new Chart(ctx, {

type: "pie",

data: data,

options: options

});

</script>

</body>

</html>

Remember to include highchart js libraries on your blade file:

<link rel="stylesheet" href="https://stackpath.bootstrapcdn.com/bootstrap/4.3.1/css/bootstrap.min.css">
 <script src="https://cdnjs.cloudflare.com/ajax/libs/Chart.js/2.8.0/Chart.js"></script>
 <script src="https://code.jquery.com/jquery-3.3.1.min.js"></script>

Use below javascript as per requirement :

  <script>
  $(function(){
      //get the pie chart canvas
      var cData = JSON.parse(`<?php echo $chart_data; ?>`);
      var ctx = $("#pie-chart");
 
      //pie chart data
      var data = {
        labels: cData.label,
        datasets: [
          {
            label: "Users Count",
            data: cData.data,
            backgroundColor: [
              "#DEB887",
              "#A9A9A9",
              "#DC143C",
              "#F4A460",
              "#2E8B57",
              "#1D7A46",
              "#CDA776",
            ],
            borderColor: [
              "#CDA776",
              "#989898",
              "#CB252B",
              "#E39371",
              "#1D7A46",
              "#F4A460",
              "#CDA776",
            ],
            borderWidth: [1, 1, 1, 1, 1,1,1]
          }
        ]
      };
 
      //options
      var options = {
        responsive: true,
        title: {
          display: true,
          position: "top",
          text: "Last Week Registered Users -  Day Wise Count",
          fontSize: 18,
          fontColor: "#111"
        },
        legend: {
          display: true,
          position: "bottom",
          labels: {
            fontColor: "#333",
            fontSize: 16
          }
        }
      };
 
      //create Pie Chart class object
      var chart1 = new Chart(ctx, {
        type: "pie",
        data: data,
        options: options
      });
 
  });
</script>

$(function(){

//get the pie chart canvas

var cData = JSON.parse(`<?php echo $chart_data; ?>`);

var ctx = $("#pie-chart");

//pie chart data

var data = {

labels: cData.label,

datasets: [

{

label: "Users Count",

data: cData.data,

backgroundColor: [

"#DEB887",

"#A9A9A9",

"#DC143C",

"#F4A460",

"#2E8B57",

"#1D7A46",

"#CDA776",

borderColor: [

"#CDA776",

"#989898",

"#CB252B",

"#E39371",

"#1D7A46",

"#F4A460",

"#CDA776",

borderWidth: [1, 1, 1, 1, 1,1,1]

}

]

};

//options

var options = {

responsive: true,

title: {

display: true,

position: "top",

text: "Last Week Registered Users - Day Wise Count",

fontSize: 18,

fontColor: "#111"

legend: {

display: true,

position: "bottom",

labels: {

fontColor: "#333",

fontSize: 16

}

};

//create Pie Chart class object

var chart1 = new Chart(ctx, {

type: "pie",

data: data,

options: options

});

</script>

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

1	http://127.0.0.1:8000/chart-js

Laravel 9 Create JSON File Download From Text

In this Laravel 9 Create JSON File and Download From Text tutorial I will show you how to convert form data to JSON and download json file. I will also show you how to convert and insert json format data into MySQL database. In this tutorial you will learn convert form data or text file data into json format and to save text file data from JSON data into MySQL database and download data from mysql database.

Laravel 9 Create JSON File & Download From Text

In this step by step tutorial I will guide you through how to save form or text data into database with json format and to download in laravel 9 application. Please follow the instruction given below:

Install Laravel 9
Setup Database
Generate migration and model
Migrate Database
Add Route
Create controller
Create blade view
Start Development Server

Install Laravel 9

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

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

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

Setup Database

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

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

DB_CONNECTION=mysql

DB_HOST=127.0.0.1

DB_PORT=3306

DB_DATABASE=here your database name here

DB_USERNAME=here database username here

DB_PASSWORD=here database password here

Migrate Database

Before you run php artisan migrate command go to app/providers/AppServiceProvider.php and update the below code into AppServiceProvider.php file:

 use Illuminate\Support\Facades\Schema;

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

use Illuminate\Support\Facades\Schema;

function boot()

{

Schema::defaultStringLength(191);

}

Generate migration and model

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

php artisan make:model Test -m

1	php artisan make:model Test -m

The above command will create a model and migration file. Go to app/database/migration and find the migration file name create_tests_table.php and update the following code into it:

public function up()
 {
     Schema::create('tests', function (Blueprint $table) {
         $table->increments('id');
         $table->string('token')->nullable();
         $table->text('data')->nullable();
         $table->timestamps();
     });
 }

public function up()

{

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

$table->increments('id');

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

$table->text('data')->nullable();

$table->timestamps();

});

}

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

php artisan migrate

1	php artisan migrate

Add Route

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

routes/web.php

use App\Http\Controllers\JsonController;
 
 
Route::get('laravel-json', [JsonController::class, 'index']);
Route::post('json-file-download', [JsonController::class, 'download']);

use App\Http\Controllers\JsonController;

Route::get('laravel-json', [JsonController::class, 'index']);

Route::post('json-file-download', [JsonController::class, 'download']);

Create Controller

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

php artisan make:controller JsonController

1	php artisan make:controller JsonController

Now, go to app/http/controllers open JsonController and create two method. The first method is to display the form and second method convert form data to json format and save it to database:

<?php
 
namespace App\Http\Controllers;
use Redirect,Response;
use Illuminate\Http\Request;
use App\Models\Test;
 
class JsonController extends Controller
{
   public function index()
   {
      return view('json_form');
   }  
 
  public function download(Request $request)
  {
      $data = $request->only('name','email','mobile_number');
      $test['token'] = time();
      $test['data'] = json_encode($data);
      Test::insert($test);
      $fileName = $test['token']. '_datafile.json';
      File::put(public_path('/upload/json/'.$fileName),$test);
      return download(public_path('/upload/jsonfile/'.$fileName));
  }
 
}

<?php

namespace App\Http\Controllers;

use Redirect,Response;

use Illuminate\Http\Request;

use App\Models\Test;

class JsonController extends Controller

{

public function index()

{

return view('json_form');

}

public function download(Request $request)

{

$data = $request->only('name','email','mobile_number');

$test['token'] = time();

$test['data'] = json_encode($data);

Test::insert($test);

$fileName = $test['token']. '_datafile.json';

File::put(public_path('/upload/json/'.$fileName),$test);

return download(public_path('/upload/jsonfile/'.$fileName));

}

Create Blade view

In this step we will create blade view file. Now, create a blade view name json_form.blade.php in resources/views directory. Put the below code here :

<!doctype html>
<html lang="en">
  <head>
  <meta charset="utf-8">
  <meta name="viewport" content="width=device-width, initial-scale=1, shrink-to-fit=no">
  <meta name="csrf-token" content="{{ csrf_token() }}">
  <title>Laravel Store Data To Json Format In Database</title>
  <link rel="stylesheet" href="https://cdnjs.cloudflare.com/ajax/libs/twitter-bootstrap/4.1.3/css/bootstrap.min.css" />
  <style>
   .error{ color:red; } 
  </style>
</head>
 
<body>
 
<div class="container">
    <h2 style="margin-top: 10px;">Laravel Store Data To Json Format In Database</h2>
    <br>
    <br>
 
    @if ($message = Session::get('success'))
    <div class="alert alert-success alert-block">
        <button type="button" class="close" data-dismiss="alert">×</button>
          <strong>{{ $message }}</strong>
    </div>
    <br>
    @endif
   
    <form id="laravel_json" method="post" action="{{url('json-file-download')}}">
      @csrf
      <div class="form-group">
        <label for="formGroupExampleInput">Name</label>
        <input type="text" name="name" class="form-control" id="formGroupExampleInput" placeholder="Please enter name">
      </div>
      <div class="form-group">
        <label for="email">Email Id</label>
        <input type="text" name="email" class="form-control" id="email" placeholder="Please enter email id">
      </div>      
      <div class="form-group">
        <label for="mobile_number">Mobile Number</label>
        <input type="text" name="mobile_number" class="form-control" id="mobile_number" placeholder="Please enter mobile number">
      </div>
      <div class="form-group">
       <button type="submit" class="btn btn-success">Submit</button>
      </div>
    </form>
 
</div>
 
</body>
</html>

<!doctype html>

<head>

<title>Laravel Store Data To Json Format In Database</title>

<style>

.error{ color:red; }

</style>

</head>

<body>

<h2 style="margin-top: 10px;">Laravel Store Data To Json Format In Database</h2>

<br>

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

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

</div>

<br>

@endif

@csrf

</div>

<label for="email">Email Id</label>

</div>

<label for="mobile_number">Mobile Number</label>

</div>

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

</div>

</form>

</div>

</body>

</html>

Start Development Server

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

php artisan serve

1	php artisan serve

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

 http://localhost:8000/

1	http://localhost:8000/

Laravel 9 Store JSON Format Data to Database

In this Laravel 9 Store JSON Format Data to Database tutorial I will show you how to store/insert json form data into mysql database. I will also show you how to convert and insert json format data into MySQL database. In this tutorial you will learn convert form data into json format and to save data from JSON data into MySQL database.

Laravel 9 Store JSON Format Data to Database

In this step by step tutorial you will learn how to store JSON format data into MySQL database in laravel 9 application. Please follow the instruction given below:

Install Laravel 9
Setup Database
Generate migration and model
Migrate Database
Add Route
Create controller
Create blade view
Start Development Server

Install Laravel 9

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

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

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

Setup Database

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

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

DB_CONNECTION=mysql

DB_HOST=127.0.0.1

DB_PORT=3306

DB_DATABASE=here your database name here

DB_USERNAME=here database username here

DB_PASSWORD=here database password here

Migrate Database

Run the migration to create database table using following artisan command:

php artisan migrate

1	php artisan migrate

Generate migration and model

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

php artisan make:model Test -m

1	php artisan make:model Test -m

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

public function up()
 {
     Schema::create('tests', function (Blueprint $table) {
         $table->increments('id');
         $table->string('token')->nullable();
         $table->text('data')->nullable();
         $table->timestamps();
     });
 }

public function up()

{

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

$table->increments('id');

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

$table->text('data')->nullable();

$table->timestamps();

});

}

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

php artisan migrate

1	php artisan migrate

Add Route

In this step, we will create two routes in the web.php file. One to display form and the second route is to store data in JSON to MySQL database. Open app/routes/web.php file and put the following routes in it:

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

<?php

use Illuminate\Support\Facades\Route;

use App\Http\Controllers\JsonController;

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

| Web Routes

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

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

| routes are loaded by the RouteServiceProvider within a group which

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

Route::get('laravel-json', [JsonController::class, 'index']);

Route::post('store-json', [JsonController::class, 'store']);

Create controller

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

php artisan make:controller JsonController

1	php artisan make:controller JsonController

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

app/Http/Controllers/JsonController.php

<?php
 
namespace App\Http\Controllers;
use Redirect,Response;
use Illuminate\Http\Request;
use App\Models\Test;
 
class JsonController extends Controller
{
   public function index()
   {
      return view('json_form');
   }  
 
  public function store(Request $request)
  {
      $data = $request->only('name','email','mobile_number');
      $test['token'] = time();
      $test['data'] = json_encode($data);
      Test::insert($test);
      return Redirect::to("laravel-json")->withSuccess('Great! Successfully store data in json format in datbase');
  }
 
}

<?php

namespace App\Http\Controllers;

use Redirect,Response;

use Illuminate\Http\Request;

use App\Models\Test;

class JsonController extends Controller

{

public function index()

{

return view('json_form');

}

public function store(Request $request)

{

$data = $request->only('name','email','mobile_number');

$test['token'] = time();

$test['data'] = json_encode($data);

Test::insert($test);

return Redirect::to("laravel-json")->withSuccess('Great! Successfully store data in json format in datbase');

}

Create blade view

In this step, we will create a blade view name json.blade.php. Go to resources/views and create one blade view file.

json.blade.php

<!doctype html>
<html lang="en">
  <head>
  <meta charset="utf-8">
  <meta name="viewport" content="width=device-width, initial-scale=1, shrink-to-fit=no">
  <meta name="csrf-token" content="{{ csrf_token() }}">
  <title>Laravel Store Data To Json Format In Database</title>
  <link rel="stylesheet" href="https://cdnjs.cloudflare.com/ajax/libs/twitter-bootstrap/4.1.3/css/bootstrap.min.css" />
  <style>
   .error{ color:red; } 
  </style>
</head>
 
<body>
 
<div class="container">
    <h2 style="margin-top: 10px;">Laravel Store Data To Json Format In Database</h2>
    <br>
    <br>
 
    @if ($message = Session::get('success'))
    <div class="alert alert-success alert-block">
        <button type="button" class="close" data-dismiss="alert">×</button>
          <strong>{{ $message }}</strong>
    </div>
    <br>
    @endif
   
    <form id="laravel_json" method="post" action="{{url('store-json')}}">
      @csrf
      <div class="form-group">
        <label for="formGroupExampleInput">Name</label>
        <input type="text" name="name" class="form-control" id="formGroupExampleInput" placeholder="Please enter name">
      </div>
      <div class="form-group">
        <label for="email">Email Id</label>
        <input type="text" name="email" class="form-control" id="email" placeholder="Please enter email id">
      </div>      
      <div class="form-group">
        <label for="mobile_number">Mobile Number</label>
        <input type="text" name="mobile_number" class="form-control" id="mobile_number" placeholder="Please enter mobile number">
      </div>
      <div class="form-group">
       <button type="submit" class="btn btn-success">Submit</button>
      </div>
    </form>
 
</div>
 
</body>
</html>

<!doctype html>

<head>

<title>Laravel Store Data To Json Format In Database</title>

<style>

.error{ color:red; }

</style>

</head>

<body>

<h2 style="margin-top: 10px;">Laravel Store Data To Json Format In Database</h2>

<br>

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

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

</div>

<br>

@endif

@csrf

</div>

<label for="email">Email Id</label>

</div>

<label for="mobile_number">Mobile Number</label>

</div>

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

</div>

</form>

</div>

</body>

</html>

Start Development Server

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

php artisan serve

1	php artisan serve

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

http://localhost:8000/laravel-json

1	http://localhost:8000/laravel-json

Laravel 9 Get Current User Location From IP

In this Laravel 9 Get Current User Location From IP tutorial I will show you how to get user location information using user IP address in laravel 9. In this tutorial you will learn to get country name, country code, city name, and address from user IP address in laravel 9. When you working on web development project you come to situation where you may want to fetch user information such as country Name, country Code, region Code, region Name, city Name, zip Code, iso Code, postal Code, latitude, longitude, metro Code, metro Code from ip address in laravel 8. In this example I will help you to fetch user info from IP their ip address. We will be using stevebauman/location package in this example to fetch country name, country code, city name, and address from IP address.

How to Get Current User Location in Laravel 9

In this tutorial you will learn how to get current user location with ip address using stevebauman location package. The stevebauman/location laravel package is used to get users location data by their IP Address. This helps in retrieving user’s location information from IP address. The location library helps in retrieving following location information:

Country name and code
Region name and code
City name
Zipcode
ISO code
Postal code
Latitude and longitude
Metro code

Laravel 9 Get Current User Location From IP

Install Laravel 9
Connecting App to Database
Install stevebauman/location Package
Create Route
Create Controller By Artisan Command
Create Blade View
Run Development Server

Install Laravel 9

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

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

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

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=database-name
DB_USERNAME=database-user-name
DB_PASSWORD=database-password

DB_CONNECTION=mysql

DB_HOST=127.0.0.1

DB_PORT=3306

DB_DATABASE=database-name

DB_USERNAME=database-user-name

DB_PASSWORD=database-password

Install stevebauman/location Package

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

composer require stevebauman/location

1	composer require stevebauman/location

Then, Go to config directory and open app.php file. And register this package into laravel 8 app by adding the following code into your app.php file:

'providers' => [
 
    ....
 
    Stevebauman\Location\LocationServiceProvider::class,
 
],
 
'aliases' => [
 
    ....
 
    'Location' => 'Stevebauman\Location\Facades\Location',
 
]

'providers' => [

....

Stevebauman\Location\LocationServiceProvider::class,

'aliases' => [

....

'Location' => 'Stevebauman\Location\Facades\Location',

]

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

<?php

use Illuminate\Support\Facades\Route;

use App\Http\Controllers\UserController;

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

| Web Routes

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

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

| routes are loaded by the RouteServiceProvider within a group which

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

Route::get('display-user', [UserController::class, 'index']);

Create Controller By Artisan Command

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 put the following code into your UserController.php file:

<?php
   
namespace App\Http\Controllers;
   
use Illuminate\Http\Request;
use Stevebauman\Location\Facades\Location;
   
class UserController extends Controller
{
    /**
     * Display a listing of the resource.
     *
     * @return \Illuminate\Http\Response
     */
    public function index(Request $request)
    {
        /* $ip = $request->ip(); Dynamic IP address */
        $ip = '162.159.24.227'; /* Static IP address */
        $currentUserInfo = Location::get($ip);
           
        return view('user', compact('currentUserInfo'));
    }
}

<?php

namespace App\Http\Controllers;

use Illuminate\Http\Request;

use Stevebauman\Location\Facades\Location;

class UserController extends Controller

{

/**

* Display a listing of the resource.

* @return \Illuminate\Http\Response

public function index(Request $request)

{

/* $ip = $request->ip(); Dynamic IP address */

$ip = '162.159.24.227'; /* Static IP address */

$currentUserInfo = Location::get($ip);

return view('user', compact('currentUserInfo'));

}

Create Blade View

In this step we will create blade view file. Go to resources/views directory and create user.blade.php. Then add the following code into it:

<!DOCTYPE html>
<html>
<head>
    <meta charset="utf-8">
    <title></title>
    <link href="https://cdn.jsdelivr.net/npm/bootstrap@5.0.2/dist/css/bootstrap.min.css" rel="stylesheet">
</head>
<body>
   
<div class="container">
    <h1>How to Get Current User Location with Laravel</h1>
    <div class="card">
        <div class="card-body">
            @if($currentUserInfo)
                <h4>IP: {{ $currentUserInfo->ip }}</h4>
                <h4>Country Name: {{ $currentUserInfo->countryName }}</h4>
                <h4>Country Code: {{ $currentUserInfo->countryCode }}</h4>
                <h4>Region Code: {{ $currentUserInfo->regionCode }}</h4>
                <h4>Region Name: {{ $currentUserInfo->regionName }}</h4>
                <h4>City Name: {{ $currentUserInfo->cityName }}</h4>
                <h4>Zip Code: {{ $currentUserInfo->zipCode }}</h4>
                <h4>Latitude: {{ $currentUserInfo->latitude }}</h4>
                <h4>Longitude: {{ $currentUserInfo->longitude }}</h4>
            @endif
        </div>
    </div>
</div>
   
</body>
</html>

<!DOCTYPE html>

<html>

<head>

</head>

<body>

<h1>How to Get Current User Location with Laravel</h1>

@if($currentUserInfo)

<h4>IP: {{ $currentUserInfo->ip }}</h4>

<h4>Country Name: {{ $currentUserInfo->countryName }}</h4>

<h4>Country Code: {{ $currentUserInfo->countryCode }}</h4>

<h4>Region Code: {{ $currentUserInfo->regionCode }}</h4>

<h4>Region Name: {{ $currentUserInfo->regionName }}</h4>

<h4>City Name: {{ $currentUserInfo->cityName }}</h4>

<h4>Zip Code: {{ $currentUserInfo->zipCode }}</h4>

<h4>Latitude: {{ $currentUserInfo->latitude }}</h4>

<h4>Longitude: {{ $currentUserInfo->longitude }}</h4>

@endif

</div>

</body>

</html>

Run Development Server

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

php artisan serve

1	php artisan serve

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

http://127.0.0.1:8000/display-user

1	http://127.0.0.1:8000/display-user

Laravel 9 Socialite Login with Linkedin Example

In this Laravel 9 Login with Linkedin Example Tutorial I’ll show you how to integrate socialite LinkedIn social login in laravel 9 application. In this tutorial you will learn to integrate LinkedIn login in laravel. In this article we will integrate login with LinkedIn in laravel 9 application.

As we all know that users are not much interested in filling up long registration form to register with any application. Allowing users to login with their social media accounts is quick and powerful way to get registered/verified users for your laravel application. Allowing users to login with their social media accounts makes registration/login process much easier, it also encourages more users to register for your application. In this step by step tutorial, you will learn to integrate linkedin login with your laravel 9 application.

This tutorial is step by step guide for you on how to integrate linkedin social login in laravel 9 using socialite package.

Step 1:- create linkedin app by click the following url :- https://www.linkedin.com/developers/apps/new . And create linkedin app.

Step 2:- After successfully create the app set the redirect URL for example :

Step 3:- Finally, you redirect to dashboard by linkedin.com. So you can copy client id and secret from linkedin app dashboard.

Install Laravel 9
Connecting App to Database
Configure the Linkedin App
Install Socialite & Configure
Add Field In Table Using Migration
Install Jetstream Auth
Make Routes
Create Linkedin Login Controller By Command
Integrate Linkedin Login Button In Login Page
Start Development Server

Install Laravel 9

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

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

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

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

Configure Linkedin App

In this step, we will create linkedin app for client and secret key, go to following link

https://www.linkedin.com/developers/apps/new

1	https://www.linkedin.com/developers/apps/new

Now create linkedin app filling the details and create your linkedin app. After creating the app set the redirect URL. Now, copy the client id and secret from linkedin app dashboard.Now, configure Linkedin app with this laravel app. So, open your laravel Linkedin social login project in any text editor. Then navigate the config directory and open service.php file and add the client id, secret and callback url:

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

'linkedin' => [

'client_id' => 'xxxx',

'client_secret' => 'xxx',

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

Install Socialite & Configure

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

composer require laravel/socialite

1	composer require laravel/socialite

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

config/app.php

'providers' => [
    /*
     * Package Service Providers...
     */
    Laravel\Socialite\SocialiteServiceProvider::class,
]

'providers' => [

* Package Service Providers...

Laravel\Socialite\SocialiteServiceProvider::class,

]

Then add the Facade in config/app.php:

'aliases' => [
    ...
    'Socialite' => Laravel\Socialite\Facades\Socialite::class,
]

'aliases' => [

...

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

]

Add Field In Table Using Migration

Now, we will create a migration file to add social login fields using following command:

php artisan make:migration add_social_login_field

1	php artisan make:migration add_social_login_field

Now, open the add_social_login_field.php file, which is found inside database/migration directory and add the following code into it:

<?php
   
use Illuminate\Support\Facades\Schema;
use Illuminate\Database\Schema\Blueprint;
use Illuminate\Database\Migrations\Migration;
    
class AddSoicalLoginField extends Migration
{
    /**
     * Run the migrations.
     *
     * @return void
     */
    public function up()
    {
        Schema::table('users', function ($table) {
            $table->string('social_id')->nullable();
            $table->string('social_type')->nullable();
        });
    }
    
    /**
     * Reverse the migrations.
     *
     * @return void
     */
    public function down()
    {
        Schema::table('users', function ($table) {
            $table->dropColumn('social_id');
           $table->dropColumn('social_type');
         });
    }
}

<?php

use Illuminate\Support\Facades\Schema;

use Illuminate\Database\Schema\Blueprint;

use Illuminate\Database\Migrations\Migration;

class AddSoicalLoginField extends Migration

{

/**

* Run the migrations.

* @return void

public function up()

{

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

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

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

});

}

/**

* Reverse the migrations.

* @return void

public function down()

{

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

$table->dropColumn('social_id');

$table->dropColumn('social_type');

});

}

After successfully add field in database table. Then add fillable property in User.php model, which is found inside app/Models/ directory:

<?php
 
namespace App\Models;
 
use Illuminate\Contracts\Auth\MustVerifyEmail;
use Illuminate\Database\Eloquent\Factories\HasFactory;
use Illuminate\Foundation\Auth\User as Authenticatable;
use Illuminate\Notifications\Notifiable;
use Laravel\Fortify\TwoFactorAuthenticatable;
use Laravel\Jetstream\HasProfilePhoto;
use Laravel\Sanctum\HasApiTokens;
 
class User extends Authenticatable
{
    use HasApiTokens;
    use HasFactory;
    use HasProfilePhoto;
    use Notifiable;
    use TwoFactorAuthenticatable;
 
    /**
     * The attributes that are mass assignable.
     *
     * @var array
     */
    protected $fillable = [
        'name',
        'email',
        'password',
        'social_id',
        'social_type'
    ];
 
    /**
     * The attributes that should be hidden for arrays.
     *
     * @var array
     */
    protected $hidden = [
        'password',
        'remember_token',
        'two_factor_recovery_codes',
        'two_factor_secret',
    ];
 
    /**
     * The attributes that should be cast to native types.
     *
     * @var array
     */
    protected $casts = [
        'email_verified_at' => 'datetime',
    ];
 
    /**
     * The accessors to append to the model's array form.
     *
     * @var array
     */
    protected $appends = [
        'profile_photo_url',
    ];
}

<?php

namespace App\Models;

use Illuminate\Contracts\Auth\MustVerifyEmail;

use Illuminate\Database\Eloquent\Factories\HasFactory;

use Illuminate\Foundation\Auth\User as Authenticatable;

use Illuminate\Notifications\Notifiable;

use Laravel\Fortify\TwoFactorAuthenticatable;

use Laravel\Jetstream\HasProfilePhoto;

use Laravel\Sanctum\HasApiTokens;

class User extends Authenticatable

{

use HasApiTokens;

use HasFactory;

use HasProfilePhoto;

use Notifiable;

use TwoFactorAuthenticatable;

/**

* The attributes that are mass assignable.

* @var array

protected $fillable = [

'name',

'email',

'password',

'social_id',

'social_type'

];

/**

* The attributes that should be hidden for arrays.

* @var array

protected $hidden = [

'password',

'remember_token',

'two_factor_recovery_codes',

'two_factor_secret',

];

/**

* The attributes that should be cast to native types.

* @var array

protected $casts = [

'email_verified_at' => 'datetime',

];

/**

* The accessors to append to the model's array form.

* @var array

protected $appends = [

'profile_photo_url',

];

}

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

php artisan migrate

1	php artisan migrate

Install Jetstream Auth

In this step, install jetstream laravel auth scaffolding package with livewire. We have provided a complete guide in this Laravel 9 Auth Scaffolding using Jetstream Tutorial.

Make Routes

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

routes/web.php

use Illuminate\Support\Facades\Route;
use App\Http\Controllers\Auth\LinkedinSocialiteController;
 
 
Route::get('auth/linkedin', [LinkedinSocialiteController::class, 'redirectToLinkedin']);
Route::get('callback/linkedin', [LinkedinSocialiteController::class, 'handleCallback']);

use Illuminate\Support\Facades\Route;

use App\Http\Controllers\Auth\LinkedinSocialiteController;

Route::get('auth/linkedin', [LinkedinSocialiteController::class, 'redirectToLinkedin']);

Route::get('callback/linkedin', [LinkedinSocialiteController::class, 'handleCallback']);

In this step, run the following command to create LinkedinSocialiteController.php file:

php artisan make:controller LinkedinSocialiteController

1	php artisan make:controller LinkedinSocialiteController

Now, go to app/http/controllers directory and open LinkedinSocialiteController.php file in any text editor. Then add the following code into LinkedinSocialiteController.php file:

<?php
   
namespace App\Http\Controllers\Auth;
   
use App\Http\Controllers\Controller;
use Socialite;
use Auth;
use Exception;
use App\Models\User;
   
class LinkedinSocialiteController extends Controller
{
    /**
     * Create a new controller instance.
     *
     * @return void
     */
    public function redirectToLinkedin()
    {
        return Socialite::driver('linkedin')->redirect();
    }
       
    /**
     * Create a new controller instance.
     *
     * @return void
     */
    public function handleCallback()
    {
        try {
     
            $user = Socialite::driver('linkedin')->user();
      
            $finduser = User::where('social_id', $user->id)->first();
      
            if($finduser){
      
                Auth::login($finduser);
     
                return redirect('/home');
      
            }else{
                $newUser = User::create([
                    'name' => $user->name,
                    'email' => $user->email,
                    'social_id'=> $user->id,
                    'social_type'=> 'linkedin',
                    'password' => encrypt('my-linkedin')
                ]);
     
                Auth::login($newUser);
      
                return redirect('/home');
            }
     
        } catch (Exception $e) {
            dd($e->getMessage());
        }
    }
}

<?php

namespace App\Http\Controllers\Auth;

use App\Http\Controllers\Controller;

use Socialite;

use Auth;

use Exception;

use App\Models\User;

class LinkedinSocialiteController extends Controller

{

/**

* Create a new controller instance.

* @return void

public function redirectToLinkedin()

{

return Socialite::driver('linkedin')->redirect();

}

/**

* Create a new controller instance.

* @return void

public function handleCallback()

{

try {

$user = Socialite::driver('linkedin')->user();

$finduser = User::where('social_id', $user->id)->first();

if($finduser){

Auth::login($finduser);

return redirect('/home');

}else{

$newUser = User::create([

'name' => $user->name,

'email' => $user->email,

'social_id'=> $user->id,

'social_type'=> 'linkedin',

'password' => encrypt('my-linkedin')

]);

Auth::login($newUser);

return redirect('/home');

}

} catch (Exception $e) {

dd($e->getMessage());

}

In this step, integrate linkedin login button into login.blade.php file. So, open login.blade.php, which is found inside resources/views/auth/ directory:

<x-guest-layout>
    <x-jet-authentication-card>
        <x-slot name="logo">
            <x-jet-authentication-card-logo />
        </x-slot>
 
        <x-jet-validation-errors class="mb-4" />
 
        @if (session('status'))
            <div class="mb-4 font-medium text-sm text-green-600">
                {{ session('status') }}
            </div>
        @endif
 
        <form method="POST" action="{{ route('login') }}">
            @csrf
 
            <div>
                <x-jet-label value="{{ __('Email') }}" />
                <x-jet-input class="block mt-1 w-full" type="email" name="email" :value="old('email')" required autofocus />
            </div>
 
            <div class="mt-4">
                <x-jet-label value="{{ __('Password') }}" />
                <x-jet-input class="block mt-1 w-full" type="password" name="password" required autocomplete="current-password" />
            </div>
 
            <div class="block mt-4">
                <label class="flex items-center">
                    <input type="checkbox" class="form-checkbox" name="remember">
                    <span class="ml-2 text-sm text-gray-600">{{ __('Remember me') }}</span>
                </label>
            </div>
 
            <div class="flex items-center justify-end mt-4">
                @if (Route::has('password.request'))
                    <a class="underline text-sm text-gray-600 hover:text-gray-900" href="{{ route('password.request') }}">
                        {{ __('Forgot your password?') }}
                    </a>
                @endif
 
                <x-jet-button class="ml-4">
                    {{ __('Login') }}
                </x-jet-button>
 
                <a href="{{ url('auth/linkedin') }}" style="margin-top: 0px !important;background: green;color: #ffffff;padding: 5px;border-radius:7px;" class="ml-2">
                  <strong>Linkedin Login</strong>
                </a> 
            </div>
        </form>
    </x-jet-authentication-card>
</x-guest-layout>

<x-guest-layout>

<x-jet-authentication-card>

<x-slot name="logo">

<x-jet-authentication-card-logo />

</x-slot>

<x-jet-validation-errors class="mb-4" />

@if (session('status'))

</div>

@endif

@csrf

<div>

<x-jet-label value="{{ __('Email') }}" />

<x-jet-input class="block mt-1 w-full" type="email" name="email" :value="old('email')" required autofocus />

</div>

<x-jet-label value="{{ __('Password') }}" />

<x-jet-input class="block mt-1 w-full" type="password" name="password" required autocomplete="current-password" />

</div>

<span class="ml-2 text-sm text-gray-600">{{ __('Remember me') }}</span>

</label>

</div>

@if (Route::has('password.request'))

</a>

@endif

<x-jet-button class="ml-4">

</x-jet-button>

<strong>Linkedin Login</strong>

</a>

</div>

</form>

</x-jet-authentication-card>

</x-guest-layout>

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

1	http://127.0.0.1:8000

Laravel 9 Socialite Login with Github Example Tutorial

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

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

Install Laravel 9
Configure Database With App
Configure Github App
Install Socialite & Configure
Add Field In Table Using Migration
Install Jetstream Auth
Make Routes
Create Controller By Command
Implement Github Login In Login Page
Start Development Server

Install Laravel 9

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

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

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

Configure Database With App

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

Configure Github App

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

https://github.com/settings/developers

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

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

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

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

'github' => [

'client_id' => 'xxxx',

'client_secret' => 'xxx',

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

Install Socialite & Configure

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

composer require laravel/socialite

1	composer require laravel/socialite

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

config/app.php

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

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

'providers' => [

// Other service providers…

Laravel\Socialite\SocialiteServiceProvider::class,

'aliases' => [

// Other aliases…

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

Add Field In Table Using Migration

In this step we will create migration to add some fields using following command:

php artisan make:migration add_social_login_field

1	php artisan make:migration add_social_login_field

After that, open the add_social_login_field.php file, which is found inside database/migration directory and add the following code into it:

<?php
   
use Illuminate\Support\Facades\Schema;
use Illuminate\Database\Schema\Blueprint;
use Illuminate\Database\Migrations\Migration;
    
class AddSoicalLoginField extends Migration
{
    /**
     * Run the migrations.
     *
     * @return void
     */
    public function up()
    {
        Schema::table('users', function ($table) {
            $table->string('social_id')->nullable();
            $table->string('social_type')->nullable();
        });
    }
    
    /**
     * Reverse the migrations.
     *
     * @return void
     */
    public function down()
    {
        Schema::table('users', function ($table) {
            $table->dropColumn('social_id');
           $table->dropColumn('social_type');
         });
    }
}

<?php

use Illuminate\Support\Facades\Schema;

use Illuminate\Database\Schema\Blueprint;

use Illuminate\Database\Migrations\Migration;

class AddSoicalLoginField extends Migration

{

/**

* Run the migrations.

* @return void

public function up()

{

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

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

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

});

}

/**

* Reverse the migrations.

* @return void

public function down()

{

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

$table->dropColumn('social_id');

$table->dropColumn('social_type');

});

}

After successfully add field in database table. Then add fillable property in User.php model, which is found inside app/Models/ directory:

<?php
 
namespace App\Models;
 
use Illuminate\Contracts\Auth\MustVerifyEmail;
use Illuminate\Database\Eloquent\Factories\HasFactory;
use Illuminate\Foundation\Auth\User as Authenticatable;
use Illuminate\Notifications\Notifiable;
use Laravel\Fortify\TwoFactorAuthenticatable;
use Laravel\Jetstream\HasProfilePhoto;
use Laravel\Sanctum\HasApiTokens;
 
class User extends Authenticatable
{
    use HasApiTokens;
    use HasFactory;
    use HasProfilePhoto;
    use Notifiable;
    use TwoFactorAuthenticatable;
 
    /**
     * The attributes that are mass assignable.
     *
     * @var array
     */
    protected $fillable = [
        'name',
        'email',
        'password',
        'social_id',
        'social_type'
    ];
 
    /**
     * The attributes that should be hidden for arrays.
     *
     * @var array
     */
    protected $hidden = [
        'password',
        'remember_token',
        'two_factor_recovery_codes',
        'two_factor_secret',
    ];
 
    /**
     * The attributes that should be cast to native types.
     *
     * @var array
     */
    protected $casts = [
        'email_verified_at' => 'datetime',
    ];
 
    /**
     * The accessors to append to the model's array form.
     *
     * @var array
     */
    protected $appends = [
        'profile_photo_url',
    ];
}

<?php

namespace App\Models;

use Illuminate\Contracts\Auth\MustVerifyEmail;

use Illuminate\Database\Eloquent\Factories\HasFactory;

use Illuminate\Foundation\Auth\User as Authenticatable;

use Illuminate\Notifications\Notifiable;

use Laravel\Fortify\TwoFactorAuthenticatable;

use Laravel\Jetstream\HasProfilePhoto;

use Laravel\Sanctum\HasApiTokens;

class User extends Authenticatable

{

use HasApiTokens;

use HasFactory;

use HasProfilePhoto;

use Notifiable;

use TwoFactorAuthenticatable;

/**

* The attributes that are mass assignable.

* @var array

protected $fillable = [

'name',

'email',

'password',

'social_id',

'social_type'

];

/**

* The attributes that should be hidden for arrays.

* @var array

protected $hidden = [

'password',

'remember_token',

'two_factor_recovery_codes',

'two_factor_secret',

];

/**

* The attributes that should be cast to native types.

* @var array

protected $casts = [

'email_verified_at' => 'datetime',

];

/**

* The accessors to append to the model's array form.

* @var array

protected $appends = [

'profile_photo_url',

];

}

Now, run following command to migrate database schema.

php artisan migrate

1	php artisan migrate

Install Jetstream Auth

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

composer require laravel/jetstream

1	composer require laravel/jetstream

Now, you have to install livewire with jetstream. Use the following command to install livewire with jetstream in laravel application:

php artisan jetstream:install livewire

1	php artisan jetstream:install livewire

Install necessary NPM dependency:

npm install

1	npm install

Start node development server:

npm run dev

1	npm run dev

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

php artisan migrate

1	php artisan migrate

Make Routes

In this step, Go to routes directory and open web.php file. Then add the following routes into web.php file:

use Illuminate\Support\Facades\Route;
use App\Http\Controllers\Auth\SocialGithubController;
 
 
Route::get('auth/github', [SocialGithubController::class, 'redirectToGithub']);
Route::get('callback/github', [SocialGithubController::class, 'handleCallback']);

use Illuminate\Support\Facades\Route;

use App\Http\Controllers\Auth\SocialGithubController;

Route::get('auth/github', [SocialGithubController::class, 'redirectToGithub']);

Route::get('callback/github', [SocialGithubController::class, 'handleCallback']);

Create Controller By Command

In this step, run the following command to create GithubSocialController.php file:

php artisan make:controller SocialGithubController

1	php artisan make:controller SocialGithubController

Now, go to app/http/controllers directory and open SocialGithubController.php file in any text editor. Then put the following code into SocialGithubController.php file:

<?php
   
namespace App\Http\Controllers\Auth;
   
use App\Http\Controllers\Controller;
use Socialite;
use Auth;
use Exception;
use App\Models\User;
   
class SocialGithubController extends Controller
{
    /**
     * Create a new controller instance.
     *
     * @return void
     */
    public function redirectToGithub()
    {
        return Socialite::driver('github')->redirect();
    }
       
    /**
     * Create a new controller instance.
     *
     * @return void
     */
    public function handleCallback()
    {
        try {
     
            $user = Socialite::driver('github')->user();
      
            $finduser = User::where('social_id', $user->id)->first();
      
            if($finduser){
      
                Auth::login($finduser);
     
                return redirect('/home');
      
            }else{
                $newUser = User::create([
                    'name' => $user->name,
                    'email' => $user->email,
                    'social_id'=> $user->id,
                    'social_type'=> 'github',
                    'password' => encrypt('github123456')
                ]);
     
                Auth::login($newUser);
      
                return redirect('/home');
            }
     
        } catch (Exception $e) {
            dd($e->getMessage());
        }
    }
}

<?php

namespace App\Http\Controllers\Auth;

use App\Http\Controllers\Controller;

use Socialite;

use Auth;

use Exception;

use App\Models\User;

class SocialGithubController extends Controller

{

/**

* Create a new controller instance.

* @return void

public function redirectToGithub()

{

return Socialite::driver('github')->redirect();

}

/**

* Create a new controller instance.

* @return void

public function handleCallback()

{

try {

$user = Socialite::driver('github')->user();

$finduser = User::where('social_id', $user->id)->first();

if($finduser){

Auth::login($finduser);

return redirect('/home');

}else{

$newUser = User::create([

'name' => $user->name,

'email' => $user->email,

'social_id'=> $user->id,

'social_type'=> 'github',

'password' => encrypt('github123456')

]);

Auth::login($newUser);

return redirect('/home');

}

} catch (Exception $e) {

dd($e->getMessage());

}

In this step, implement github login button into login.blade.php file. So, open login.blade.php, which is found inside resources/views/auth/ directory:

<x-guest-layout>
    <x-jet-authentication-card>
        <x-slot name="logo">
            <x-jet-authentication-card-logo />
        </x-slot>
 
        <x-jet-validation-errors class="mb-4" />
 
        @if (session('status'))
            <div class="mb-4 font-medium text-sm text-green-600">
                {{ session('status') }}
            </div>
        @endif
 
        <form method="POST" action="{{ route('login') }}">
            @csrf
 
            <div>
                <x-jet-label value="{{ __('Email') }}" />
                <x-jet-input class="block mt-1 w-full" type="email" name="email" :value="old('email')" required autofocus />
            </div>
 
            <div class="mt-4">
                <x-jet-label value="{{ __('Password') }}" />
                <x-jet-input class="block mt-1 w-full" type="password" name="password" required autocomplete="current-password" />
            </div>
 
            <div class="block mt-4">
                <label class="flex items-center">
                    <input type="checkbox" class="form-checkbox" name="remember">
                    <span class="ml-2 text-sm text-gray-600">{{ __('Remember me') }}</span>
                </label>
            </div>
 
            <div class="flex items-center justify-end mt-4">
                @if (Route::has('password.request'))
                    <a class="underline text-sm text-gray-600 hover:text-gray-900" href="{{ route('password.request') }}">
                        {{ __('Forgot your password?') }}
                    </a>
                @endif
 
                <x-jet-button class="ml-4">
                    {{ __('Login') }}
                </x-jet-button>
 
                <a href="{{ url('auth/github') }}" style="margin-top: 0px !important;background: green;color: #ffffff;padding: 5px;border-radius:7px;" class="ml-2">
                  <strong>Github Login</strong>
                </a> 
            </div>
        </form>
    </x-jet-authentication-card>
</x-guest-layout>

<x-guest-layout>

<x-jet-authentication-card>

<x-slot name="logo">

<x-jet-authentication-card-logo />

</x-slot>

<x-jet-validation-errors class="mb-4" />

@if (session('status'))

</div>

@endif

@csrf

<div>

<x-jet-label value="{{ __('Email') }}" />

<x-jet-input class="block mt-1 w-full" type="email" name="email" :value="old('email')" required autofocus />

</div>

<x-jet-label value="{{ __('Password') }}" />

<x-jet-input class="block mt-1 w-full" type="password" name="password" required autocomplete="current-password" />

</div>

<span class="ml-2 text-sm text-gray-600">{{ __('Remember me') }}</span>

</label>

</div>

@if (Route::has('password.request'))

</a>

@endif

<x-jet-button class="ml-4">

</x-jet-button>

<strong>Github Login</strong>

</a>

</div>

</form>

</x-jet-authentication-card>

</x-guest-layout>

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

1	http://127.0.0.1:8000