Little How To? use PHP and PDO communication with MYSQL

Creating desktop or client-server database solutions?

Moderators: heatherlaine, Klaus, FourthWorld, robinmiller, kevinmiller

matthiasr
VIP Livecode Opensource Backer
VIP Livecode Opensource Backer
Posts: 65
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: 591
Joined: Sat Sep 27, 2014 10:32 am
Location: the Netherlands

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.
Sony HitBit HB75P MSX-1, Amiga 500 v1.3, Amiga 600, Amiga 1200, Pentium 1 and onwards to all loose PC crap boards which already was in the Amiga for ages not mentioning the startup speed, which we now have again with SSD :D

matthiasr
VIP Livecode Opensource Backer
VIP Livecode Opensource Backer
Posts: 65
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: 591
Joined: Sat Sep 27, 2014 10:32 am
Location: the Netherlands

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
Sony HitBit HB75P MSX-1, Amiga 500 v1.3, Amiga 600, Amiga 1200, Pentium 1 and onwards to all loose PC crap boards which already was in the Amiga for ages not mentioning the startup speed, which we now have again with SSD :D

Post Reply

Return to “Databases”