jQuery Grid Plugin - jqGrid - Topic: JSON Format with PHP/Zend Framework = empty table

ivano on JSON Format with PHP/Zend Framework = empty table

Mon, 13 Jul 2009 15:18:28 +0300

This is working for me:

public function indexAction() {

        $response->page = 1;
        $response->total = 4;
        $response->records = 22;
        $response->rows = array(
                    array("id" => 1, "cell" => array("Quantum of Solace","Marc Forster","2008","Daniel Craig","200")),
                    array("id" => 2, "cell" => array("Casino Royale","Martin Campbell","2006","Daniel Craig","150")),
                    array("id" => 3, "cell" => array("Die Another Day","Lee Tamahori","2002","Pierce Brosnan","142")));

        $this->_helper->json($response);

}

saltcreep on JSON Format with PHP/Zend Framework = empty table

Thu, 09 Jul 2009 16:24:21 +0300

I've noticed more differences between my working version and what is being returned…

Actually, a lot of differences, including quotations, brackets, etc…. I'm going to punt and try xml or build the json string manually.

Just thought I would mention it if anyone else decides to try JSON with the Zend Framework & JQGrid.

saltcreep on JSON Format with PHP/Zend Framework = empty table

Thu, 09 Jul 2009 15:52:45 +0300

I have been fighting the JSON monster all mornin and I'm afraid he's winning, I can not figure away around this to get JQGrid working.

I'm using the JSON with Zend Framework, I don't see where any options can be specified when you call the encoding function. I've also tried a different version of JSON.php as well. I'm getting curly brackets ({}'s) instead of the other brackets ([]'s) to outline the rows section.. JQGrid does not render anything with these type of brackets… Any ideas would be very much appreciated on a way to work around this.

Thanks, Brandon

Does not work.. this is what the PHP JSON RETURNS

{”page”:1,”total”:4,”records”:323,
“rows”:{
“1″:{”id”:”0000020003″,”cell”:["0000020003","username-1"]},

“2″:{”id”:”0000020003″,”cell”:["0000020004","username-2"]}

}}

This works

{”page”:1,”total”:4,”records”:323,
“rows”:[
"1":{"id":"0000020003","cell":["0000020003","username-1"]},

“2″:{”id”:”0000020003″,”cell”:["0000020004","username-2"]}

]}