The grid works. The + opens the subgrid correctly and displays the header row. The correct number of rows display in the subgrid but are empty despite the correct json being created as displayed in firebug.
Code snippet for grid:-
// Create the jqGrid instance
$grid = new jqGridRender($conn);
// Write the SQL Query
// We suppose that mytable exists in your database
$grid->SelectCommand = “select uid,lastname,firstname,phonehome,phonework,mobile from students “.$where;
// set the ouput format to json
$grid->dataType = 'json';
// Let the grid create the model
$grid->setColModel();
// Set the url from where we obtain the data
$grid->setUrl('students/getstudents.php');
// Set grid caption using the option caption
$grid->setGridOptions(array(
Copyright 2014 TriRand LtdAll Rights ReservedRSS
Back to Top