jQuery Grid Plugin - jqGrid

Hello,

I am having same problem as Jiggazzzzs first problem, when I click the find button it returns all table records.

my code is:

javascript:

<?php // no direct access
defined( '_JEXEC' ) or die( 'Restricted access' );?>
<?php
    $myfirstgridpath=JURI::root().'modules/mod_Nderprerje/';
    
    $document =& JFactory::getDocument();
      
    $document->addStyleSheet($myfirstgridpath.'css/ui-lightness/jquery-ui-1.7.2.custom.css');
    $document->addStyleSheet($myfirstgridpath.'css/ui.jqgrid.css');
      
    $document->addScript($myfirstgridpath.'js/jquery-1.4.2.min.js');
    $document->addScript($myfirstgridpath.'js/i18n/grid.locale-en.js');
    $document->addScript($myfirstgridpath.'js/jquery.jqGrid.min.js');

?>

<script type="text/javascript">
    jQuery.noConflict();

    jQuery(document).ready(function(){
          jQuery("#list").jqGrid({
              url:'<?php echo $myfirstgridpath.'/datasource.php';?>',
              datatype: "xml",
              mtype:'GET',
              colNames:['ID','Emri','Kontrata', 'Data', 'Debia','Tipi','Zona'],
              colModel:[{name:'ID',index:'ID', width:50},
                  {name:'EMER_DEBITORI',index:'EMER_DEBITORI', width:100},
                  {name:'NR_CONT',index:'NR_CONT', width:60},
                  {name:'Joomla_Date_Shkeputje',index:'Joomla_Date_Shkeputje', width:110},
                  {name:'DEBIA_TOTALE',index:'DEBIA_TOTALE', width:80, align:"right"},
                  {name:'TIP_DESC',index:'TIP_DESC', width:70, align:"right"},
                  {name:'EMER_ZONE',index:'EMER_ZONE', width:80,align:"right"}],
              rowNum:10,
              loadonce:false,
              autowidth:true,
              rowList:[10,20,30,100],
              pager: jQuery('#pager'),
              sortname: 'ID',
              viewrecords: true,
              sortorder: "ASC",
              caption:"Lista e Debitoreve te nderprere",
              loadtext:"Ne kerkim, ju lutem prisni",
              toolbar:[true,"top"]
          });

        jQuery("#list").jqGrid('navGrid','#pager',{edit:false,add:false,del:false});

          });

</script>

<table id="list" class="search"></table>
<div id="pager" class="search" style="text-align:center;"></div>

and PHP:

<?php
//defined('_JEXEC',1) or die('Restricted access');
//defined( '_VALID_MOS' ) or die( 'Restricted access' );

//$host        = trim( $params->get( 'host' ) );
//$database        = trim( $params->get( 'database' ) );
//$user        = trim( $params->get( 'user' ) );
//$password        = trim( $params->get( 'password' ) );

$host     = 'host';
$user     = 'xxxxxx';
$password = 'xxxxx';
$database = 'xxxxxx';

$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
$db = mssql_connect($host, $user, $password) or die("Connection Error: " . mssql_error());
mssql_select_db($database) or die("Error conecting to db.");

$result = mssql_query("SELECT COUNT(*) AS count FROM [Joomla].[dbo].[DEBITOR_TE_SHKEPUTUR]");
$row = mssql_fetch_array($result,MSSQL_ASSOC);
$count = $row['count'];
$plus1='1';

if( $count >0 ) {
    $totalpages = ceil($count/$limit);
    } else {
    $totalpages = 0;
    }

if ($page > $totalpages) $page=$totalpages;
$start = ($limit*$page - $limit);
$start1=$start+$plus1;
$next=$start+$limit; // do not put $limit*($page - 1)
$SQL = "SELECT * FROM (SELECT row_number() OVER (ORDER BY ".$sidx."   ".$sord.") AS rownum ,ID,[EMER_DEBITORI],[NR_CONT] ,[Joomla_Date_Shkeputje],[DEBIA_TOTALE],[TIP_DESC],[EMER_ZONE] FROM [Joomla].[dbo].[DEBITOR_TE_SHKEPUTUR]) AS A
WHERE A.rownum BETWEEN ".$start1." and ".$next;
$result = mssql_query( $SQL ) or die("Couldn t execute query.".mssql_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>".$totalpages."</total>";
    echo "<records>".$count."</records>";

    // be sure to put text data in CDATA
    while($row = mssql_fetch_array($result,MSSQL_ASSOC)) {
        echo "<row id='". $row[ID]."'>";
            echo "<cell>". $row[ID]."</cell>";
            echo "<cell>". $row[EMER_DEBITORI]."</cell>";
            echo "<cell>". $row[NR_CONT]."</cell>";
          //echo "<cell>". $row[name]."</cell>";
        //  echo "<cell><![CDATA[". $row[Joomla_Date_Shkeputje]."]]></cell>";
            echo "<cell>". $row[Joomla_Date_Shkeputje]."</cell>";
            echo "<cell>". $row[DEBIA_TOTALE]."</cell>";
            echo "<cell>". $row[TIP_DESC]."</cell>";
            echo "<cell>". $row[EMER_ZONE]."</cell>";
     //     echo "<cell>". $row[note]."</cell>";
       //   echo "<cell><![CDATA[". $row[note]."]]></cell>";
        echo "</row>";
            
    }
               
    echo "</rows>";

    mssql_close($db)

?>

I can't find the problem, pleas a help will be great