First off, let me say that this will not be a public use site. We want to create a site that allows us to run queries in our database; this way we don't need to log into the MySQL server when ever we want to run a query.
Basically, I am trying to create something as simple as a form with a text-input and a submit button. In this text-input, we will write a query (such as SELECT * FROM xxxx). When we hit submit, we would like to have the MySQL table printed out in a large textbox below.
Our database has multiple tables, so something that works across the entire database seamlessly is key.
Has anyone ever made anything like this? Is there another way to go about this? We really just want an easy way to run queries on the go.
Thanks in advance to anyone who replies!