Laravel 9 Google Line Chart Tutorial Example

In this tutorial you will learn about the Laravel 9 Google Line Chart Tutorial Example and its application with practical 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.

Table Of Contents−

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

AngularJS

CodeIgniter

Laravel

Node Js

Wordpress

More Blog

Learn

ABOUT PAGES

Laravel 9 Google Line Chart Tutorial Example