Laravel 8 Google Bar Chart Example From Scratch

In this article, we will explain to you how to Implement Google Bar Chart in laravel 8(Laravel 8 Google Bar Chart Example From Scratch). today we will fetch data into MySQL, and plot a bar graph.

There are many types of charts provide by Google, like a bar chart, area chart, line chart, pie chart, etc. but here we use a bar chart.

In this example, we will plot a bar graph using Google API. so you can see below the following steps.

Overview

Step 1: Install Laravel 8
Step 2: Setting Database Configuration
Step 4: Create Table using migration
Step 5: Create Routes
Step 6: Create Model and Controller
Step 7: Create Blade Files
Step 8: Run Our Laravel Application

Step 1: Install Laravel 8

We are going to install laravel 8, so first open the command prompt or terminal and go to xampp htdocs folder directory using the command prompt. after then run the below command for laravel 8 install.

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

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

Step 2: Setting Database Configuration

After the complete installation of laravel. we have to database configuration. now we will open the .env file and change the database name, username, password in the .env file. See below changes in a .env file.

DB_CONNECTION=mysql
DB_HOST=127.0.0.1
DB_PORT=3306
DB_DATABASE=Enter_Your_Database_Name(laravel8_chart)
DB_USERNAME=Enter_Your_Database_Username(root)
DB_PASSWORD=Enter_Your_Database_Password(root)

DB_CONNECTION=mysql

DB_HOST=127.0.0.1

DB_PORT=3306

DB_DATABASE=Enter_Your_Database_Name(laravel8_chart)

DB_USERNAME=Enter_Your_Database_Username(root)

DB_PASSWORD=Enter_Your_Database_Password(root)

Step 4: Create Table using migration

Now, We need to create a migration. so we will below command using create the products table migration.

php artisan make:migration create_students_table --create=products

1	php artisan make:migration create_students_table --create=products

After complete migration. we need the below changes in the database/migrations/create_products_table file.

<?php
use Illuminate\Support\Facades\Schema;
use Illuminate\Database\Schema\Blueprint;
use Illuminate\Database\Migrations\Migration;
class CreateProductsTable extends Migration
{
    /**
     * Run the migrations.
     *
     * @return void
     */
    public function up()
    {
        Schema::create('students', function (Blueprint $table) {
			$table->string("name")->nullable();
			$table->string("sku")->nullable();
			$table->string("description")->nullable();
			$table->string("price")->nullable();
			$table->integer("quantity");
			$table->integer("sales");
        });
    }
    /**
     * Reverse the migrations.
     *
     * @return void
     */
    public function down()
    {
        Schema::dropIfExists('products');
    }
}
?>

<?php

use Illuminate\Support\Facades\Schema;

use Illuminate\Database\Schema\Blueprint;

use Illuminate\Database\Migrations\Migration;

class CreateProductsTable extends Migration

{

/**

* Run the migrations.

* @return void

public function up()

{

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

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

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

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

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

$table->integer("quantity");

$table->integer("sales");

});

}

/**

* Reverse the migrations.

* @return void

public function down()

{

Schema::dropIfExists('products');

}

Run the below command. after the changes above file.

php artisan migrate

1	php artisan migrate

Step 5: Create Routes
Add the following route code in the “routes/web.php” file.

use App\Http\Controllers\ProductController;

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

use App\Http\Controllers\ProductController;

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

Step 6: Create Model and Controller
Here below command help to create the controller and model.

php artisan make:controller ProductController --resource --model=Product

1	php artisan make:controller ProductController --resource --model=Product

Product.php

<?php

namespace App\Models;
use Illuminate\Database\Eloquent\Factories\HasFactory;
use Illuminate\Database\Eloquent\Model;

class Product extends Model
{
    use HasFactory;
    protected $fillable = [
        'name','sku', 'description', 'price', 'quantity', 'sales'
    ];
}
?>

<?php

namespace App\Models;

use Illuminate\Database\Eloquent\Factories\HasFactory;

use Illuminate\Database\Eloquent\Model;

class Product extends Model

{

use HasFactory;

protected $fillable = [

'name','sku', 'description', 'price', 'quantity', 'sales'

];

}

ProductController.php

<?php
 
namespace App\Http\Controllers;
 
use Illuminate\Http\Request;
use App\Models\Product; 
 
class ProductController extends Controller
{
     /**
     * Display a listing of the resource.
     *
     * @return \Illuminate\Http\Response
     */
    public function index()
    {		
	   $products = \App\Product::all();
       return view('bar-chart',['products' => $products]);
    }
}

?>

<?php

namespace App\Http\Controllers;

use Illuminate\Http\Request;

use App\Models\Product;

class ProductController extends Controller

{

/**

* Display a listing of the resource.

* @return \Illuminate\Http\Response

public function index()

{

$products = \App\Product::all();

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

}

Step 7: Create Blade Files
So finally, first we need to create the bar-chart.blade.php file in the “resources/views/” directory and update the below code.
bar-chart.blade.php

<!doctype html>
<html lang="en">
  <head>
    <title>Laravel 8 Google Bar Chart Example From Scratch - XpertPhp</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>
  </head>
  <body>
		<div class="container">
			<div id="bar-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':['bar']});
		  google.charts.setOnLoadCallback(drawChart);

		  function drawChart() {
			var data = google.visualization.arrayToDataTable([
				['Product Id', 'Sales', 'Quantity'],

				@php
				  foreach($products as $product) {
					  echo "['".$product->id."', ".$product->sales.", ".$product->quantity."],";
				  }
				@endphp
			]);

			var options = {
			  chart: {
				title: 'Bar Graph | Sales',
				subtitle: 'Sales, and Quantity: @php echo $products[0]->created_at @endphp',
			  },
			  bars: 'vertical'
			};
			var chart = new google.charts.Bar(document.getElementById('bar-chart'));
			chart.draw(data, google.charts.Bar.convertOptions(options));
		  }
		</script>
	</body>
</html>

<!doctype html>

<head>

<title>Laravel 8 Google Bar Chart Example From Scratch - XpertPhp</title>

</head>

<body>

</div>

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

google.charts.setOnLoadCallback(drawChart);

function drawChart() {

var data = google.visualization.arrayToDataTable([

['Product Id', 'Sales', 'Quantity'],

@php

foreach($products as $product) {

echo "['".$product->id."', ".$product->sales.", ".$product->quantity."],";

}

@endphp

]);

var options = {

chart: {

title: 'Bar Graph | Sales',

subtitle: 'Sales, and Quantity: @php echo $products[0]->created_at @endphp',

bars: 'vertical'

};

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

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

}

</script>

</body>

</html>

Step 8: Run Our Laravel Application
We can start the server and run this example using the below command.

php artisan serve

1	php artisan serve

Now we will run our example using the below Url in the browser.

http://127.0.0.1:8000/bar-chart

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