Dear All...
I've create combogrid with pagination that contains about 6000 data's... It works well (see combogrid-oke.jpg)...
Problems arise on edit mode when its value was on page 2 (on page 1 it works fine - combogrid-oke-oke.jpg) and so only appear idField (without textField - see combogrid-not-oke.jpg). How to fix it? Can anyone help me?
This is my code
HTML
<input id="asptimsmhs_datamhs" name="asptimsmhs" class="easyui-combogrid" style="width:95%;height:20px;" prompt="Pilih" data-options="
panelWidth:400,panelHeight:'auto',
url: '_modul/mod_datamhs/aksi_datamhs.php?act=asal_pt',
idField:'kdptitbpti', textField:'nmptitbpti', mode:'remote',
pagination:true, pageSize:10, pageList: [10],
multiple:false,fitColumns:true,
columns:[[
{field:'kdptitbpti',title:'Kode',align:'center',width:50},
{field:'nmptitbpti',title:'Nama Perguruan Tinggi',width:250}
]],
"
>
PHP:
$q = isset($_POST['q']) ? strval($_POST['q']) : '';
$page = isset($_POST['page']) ? intval($_POST['page']) : 1;
$rows = isset($_POST['rows']) ? intval($_POST['rows']) : 15;
$offset = ($page-1)*$rows;
$result = array();
$sql = "SELECT kdptitbpti,nmptitbpti FROM _tbpti WHERE kdptitbpti LIKE '%$q%' OR nmptitbpti LIKE '%$q%'";
$res = $conDB->query($sql);
$result["total"] = $res->num_rows;
$sql="SELECT kdptitbpti,nmptitbpti FROM _tbpti WHERE kdptitbpti LIKE '%$q%' OR nmptitbpti like '%$q%' limit $offset,$rows";
$res = $conDB->query($sql);
$rows = array();
while($row = $res->fetch_assoc()){
array_push($rows, $row);
}
$result["rows"] = $rows;
echo json_encode($result);
Please help.... Thx