Forum
Log In
Home
Topic RSS
Related Topics
13:23
07/02/2013
Offline
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
13:27
07/02/2013
Offline
I used the below statement for my grid.php test
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"]}]}
13:46
07/02/2013
Offline
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.
Most Users Ever Online: 715
Currently Online:
49 Guest(s)
Currently Browsing this Page:
1 Guest(s)
Top Posters:
OlegK: 1255
markw65: 179
kobruleht: 144
phicarre: 132
YamilBracho: 124
Renso: 118
Member Stats:
Guest Posters: 447
Members: 11373
Moderators: 2
Admins: 1
Forum Stats:
Groups: 1
Forums: 8
Topics: 10592
Posts: 31289
Newest Members:
, razia, Prankie, psky, praveen neelam, greg.valainis@pa-tech.comModerators: tony: 7721, Rumen[Trirand]: 81
Administrators: admin: 66
