Creating a webpage by using mySQL specifially by PHPMyAdmin

CSCI 380, Web Programming and Interfaces

June 28 th

, 2021 Course Project Instructions and Guidelines

The course project of this course is a showcase of what you have been learning and a demonstration of your continuously developing skillet. 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, personal collections such as DVD’s, coins, books (a personal library), multi- media …etc. Other options include personal finances or diet and workout trackers. Decide on your application of choice which will be your course project. Remember that this part of the course work is worth 55% of the course grade. The project development will be divided into three phases to help you better manage your milestones.

Web Database Project - Phase 1: Database design 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. You may want to create a home page now that is related to the database that you are creating for the project. 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. In the following phases of the project you will have to create a home page that will link to your database pages that will permit access to the database. Deliverables for Phase1: 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 dropbox (project_phase1). In the next project phase you will create a Web interface using PHP that will interface with your database.

Web Database Project - Phase 2: In this phase you will 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 the following CRUD features:

 Create - Inserting data using SQL INSERT commands (or equivalent for NoSQL)

 Read - Reading the data from the database SQL SELECT commands (or equivalent for NoSQL)

 Update - Update the existing data in the database using SQL UPDATE commands (or equivalent for NoSQL)

 Delete - Delete existing data in the database using SQL DELETE commands (or equivalent for NoSQL)

NOTE: Apart from the original CREATE TABLE (DDL) commands all the remaining data operation (DML) commands need to be executed via your web application. 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 an interview. Deliverables for Phase2: Create a text file in which to store hyperlinks to your home page and PHP scripts. Turn in this file to the appropriate submission dropbox (project_phase2).

Web Database Project - Phase 3: Now is the time to make your project look good and as professional as possible using CSS. 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 project. I will be looking to see if you put some real work into this final project. Deliverables for Phase3: When you are 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 dropbox (project_phase3). For all submissions: use the file naming convention we have been using throughout the course: lastname_firstname.txt