jQGrid with JSON

http://www.trirand.com/blog/jqgrid/jqgrid.html jQGrid with JSON Tutorial

 

--
-- 表的结构 `book`
--

CREATE TABLE `book` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `no` int(11) NOT NULL,
  `title` varchar(255) NOT NULL,
  `author` varchar(30) NOT NULL,
  `publisher` varchar(30) NOT NULL,
  `year_published` year(4) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

book.php JSON

jqGrid获取json数据方法

 

{
  "page": "1",
  "total": "1",
  "records": "3",
  "rows": [
    {
      "id": "1",
      "cell": [
        "22",
        "title1",
        "author1",
        "publisher1",
        "2013"
      ]
    },
    {
      "id": "2",
      "cell": [
        "25",
        "title2",
        "author",
        "publisher2",
        "2014"
      ]
    }
  ]
}