Using JSONReader

[dayour]

I'm a newbie to extjs and so far it looks great. I'm trying to integrate it with PHP but having some issues. The grid is defined as below and it tries to use a jsonreader to load data from the database

var ds = new Ext.data.Store({
    proxy: new Ext.data.HttpProxy({
        url: 'dataload.php'        
    }),

    reader: new Ext.data.JsonReader({
        root: 'countries'            
    }, [
    {name: 'id'},
    {name: 'code'},
    {name: 'country'}
    ]),

    remoteSort: true
});
ds.setDefaultSort('id', 'desc');

var countrygrid = new Ext.grid.GridPanel({
    store: ds,
    columns: [
        {id:'id', header: "id", width: 200, sortable: true, dataIndex: 'id'},
        {header: "Code", width: 120, sortable: true, dataIndex: 'code'},
        {header: "Country", width: 120, sortable: true, dataIndex: 'country'}        
    ],
    viewConfig: {
        forceFit: true
    },
    sm: new Ext.grid.RowSelectionModel({singleSelect:true}),
    width:600,
    height:300,
    frame:true,
    title:'Countries',
    iconCls:'icon-grid'
    
});
countrygrid.render('country-grid');
countrygrid.getSelectionModel().selectFirstRow(); 

ds.loadData(); 

the dataload.php file simply selects countries from the database and encodes it as follows

$jsonEncodedCountries = json_encode($arr);    
header('Content-Type', 'text/javascript');
    
 echo $jsonEncodedCountries; 

Even after doing this i do not see the data displayed in the grid? Please let me know what i'm missing

[halkon_polako]

Use ds.load() instead of ds.loadData()

[dayour]

this does not work either. Turning on Firebug to view the response shows that the response is null.
POST infor shows

dir DESC
sort id 

Header shows

Date Sat, 03 May 2008 16:12:17 GMT
ServerApache/2.0.63 (Win32) 
PHP/5.2.5X-Powered-ByPHP/5.2.5
ExpiresThu, 19 Nov 1981 08:52:00 GMT
Cache-Controlno-store, no-cache, must-revalidate, post-check=0, pre-check=0
Pragmano-cache
Content-Length4
Keep-Alivetimeout=15, max=85Connection
Keep-AliveContent-
Typetext/htmlRequest 
HeadersHostlocalhost
User-AgentMozilla/5.0 (Windows; U; Windows NT 5.1; en-GB; rv:1.8.1.14) Gecko/20080404 Firefox/2.0.0.14
Accepttext/xml,application/xml,application/xhtml+xml,text/html;q=0.9,text/plain;q=0.8,image/png,*/*;q=0.5Accept-Languageen-gb,en;q=0.5Accept-Encodinggzip,deflateAccept-CharsetISO-8859-1,utf-8;q=0.7,*;q=0.7Keep-Alive300Connectionkeep-aliveX-Requested-WithXMLHttpRequestContent-Typeapplication/x-www-form-urlencodedRefererhttp://localhost/seedcomputers/startpage.phpContent-Length16CookiePHPSESSID=92bcg8clomcc8nge2acvs4o914Pragmano-cacheCache-Controlno-cache 

for completeness the dataload.php is

$query1 = "select * from countries";
    $result= mysql_query($query1, $connGFriday) or die(mysql_error());
    $row = mysql_fetch_array($result);
    $countries  = array();
    while ($row = mysql_fetch_assoc($countries)) {
        $country = array();
        $country['id'] = $row['id'];
        $country['code'] = $row['code'];
        $country['country'] = $row['country'];
        $countries[] = $country;        
    }
    $jsonEncodedCountries = json_encode($arr);    
    header('Content-Type', 'text/javascript');
    
    echo $jsonEncodedCountries; 

[Animal]

dir DESC
sort id

That's the request.

What is your PHP scrips sending back?

[dayour]

it sends back a jsonencoded string made from an array of arrays. see below

$jsonEncodedCountries = json_encode($arr);    
    header('Content-Type', 'text/javascript');
    
    echo $jsonEncodedCountries; 

[Animal]

yehbut what does that look like? From Firebug.

[halkon_polako]

I don't know PHP, but ...what is $arr ?
Maybe you want to do :

$jsonEncodedCountries = json_encode($countries);

Also, as animal says, what is the response showed in firebug?

[dayour]

Firebug shows the following. This is only part of it as the string is quite long

[["4"," AFG","Afghanistan"],["5"," ALB","Albania"],["6"," ALG","Algeria"],["7"," ASA","American Samoa"],["8"," ADR","Andorra"],["9"," ANG","Angola"],["10"," AGI","Anguilla"],["11"," ANT","Antarctica"]] 

Do i need some sort of listner to get the data into the table after it's returned?

[elishnevsky]

This is a multi-dimensional array. In order for JsonReader to work your server-side script has to return an array of object literals. Something like this:

[{id:"4",code:"AFG",country:"Afghanistan"},{id:"5",code:"ALB",country:"Albania"]}...]

[dayour]

interestingly the way you create the array has an impact on the json encoding. using
a = array(b=>'itemb',c=>'itemc') generates didfferent json encoding from a['b'] = "itemb";a['c']="itemc".

None the less getting the encoding the eli mentioned did not work either, the json encoding is shown below. not usre if the quote around the identifiers make a difference. I haven't figured out a way to get them to disappear. Any other ideas?

[{"id":"4","code":" AFG","country":"Afghanistan"},{"id":"5","code":" ALB","country":"Albania"}