facebook

Displaying data from a MySQL database – advice needed.

  1. MobiOne Archive
  2.  > 
  3. Getting Help – General
Viewing 3 posts - 1 through 3 (of 3 total)
  • Author
    Posts
  • #331987 Reply

    philipeft
    Member

    Hi,

    I have created a Mobione site and that works well. Now I am trying to add functionality and I am having problems.

    I want to get some data from a mySQL database and display it on the screen. But I cant seem to find anywhere that will tell me how to do exactly what I want…

    This is an idea of what I want to do…

    1. Have a list of available course types. (This is a standard mobione static screen that I can create ok)

    Available Course Types:
    Java Programming >
    MySQL and you >
    PHP Primer >
    HTML for Dummies >
    etc.

    2. When someone clicks on Java Programming, they get a list of “available courses” that we run on that topic…. looking something like this…

    Java Programming Courses:
    23rd June 2013 – £250 – in Birmingham >
    15th Sept 2013 – £250 – in London >
    etc.
    This screen is created dynamically using the data contained in the database.

    THEN… when they click on (for example) the London course, they get a screen that shows them all the extended details of the course, along with a button to book the course.

    All of this I can do on a standard HTML/PHP page, but I am struggling to do this within the Mobione/Jquery framework – because I cant see how I can DYNAMICALLY create a page that contains a list of items that can be selected for more details.

    Can anyone help me and tell me where is a good place to look for how to create those dynamic pages. Or point me to a tutorial?

    Many thanks!
    Philip.

    #332049 Reply

    Hi philipeft,

    1) Please see Wayne’s reply for a similar question on this thread: http://www.genuitec.com/support-genuitec/viewtopic.php?p=11094#p11094

    If you create the web api to return app data in json format, this Mobibike example might be helpful for you to learn how to get the data in mobione apps.
    http://www.genuitec.com/support-genuitec/viewtopic.php?f=14&t=1386

    2) You can modified manually the generated files and add your php code to populate your design. See http://www.genuitec.com/support-genuitec/viewtopic.php?f=14&t=1995

    #332067 Reply

    philipeft
    Member

    Great… many thanks!

Viewing 3 posts - 1 through 3 (of 3 total)
Reply To: Displaying data from a MySQL database – advice needed.

You must be logged in to post in the forum log in