[eluser]Unknown[/eluser]
Hello everyone, this is my first Topic,
before asking, i'll show up code first,
Flexigrid.php on Controller
Code:
class Flexigrid extends CI_Controller {
function __construct ()
{
parent::__construct();
$this->load->helper('flexigrid');
}
function index()
{
$colModel['CustID'] = array('CustID',50,TRUE,'center',2);
$colModel['NamaUser'] = array('Nama User',40,TRUE,'center',2);
$colModel['Alamat1'] = array('Alamat',180,TRUE,'left',2);
// next code no need to be written
Ajax.php on controller
Code:
class Ajax extends CI_Controller {
function __construct ()
{
parent::__construct();
$this->load->model('SanMod');
$this->load->library('flexigrid');
}
function index()
{
$valid_fields = array('CustID','Nama_User','Alamat1');
$this->flexigrid->validate_post('CustID','asc',$valid_fields);
$records = $this->SanMod->GetCust();
$this->output->set_header($this->config->item('json_header'));
$i=1;
foreach ($records['records']->result() as $row)
{
$record_items[] = array($row->CustID,
$i++,
$row->Nama_User,
$row->Alamat1
);
}
And
SanMod.php on Model
Code:
class SanMod extends CI_Model {
function __construct ()
{
parent::__construct();
$this->CI =& get_instance();
}
public function GetCust()
{
$table_name = "T_Customer";
$this->db->select('CustID,Nama_User,Alamat1')->from($table_name);
$this->CI->flexigrid->build_query();
$return['records'] = $this->db->get();
$this->db->select('count(CustID) as record_count')->from($table_name);
$this->CI->flexigrid->build_query(FALSE);
$record_count = $this->db->get();
$row = $record_count->row();
$return['record_count'] = $row->record_count;
return $return;
}
No Error shown in the code,but i cant view my flexigrid, anyone can helpme? >_<
*nb: Im using codeigniter 2.10 and sqlsrv driver, and sorry if my english is bad >_<