Welcome Guest, Not a member yet? Register   Sign In
Why My Flexigrid Doesn't Display?
#1

[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 >_<

#2

[eluser]beben[/eluser]
$valid_fields = array('CustID','Nama_User','Alamat1');

$colModel['CustID'] = array('CustID',50,TRUE,'center',2);
$colModel['NamaUser'] = array('NamaUser',40,TRUE,'center',2);
$colModel['Alamat1'] = array('Alamat',180,TRUE,'left',2);

Your col model NamaUser is not consistent with your valid fields Nama_User

Change valid fields to NamaUser




Theme © iAndrew 2016 - Forum software by © MyBB