jQuery Grid Plugin - jqGrid - Topic: Simple jqGrid doesnt work for me http://www.trirand.com/blog/?page_id=393/help/simple-jqgrid-doesnt-work-for-me Simple:Press Version 5.7.5.3 dbalagosa on Simple jqGrid doesnt work for me http://www.trirand.com/blog/?page_id=393/help/simple-jqgrid-doesnt-work-for-me#p28238 Help http://www.trirand.com/blog/?page_id=393/help/simple-jqgrid-doesnt-work-for-me#p28238 SORRY for wasting your time, but after 10 minutes I already solved it. WEIRD because I never understood that error had a great impact.

below is my new grid.php code

===================================

<?php

$db = mysql_connect('localhost:3307', 'root', 'root')
or die("Connection Error: " . mysql_error());

mysql_select_db('ipiwms') or die("Error conecting to db.");

$SQL = "SELECT `no`, `order`, `serve`, `item` FROM book";
$result = mysql_query( $SQL ) or die("Couldn t execute query.".mysql_error());

$i=0;
while($row = mysql_fetch_array($result,MYSQL_ASSOC)) {
    $responce->rows[$i]['id']=$row['no'];
    $responce->rows[$i]['cell']=array($row['no'], $row['order'],$row['serve'],$row['item']);
    $i++;
}        
echo json_encode($responce);
?>

===================================

As you can see I deleted all the unnecessary stuff and went straight to the select query.

]]> Thu, 07 Feb 2013 13:46:20 +0200 dbalagosa on Simple jqGrid doesnt work for me http://www.trirand.com/blog/?page_id=393/help/simple-jqgrid-doesnt-work-for-me#p28236 Help http://www.trirand.com/blog/?page_id=393/help/simple-jqgrid-doesnt-work-for-me#p28236 I used the below statement for my grid.php test

localhost/jgrid/grid.php?page=1&rows=2&sidx=no&sord=asc

seems ok with one error as shown below (also shown below is its result from json)

( ! ) SCREAM: Error suppression ignored for
( ! ) Warning: Creating default object from empty value in C:wampwwwjgridgrid.php on line 28
Call Stack
# Time Memory Function Location
1 0.0008 146752 {main}( ) ..grid.php:0

{"page":"1″,"total":1,"records":"2″,"rows":[{"id":"1","cell":["1","ABC","DEF","GHI"]},{"id":"2″,"cell":["2","JKL","MNO","PQR"]}]}

]]> Thu, 07 Feb 2013 13:27:22 +0200 dbalagosa on Simple jqGrid doesnt work for me http://www.trirand.com/blog/?page_id=393/help/simple-jqgrid-doesnt-work-for-me#p28235 Help http://www.trirand.com/blog/?page_id=393/help/simple-jqgrid-doesnt-work-for-me#p28235 index.html

==========================

<html>
<head>
<link rel="stylesheet" type="text/css" media="screen" href="css/jquery-ui-custom.css">
<link rel="stylesheet" type="text/css" media="screen" href="css/ui.jqgrid.css">
<link rel="stylesheet" type="text/css" media="screen" href="css/ui.multiselect.css">
<script type="text/javascript" src="jquery-1.7.2.min.js" ></script>
<script type="text/javascript" src="jquery.jqGrid.min.js" ></script>
<script type="text/javascript" src="i18n/grid.locale-en.js" ></script>

<script>
jQuery(document).ready(function(){
jQuery("#list2").jqGrid({
       url:'grid.php?q=2',
    datatype: "json",
       colNames:['No','Order', 'Serve','Item'],
       colModel:[
           {name:'no',index:'no', width:55},
           {name:'order',index:'order', width:70},
           {name:'serve',index:'serve', width:70},    
        {name:'item',index:'item', width:70}
       ],
       rowNum:20,
       rowList:[10,20,30],
       pager: '#pager2',
       sortname: 'no',
    viewrecords: true,
    sortorder: "desc",
    caption:"JSON Example"
});
jQuery("#list2").jqGrid('navGrid','#pager2',{edit:false,add:false,del:false});
});
</script>
</head>
<body>
<div id="report">
        <table id="list2"></table>
        <div id="pager2">
        </div>
<div>
</body>
</html>

=================

END OF INDEX.HTML

grid.php

=================

<?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
$db = mysql_connect('localhost:3308', 'root', 'root')
or die("Connection Error: " . mysql_error());

mysql_select_db('ipiwms') or die("Error conecting to db.");
$result = mysql_query("SELECT COUNT(*) AS count FROM book");
$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 `no`, `order`, `serve`, `item` FROM book ORDER BY $sidx $sord LIMIT $start , $limit";
$result = mysql_query( $SQL ) or die("Couldn t execute query.".mysql_error());

$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['no'];
    $responce->rows[$i]['cell']=array($row['no'], $row['order'],$row['serve'],$row['item']);
    $i++;
}        
echo json_encode($responce);
?>

=================

END OF GRID.PHP

ipiwms.sql

=================

/*
SQLyog Enterprise - MySQL GUI v7.02
MySQL - 5.0.27-community-nt : Database - ipiwms
*********************************************************************
*/

/*!40101 SET NAMES utf8 */;

/*!40101 SET SQL_MODE=''*/;

/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;

USE `ipiwms`;

/*Table structure for table `book` */

DROP TABLE IF EXISTS `book`;

CREATE TABLE `book` (
  `no` int(11) NOT NULL auto_increment,
  `order` varchar(255) default NULL,
  `serve` varchar(30) default NULL,
  `item` varchar(30) default NULL,
  PRIMARY KEY  (`no`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

/*Data for the table `book` */

insert  into `book`(`no`,`order`,`serve`,`item`) values (1,'ABC','DEF','GHI');
insert  into `book`(`no`,`order`,`serve`,`item`) values (2,'JKL','MNO','PQR');

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;

=================

END OF IPIWMS.SQL

]]> Thu, 07 Feb 2013 13:23:50 +0200