Page 2 of 2
Re: Little How To? use PHP and PDO communication with MYSQL
Posted: Tue Jan 23, 2018 2:13 pm
by matthiasr
For a long time we are using now Livecode desktop apps in combination with livecode server scripts on the webserver to access MySQL databases. No exposed dababase.
A very good tutorial how your Livecode desktop apps can connect to MySQL without exposing the database can be found here
https://www.hostm.com/tutorials/livecod ... iadb-mysql
You´ll even find a complete livecode server based api for download there.
Matthias
Re: Little How To? use PHP and PDO communication with MYSQL
Posted: Tue Jan 23, 2018 9:08 pm
by sphere
On many shared hosting providers you can not install lc server unfortunately.
Re: Little How To? use PHP and PDO communication with MYSQL
Posted: Tue Jan 23, 2018 9:40 pm
by matthiasr
Yes that´s true. But there are also many providers who either allow to install Livecode Server using .htaccess method or even install it if manual installation by the customer is not possible.
Sometimes the method described in the lesson about "how to install Livecode Server using .htaccess" is not suitable for all providers. Some providers need FilesMatch in association with SetHandler. So in case the described method in the lesson does not work one could try to use the other method. See an example below.
Options +ExecCGI
Action custom-livecode /cgi-bin/livecode-server-9dp6/livecode-server
<FilesMatch ".+\.lc$">
SetHandler custom-livecode
</FilesMatch>
Matthias
Re: Little How To? use PHP and PDO communication with MYSQL
Posted: Wed Jan 24, 2018 11:12 am
by sphere
thanks Matthiasr, unfortunately also installing via .htaccess is not allowed on the share hosting i'm with.
So i'll have to stick to PHP