loose on Problem with Add, Edit, Del, Search not working

Thu, 28 Nov 2013 20:30:12 +0200

I'm having some problems with Inline Navigator feature, when I try to add, edit, del, search, nothing happens, the grid just say loading, refresh and the record dont change.

[Image Can Not Be Found]

My Code:

index.php

<html>
<head>
    <title>Municipios</title>
    <link rel="stylesheet" type="text/css" media="screen" href="css/humanity/jquery-ui-1.10.3.custom.min.css" />
    <link rel="stylesheet" type="text/css" media="screen" href="css/ui.jqgrid.css" />

   <script src="js/jquery-1.9.0.min.js" type="text/javascript"></script>
    <script src="js/i18n/grid.locale-pt-br.js" type="text/javascript"></script>
    <script src="js/jquery.jqGrid.min.js" type="text/javascript"></script>

</head>

<body>

</body>
</html>

gridquery.php

<?php
$dbhost='xxxx';
$dbuser='xxxx';
$dbpassword='xxxx';
$database='xxxx';

$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;
// conectar no database
$db = mysql_connect($dbhost, $dbuser, $dbpassword)
or die("Connection Error: " . mysql_error());

mysql_select_db($database) or die("Erro ao conectar ao DB.");
$result = mysql_query("SELECT COUNT(*) AS count FROM municipios_ibge"); //count para saber numero elementos a serem impressos
$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 * FROM municipios_ibge ORDER BY $sidx $sord LIMIT $start , $limit";
$result = mysql_query( $SQL ) or die("Não foi possível executar a query.".mysql_error());

$responce = new StdClass;
$responce->page = $page;
$responce->total = $total_pages;
$responce->records = $count;
$i=0;
while($row = mysql_fetch_array($result,MYSQL_ASSOC)) {
     $responce->rows[$i]['id']=$row['codigo'];
    $responce->rows[$i]['cell']=array($row['codigo'],$row['municipio'],$row['uf']);
    $i++;
}
echo json_encode($responce);

scriptgrid.js

jQuery("#list2").jqGrid({
    url:'gridquery.php?q=2',
   datatype: "json",
    colNames:['Codigo','Municipio', 'UF'],
    colModel:[
    {name:'codigo',index:'codigo', width:150, editable:true},
    {name:'municipio',index:'municipio', width:500, editable:true},
    {name:'uf',index:'uf', width:70, editable:true},
    ],
    rowNum:10,
    rowList:[10,20,30],
    pager: '#pager2',
    sortname: 'codigo',
    height: 'auto',
    width:'auto',
    viewrecords: true,
    sortorder: "desc",
    editurl: "gridquery.php",
    caption:"Lista Municipios"
});
jQuery("#list2").jqGrid('navGrid','#pager2',{edit:true,add:true,del:true});
jQuery("#list2").jqGrid('inlineNav',"#list2");

Whats its the problem ?

jQuery Grid Plugin - jqGrid - Topic: Problem with Add, Edit, Del, Search not working

loose on Problem with Add, Edit, Del, Search not working