Migrating Longitude and Latitude from mysql database

Good day again Corona pros, As We’ve developed in making our app work in using system.openurl() to set chrome as our default browser in our app. We now encountered a problem and we haven’t found a way on how to migrate or retrieve the data and put it in our app that uses google maps to make a specific pin. thanks in advance. if you have a problem in understanding my question, feel free to ask one question at a time. :slight_smile: Good day.

Would you be able to rephrase your question ? As I do not understand what you want to accomplish. 

Hi and thanks for the reply. So sorry for the vague question. I will start by asking one question.  I have a simple web application that display files from a database. Now , the question is that, can i pass the data from the database to my corona android app? thanks in advance for the reply.

Do you mean query information from a database on a web server ? or access a Sqlite database file part of you app ?

Corona SDK works well with web based apps, in particular if they are REST based.  But if you can make an HTTP GET call to get the data:

http://yoursite.com/somescript.php?somevar=someval&someothervar=someotherval

type request, the output will be captured in the callback function for our network.request() API.  See: http://docs.coronalabs.com/api/library/network/request.html

Now if you can control that script’s output to have it out JSON you’re golden because you can use our json library to convert it directly to a Lua table.  If it’s XML output you would need to find an XML parser (we have one in a blog post somewhere) as well as our Business Sample App, part of the RSS handler: https://github.com/coronalabs/business-app-sample)

If it’s in some other format, you would have to use the string library to parse it yourself.

Rob

yes to query the data from a mysql from a web app to a corona sdk app without using sql lite. , like posting some point in google map by inputting the longlat of a specific location. i hope i’m not confusing you sir. thanks for the reply.

Would you be able to rephrase your question ? As I do not understand what you want to accomplish. 

Hi and thanks for the reply. So sorry for the vague question. I will start by asking one question.  I have a simple web application that display files from a database. Now , the question is that, can i pass the data from the database to my corona android app? thanks in advance for the reply.

Do you mean query information from a database on a web server ? or access a Sqlite database file part of you app ?

Corona SDK works well with web based apps, in particular if they are REST based.  But if you can make an HTTP GET call to get the data:

http://yoursite.com/somescript.php?somevar=someval&someothervar=someotherval

type request, the output will be captured in the callback function for our network.request() API.  See: http://docs.coronalabs.com/api/library/network/request.html

Now if you can control that script’s output to have it out JSON you’re golden because you can use our json library to convert it directly to a Lua table.  If it’s XML output you would need to find an XML parser (we have one in a blog post somewhere) as well as our Business Sample App, part of the RSS handler: https://github.com/coronalabs/business-app-sample)

If it’s in some other format, you would have to use the string library to parse it yourself.

Rob

yes to query the data from a mysql from a web app to a corona sdk app without using sql lite. , like posting some point in google map by inputting the longlat of a specific location. i hope i’m not confusing you sir. thanks for the reply.