jQuery Grid Plugin - jqGrid

<?php

$page = $_GET['page']; // get the requested page

$limit = $_GET['rows']; // get how many rows we want to have into the grid

$sidx = $_GET['sidx']; // get index row – i.e. user click to sort

$sord = $_GET['sord']; // get the direction

if(!$sidx) $sidx =1;

// connect to the database

require “db.php”;

$result = mysql_query(”SELECT COUNT(*) AS count FROM Cert_Itm”);

$row = mysql_fetch_array($result,MYSQL_ASSOC);

$count = $row['count'];

if( $count >0 ) {

$total_pages = ceil($count/$limit);

} else {

$total_pages = 0;

}

if ($page > $total_pages) $page=$total_pages;

$start = $limit*$page – $limit; // do not put $limit*($page – 1)

$SQL = “SELECT CertRefNo, CertItemNo, ClientId, ItemDesc FROM Cert_Itm ORDER BY $sidx $sord LIMIT $start , $limit”;

$result = mysql_query( $SQL ) or die(”Couldn't execute query.”.mysql_error());

if ( stristr($_SERVER["HTTP_ACCEPT"],”application/xhtml+xml”) ) {

header(”Content-type: application/xhtml+xml;charset=utf-8″); } else {

header(”Content-type: text/xml;charset=utf-8″);

}

$et = “>”;

echo “<?xml version='1.0' encoding='utf-8'?$et\\n”;

echo “<rows>”;

echo “<page>”.$page.”</page>”;

echo “<total>”.$total_pages.”</total>”;

echo “<records>”.$count.”</records>”;

// be sure to put text data in CDATA

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

echo “<row id='”. $row[CertRefNo].”'>”;

echo “<cell>”. $row[CertRefNo].”</cell>”;

echo “<cell>”. $row[CertItemNo].”</cell>”;

echo “<cell>”. $row[ClientId].”</cell>”;

echo “<cell>”. $row[ItemDesc].”</cell>”;

echo “</row>”;

}

echo “</rows>”;

?>