I would like to realize quiz game. In order to have possibility to add new questions and compare player's score, my app should access an online database.
I have a web hosting with php and mysql.
What is the correct procedure?
A) Livecode app can directly access mysql records on my hosting by sql queries
B) Livecode can only make an http request with specific url and I must make php code in my website that understand what livecode wants and make correct sql query?
Thanks
Quiz game
Moderators: FourthWorld, heatherlaine, Klaus, kevinmiller
Re: Quiz game
The definition of "correct" here is part of the answer. If it works, it may be "correct" but with an eye to a robust and secure method, choice B) is "preferred" (with a few superlatives for added emphasis). You can use LiveCode server side if you have it set up too, rather than php.
You will probably find your ISP blocks the ports for A) to work anyway, unless you jump through lots of hoops.
So short answer: go with B)
You will probably find your ISP blocks the ports for A) to work anyway, unless you jump through lots of hoops.
So short answer: go with B)