| [ tanya url jason ]
if (isset($_GET['action']) && $_GET['action'] == 'getdata') { $page = (isset($_POST['page']))?$_POST['page']: 1; $rp = (isset($_POST['rp']))?$_POST['rp'] : 10; $sortname = (isset($_POST['sortname']))? $_POST['sortname'] : 'nama'; $sortorder = (isset($_POST['sortorder']))? $_POST['sortorder'] : 'asc'; $sort = "ORDER BY $sortname $sortorder"; $start = (($page-1) * $rp); $limit = "LIMIT $start, $rp"; $query = (isset($_POST['query']))? $_POST['query'] : ''; $qtype = (isset($_POST['qtype']))? $_POST['qtype'] : ''; $where = ""; if ($query) $where .= "WHERE $qtype LIKE '%$query%' "; $query = "SELECT iduser,username, password,nama, alamat,email "; $query_from =" FROM tbladmin "; $query .= $query_from . " $where $sort $limit"; $query_total = "SELECT COUNT(*)". $query_from." ".$where; $sql = mysql_query($query) or die($query); $sql_total = mysql_query($query_total) or die($query_total); $total = mysql_fetch_row($sql_total); $data = $_POST; $data['total'] = $total[0]; $datax = array(); $datax_r = array(); while ($row = mysql_fetch_row($sql)) { $rows['id'] = $row[0]; $datax['cell'] = $row; array_push($datax_r, $datax); } $data['rows'] = $datax_r; echo json_encode($data); exit;
$('#flex1').flexigrid ( { url: 'dataadmin&action=getdata', dataType: 'json', colModel : [ {display: 'aa', name : 'iduser', width : 10, sortable : true, align: 'left', process: doaction}, {display: 'Username', name : 'username', width : 100, sortable : true, align: 'left', process: doaction}, {display: 'bb', name : 'password', width : 10, sortable : true, align: 'left', process: doaction}, {display: 'Nama', name : 'nama', width : 200, sortable : true, align: 'left', process: doaction}, {display: 'Alamat', name : 'alamat', width : 150, sortable : true, align: 'left', process: doaction}, {display: 'Email', name : 'email', width : 150, sortable : true, align: 'left', process: doaction} ]
datanya kok gak muncul bagaimana yahh...?? urlnya yang bermasalah.. |
Tidak ada komentar:
Posting Komentar