for : Muhammad Abu Bakar As'sidiq (Group CI - Indo)

Coba.php

<?php
/* ------------------------------------------------------------------------
 * File Controller
*/ ------------------------------------------------------------------------
defined('BASEPATH') OR exit('No direct script access allowed');

class Coba extends CI_Controller {

  public function __construct()
  {
    parent::__construct();
    $this->load->model('m_coba');
  }

  public function index()
  {
    $data['query'] = $this->m_coba->get_all();
    $this->load->view('v_coba', $data);
  }

}

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

M_coba.php

<?php
/* ------------------------------------------------------------------------
 * File Model
*/ ------------------------------------------------------------------------
defined('BASEPATH') OR exit('No direct script access allowed');

class M_coba extends CI_Model {

  function get_all() {
    return $this->db->get('tb_nama');
  }

}

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

tb_nama.sql

/* ------------------------------------------------------------------------
 * File SQL
*/ ------------------------------------------------------------------------

CREATE TABLE `tb_nama` (
  `id` INTEGER PRIMARY KEY AUTOINCREMENT,
  `nama` TEXT
);

v_coba.php

<?php
/* ------------------------------------------------------------------------
 * File View
*/ ------------------------------------------------------------------------
  $rs = array();
  foreach ($query->result() as $t) {
    $rs[] = $t;
  }

  $json = json_encode($rs);
  print $json;

/* End of file v_coba.php */
/* Location: ./application/views/v_coba.php */