Guriddo » Topic: Subgrid data not loading

Subgrid data not loading

Guriddo
Subgrid data not loading

This topic has 0 replies, 1 voice, and was last updated 13 years, 4 months ago by olefrank.

Creator

Topic

March 15, 2013 at 4:37 pm #80820

olefrank

Participant

I'm new to JqGrid. I'm trying to make a grid with products. For each product I want a subgrid showing orders.

I can't load data in the subgrids. The 'load_sub_data_json.php' is never loaded…

Here's the JS my HTML file:

<div class="sfcode"><pre><br />
jQuery(document).ready(function() {<br />
$("#list").jqGrid({<br />
height: &#39;auto&#39;,<br />
blockui: true,<br />
altRows: true,<br />
loadonce: true,<br />
url:&#39;load_main_data_json.php&#39;,<br />
datatype: &#39;json&#39;,<br />
mtype: &#39;GET&#39;,<br />
colNames:[&#39;ProductCode&#39;,&#39;ProductName&#39;, &#39;ProductVendor&#39;],<br />
colModel :[<br />
{name:&#39;productcode&#39;, index:&#39;productcode&#39;, width:100, align:&#39;right&#39;},<br />
{name:&#39;productname&#39;, index:&#39;productname&#39;, width:280, align:&#39;right&#39;},<br />
{name:&#39;productvendor&#39;, index:&#39;productvendor&#39;, width:200, align:&#39;right&#39;}<br />
],<br />
rowNum:35,<br />
rowList:[25,50,75,100,125,150,175,200],<br />
sortname: &#39;productcode&#39;,<br />
sortorder: &#39;desc&#39;,<br />
viewrecords: true,<br />
caption: &#39;My first grid&#39;,<br />
subGrid: true,<br />
subGridUrl: &#39;load_sub_data_json.php&#39;,<br />
subGridModel: [<br />
{ name  : [&#39;Order number&#39;,&#39;Order date&#39;,&#39;Shipped date&#39;,&#39;Comments&#39;],<br />
index : [&#39;orderNumber&#39;, &#39;orderDate&#39;, &#39;shippedDate&#39;, &#39;comments&#39;],<br />
width : [55,100,100,200],<br />
align : [&#39;right&#39;,&#39;right&#39;,&#39;right&#39;,&#39;right&#39;],<br />
params: [&#39;productcode&#39;]<br />
}<br />
]<br />
});<br />
});<br />

jQuery(document).ready(function() {

$("#list").jqGrid({

height: 'auto',

blockui: true,

altRows: true,

loadonce: true,

url:'load_main_data_json.php',

datatype: 'json',

mtype: 'GET',

colNames:['ProductCode','ProductName', 'ProductVendor'],

colModel :[

{name:'productcode', index:'productcode', width:100, align:'right'},

{name:'productname', index:'productname', width:280, align:'right'},

{name:'productvendor', index:'productvendor', width:200, align:'right'}

],

rowNum:35,

rowList:[25,50,75,100,125,150,175,200],

sortname: 'productcode',

sortorder: 'desc',

viewrecords: true,

caption: 'My first grid',

subGrid: true,

subGridUrl: 'load_sub_data_json.php',

subGridModel: [

{ name : ['Order number','Order date','Shipped date','Comments'],

index : ['orderNumber', 'orderDate', 'shippedDate', 'comments'],

width : [55,100,100,200],

align : ['right','right','right','right'],

params: ['productcode']

}

]

});

And this is my php-file loading data to the subgrid:

<div class="sfcode"><pre><br />
<br />
include("dbconfig.php");<br />
<br />
$id = $_REQUEST[&#39;id&#39;];<br />
$productCode = $_REQUEST[&#39;productcode&#39;]; // param passed by query<br />
<br /><br />
// connect to the database<br />
$db = mysql_connect($dbhost, $dbuser, $dbpassword) or die("Connection Error: " .     mysql_error());<br />
<br />
// select database<br />
mysql_select_db($database) or die("Error conecting to db.");<br />
<br />
// select columns<br />
$SQL = "select o.orderNumber, o.orderDate, o.shippedDate, o.comments from orderdetails d inner join orders o on o.orderNumber = d.orderNumber where d.productcode=&#39;" . $id. "&#39;;";<br />
<br />
$result = mysql_query( $SQL ) or die("CouldnÂ’t execute query.".mysql_error());<br />
<br />
$response = new stdClass;<br />
$i=0;<br />
while($row = mysql_fetch_array($result,MYSQL_ASSOC)) {<br />
$response->rows[$i][&#39;id&#39;]=$row[&#39;orderNumber&#39;];<br />
$response->rows[$i]    [&#39;cell&#39;]=array($row[&#39;orderNumber&#39;],$row[&#39;orderDate&#39;],$row[&#39;shippedDate&#39;],$row[&#39;comments&#39;]);<br />
$i++;<br />
}<br />
<br />
echo json_encode($response);<br />
<br />

include("dbconfig.php");

$id = $_REQUEST['id'];

$productCode = $_REQUEST['productcode']; // param passed by query

// connect to the database

$db = mysql_connect($dbhost, $dbuser, $dbpassword) or die("Connection Error: " . mysql_error());

// select database

mysql_select_db($database) or die("Error conecting to db.");

// select columns

$SQL = "select o.orderNumber, o.orderDate, o.shippedDate, o.comments from orderdetails d inner join orders o on o.orderNumber = d.orderNumber where d.productcode='" . $id. "';";

$result = mysql_query( $SQL ) or die("CouldnÂ’t execute query.".mysql_error());

$response = new stdClass;

$i=0;

while($row = mysql_fetch_array($result,MYSQL_ASSOC)) {

$response->rows[$i]['id']=$row['orderNumber'];

$response->rows[$i] ['cell']=array($row['orderNumber'],$row['orderDate'],$row['shippedDate'],$row['comments']);

$i++;

}

echo json_encode($response);

You must be logged in to reply to this topic.

Stay connected with us in your favorite flavor!

Subgrid data not loading

Search Forum

Recent Replies

Forum Statistics

UserOnline