Laravel 9 Google Pie Chart Tutorial Example

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

Table Of Contents−

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

AngularJS

CodeIgniter

Laravel

Node Js

Wordpress

More Blog

Learn

ABOUT PAGES

Laravel 9 Google Pie Chart Tutorial Example