Laravel 8 Highcharts Example From Scratch

October 16, 2020 XpertPhp

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

Now, we will plot a Highcharts graph using the Highcharts js library. so you can see the following steps.

Overview

Step 1: Install Laravel 8
Step 2: Setting Database Configuration
Step 3: Create Routes
Step 4: Create Controller
Step 5: Create Blade Files
Step 6: 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 3: Create Routes
Add the following route code in the “routes/web.php” file.

use App\Http\Controllers\UserController;

Route::get('high-chart',[UserController::class, 'index']);

use App\Http\Controllers\UserController;

Route::get('high-chart',[UserController::class, 'index']);

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

php artisan make:controller UserController

1	php artisan make:controller UserController

UserController.php

<?php

namespace App\Http\Controllers;

use Illuminate\Http\Request;
use App\Models\User;

class UserController extends Controller
{
    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('high_chart', compact('users'));
    }
}

?>

<?php

namespace App\Http\Controllers;

use Illuminate\Http\Request;

use App\Models\User;

class UserController extends Controller

{

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('high_chart', compact('users'));

}

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

<!DOCTYPE html>
<html>
<head>
    <title>Laravel 8 Highcharts Example From Scratch - XpertPhp</title>
    <link rel="stylesheet" href="https://cdnjs.cloudflare.com/ajax/libs/twitter-bootstrap/4.5.2/css/bootstrap.min.css" integrity="sha512-MoRNloxbStBcD8z3M/2BmnT+rg4IsMxPkXaGh2zD6LGNNFE80W3onsAhRcMAMrSoyWL9xD7Ert0men7vR8LUZg==" crossorigin="anonymous" />
</head>   
<body>
    <div class="container mt-5">
        <h2 class="text-center"><strong>Laravel Highcharts Example</strong></h2>
        <div id="hight-chart"></div>
    </div>
</body>
<script src="https://code.highcharts.com/highcharts.js"></script>
<script type="text/javascript">
    var users =  <?php echo json_encode($users) ?>;
   
    Highcharts.chart('hight-chart', {
        title: {
            text: 'New User Growth, 2019'
        },
        subtitle: {
            text: 'Source: XpertPhp'
        },
         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 From Scratch - XpertPhp</title>

</head>

<body>

<h2 class="text-center"><strong>Laravel Highcharts Example</strong></h2>

</div>

</body>

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

Highcharts.chart('hight-chart', {

title: {

text: 'New User Growth, 2019'

subtitle: {

text: 'Source: XpertPhp'

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>

Step 6: 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/high-chart

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

Please follow and like us:

Related posts: