Having written a ga-zillian scripts, to query dbs, decided it would be much simpler to call just one function multiple times, duh! 🙂
Then fulfilling business request after request – with many short php web pages calling the function. Decided to progressing this further – by removing the web page altogether (hitting the function via a wrapper). Let it handle the query, via variable parameters passed in on the HTTP GET.
This posed a bit of problem, pushing complexity on the enquirer. So then decided to write a web (interface) form to drive the function (wrapper) – which subsequently made the query. 🙂
Moved to github – View here
The web interface prepares the fields, which are subsequently submitted to the function for you.
You may notice that run_q is a PHP script, this is so you can either e-mail links directly to the function (genericQuery.php) or to this interface (run_q.php).
This query selects all fields and rows with a limit of 2 rows, to be returned – directly submitted to the function.
After the interface submits, the subsequent query to the function can be cut and paste from the browser address bar.
Also this interface shows all the possible functions, where you can get quite creative in your query – try it out.
[tags]PHP MySQL Web Interface, PHP Coding School[/tags]