In Search of the Elusive Middleware Example

Creating desktop or client-server database solutions?

Moderators: Klaus, FourthWorld, heatherlaine, kevinmiller, robinmiller

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

Re: In Search of the Elusive Middleware Example

Post by sphere » Sun Apr 19, 2015 7:13 pm

Yes thanks!
..... but there is even a far more simple way, i read a bit on the stackoverflow site and tested it and the solution is very simple.

the whole database is UTF-8.

the script i used are edited in Notepad++, with coding as UTF8 (with BOM) , this BOM produces the characters you do not want to see.
So if you save the PHP scripts again with Notepad++ but then use coding UTF8 (without BOM) then the characters will not be shown in the livecode text fields.

So it simply has to do with the encoding of the scripts and the database, they have to match completely.

some usefull links:

http://en.wikipedia.org/wiki/Byte_order_mark#UTF-8
http://stackoverflow.com/questions/1505 ... 5#15051235
http://stackoverflow.com/questions/1446 ... ing-in-php
http://stackoverflow.com/questions/6779 ... characters
http://php.net/manual/en/mysqli.set-charset.php
http://stackoverflow.com/questions/2223 ... 41#6647241

ghettocottage
Livecode Opensource Backer
Livecode Opensource Backer
Posts: 362
Joined: Tue Apr 10, 2012 9:18 am

Re: In Search of the Elusive Middleware Example

Post by ghettocottage » Sun Apr 19, 2015 7:35 pm

Very interesting.

So you are working in Windows? I think that is a known bug. But you can fix that easily by installing Ubuntu.

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

Re: In Search of the Elusive Middleware Example

Post by sphere » Sun Apr 19, 2015 9:47 pm

Yes i'm working in Windows.
I tried that a few times, but i don't like Ubuntu. alltough it has some advantages.
It still feels not souplesse enough to me and above all that, my other hobby, making some music, and i tried it in Ubuntu, is totally nothing compared to windows or mac.
Total no support for vsti or from companies like Steinberg, Ableton etc etc etc i'm not going that adventure anymore.

If Commodore amiga had evolved like it should have then probably i would still be using that...ok this discussion is going to another direction.

But thanks for you suggestion.

istech
Posts: 130
Joined: Thu Sep 19, 2013 10:08 am

Re: In Search of the Elusive Middleware Example

Post by istech » Fri May 22, 2015 8:14 am

I think this discussion was very helpful and should be made into a official livecode tutorial. Maybe one of the mods could do this?

FourthWorld
VIP Livecode Opensource Backer
VIP Livecode Opensource Backer
Posts: 8012
Joined: Sat Apr 08, 2006 7:05 am
Location: Los Angeles
Contact:

Re: In Search of the Elusive Middleware Example

Post by FourthWorld » Fri May 22, 2015 3:28 pm

istech wrote:I think this discussion was very helpful and should be made into a official livecode tutorial. Maybe one of the mods could do this?
The moderators here are volunteers and may not have the time to also summarize threads into tutorials. However, if you or any other member of the community wants to do that I'd happily flag it as "sticky" in this forum so others can find it easily.
Richard Gaskin
Community volunteer LiveCode Community Liaison

LiveCode development, training, and consulting services: Fourth World Systems: http://FourthWorld.com
LiveCode User Group on Facebook : http://FaceBook.com/groups/LiveCodeUsers/

istech
Posts: 130
Joined: Thu Sep 19, 2013 10:08 am

Re: In Search of the Elusive Middleware Example

Post by istech » Mon Jun 15, 2015 2:58 pm

I hear you Richard and agree. Time is always a factor in any voluntary role. Maybe a request can be made to RunRev to get a official tutorial done as this could help a lot of people looking to develop and join the live code ranks. 8)

Presently I am still in the investigating level of this example. So would not be the best to write a extensive tutorial on this matter. But if that changes I will jump in feet legs and arms included. :lol:

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

Re: In Search of the Elusive Middleware Example

Post by sphere » Mon Jun 15, 2015 3:56 pm

Well there need to be some update as in the examples of the php scripts, direct mysql command will not be supported anymore as of 5.6 if i'm correct. So i was told on stackoverflow.com. So better is to learn PDO statements as this will be the future and/or use MYSQLi.

So for now this will work, but as soon your webhost updates his software it could be the case that it don't work anymore.

So i have to dive into that and in time change my script towards the new.
But for now it's working :)

Post Reply

Return to “Databases”