ISP has no remote access on connecting to MySQL database. Now what?

[Guglielmo Braguglia]

Hi William,
as your first time, probably is not a good idea to start connecting to a 
remote DB using a PHP script ...

To start to learn, probably the best is to create a little 'TEST' 
environment locally ...

... if you run on MAC, you can install MAMP 
(http://www.mamp.info/en/mamp/index.html), if you run on WIN you can use 
WAMP (http://www.wampserver.com/en/). In this way you have a complete 
environment (Apache, MySQL and ... PHP) running on your system and you 
can do all the test you like.

After ... you can start play with a remote server ... :-)

Guglielmo



On 01.07.2012 20:07, William de Smet wrote:
> Hi Malte,
>
> Thanks, but I don't get it ;-(
> Do you mean I have to put the db_username and db_password etc. in a
> .php file on my server.
> But how do I connect? And how do I retrieve the data?
>
> Like I said: it's my first time on database!
>
> groeten,
>
> William
>
>
> 2012/7/1 Malte Brill <revolution at derbrill.de>:
>> Hi William,
>>
>> best bet is to implement a piece of middleware (e.G. a PHP script) you can get the data from. Then the server does the connection to the mySQL database and you retrieve the data using a http request.
>>
>> Hth,
>>
>> Malte
>>
>>
>> _______________________________________________
>> use-livecode mailing list
>> use-livecode at lists.runrev.com
>> Please visit this url to subscribe, unsubscribe and manage your subscription preferences:
>> http://lists.runrev.com/mailman/listinfo/use-livecode
> _______________________________________________
> use-livecode mailing list
> use-livecode at lists.runrev.com
> Please visit this url to subscribe, unsubscribe and manage your subscription preferences:
> http://lists.runrev.com/mailman/listinfo/use-livecode
>