Using $_GET with EasyUI not working

[nprioleau]

I want to build an embedded grid. I have success with the master detail but when trying to get the detail records, I don't get a result. I am using PHP Version 5.6.3. My code returns a json_result if I run it on it's own. The code as follows:

<?
require('kernal.php');

$itemid=mysqli_real_escape_string($db, $_REQUEST['id']);
print $itemid;
//print $itemid;
//$itemid=$_REQUEST['id'];
//print $itemid;
// Get sales
$getRows = $db->query(sprintf("SELECT *, p.prod_productID, p.prod_productName FROM sales_detail inner join products p on p.prod_productID = salesd_productID WHERE salesd_salesID = '$itemid' GROUP BY salesd_ID")) or SQLError();

while($row = $getRows->fetch_assoc()) {
    $rows[] = $row;
}
$smarty->assign('rowsNum', $total);
$smarty->assign('rows', $rows);
echo json_encode($rows);

?>

I have more or less copied the code from the demo site.
Can anyone help me please?

[stworthy]

Please make sure your code can return the correct json data back to the browser.