<?php require_once '../../../tabs.php'; ?> <!DOCTYPE html PUBLIC "//W3C//DTD XHTML 1.0 Strict//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.
dtd"> <html> <head> <title>jqGrid PHP Demo</title> <meta http-equiv="Content-Type" content="text/html; charset=utf-8" /> <link rel="stylesheet" type="text/css" media="screen" href="../../../themes/redmon d/jquery-ui-1.8.2.custom.css" /> <link rel="stylesheet" type="text/css" media="screen" href="../../../themes/ui.jqg rid.css" /> <link rel="stylesheet" type="text/css" media="screen" href="../../../themes/ui.mul tiselect.css" /> <style type="text"> html, body { margin: 0; /* Remove body margin/padding */ padding: 0; overflow: hidden; /* Remove scroll bars on browser window */ font-size: 75%; } .ui-elipsis {text-overflow:ellipsis; -mozbinding:url('../../../themes/ellipsis-xbl.xml#ellipsis') } </style> <script src="../../../js/jquery.js" type="text/javascript"></script> <script src="../../../js/i18n/grid.locale-en.js" type="text/javascript"></script> <script type="text/javascript"> $.jgrid.no_legacy_api = true; $.jgrid.useJSON = true; </script> <script src="../../../js/jquery.jqGrid.min.js" type="text/javascript"></script> <script src="../../../js/jquery-uicustom.min.js" type="text/javascript"></script> </head> <body> <div> <?php include ("grid.php");?> </div> <br/> <?php tabs(array("grid.php"));?> </body> </html>
grid.php.
<?php require_once '../../../jq-config.php'; // include the jqGrid Class require_once ABSPATH."php/jqGrid.php"; // include the driver class require_once ABSPATH."php/jqGridPdo.php"; // Connection to the server $conn = new PDO(DB_DSN,DB_USER,DB_PASSWORD); // Tell the db that we use utf-8 $conn->query("SET NAMES utf8"); // Create the jqGrid instance $grid = new jqGridRender($conn); // Write the SQL Query $grid>SelectCommand = 'SELECT OrderID, OrderDate, CustomerID, Freight, ShipNam e FROM longorders'; // 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('grid.php'); // Set some grid options $grid>setGridOptions(array("rowNum"=>100,"sortname"=>"OrderID","height"=>150)) ; // Change some property of the field(s) $grid->setColProperty("OrderDate", array( "formatter"=>"date", "formatoptions"=>array("srcformat"=>"Y-md H:i:s","newformat"=>"m/d/Y"), "search"=>false ) ); $grid->setColProperty("ShipName",array("classes"=>"ui-ellipsis")); // Enable toolbar searching $grid->toolbarfilter = true; $grid->setFilterOptions(array("stringResult"=>true)); // Enjoy $grid->renderGrid('#grid','#pager',true, null, null, true,true);
$conn = null; ?>
