Highcharts Get Data From URL With Codeigniter

It's tutorial access data json from URL with Codeigniter .

1. Your have data from your tables/database
2. Create Models, sample i try highchart to My Dashboard.

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

class DashboardModel extends CI_Model {

 public function dataAccount()
 {
  $sql = "
   SELECT
   *
   FROM
   (SELECT COUNT(ACCOUNT_USERNAME) AS HRMANAGER FROM MST_ACCOUNT WHERE ACCOUNT_LEVEL = '1'),
   (SELECT COUNT(ACCOUNT_USERNAME) AS HRADMIN FROM MST_ACCOUNT WHERE ACCOUNT_LEVEL = '2'),
   (SELECT COUNT(ACCOUNT_USERNAME) AS TRAINING FROM MST_ACCOUNT WHERE ACCOUNT_LEVEL = '3'),
   (SELECT COUNT(ACCOUNT_USERNAME) AS SUPERVAISOR FROM MST_ACCOUNT WHERE ACCOUNT_LEVEL = '4')
  ";

  $result = $this->db->query($sql)->result();

  return $result;
 }

}

/* End of file DashboardModel.php */
/* Location: ./application/models/DashboardModel.php */

3. In the controller

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

class Dashboard extends CI_Controller
{

    public $page = 'Dashboard';

    public function __construct()
    {
        parent::__construct();
        //Load Dependencies

        $this->load->model('DashboardModel');
    }

    public function index()
    {
        $this->content = 'dashboard/HrManagerIndexView';

        $this->layout(
            (!empty($data)) ? $data : null,
            $addCss = array(
                'assets/css/ace.min.css',
                'assets/css/ace-rtl.min.css',
            ),
            $addJs = array(
                'assets/js/callJsMobile.js',
                'assets/js/bootstrap.min.js',
                'assets/plugin/highcharts/highcharts.js',
                'assets/plugin/highcharts/modules/exporting.js',
                'assets/plugin/highcharts/modules/data.js',
                'assets/plugin/highcharts/modules/drilldown.js',
                'assets/js/ace-elements.min.js',
                'assets/js/ace.min.js',
                'assets/js/custome/DashboardManager.js',
            )
        );
    }

    /*    Dashboard Data Report    */
    public function getDataAccount()
    {
        $list = $this->DashboardModel->dataAccount();

        $total       = array($list[0]->HRMANAGER, $list[0]->HRADMIN, $list[0]->TRAINING, $list[0]->SUPERVAISOR);
        $resultTotal = array_sum($total);

        foreach ($list as $value) {
            $data = array(
                'name'         => 'Total Data',
                'colorByPoint' => true,
                'data'         => array(
                    array('name' => 'HRMANAGER', 'y' => $this->nameformat->chartCeil($value->HRMANAGER, $resultTotal)),
                    array('name' => 'HRADMIN', 'y' => $this->nameformat->chartCeil($value->HRADMIN, $resultTotal)),
                    array('name' => 'TRAINING', 'y' => $this->nameformat->chartCeil($value->TRAINING, $resultTotal)),
                    array('name' => 'SUPERVAISOR', 'y' => $this->nameformat->chartCeil($value->SUPERVAISOR, $resultTotal)),
                ),
            );
        }

        echo json_encode($data, JSON_PRETTY_PRINT);
    }

}

/* End of file Dashboard.php */
/* Location: ./application/controllers/Dashboard.php */

4. In View
5. In Javascript

$(document).ready(function() {
    var chartAccount = {
        chart: {
            renderTo: 'chartAccount',
            plotBackgroundColor: null,
            plotBorderWidth: null,
            plotShadow: false,
            type: 'pie'
        },
        title: {
            text: 'Summary Data Account Academy'
        },
        tooltip: {
            pointFormat: '{series.name}: {point.percentage:.1f}%'
        },
        plotOptions: {
            pie: {
                allowPointSelect: true,
                cursor: 'pointer',
                dataLabels: {
                    enabled: false
                },
                showInLegend: true
            }
        },
        series: [{}]
    };

    var urlChartAccount = base_dash + 'getDataAccount';
    $.getJSON(urlChartAccount, function(data) {
        chartAccount.series[0] = data;
        var chart = new Highcharts.Chart(chartAccount);
    });
});

Refrensi: http://www.highcharts.com/docs/working-with-data/getting-data-across-domains-jsonp

How to access database in custom library codeigniter

1. Create your library, example “sample.php”

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

class Sample
{
 protected $ci;

 public function __construct()
 {
        $this->ci =& get_instance();
 }

 public function debug($id)
 {
  $table = $this->ci->db->get_where('table', array('id' => $id))->num_rows();

  if (empty($table)) {
   $result = 'table is empty';
  } else {
   $result = $table;
  }

  return $result;
 }

}

2. Load your library in controller

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

class Testing extends READY_Controller {

 public $page = 'Training';

 public function __construct()
 {
  parent::__construct();

  //Load Dependencies
  $this->load->library('sample');
 }

 public function index()
 {
  $data['result'] = $this->db->get('table')->result();

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

}

3. So, call function library in your views.

foreach ($result as $row) {

echo $this->sample->debug($row->id) . “\n\n\n”;

}