Forum


07:37

16/04/2009

I use data from php, grid return empty. I see error in fire bug:
<br /> <b>Notice</b>: Use of undefined constant cd - assumed 'cd' in <b>C:\\wamp\\www\\grid\\g1.php</b> on line <b>40</b><br /> <br /> <b>Notice</b>: Use of undefined constant cd - assumed 'cd' in <b>C:\\wamp\\www\\grid\\g1.php</b> on line <b>41</b><br /> <br /> <b>Notice</b>: Use of undefined constant t1 - assumed 't1' in <b>C:\\wamp\\www\\grid\\g1.php</b> on line <b>41</b><br /> <br /> <b>Notice</b>: Use of undefined constant fg - assumed 'fg' in <b>C:\\wamp\\www\\grid\\g1.php</b> on line <b>41</b><br /> <br /> <b>Notice</b>: Use of undefined constant cd - assumed 'cd' in <b>C:\\wamp\\www\\grid\\g1.php</b> on line <b>40</b><br /> <br /> <b>Notice</b>: Use of undefined constant cd - assumed 'cd' in <b>C:\\wamp\\www\\grid\\g1.php</b> on line <b>41</b><br /> <br /> <b>Notice</b>: Use of undefined constant t1 - assumed 't1' in <b>C:\\wamp\\www\\grid\\g1.php</b> on line <b>41</b><br /> <br /> <b>Notice</b>: Use of undefined constant fg - assumed 'fg' in <b>C:\\wamp\\www\\grid\\g1.php</b> on line <b>41</b><br /> <br /> <b>Notice</b>: Use of undefined constant cd - assumed 'cd' in <b>C:\\wamp\\www\\grid\\g1.php</b> on line <b>40</b><br /> <br /> <b>Notice</b>: Use of undefined constant cd - assumed 'cd' in <b>C:\\wamp\\www\\grid\\g1.php</b> on line <b>41</b><br /> <br /> <b>Notice</b>: Use of undefined constant t1 - assumed 't1' in <b>C:\\wamp\\www\\grid\\g1.php</b> on line <b>41</b><br /> <br /> <b>Notice</b>: Use of undefined constant fg - assumed 'fg' in <b>C:\\wamp\\www\\grid\\g1.php</b> on line <b>41</b><br /> <br /> <b>Notice</b>: Use of undefined constant cd - assumed 'cd' in <b>C:\\wamp\\www\\grid\\g1.php</b> on line <b>40</b><br /> <br /> <b>Notice</b>: Use of undefined constant cd - assumed 'cd' in <b>C:\\wamp\\www\\grid\\g1.php</b> on line <b>41</b><br /> <br /> <b>Notice</b>: Use of undefined constant t1 - assumed 't1' in <b>C:\\wamp\\www\\grid\\g1.php</b> on line <b>41</b><br /> <br /> <b>Notice</b>: Use of undefined constant fg - assumed 'fg' in <b>C:\\wamp\\www\\grid\\g1.php</b> on line <b>41</b><br /> <br /> <b>Notice</b>: Use of undefined constant cd - assumed 'cd' in <b>C:\\wamp\\www\\grid\\g1.php</b> on line <b>40</b><br /> <br /> <b>Notice</b>: Use of undefined constant cd - assumed 'cd' in <b>C:\\wamp\\www\\grid\\g1.php</b> on line <b>41</b><br /> <br /> <b>Notice</b>: Use of undefined constant t1 - assumed 't1' in <b>C:\\wamp\\www\\grid\\g1.php</b> on line <b>41</b><br /> <br /> <b>Notice</b>: Use of undefined constant fg - assumed 'fg' in <b>C:\\wamp\\www\\grid\\g1.php</b> on line <b>41</b><br /> {"page":"1","total":1,"records":"5","rows":[{"cd":"5","cell":["5","hh","10"]},{"cd":"4","cell":["4","nos" ,"4"]},{"cd":"3","cell":["3","ele","3"]},{"cd":"2","cell":["2","tu","2"]},{"cd":"1","cell":["1","eu" ,"1"]}]}
My files:
<?php
include("grid/dbconfig.php");
//since we want to use a JSON data we should include
//encoder and decoder for JSON notation
//If you use a php >= 5 this file is not needed
include("grid/JSON.php");
// create a JSON service
$json = new Services_JSON();
$page = $_GET['page']; // get the requested page
$limit = $_GET['rows']; // get how many rows we want to have into the grid
$sidx = $_GET['sidx']; // get index row - i.e. user click to sort
$sord = $_GET['sord']; // get the direction
if(!$sidx) $sidx =1;
// connect to the database
$db = mysql_connect($dbhost, $dbuser, $dbpassword)
or die("Connection Error: " . mysql_error());
mysql_select_db($database) or die("Error conecting to db.");
$result = mysql_query("SELECT COUNT(*) AS count FROM tabela_teste");
$row = mysql_fetch_array($result,MYSQL_ASSOC);
$count = $row['count'];
if( $count >0 ) {
$total_pages = ceil($count/$limit);
} else {
$total_pages = 0;
}
if ($page > $total_pages) $page=$total_pages;
$start = $limit*$page - $limit; // do not put $limit*($page - 1)
$SQL = "SELECT cd,t1,fg FROM tabela_teste ORDER BY $sidx $sord LIMIT $start , $limit";
$result = mysql_query( $SQL ) or die("Couldn t execute query.".mysql_error());
$responce->page = $page;
$responce->total = $total_pages;
$responce->records = $count;
$i=0;
while($row = mysql_fetch_array($result,MYSQL_ASSOC)) {
$responce->rows[$i]['cd']=$row[cd];
$responce->rows[$i]['cell']=array($row[cd],$row[t1],$row[fg]);
$i++;
}
echo json_encode($responce);
?>
html:
<!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>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
<title>Untitled Document</title>
<!-- In head section we should include the style sheet for the grid -->
<link rel="stylesheet" type="text/css" media="screen" href="grid/themes/sand/grid.css" />
<!-- Of course we should load the jquery library -->
<script src="grid/jquery.js" type="text/javascript"></script>
<!-- and at end the jqGrid Java Script file -->
<script src="grid/jquery.jqGrid.js" type="text/javascript"></script>
<link rel='stylesheet' type='text/css' media='screen' href='grid/themes/jqModal.css' />
<script type='text/javascript' src='grid/js/jqDnR.js'></script>
<script type='text/javascript' src='grid/js/jqModal.js'></script>
<script type='text/javascript' src='grid/js/json2.js'></script>
<script type='text/javascript' src='grid/js/grid.locale-pt-br.js'></script>
<script type='text/javascript' src='grid/js/jquery.tablednd.js'></script>
<script type='text/javascript' src='grid/js/grid.base.js'></script>
<script type='text/javascript' src='grid/js/grid.formedit.js'></script>
<script type='text/javascript' src='grid/js/grid.import.js'></script>
<script type="text/javascript">
jQuery(document).ready(function(){
jQuery("#list2").jqGrid({
url:'http://localhost/grid/g1.php?q=2',
datatype: "json",
//mtype: 'GET',
multiselect: true,
toolbar :[true,"bottom"], //?? how to use this toolbar ??
colNames:['cd','fg', 't1'],
colModel:[
{name:'cd',index:'cd', sorttype:"int"},
{name:'fg',index:'fg', width:90},
{name:'t1',index:'t1', sorttype:"int"}
],
rowNum:5,
rowList:[5,20,30],
imgpath: 'grid/themes/sand/images',
pager: jQuery('#pager2'),
sortname: 'cd',
viewrecords: true,
sortorder: "desc",
caption:"JSON Example"
}).navGrid('#pager2',{edit:true,add:true,del:true});
});
</script>
</head>
<body>
<table id="list2" class="scroll" cellpadding="0" cellspacing="0"></table>
<div id="pager2" class="scroll" style="text-align:center;"></div>
06:16

Moderators
30/10/2007

Hello,
This is not jqGrid problem.
Regards
Tony
For professional UI suites for Java Script and PHP visit us at our commercial products site - guriddo.net - by the very same guys that created jqGrid.
Most Users Ever Online: 715
Currently Online:
89 Guest(s)
Currently Browsing this Page:
1 Guest(s)
Top Posters:
OlegK: 1255
markw65: 179
kobruleht: 144
phicarre: 132
YamilBracho: 124
Renso: 118
Member Stats:
Guest Posters: 447
Members: 11373
Moderators: 2
Admins: 1
Forum Stats:
Groups: 1
Forums: 8
Topics: 10592
Posts: 31289
Newest Members:
, razia, Prankie, psky, praveen neelam, greg.valainis@pa-tech.comModerators: tony: 7721, Rumen[Trirand]: 81
Administrators: admin: 66