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
Little How To? use PHP and PDO communication with MYSQL
Moderators: FourthWorld, heatherlaine, Klaus, kevinmiller, robinmiller
Re: Little How To? use PHP and PDO communication with MYSQL
On many shared hosting providers you can not install lc server unfortunately.
-
- VIP Livecode Opensource Backer
- Posts: 190
- Joined: Sat Apr 08, 2006 7:55 am
- Location: Lübbecke, Germany
- Contact:
Re: Little How To? use PHP and PDO communication with MYSQL
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
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
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
So i'll have to stick to PHP