PDA

View Full Version : Retrieving MySql Queries to JSON in Architect - how?



ionosphere
5 May 2012, 5:11 AM
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
6 May 2012, 2:51 PM
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
6 May 2012, 11:42 PM
Aye as above, then a JSONP proxy to retrieve the data afterwards into a model/store

d.velev
8 May 2012, 11:01 AM
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
8 May 2012, 11:34 AM
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
16 May 2012, 7:43 AM
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
16 May 2012, 7:54 AM
But I want to know how that can be done in Architect.


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

page10
21 May 2012, 5:05 PM
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,