Web Database Project – Phase 1
Think of a useful application for a database. If possible, try to come up with something that would be useful for you or a friend. Some ideas that come to mind are databases to organize your contact list, dvd collection, book collection (for a personal library), multi-media collection…etc.
Design a relational database to meet your needs for your application. Create your MySQL database using your web hosting account. I suggest using the PHPMyAdmin tool to create your tables. You can also use the PHPMyAdmin tool to populate your tables with some initial data. Put some thought into how you will organize your database before you start creating it in MySQL. Pay attention to things like primary keys and data types. I would suggest keeping the scope of your database somewhat reasonable. Keep in mind that what you create could be used in a portfolio (examples of projects completed as part of your course requirements) to show during a job interview. Your database must have a minimum of two tables.
In the following assignments you will have to create a home page that will link to your database pages that will pemit access to the database. You may want to create a home page now that is related to the database that you create for this assignment. Keep in mind that from the home page you will want to link to one or more pages to access the database. You will have to be able to link back to the home page on any pages you create.
When you have created your MySQL database, grab some screen shots of your tables in the PHPMyAdmin tool and paste them into a Word file (or similar format). Turn in this file with your screenshots into the appropriate submission box.
In the next project phase you will create a Web interface using PHP that will interface with your database.
Web Database Project: Phase 2
Create web pages for your database using PHP. You should have one page that will return all the information from the database. You should create additional pages that will allow you to do various queries of your database. You should be able to retrieve and insert data; also include functionality to delete data from your database. I will be looking for these features. Feel free to handle those functions however you feel is best for your project.
Create an html form that will allow you to enter in new information for the database. The information should be handled by a PHP script that will take the data and input it into the database.
The interface doesn’t have to look real pretty at this point. That will be done in the next phase. If you want to go ahead and make things look nice, feel free to do so.
If you have not yet created a home page, create a separate home page that contains links to each of the web pages you create to access your database. Your database (must have a minimum of two tables) is not to be displayed on the home page; be creative on this page. On each of the database pages create a button (link) to go back to the home page. Your project must have more than one page; your home page should have links to other pages to perform operations on the database. Some appropriate picture or image should be on the home page that relates to you project. Make your project look as professional as possible. You may want to show it during a interview.
Create a text file in which to store hyperlinks to your home page and PHP scripts. Turn in this file to the appropriate submission box.
Web Database Project: Phase 3
Now is the time to make your project look good and as professional as possible.
By now you should have created your MySQL database and PHP scripts that can be used to query, insert, and delete data. The objective of Phase 3 is to make it look nice. For example, you can use HTML in your PHP scripts to put the queried data into a table. You might also choose to create a style sheet to control colors, fonts, etc.
You must have a home page which links to other pages you have created to manipulate your database. Be sure that all pages have a button to link back to the home page and possibly buttons to link to other pages as necessary. If you only create one page and display everything on that page you will have not met the minimum requirement for this class. I will be looking to see if you put some real work into this final project.
When you have finished with your project, create a text file in which to turn in a hyperlink to your home page and if you wish hyperlinks to your PHP scripts. Include your name in this file and any other comments you choose to include about your project. Upload the file to the appropriate submission box.
Use the file naming convention shown in the drop box.