User interface written in PHP and HTML for MySQL database application
Posted on 2004-11-21
I am new to programming and web development so please be nice and don’t take anything for granted. I have been studying HTML, XHTML, PHP and MySQL. I have also studied, to some extent, Java and C++, but I am a novice in each area. I have read the books, but I have 0 practical experience.
My goal is this, I want to develop a custom database application that has a web user interface. For this project, I have selected the Apache web server, MySQL and PHP as the technologies to develop my custom application.
I have already created my database and tables within MySQL. I now need to develop a user interface to interact with this database. My vision is to have the main interface window contain (3) framesets. The first frameset would be on the left of the screen. The other two framesets would be divided equally vertically on the right side of the screen as such:
| | 2 |
| 1 |________|
| | 3 |
In frameset 1 I would have options such as New Employee, Products, Customers, Opportunities, etc… Let’s take New Employees for example. When you click New Employees in frameset 1 frameset 2 would displays a tabbed interface where each tab contains related items that you can enter for a specific employee. The tabs would be on top and would be labeled such as General, Detailed, etc… Once you click submit, the new employee is added to the MySQL database and the result is displayed in frameset 3.
I setup the basic window layout using framesets and I know how to display the results in frameset 3 by using “target” in <form> of frameset 2, but I do not know how to do the following:
1. Create the tabbed interface for frameset 2.
2. How to take all the values from the different tabs in frameset 2 to create an INSERT MySQL statement.
I would be greatly indebted to someone if they could provide me either examples or something that I could use to help me pull all this together. Once I understand how to accomplish such tasks, then I feel I could apply the concepts to the rest of the application.
Finally, could you please provide me with what resources you find useful in trying to develop such applications. I have several books, but none of them really cover developing user interfaces in PHP and HTML for database application that utilize MySQL.