selectLimit in JQgrid
- by Leander
Hallo,
I have a problem. I'am trying to get some data from my database. But with a limit. So i use the selectLimit command. But when i load the grid my firebug gives the following error:
"parsererror"?e:null},parse:function(d...d(a.fn.jqGrid,d);this.no_legacy_api||
When I go to the selectLimit in the jqgrid.php and print out what the function returns it normaly return an array with all 500 objects with the correct data. This is the code of the grid:
<?php
require_once ($_SERVER['DOCUMENT_ROOT'].'/includes_config/config.inc.php');
require_once ($_SERVER['DOCUMENT_ROOT'].'/portal/classes/core/database/class_Database_control.php');
$dtb = new clsDatabaseControl();
$dtb = $dtb->getDatabase(ConnectionString);
$dtb->doConnect();
require_once (ClassRoot.'/3rd/jqgrid/jq-config.php');
require_once (ClassRoot.'/3rd/jqgrid/php/jqGrid.php');
require_once (ClassRoot.'/3rd/jqgrid/php/jqGridPdo.php');
//require_once (ClassRoot.'/modules/logging/class_logging_control.php');
//
//$oLogginControl = new clsLoggingControl($dtb);
//$sSQL = $oLogginControl->getAanmeldingenGrid();
$sSQL = "SELECT LogAanmeldID, LogAanmeldStamp, UserFirstName, UserLastName, LogAanmeldIP, LogAanmeldMethod, LogAanmeldHost, LogAanmeldAgent FROM log_aanmelden, user WHERE log_aanmelden.LogAanmeldUserID = user.UserID";
$conn = new PDO(DB_DSN,DB_USER,DB_PASSWORD);
$conn->query("SET NAMES utf8");
$grid = new jqGridRender($conn);
//$grid->SelectCommand = $sSQL;
$grid->selectLimit($sSQL ,500,1);
$grid->dataType = 'json';
$grid->setColModel();
$grid->setUrl('modules/module_logging/index.php?grid=2');
$grid->setGridOptions(array(
"hoverrows"=>true,
//"sortname"=>"naam",
"height"=>450
));
// Enable toolbar searching
$grid->toolbarfilter = true;
$grid->setFilterOptions(array("stringResult"=>true));
$grid->navigator = true;
$grid->setNavOptions('navigator', array("excel"=>true,"add"=>false,"edit"=>false,"del"=>false,"view"=>true, "refresh"=>false));
$custom = <<<CUSTOM
$(document).ready(function()
{
gridParentWidth = $(window).width();
$('#grid').jqGrid('setGridWidth',gridParentWidth-10);
})
$(window).resize(function()
{
gridParentWidth = $(window).width();
$('#grid').jqGrid('setGridWidth',gridParentWidth-10);
});
function formatAddAdresboek(cellValue, options, rowObject)
{
var imageHtml = "<a href='?FFID=51000&TID=1&INS=3&contactID=" + cellValue + "' originalValue='" + cellValue + "'><img border='0' alt='Toevoegen aan Persoonlijk Adresboek' src='images/16X16/new_user.gif'/></a>";
imageHtml = imageHtml + " <a href='?FFID=51000&TID=2&INS=3&contactID=" + cellValue + "' originalValue='" + cellValue + "'><img border='0' alt='Toevoegen aan Praktijk Adresboek' src='images/16X16/new_usergroup.gif'/></a>";
return imageHtml;
}
function unformatAddAdresboek(cellValue, options, cellObject)
{
return $(cellObject.html()).attr("originalValue");
}
CUSTOM;
$grid->setJSCode($custom);
// Enjoy
$grid->renderGrid('#grid','#pager',true, null, null, true,true);
$conn = null;
?>
When I inspect the $_GET the answer is empty and in stead of a JSON tab there is an HTML tab. When i use the selectCommand in stead of the selectLimit it return all the data correct as an json object an parses it correcly in the grid but it doens't use the LIMIT, Because when i add the limit. PDO doens't work anymore.
So how do I get the object from the selectLimit to the grid?
Can someone please help me get the grid working?
