Laravel 7 GEO Chart Example using lavacharts

May 12, 2020 XpertPhp Comments 0 Comment

In this article, We would like to share with you how to create a GEO chart in Laravel 7. in this example we will use the “khill/lavacharts” package for creating a Geo chart in Laravel.

The “khill/lavacharts” package provides facilities like a bar chart, Area Chart, Column Chart, Pie Chart, Line Chart, etc.

So you can follow the below steps to create a GEO chart.

Overview

Step 1: Install Laravel

Step 2: Setting Database Configuration

Step 3: Create Table using migration

Step 4: Install the Package

Step 5: Add providers and aliases

Step 6: Create Route

Step 7: Create a Model and Controller

Step 8: Create Blade Files

Step 9: Run Our Laravel Application

Step 1: Install Laravel

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

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

1	composer create-project --prefer-dist laravel/laravel laravel7_geo_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(laravel7_geo_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(laravel7_geo_chart)

DB_USERNAME=Enter_Your_Database_Username(root)

DB_PASSWORD=Enter_Your_Database_Password(root)

Step 3: Create Table using migration

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

php artisan make:migration create_visit_users_table --create=visit_users

1	php artisan make:migration create_visit_users_table --create=visit_users

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

<?php

use Illuminate\Support\Facades\Schema;
use Illuminate\Database\Schema\Blueprint;
use Illuminate\Database\Migrations\Migration;

class CreateVisitUsersTable extends Migration
{
    /**
     * Run the migrations.
     *
     * @return void
     */
    public function up()
    {
        Schema::create('visit_users', function (Blueprint $table) {
            $table->bigIncrements('id');
            $table->string('country_name');
            $table->integer('total_users');
            $table->timestamps();
        });
    }

    /**
     * Reverse the migrations.
     *
     * @return void
     */
    public function down()
    {
        Schema::dropIfExists('visit_users');
    }
}
?>

<?php

use Illuminate\Support\Facades\Schema;

use Illuminate\Database\Schema\Blueprint;

use Illuminate\Database\Migrations\Migration;

class CreateVisitUsersTable extends Migration

{

/**

* Run the migrations.

* @return void

public function up()

{

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

$table->bigIncrements('id');

$table->string('country_name');

$table->integer('total_users');

$table->timestamps();

});

}

/**

* Reverse the migrations.

* @return void

public function down()

{

Schema::dropIfExists('visit_users');

}

Run the below command. after the changes above file.

php artisan migrate

1	php artisan migrate

Step 4: Install The Package

Now, We will install “khill/lavacharts” package using the below command.

composer require khill/lavacharts

1	composer require khill/lavacharts

Step 5: Add providers and aliases

We will add below providers and aliases in the “config/app.php” file.

'providers' => [
	....
	Khill\Lavacharts\Laravel\LavachartsServiceProvider::class,
],
'aliases' => [
	....
	'Lava' => Khill\Lavacharts\Laravel\LavachartsFacade::class,
]

'providers' => [

....

Khill\Lavacharts\Laravel\LavachartsServiceProvider::class,

'aliases' => [

....

'Lava' => Khill\Lavacharts\Laravel\LavachartsFacade::class,

]

Step 6: Create Route

Add the following route code in the “routes/web.php” file.

<?php
/*
|--------------------------------------------------------------------------
| 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('/', function () {
   // return view('welcome');	
});
Route::get('larachart','VisitusersController@getUsers');
?>

<?php

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

| 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('/', function () {

// return view('welcome');

});

Route::get('larachart','VisitusersController@getUsers');

Step 7: Create a Model and Controller

Here below command help to create the controller and model.

php artisan make:controller VisitusersController
php artisan make:model Visitusers -m

1 2	php artisan make:controller VisitusersController php artisan make:model Visitusers -m

Visitusers.php

<?php
namespace App;
use Illuminate\Database\Eloquent\Model;
class Visitusers extends Model
{
    //
	protected $fillable = [
        public $fillable = ['country_name','total_users'];
    ];
}
?>

<?php

namespace App;

use Illuminate\Database\Eloquent\Model;

class Visitusers extends Model

{

protected $fillable = [

public $fillable = ['country_name','total_users'];

];

}

VisitusersController.php

namespace App\Http\Controllers;


use Illuminate\Http\Request;
use Khill\Lavacharts\Lavacharts;
use App\Visitusers;


class VisitusersController extends Controller
{


    public function getUsers()
    {
        	$lava = new Lavacharts; // See note below for Laravel

		$popularity = $lava->DataTable();
		$data = Visitusers::select("country_name as 0","total_users as 1")->get()->toArray();


		$popularity->addStringColumn('Country')
		           ->addNumberColumn('Popularity')
		           ->addRows($data);

		$lava->GeoChart('Popularity', $popularity);

                return view('larachart',compact('lava'));
    }


}

namespace App\Http\Controllers;

use Illuminate\Http\Request;

use Khill\Lavacharts\Lavacharts;

use App\Visitusers;

class VisitusersController extends Controller

{

public function getUsers()

{

$lava = new Lavacharts; // See note below for Laravel

$popularity = $lava->DataTable();

$data = Visitusers::select("country_name as 0","total_users as 1")->get()->toArray();

$popularity->addStringColumn('Country')

->addNumberColumn('Popularity')

->addRows($data);

$lava->GeoChart('Popularity', $popularity);

return view('larachart',compact('lava'));

}

Step 8: Create Blade Files

Finally, We will create a larachart.blade.php file in the “resources/views/” folder directory and paste below code.

larachart.blade.php

<!-- geochart.blade.php -->

<!DOCTYPE html>
<html>
  <head>
    <meta charset="utf-8">
    <title>Laravel GeoChart Example</title>
    <link rel="stylesheet" href="{{asset('css/app.css')}}">  
  </head>
  <body>
    <div class="container">
      <h2>Laravel GeoChart Example</h2><br/>
      <div id="geo"></div>
       <?= $lava->render('GeoChart', 'Popularity', 'pop-div') ?>
   </div>
  </body>
</html>

<!DOCTYPE html>

<html>

<head>

<title>Laravel GeoChart Example</title>

</head>

<body>

<h2>Laravel GeoChart Example</h2><br/>

<?= $lava->render('GeoChart', 'Popularity', 'pop-div') ?>

</div>

</body>

</html>

Step 9: 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/larachart

1	http://127.0.0.1:8000/larachart