1. #1
    Sencha User
    Join Date
    May 2012
    Posts
    1
    Vote Rating
    0
    ionosphere is on a distinguished road

      0  

    Default Retrieving MySql Queries to JSON in Architect - how?

    Retrieving MySql Queries to JSON in Architect - how?


    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?

  2. #2
    Sencha Premium Member
    Join Date
    May 2010
    Location
    Guatemala, Central America
    Posts
    1,260
    Vote Rating
    79
    ssamayoa is a jewel in the rough ssamayoa is a jewel in the rough ssamayoa is a jewel in the rough ssamayoa is a jewel in the rough

      0  

    Default


    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.
    UI: Sencha Architect 3.x / ExtJS 4 & 5
    Server side: JEE / EJB 3.x / CDI / JPA 2.x/ JAX-RS / JasperReports
    Application Server: Glassfish / WildFly
    Databases: Oracle / DB2 / MySQL / Firebird

    If you like my answer please vote!

  3. #3
    Sencha Premium Member intellix's Avatar
    Join Date
    Mar 2012
    Location
    UK + Malta
    Posts
    263
    Vote Rating
    18
    intellix will become famous soon enough

      0  

    Default


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

  4. #4
    Sencha User
    Join Date
    Apr 2012
    Posts
    8
    Vote Rating
    0
    d.velev is on a distinguished road

      0  

    Default I have done this using php

    I have done this using php


    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.
    Attached Files

  5. #5
    Sencha Premium Member
    Join Date
    May 2010
    Location
    Guatemala, Central America
    Posts
    1,260
    Vote Rating
    79
    ssamayoa is a jewel in the rough ssamayoa is a jewel in the rough ssamayoa is a jewel in the rough ssamayoa is a jewel in the rough

      0  

    Default


    Quote Originally Posted by d.velev View Post
    After a day of reading a finally got a working CRUD Example for Sencha Architect 2
    Excellent!

    A good starting point for newcomers.

    Regards.
    UI: Sencha Architect 3.x / ExtJS 4 & 5
    Server side: JEE / EJB 3.x / CDI / JPA 2.x/ JAX-RS / JasperReports
    Application Server: Glassfish / WildFly
    Databases: Oracle / DB2 / MySQL / Firebird

    If you like my answer please vote!

  6. #6
    Sencha User
    Join Date
    Feb 2012
    Posts
    3
    Vote Rating
    0
    NitinMishra123 is on a distinguished road

      0  

    Default How do we manage double click in Sencha Architect

    How do we manage double click in Sencha Architect


    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

  7. #7
    Sencha Premium Member
    Join Date
    May 2010
    Location
    Guatemala, Central America
    Posts
    1,260
    Vote Rating
    79
    ssamayoa is a jewel in the rough ssamayoa is a jewel in the rough ssamayoa is a jewel in the rough ssamayoa is a jewel in the rough

      0  

    Default


    Quote Originally Posted by NitinMishra123 View Post
    But I want to know how that can be done in Architect.
    In an event handler as you would with hand coded application...
    UI: Sencha Architect 3.x / ExtJS 4 & 5
    Server side: JEE / EJB 3.x / CDI / JPA 2.x/ JAX-RS / JasperReports
    Application Server: Glassfish / WildFly
    Databases: Oracle / DB2 / MySQL / Firebird

    If you like my answer please vote!

  8. #8
    Sencha User
    Join Date
    Nov 2011
    Posts
    1
    Vote Rating
    0
    page10 is on a distinguished road

      0  

    Default


    Quote Originally Posted by d.velev View Post
    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,