- Beranda
- Programmer Forum
[ASK] JSON Flexigrid kenapa data gak tampil ya ?
...
TS
diocio
[ASK] JSON Flexigrid kenapa data gak tampil ya ?
[ASK] JSON Flexigrid kenapa data gak tampil ya ?
buat juragan yg udah pernah pake Flexigrid ( [url]www.flexigrid.info[/url] ]
mohon petunjuknya kenapa ya data tidak tampil, cuma tampil kotak doang.
kalo data di debug sih udah bener seperti ini :
{"page":1,"total":"10","rows":[{"id":"TV","cell":["TV","Television"]},{"id":"RE","cell":["RE","Remote"]},{"id":"PL","cell":["PL","PLUMBER"]},{"id":"CO","cell":["CO","Computer"]},{"id":"4","cell":["4","Category 4"]},{"id":"34","cell":["34","Touch Pad"]},{"id":"3","cell":["3","Category 3"]},{"id":"22","cell":["22","Mouse"]},{"id":"2","cell":["2","categori 2"]},{"id":"1","cell":["1","categori 1"]}]}
Code untuk tampilin tb_categories.php
Code untuk tb_categories_data.php
buat juragan yg udah pernah pake Flexigrid ( [url]www.flexigrid.info[/url] ]
mohon petunjuknya kenapa ya data tidak tampil, cuma tampil kotak doang.
kalo data di debug sih udah bener seperti ini :
{"page":1,"total":"10","rows":[{"id":"TV","cell":["TV","Television"]},{"id":"RE","cell":["RE","Remote"]},{"id":"PL","cell":["PL","PLUMBER"]},{"id":"CO","cell":["CO","Computer"]},{"id":"4","cell":["4","Category 4"]},{"id":"34","cell":["34","Touch Pad"]},{"id":"3","cell":["3","Category 3"]},{"id":"22","cell":["22","Mouse"]},{"id":"2","cell":["2","categori 2"]},{"id":"1","cell":["1","categori 1"]}]}
Code untuk tampilin tb_categories.php
Code:
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
\t<meta http-equiv="content-type" content="text/html; charset=iso-8859-1" />
\t<title>Categories</title>
\t<link rel="stylesheet" type="text/css" href="flexigrid/css/flexigrid.css" />
\t<script type="text/javascript" src="js/jquery-1.2.3.pack.js"></script>
\t<script type="text/javascript" src="flexigrid/js/flexigrid.js"></script>
\t\t
<script type="text/javascript">
\t$(function() { $("#flex1").flexigrid({
url: 'tb_categories_data.php',
dataType: 'json',
colModel : [
{display: 'ID', name : 'id_cat', width : 40, sortable : true, align: 'left'},
{display: 'Description', name : 'nm_cat', width : 150, sortable : true, align: 'left'},
],
buttons : [
{name: 'Add', bclass: 'add', onpress : doCommand},
{name: 'Edit', bclass: 'edit', onpress : doCommand},
{name: 'Delete', bclass: 'delete', onpress : doCommand},
{separator: true}
],
searchitems : [
{display: 'ID', name : 'id_cat'},
{display: 'Description', name : 'nm_cat', isdefault: true},
],
sortname: "id",
sortorder: "asc",
usepager: true,
title: "Categories",
useRp: true,
rp: 10,
showTableToggleBtn: false,
resizable: false,
width: 700,
height: 370,
singleSelect: true
});
});
function doCommand(com, grid) {
\tif (com == 'Edit'/;)/ {
\t\t$('.trSelected', grid).each(function() {
\t\t\tvar id = $(this).attr('id'/;)/;
\t\t\tid = id.substring(id.lastIndexOf('row'/;)/+3);
\t\t\talert("Edit row " + id);
\t\t});
\t} else if (com == 'Delete'/;)/ {
\t\t$('.trSelected', grid).each(function() {
\t\t\tvar id = $(this).attr('id'/;)/;
\t\t\tid = id.substring(id.lastIndexOf('row'/;)/+3);
\t\t\talert("Delete row " + id);
\t\t});
\t}
}
</script>\t
</head>
<body>
\t<table id="flex1" style="display:none"></table>
</body>\t
</html>\t
Code untuk tb_categories_data.php
Code:
<?php
error_reporting(0);
session_start();
function countRec($con, $fname,$tname,$where) {
\t$sql = "SELECT count($fname) as fcount FROM $tname $where";
\t$rsl = $con->executeQuery($sql);
\t$rec = $con->loadResult();
\tforeach($rec as $fld){
\t\t$countRec = $fld->fcount;
\t}
\treturn $countRec;
}
function readRec($con, $tname, $where, $sort, $limit){
\t$sql = "select * from $tname $where $sort $limit";
\t$rsl = $con->executeQuery($sql);
\t$readRec = $con->loadResult();
\treturn $readRec;
}
$page = $_POST['page'];
$rp = $_POST['rp'];
$sortname = $_POST['sortname'];
$sortorder = $_POST['sortorder'];
if (!$sortname) $sortname = 'id_cat';
if (!$sortorder) $sortorder = 'desc';
if($_POST['query']!=''/;)/{
\t$where = "WHERE `".$_POST['qtype']."` LIKE '%".$_POST['query']."%' ";
} else {
\t$where = '';
}
if($_POST['letter_pressed']!=''/;)/{
\t$where = "WHERE `".$_POST['qtype']."` LIKE '".$_POST['letter_pressed']."%' ";\t
}
if($_POST['letter_pressed']=='#'/;)/{
\t$where = "WHERE `".$_POST['qtype']."` REGEXP '[[:digit:]]' ";
}
$sort = "ORDER BY $sortname $sortorder";
if (!$page) $page = 1;
if (!$rp) $rp = 10;
$start = (($page-1) * $rp);
$limit = "LIMIT $start, $rp";
require_once("dbmanager.class.php");
// Connection
$con = new dbmanager;
//read data to display
$records = readRec($con, 'tb_categories', $where, $sort, $limit);
//Count data
$total = countRec($con, 'id_cat','tb_categories',$where);
header("Expires: Tue, 31 Dec 2011 00:00:00 GMT" );
header("Last-Modified: " . gmdate( "D, d M Y H:i:s" ) . "GMT" );
header("Cache-Control: no-cache, must-revalidate" );
header("Pragma: no-cache" );
header("Content-type: text/x-json");
$data = array();
$data['page'] = $page;
$data['total'] = $total;
$data['rows'] = array();
foreach($records as $fld){
\t$data['rows'][] = array(
\t'id' => $fld->id_cat,
\t'cell' => array( $fld->id_cat, $fld->nm_cat )
//\t'cell' => array( 'id_cat' => $fld->id_cat, 'nm_cat' => $fld->nm_cat )
\t);
\t$rc = true;
};
echo json_encode($data);
?>
0
2.2K
2
Guest
Tulis komentar menarik atau mention replykgpt untuk ngobrol seru
Mari bergabung, dapatkan informasi dan teman baru!
Programmer Forum
20.2KThread•4.3KAnggota
Terlama
Guest
Tulis komentar menarik atau mention replykgpt untuk ngobrol seru