salam all, mohon bantuannya yaaa
ogut lg mw buat grid data dengan datatables + ajax (server side), udh berhasil cuma mslhnya belon nemu utk pagination dan pencariannya, ada yg bisa bantu?
ini koding ogut
Spoiler for view.php :
<?php
include_once('koneksi.php');
$str = mysql_query("SELECT COUNT(noreg) as noreg From datapasien");
$res = mysql_fetch_array($str);
$num = $res[noreg];
?>
<input type="hidden" id="numr" value="<?php echo $num; ?>" />
<div class="tombol">
<a href="?menu=peg&mod=fpeg&act=n" title="Tambah data baru">Tambah data baru</a>
</div><br />
<div>
<table class="display" cellspacing="0" width="100%" id="tabelpeg">
<thead>
<tr>
<th>ID</th>
<th>Nama Pegawai</th>
<th>Gender</th>
<th>Alamat</th>
<th>Telpon</th>
<th>Kelas</th>
<th>Edit</th>
</tr>
</thead>
</table>
</div>
[removed]
$(document).ready(function() {
var numr = $('#numr').val();
$('#tabelpeg').dataTable({
"bJQueryUI": true,
"processing": true,
"serverSide": true,
"iDisplayStart": 1,
"iDisplayLength": 15,
"iTotalRecords": numr,
"iTotalDisplayRecords": 15,
"sEcho": 15,
"bPaginate":true,
"sPaginationType":"full_numbers",
"sAjaxSource": "modul/pegawai/json.php",
"sServerMethod": "POST",
"sAjaxDataProp": "data",
"columns": [
{data: "0","searchable": true},
{data: "1","searchable": true},
{data: "2","searchable": true},
{data: "3","searchable": true},
{data: "4","searchable": true},
{data: "5","searchable": true},
null
]
});
});
[removed]
Spoiler for json.php :
<?php
include("../../koneksi.php");
$jmlreq = isset($_REQUEST["iTotalRecords"]);
$disreq = isset($_REQUEST["iTotalDisplayRecords"]);
$page = isset($_REQUEST["iDisplayStart"]);
$rows = isset($_REQUEST["iDisplayLength"]);
$str = mysql_query("SELECT noreg,nama,alamat,tlpas,umur,sex From datapasien");
$array = array();
while ($ary = mysql_fetch_array($str)) {
$array[] = array("0" => $ary[noreg],
"1" => $ary[nama],
"2" => $ary[tlpas],
"3" => $ary[umur],
"4" => $ary[sex],
"5" => $ary[alamat],
"6" => "<a >Edit</a>");
}
$result["data"] = $array;
header("Content-type: application/json");
echo json_encode($result);
?>