1. 5 May 2012 5:11 AM #1
    ionosphere
    ionosphere is offline
    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?
    Reply With Quote Reply With Quote
  2. 6 May 2012 2:51 PM #2
    ssamayoa
    ssamayoa is offline
    Sencha User
    Join Date
    May 2010
    Location
    Guatemala, Central America
    Posts
    979
    Vote Rating
    47
    ssamayoa has a spectacular aura about ssamayoa has a spectacular aura about
      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 2.x / ExtJS 4 MVC
    Server side: EJB 3.1 / CDI / JPA 2 / JAX-RS / JasperReports
    Application Server: Glassfish 3.1.x
    Databases: Oracle 10g & 11g / DB2 9 & 10 / Firebird 2.5

    If you like my answer please vote!
    Reply With Quote Reply With Quote
  3. 6 May 2012 11:42 PM #3
    intellix
    intellix is offline
    Sencha Premium Member intellix's Avatar
    Join Date
    Mar 2012
    Location
    UK + Malta
    Posts
    262
    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
    Reply With Quote Reply With Quote
  4. 8 May 2012 11:01 AM #4
    d.velev
    d.velev is offline
    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
    Reply With Quote Reply With Quote
  5. 8 May 2012 11:34 AM #5
    ssamayoa
    ssamayoa is offline
    Sencha User
    Join Date
    May 2010
    Location
    Guatemala, Central America
    Posts
    979
    Vote Rating
    47
    ssamayoa has a spectacular aura about ssamayoa has a spectacular aura about
      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 2.x / ExtJS 4 MVC
    Server side: EJB 3.1 / CDI / JPA 2 / JAX-RS / JasperReports
    Application Server: Glassfish 3.1.x
    Databases: Oracle 10g & 11g / DB2 9 & 10 / Firebird 2.5

    If you like my answer please vote!
    Reply With Quote Reply With Quote
  6. 16 May 2012 7:43 AM #6
    NitinMishra123
    NitinMishra123 is offline
    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
    Reply With Quote Reply With Quote
  7. 16 May 2012 7:54 AM #7
    ssamayoa
    ssamayoa is offline
    Sencha User
    Join Date
    May 2010
    Location
    Guatemala, Central America
    Posts
    979
    Vote Rating
    47
    ssamayoa has a spectacular aura about ssamayoa has a spectacular aura about
      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 2.x / ExtJS 4 MVC
    Server side: EJB 3.1 / CDI / JPA 2 / JAX-RS / JasperReports
    Application Server: Glassfish 3.1.x
    Databases: Oracle 10g & 11g / DB2 9 & 10 / Firebird 2.5

    If you like my answer please vote!
    Reply With Quote Reply With Quote
  8. 21 May 2012 5:05 PM #8
    page10
    page10 is offline
    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,
    Reply With Quote Reply With Quote

Tags for this Thread