How to Implement Google Pie Chart using Codeigniter

In this article, we will explain to you how to Implement Google Pie Chart using Codeigniter. today we will fetch data into MySQL, and plot a Pie 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 Pie chart.

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

Overview

Step 1: Create a Database in table
Step 2: Connect to Database
Step 3: Create Controller
Step 4: Create View File

Step 1: Create a Database in table
In this step, we have to create a table in the database, so we will create a database using the below code.

CREATE TABLE `login_history` (
  `id` int(11) NOT NULL,
  `user_id` int(11) NOT NULL,
  `login_date` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
   PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 AUTO_INCREMENT=1;

CREATE TABLE `login_history` (

`id` int(11) NOT NULL,

`user_id` int(11) NOT NULL,

`login_date` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),

PRIMARY KEY (`id`)

) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 AUTO_INCREMENT=1;

Step 2: Connect to Database
Go to the config folder and open database.php file some changes in this file like hostname, database username, database password, and database name.

$db['default'] = array(
	'dsn'	=> '',
	'hostname' => 'localhost',
	'username' => 'root',
	'password' => '',
	'database' => 'enter here database name',
	'dbdriver' => 'mysqli',
	'dbprefix' => '',
	'pconnect' => FALSE,
	'db_debug' => (ENVIRONMENT !== 'production'),
	'cache_on' => FALSE,
	'cachedir' => '',
	'char_set' => 'utf8',
	'dbcollat' => 'utf8_general_ci',
	'swap_pre' => '',
	'encrypt' => FALSE,
	'compress' => FALSE,
	'stricton' => FALSE,
	'failover' => array(),
	'save_queries' => TRUE
);

$db['default'] = array(

'dsn' => '',

'hostname' => 'localhost',

'username' => 'root',

'password' => '',

'database' => 'enter here database name',

'dbdriver' => 'mysqli',

'dbprefix' => '',

'pconnect' => FALSE,

'db_debug' => (ENVIRONMENT !== 'production'),

'cache_on' => FALSE,

'cachedir' => '',

'char_set' => 'utf8',

'dbcollat' => 'utf8_general_ci',

'swap_pre' => '',

'encrypt' => FALSE,

'compress' => FALSE,

'stricton' => FALSE,

'failover' => array(),

'save_queries' => TRUE

);

Step 3: Create Controller
In this step, we will create a Googlechart.php file in the “application/controller” directory and paste the below code in this controller. here we will count user login data and fetch data last 7 days of data from the database. that data will be pass in a chart and creating a Pie graph.
application/controller/Googlechart.php

<?php
 
defined('BASEPATH') OR exit('No direct script access allowed');
 
class Googlechart extends CI_Controller {
 
