Retrieving MySql Queries to JSON in Architect - how?

[ionosphere]

I have followed several EXTJS + PHP + MYSQL tutorials and somehow I am still confused on retrieving MySql Queries to JSON in Sencha Architect.

Currently, I want to know the process of the following:

1. Where is the part in Sencha Architect that I can request for MySql queries?
2. Is conversion for MySql to JSON in Architect automatic? Or must I need something else?

[ssamayoa]

ExtJS and Sencha Touch are UI / client side frameworks.
Sencha Architect is for UI construction only.
Data access code must be written at the server side with your favority web language/framework, say: ASP.NET, PHP, Java, Ruby, etc.

Regards.

[intellix]

Aye as above, then a JSONP proxy to retrieve the data afterwards into a model/store

[d.velev]

After a day of reading a finally got a working CRUD Example for Sencha Architect 2. Its on this forum and its named: ErnestoR-Extjs4_PHP_MySQL-417807b.zip
There is a working extjs example with php on the backend, connecting to MySQL Database
C Create
R Read
U Update
D Delete

I reAttach the zip file. Its located at github as well.

[ssamayoa]

After a day of reading a finally got a working CRUD Example for Sencha Architect 2

Excellent!

A good starting point for newcomers.

Regards.

[NitinMishra123]

I understand that Sencha Architect is just for creating UI and the rest programming can be handled in the Server. But how do we handle actions like double click.

Say you have a grid with data being populated from the database.Now you want to double click any row and get more info about that row on a pop up. I know the code for that.
But I want to know how that can be done in Architect.

Thanks in Advance
Nitin

[ssamayoa]

But I want to know how that can be done in Architect.

In an event handler as you would with hand coded application...

[page10]

After a day of reading a finally got a working CRUD Example for Sencha Architect 2. Its on this forum and its named: ErnestoR-Extjs4_PHP_MySQL-417807b.zip
There is a working extjs example with php on the backend, connecting to MySQL Database
C Create
R Read
U Update
D Delete

I reAttach the zip file. Its located at github as well.

Thank you very much for the files. Was wondering if you can include .xda file in the archive as well? This will be very useful for beginner like me.

Thanks & Regards,