get data from local database into store or directly to list view.

[gunjan.vaishnav.hs]

Hello all,
I am using some list view in my sencha touch 2 app. Currently, the data in the list view is fetched from store where i have entered the static data.
Now i want the list view to be filled from the data from the database. I want to know how to fill the store data: attribute using the sql select queries..
Also i want that data to be displayed into the list view.

Here is the sample store.:

Ext.define('myap.store.mystore', {
	extend: 'Ext.data.Store',
   
	config: {
		autoLoad: true,      
		model: 'myapp.model.myappmodel',
		grouper: function(record) {
			return record.get('title');
		},
		data: [
{title: "Title 1", id: "titleOneID"},
{title: "Title 2", id: "titleTwoID"},
{title: "Title 3", id: "titleThreeID"},
{title: "Title 4", id: "titleFourID"},
{title: "Title 5", id: "titleFifthID"},


		]
    }
      
});

I am using the above store in the list view and accesing the items of the store like {title} to accessing the title in the itemTpl attribute.

Now, i want the data to be loaded from the local database of the browser (or the app).

Any help appreciated.
Thanks.

[mitchellsimoens]

You will need a web server like Apache with PHP to get data from a database to server up to your app.

[ehboym]

But HTML 5 can create a local database, can SENCHA use that ?

[haduki]

db.transaction(function(tx){
    tx.executeSql('select * from table;', [], 
         function (transaction, results){
             //todo success
 	     var data=[];
	     for (var i=0; i<results.rows.length; i++) {
	         var row = results.rows.item(i);
	         data[i]={};
	         data[i].id=row['id'];
	         data[i].name=row['name'];
                                        
	     }
             yourStore.setData(data);
             //or yourList.setData(data);
	  },
          function(){
              //todo error
          }
    );
})