- Beranda
- Komunitas
- Tech
- 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
Urutan
Terbaru
Terlama
Guest
Tulis komentar menarik atau mention replykgpt untuk ngobrol seru
Komunitas Pilihan