7/12/2010 9:45:28 AM
Title:
Connect to MYSQl
How to get data inside Adobe AIR from a MYSQL Database?
Help me please .
Thankyou
7/12/2010 12:35:47 PM
you need to use webservice for that . The webservice can be .net , php or some other server side language . flash makes request to the server side page and the page returns the results. Flash it self is not capable of communicating with MYSQL server. Adobe air supports sqlite database for direct access. All other database like sql, mysql, oracle require the webservice.
7/12/2010 12:52:34 PM
Adobe AIR supports single page database like sqlite which provides very limited functionality. If you are using a client side database then you have only this option. But if your database is located online then you can use any server side in-between to use any database. the communication is like this
Adobe air ----> PHP / ASP page -------> SQL/ ORACLE/ MYSQL database
here you can see that the AIR application will make request to Server script which in turn will execute the sql queries and return the data in XML or text format as required.
7/12/2010 1:01:43 PM
see this link for using httpservice
http://blog.flexexamples.com/2007/10/29/passing-parameters-to-an-httpservice/