    public function __construct() {
        parent::__construct();
        // load model
        $this->load->database();
        $this->load->helper(array('url','html','form'));
    }       
    public function pie_chart() {
      $query =  $this->db->query('SELECT DATE_FORMAT(login_date, "%Y-%m-%d") AS `date`, COUNT(`login_date`) as count FROM login_history WHERE date(login_date) > (DATE(NOW()) - INTERVAL 7 DAY) AND MONTH(`login_date`) = "'. date('m') .'" AND YEAR(`login_date`) = "' . date('Y') .'" GROUP BY DAYNAME(`login_date`) ORDER BY (`login_date`) ASC'); 
      $records = $query->result_array();
	  // echo "<pre>";
	  // print_r($records);
	  // echo "</pre>"; die;
      $data = [];
      $data['chart_data'] = $records;
      $this->load->view('pie_chart',$data);
    }
<div style="clear:both; margin-top:0em; margin-bottom:1em;"><a href="https://xpertphp.com/how-to-add-multiple-markers-in-google-maps-using-codeigniter/" target="_blank" rel="nofollow" class="u54b8379c209dd3fe04e4b440f47c6978"><style>.u54b8379c209dd3fe04e4b440f47c6978{padding:0;margin:0;padding-top:1em!important;padding-bottom:1em!important;width:100%;display:block;font-weight:700;background-color:#eaeaea;border:0!important;border-left:4px solid #34495E!important;box-shadow:0 1px 2px rgba(0,0,0,.17);-moz-box-shadow:0 1px 2px rgba(0,0,0,.17);-o-box-shadow:0 1px 2px rgba(0,0,0,.17);-webkit-box-shadow:0 1px 2px rgba(0,0,0,.17);text-decoration:none}.u54b8379c209dd3fe04e4b440f47c6978:active,.u54b8379c209dd3fe04e4b440f47c6978:hover{opacity:1;transition:opacity 250ms;webkit-transition:opacity 250ms;text-decoration:none}.u54b8379c209dd3fe04e4b440f47c6978{transition:background-color 250ms;webkit-transition:background-color 250ms;opacity:1.11;transition:opacity 250ms;webkit-transition:opacity 250ms}.u54b8379c209dd3fe04e4b440f47c6978 .ctaText{font-weight:700;color:#464646;text-decoration:none;font-size:16px}.u54b8379c209dd3fe04e4b440f47c6978 .postTitle{color:#000;text-decoration:underline!important;font-size:16px}.u54b8379c209dd3fe04e4b440f47c6978:hover .postTitle{text-decoration:underline!important}</style><div style="padding-left:1em; padding-right:1em;"><span class="ctaText">See also</span>  <span class="postTitle">How to add multiple markers in google maps using Codeigniter</span></div></a></div>
}
?>

<?php

defined('BASEPATH') OR exit('No direct script access allowed');

class Googlechart extends CI_Controller {

public function __construct() {

parent::__construct();

// load model

$this->load->database();

$this->load->helper(array('url','html','form'));

}

public function pie_chart() {

$query = $this->db->query('SELECT DATE_FORMAT(login_date, "%Y-%m-%d") AS `date`, COUNT(`login_date`) as count FROM login_history WHERE date(login_date) > (DATE(NOW()) - INTERVAL 7 DAY) AND MONTH(`login_date`) = "'. date('m') .'" AND YEAR(`login_date`) = "' . date('Y') .'" GROUP BY DAYNAME(`login_date`) ORDER BY (`login_date`) ASC');

$records = $query->result_array();

// echo "<pre>";

// print_r($records);

// echo "</pre>"; die;

$data = [];

$data['chart_data'] = $records;

$this->load->view('pie_chart',$data);

}

Step 4: Create View File
So finally, we will create the pie_chart.php file in the “application/views/” directory.
application/views/pie_chart.php

<!Doctype html>
<html>
<head>
  <title>How to Implement Google Pie Chart using Codeigniter - XpertPhp</title>
  <script type="text/javascript" src="https://www.gstatic.com/charts/loader.js"></script> 
  <script type="text/javascript">
      google.charts.load('visualization', "1", {
          packages: ['corechart']
      });
  </script>
</head>
<body>
<div id="pie_chart" style="width: 900px; height: 500px; margin: 0 auto"></div>
<script language="JavaScript">
  // Draw the Pie chart 
  google.charts.setOnLoadCallback(pieChart);   
  //for month wise
  function pieChart() {
 
        /* Define the chart to be drawn.*/
        var data = google.visualization.arrayToDataTable([
            ['Month', 'Users Count'],
            <?php 
             foreach ($chart_data as $row){
             echo "['".$row['date']."',".$row['count']."],";
             }
             ?>
        ]);
        var options = {
            title: 'Last 7 day Wise Login Users Count',
            is3D: true,
        };
        /* Instantiate and draw the chart.*/
        var chart = new google.visualization.PieChart(document.getElementById('pie_chart'));
        chart.draw(data, options);
  } 
</script>
</body>
</html>

<!Doctype html>

<html>

<head>

<title>How to Implement Google Pie Chart using Codeigniter - XpertPhp</title>

google.charts.load('visualization', "1", {

packages: ['corechart']

});

</script>

</head>

<body>

// Draw the Pie chart

google.charts.setOnLoadCallback(pieChart);

//for month wise

function pieChart() {

/* Define the chart to be drawn.*/

var data = google.visualization.arrayToDataTable([

['Month', 'Users Count'],

<?php

foreach ($chart_data as $row){

echo "['".$row['date']."',".$row['count']."],";

}

]);

var options = {

title: 'Last 7 day Wise Login Users Count',

is3D: true,

};

/* Instantiate and draw the chart.*/

var chart = new google.visualization.PieChart(document.getElementById('pie_chart'));

chart.draw(data, options);

}

</script>

</body>

</html>

We think would you like this article, so you can click on the “Show Demo” button and you can see this demo article.

Show Demo