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
jqGrid JSON page BLANK - Help needed
19/11/2009
07:22
Avatar
kurk
New Member
Members
Forum Posts: 1
Member Since:
19/11/2009
sp_UserOfflineSmall Offline

Hello,

Someone can tell me why this super simple example doesn´t work.  Thanks!

<?php

switch($_GET['ajax'])
{
    case 'getData':
    echo getData();
    exit;
    break;
}

function getData()
{
   
 $respuesta['total'] = 7;
 $respuesta['page'] = 1;
 $respuesta['records'] = 7;
   
 $respuesta['rows'][0]['id'] = 1;
 $respuesta['rows'][0]['cell'] = array("id" => 1, "invdate", 2, "name" => "carlos", "aumount" => 10, "tax" => 1, "total" => 2, "note" => "caca");  
 
 $respuesta['rows'][1]['id'] = 2;
 $respuesta['rows'][1]['cell'] = array("id" => 1, "invdate", 2, "name" => "carlos", "aumount" => 10, "tax" => 1, "total" => 2, "note" => "caca");  
 
 $respuesta['rows'][2]['id'] = 3;
 $respuesta['rows'][2]['cell'] = array("id" => 1, "invdate", 2, "name" => "carlos", "aumount" => 10, "tax" => 1, "total" => 2, "note" => "caca");  
 
 $respuesta['rows'][3]['id'] = 4;
 $respuesta['rows'][3]['cell'] = array("id" => 1, "invdate", 2, "name" => "carlos", "aumount" => 10, "tax" => 1, "total" => 2, "note" => "caca");  
 
 $respuesta['rows'][4]['id'] = 5;
 $respuesta['rows'][4]['cell'] = array("id" => 1, "invdate", 2, "name" => "carlos", "aumount" => 10, "tax" => 1, "total" => 2, "note" => "caca");  
 
 $respuesta['rows'][5]['id'] = 6;
 $respuesta['rows'][5]['cell'] = array("id" => 1, "invdate", 2, "name" => "carlos", "aumount" => 10, "tax" => 1, "total" => 2, "note" => "caca");  
 
 $respuesta['rows'][6]['id'] = 7;
 $respuesta['rows'][6]['cell'] = array("id" => 1, "invdate", 2, "name" => "carlos", "aumount" => 10, "tax" => 1, "total" => 2, "note" => "caca");  
 
 return json_encode($respuesta);
}
 
?>
<!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=utf-8" />
<title>HCe - 4.0 - Alpha - 18 11 2009 13:09:56 </title>
<link href="inc/libs/js/jquery/ui-smoothness/jquery-ui-1.7.2.custom.css" rel="stylesheet" type="text/css"/>
<link rel="stylesheet" type="text/css" href="inc/libs/js/jquery/themes/ui.jqgrid.css" />

<script type="text/javascript" src="inc/libs/js/jquery/jquery.min.js"></script>
<script type="text/javascript" src="inc/libs/js/jquery/jquery.ui.min.js"></script>
<script type="text/javascript" src="inc/libs/js/jquery/jquery.jqgrid.min.js"></script>

<script type="text/javascript" language="javascript">
$(document).ready(
 function()
 {
    $("#list2").jqGrid(
    {
           url:'testGrid.php?ajax=getData',
           datatype: "json",
           colNames:['Inv No','Date', 'Client', 'Amount','Tax','Total','Notes'],
           colModel:[
               {name:'id',index:'id', width:55},
               {name:'invdate',index:'invdate', width:90},
               {name:'name',index:'name asc, invdate', width:100},
               {name:'amount',index:'amount', width:80, align:"right"},
               {name:'tax',index:'tax', width:80, align:"right"},       
               {name:'total',index:'total', width:80,align:"right"},       
               {name:'note',index:'note', width:150, sortable:false}       
           ],
           root: 'rows',
           rowNum:10,
           rowList:[10,20,30],
           imgpath: 'img',      
           sortname: 'id',
        viewrecords: true,
        sortorder: "desc",
        caption:"JSON Example",
        width: 500
    });
 });
 
</script>

</head>
<body>
<table id="list2"  cellpadding="0" cellspacing="0"></table>
<div id="pager2" style="text-align:center;"></div>
</body>
</html>

21/11/2009
07:17
Avatar
tony
Sofia, Bulgaria
Moderator
Members

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

Hello,

For this type of response you will need to configure the jsonReader.

More you can finsd here:

http://www.trirand.com/jqgridw.....#json_data

Best 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:
67 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