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

no, my first problem is solved, it missed a 'loadonce: true'. Now I have a new problem with the search: for example, when I search therows where the id is less than 5, the search returns results where the id is equal to 1,2,3,4, 10 and 11. You Have an idea?

please excuse my English, I'm French and I use a translator.

I have a problem with navigator search.

When I click on the icon 'search', window 'search' opens and I can take my data to my research.

But when I click the Find button, nothing happens. The window 'search' remains open but nothing else, the rows of the grid correspond to all rows of my database.

This is my code :

HTML :

Javascript :

And, PHP :

if you have an idea, let me know!