Connecting to a MySQL database at a hosting provider

John Allijn John at allijn.com
Fri Jan 7 12:50:47 EST 2011


Hi,

I' writing an iPad app. I want the app to get some shared data from a MySQL database. I've seen scripts for that and locally they all work great. 
However, I've got three websites, each with a different hosting provider, and they all have installed MySQL in such a way that you can only access the database from  within a webpage running at the hosting provider. For example with a PHP script.

I guess I'n not the first one who wants to pull data from a DB on the web :) 

Is there a way around that? like a special PHP script, or another kind of generally used interface that works as a server-side to my client-app?

The database itself is quite easy. just first/last name, email, a line of free format text and a date. I want to test if the user exists (is in the database), has paid his subscription (the date is an expiration date), and a system message specifically for that user (the free text field)

any suggestions????

best regards,
John.



More information about the use-livecode mailing list