jQuery Grid Plugin - jqGrid

Hello together,

i have implementated the simple democode to show a jqGrid with jQuery in a HTML page.

The data type of the grid is json.

i collect the data from a firebird database of a php script.

here the html code:

Code:

...
<div id="pagecontrol-opliste-tabelle">
    <table id="table-liste">
    </table>
    <div id="pager-liste">
    </div>
</div>
...

here is the javascript code:

Code:

$(document).ready(function(){
    $("#pagecontrol-opliste").tabs();
   
    $("#table-liste").jqGrid({
        url: 'Sql.php',
        datatype: "json",
        colNames: ['Lfd. Nr', 'Kategorie', 'Kunde', 'Stichwort', 'Ersteller', 'Bearbeiter', 'Status'],
        colModel: [{
            name: 'lfdnr',
            index: 'lfdnr',
            width: 55
        }, {
            name: 'kategorie',
            index: 'kategorie',
            width: 90
        }, {
            name: 'kunde',
            index: 'kunde',
            width: 100
        }, {
            name: 'stichwort',
            index: 'stichwort',
            width: 80
        }, {
            name: 'ersteller',
            index: 'ersteller',
            width: 80
        }, {
            name: 'bearbeiter',
            index: 'bearbeiter',
            width: 80
        }, {
            name: 'status',
            index: 'status',
            width: 150,
            sortable: false
        }],
        rowNum: 10,
        rowList: [10, 20, 30],
        pager: '#pager-liste',
        sortname: 'lfdnr',
        viewrecords: false,
        sortorder: 'asc',
        caption: "OP Liste",
        scrollrows: true
    });
   
    $("#table-liste").jqGrid('navGrid', '#pager-liste', {
        edit: false,
        add: false,
        del: false
    });    
});

here is the php code:

Code:

<?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
    $dbh = ibase_connect ('localhost:C:xampphtdocsOPManagerDatabaseOPManager.GDB', 'SYSDBA', 'masterkey');

    $stmt = 'SELECT count(*) FROM OP';
    $result = ibase_query($dbh, $stmt);
    
    $row = ibase_fetch_assoc($result);
    $count = $row["COUNT"];
    //echo $count . "<br>";

    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)
    //$start = 1;
    $SQL = "SELECT FIRST $limit SKIP $start LFDNR, KATEGORIE, ERSTDATUM, STICHWORT, ERSTELLER, BEARBEITER, STATUS FROM OP ORDER BY $sidx $sord";
    //echo $start . "-" . $limit . "<br>";
    //echo $SQL . "<br>";
    $result = ibase_query($dbh, $SQL);

    $responce->page = $page;
    $responce->total = $total_pages;
    $responce->records = $count;
    $i=0;
    while($row = ibase_fetch_assoc($result)) {
        $responce->rows[$i]['id']=$row[lfdnr];
        $responce->rows[$i]['cell']=array($row["LFDNR"],$row["KATEGORIE"],$row["ERSTDATUM"],$row["STICHWORT"],$row["ERSTELLER"],$row["BEARBEITER"],$row["STATUS"]);
        $i++;
    }
           
    echo json_encode($responce);
    
    ibase_close($dbh);   
?>

if i now try to select second or the third or .... for any time the first row was selected and deselected.

in the example on:

http://trirand.com/blog/jqgrid/jqgrid.html

it is possible to select any row and it is possible to search a record.
In my Grid i cant search for a record. After i click on search nothing is happend.

have anyone a idea what can i do?