Forum

November 2nd, 2014
A A A
Avatar

Lost password?
Advanced Search

— Forum Scope —




— Match —





— Forum Options —





Minimum search word length is 3 characters - maximum search word length is 84 characters

The forums are currently locked and only available for read only access
sp_Feed Topic RSS sp_TopicIcon
Grid Empty
16/04/2009
07:37
Avatar
adryano
New Member
Members
Forum Posts: 1
Member Since:
16/04/2009
sp_UserOfflineSmall Offline

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&#39;,
 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>

20/04/2009
06:16
Avatar
tony
Sofia, Bulgaria
Moderator
Members

Moderators
Forum Posts: 7721
Member Since:
30/10/2007
sp_UserOfflineSmall Offline

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.

Forum Timezone: Europe/Sofia

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.com

Moderators: tony: 7721, Rumen[Trirand]: 81

Administrators: admin: 66

Comments are closed.
Privacy Policy   Terms and Conditions   Contact Information