Project: Web-based administration of MySQL
The project for this chapter will set the groundwork for the next several projects. We will write a program for administering MySQL remotely through a web interface. To be sure, more sophisticated applications like PHPMyAdmin exist. The value of creating one of your own is that you can extend it and change it in the future depending on your needs. Just creating the application is a good exercise as it leaves you with code that you can import into other applications at will and gives you a better understanding of the processes involved.
By the end of this project, we want a web application that will have the following aspects:
Ability to create MySQL statements for the following commands:
CREATE,DROP,INSERT,UPDATE, andSELECTExecute the created statement
Output the results of any queries and confirm the successful execution of other commands
Be written in a modular structure that allows different functions or methods to be used independently of the...
