Quiz game

Got a LiveCode personal license? Are you a beginner, hobbyist or educator that's new to LiveCode? This forum is the place to go for help getting started. Welcome!

Moderators: FourthWorld, heatherlaine, Klaus, kevinmiller

Post Reply
calvax
Posts: 9
Joined: Fri Dec 30, 2011 6:10 pm

Quiz game

Post by calvax » Thu Dec 31, 2015 10:18 am

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

SparkOut
Posts: 2947
Joined: Sun Sep 23, 2007 4:58 pm

Re: Quiz game

Post by SparkOut » Thu Dec 31, 2015 10:52 am

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)

Post Reply