Hi All,
I am new to this, is there a sample code available somewhere that I can learn how to retrieve data from mysql? I have database host on the server, may I know how to connect to it and get the data?
Cheers,
DC [import]uid: 1995 topic_id: 1299 reply_id: 301299[/import]
There’s support for SQLite in the Corona SDK beta:
http://developer.anscamobile.com/demo/2.0BetaGuide.pdf (search for “SQLite”)
Not sure if it will work with an external database.
If not, you might be able to request a URL (page written in PHP, .NET, etc) that connects to the DB and returns the requested info. For example:
http://www.myserver.com/iPhoneGetListOfAllItems.php
http://www.myserver.com/iPhoneGetScore.php?userID=iphoneuser
http://www.myserver.com/iPhoneSetPlayerName.php?newPlayerName=Mike
See “Simple image downloading” in the Corona API Reference for Lua’s http.request for more info:
http://developer.anscamobile.com/demo/APIReference.pdf
-Mike
[import]uid: 7144 topic_id: 1299 reply_id: 3528[/import]