Skip to content
  • About Us
  • Contact Us
  • Privacy Policy
  • Terms & Conditions
  • Site Map

XpertPhp

Expertphp Is The Best Tutorial For Beginners

  • Home
  • Javascript
    • Jquery
    • React JS
    • Angularjs
    • Angular
    • Nodejs
  • Codeigniter
  • Laravel
  • Contact Us
  • About Us
  • Live Demos

Home » Laravel » Laravel 7 GEO Chart Example using lavacharts

Laravel 7 GEO Chart Example Using Lavacharts

Laravel 7 GEO Chart Example using lavacharts

Posted on May 12, 2020February 14, 2021 By XpertPhp No Comments on Laravel 7 GEO Chart Example using lavacharts

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.

PHP
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.

PHP
1
2
3
4
5
6
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
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
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
<?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
1
php artisan migrate

Step 4: Install The Package

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

PHP
1
composer require khill/lavacharts

Step 5: Add providers and aliases

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

PHP
1
2
3
4
5
6
7
8
'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
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
<?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','[email protected]');
?>

Step 7: Create a Model and Controller

Here below command help to create the controller and model.

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

Visitusers.php

PHP
1
2
3
4
5
6
7
8
9
10
11
<?php
namespace App;
use Illuminate\Database\Eloquent\Model;
class Visitusers extends Model
{
    //
protected $fillable = [
        public $fillable = ['country_name','total_users'];
    ];
}
?>

VisitusersController.php

PHP
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
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

PHP
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
<!-- 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>

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

1
php artisan serve

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

1
http://127.0.0.1:8000/larachart

Please follow and like us:
error
fb-share-icon
Tweet
fb-share-icon

Recommended Posts:

  • Laravel 7 CRUD Operation With Ajax Example
  • Laravel 9 Fullcalendar Ajax Example Tutorial
  • How To Import Excel and CSV File Using CodeIgniter
  • how to create a custom helper file and use in laravel 7
  • Laravel 7 CKeditor Image Upload With Example
Laravel, MySql Tags:geochart laravel example, laravel 7, laravel lavacharts examples

Post navigation

Previous Post: How to take database backup in laravel
Next Post: Laravel 7 Elasticsearch integration from scratch with example

Latest Posts

  • Laravel Check If Foreach is Empty Example
  • Laravel Check Array Empty in Blade
  • PHP Datatables CRUD Example
  • How to Convert Date and Time from one timezone to another in php
  • how to get current date and time in php
  • Drag and Drop Reorder Items with jQuery, PHP & MySQL
  • Laravel 9 Toastr Notifications Example Tutorial
  • Laravel 9 CRUD Operation Example Using Google Firebase
  • Laravel 9 CKeditor Image Upload With Example
  • Laravel 9 Summernote Image Upload With Example

Tools

  • Compound Interest Calculator
  • Hex to RGB Color Converter
  • Pinterest Video Downloader
  • Birthday Calculator
  • Convert JSON to PHP Array Online
  • JavaScript Minifier
  • CSS Beautifier
  • CSS Minifier
  • JSON Beautifier
  • JSON Minifier

Categories

  • Ajax
  • Angular
  • Angularjs
  • Bootstrap
  • Codeigniter
  • Css
  • Htaccess
  • Javascript
  • Jquery
  • Laravel
  • MongoDB
  • MySql
  • Nodejs
  • Php
  • React JS
  • Shopify Api
  • Ubuntu

Tags

angular 10 tutorial angular 11 ci tutorial codeigniter 4 image upload Codeigniter 4 Tutorial codeigniter tutorial CodeIgniter tutorial for beginners codeigniter with mysql crud operation eloquent relationships file upload File Validation form validation Image Upload jQuery Ajax Form Handling jquery tricks jquery tutorial laravel 6 Laravel 6 Eloquent Laravel 6 Model laravel 6 relationship laravel 6 relationship eloquent Laravel 6 Routing laravel 7 Laravel 7 Eloquent laravel 7 routing laravel 7 tutorial Laravel 8 laravel 8 example laravel 8 tutorial laravel 9 example laravel 9 tutorial Laravel Framework laravel from scratch Laravel Socialite laravel social login nodejs pagination payment gateway php with mysql react js tutorial rewrite rule send mail validation wysiwyg editor

Copyright © 2018 - 2022,

All Rights Reserved Powered by XpertPhp.com