PHP Coding School » Blog Archive » PHP MySQL Web Interface

Note: The archives category content is an automatically generated focus channel and does not neccessarily reflect the opinions of this blog. No responsibility is taken for the external links presented here, follow at your own discretion.

The archives content is never scraped from sites - but an abstract obtained from search engines.

PHP MySQL Web Interface

Problem

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.

All will become clear shortly!

You must be logged in to post a comment.

Problem	Solution	Example	Reference	Recommended
Following this link will help a bit, I hope! This 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). For example: This query selects all fields and rows with a limit of 2 rows, to be returned - directly submitted to the function. Function: MySQL Demo Query The next example drives the interface, which can then be submitted to the function. Notice it pre-selects mysql as the db (this is just for demo purposes, the table does not exit and mysql db is not accessible as this user). Interface: MYSQL Web Interface 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.

PHP MySQL Web Interface

Leave a Reply