Connecting to a MySQL database at a hosting provider
john at allijn.com
Sun Jan 9 09:39:26 EST 2011
Thanks for your reply: Last few day i've been trying to get this work, but it's more of a web-development problem than a runrev one.
I still can't get it to work, because I don't know how to setup my server-side. Still working on that one :(
Is there an example template for this that I could adapt? Or an easy tutorial? The problem is that when you start googling there is so much info that it is quite overwhelming..
On Jan 7, 2011, at 6:58 PM, Björnke von Gierke wrote:
> normally you'd create a php (or other scripted server side language) interface that queries the sql backend, or makes updates to it. But instead of outputting formatted html, you simply output machine parse-able content, like a tab delimited list, or xml. Then you can access the data, just as you would if you'd go directly into the mysql, but via an url that queries your scripted output:
> put url "http://yourServer.fake/showUser.php?user=blah&password=plainTextIsNotSecure"
> On 7 Jan 2011, at 18:50, John Allijn wrote:
>> 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,
>> use-livecode mailing list
>> use-livecode at lists.runrev.com
>> Please visit this url to subscribe, unsubscribe and manage your subscription preferences:
> official ChatRev page:
> Chat with other RunRev developers:
> go stack URL "http://bjoernke.com/chatrev/chatrev1.3b3.rev"
> use-livecode mailing list
> use-livecode at lists.runrev.com
> Please visit this url to subscribe, unsubscribe and manage your subscription preferences:
More information about the Use-livecode