Little How To? use PHP and PDO communication with MYSQL

Creating desktop or client-server database solutions?

Moderators: FourthWorld, heatherlaine, Klaus, kevinmiller, robinmiller

matthiasr
VIP Livecode Opensource Backer
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

Post by matthiasr » Tue Jan 23, 2018 2:13 pm

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

sphere
Posts: 1145
Joined: Sat Sep 27, 2014 10:32 am
Location: Earth, Except when i Jump

Re: Little How To? use PHP and PDO communication with MYSQL

Post by sphere » Tue Jan 23, 2018 9:08 pm

On many shared hosting providers you can not install lc server unfortunately.

matthiasr
VIP Livecode Opensource Backer
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

Post by matthiasr » Tue Jan 23, 2018 9:40 pm

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

sphere
Posts: 1145
Joined: Sat Sep 27, 2014 10:32 am
Location: Earth, Except when i Jump

Re: Little How To? use PHP and PDO communication with MYSQL

Post by sphere » Wed Jan 24, 2018 11:12 am

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

Post Reply

Return to “Databases”