IT 405 SEU PHP and MySQL Based Web Application Programming Code

College of Computing and InformaticsProject
Deadline: Thursday 12/05/2022 @ 23:59
[Total Mark is 15]
Student Details:
Name:
CRN:
ID:
Instructions:
•
•
•
•
•
•
•
•
•
•
You must submit two separate copies (one Word file and one PDF file) using the Assignment Template on
Blackboard via the allocated folder. These files must not be in compressed format.
It is your responsibility to check and make sure that you have uploaded both the correct files.
Zero mark will be given if you try to bypass the SafeAssign (e.g. misspell words, remove spaces between
words, hide characters, use different character sets, convert text into image or languages other than English
or any kind of manipulation).
Email submission will not be accepted.
You are advised to make your work clear and well-presented. This includes filling your information on the cover
page.
You must use this template, failing which will result in zero mark.
You MUST show all your work, and text must not be converted into an image, unless specified otherwise by
the question.
Late submission will result in ZERO mark.
The work should be your own, copying from students or other resources will result in ZERO mark.
Use Times New Roman font for all your answers.
Description and Instructions
Pg. 01
Description and Instructions
Project Objective:
This project is an opportunity for you to practice your knowledge in PHP and MySQL.
It will allow you to develop skills of working in teams.
Project Description:
This project is about the creation of PHP and MySQL based web application in which
you will be required to upload the given data into MySQL database using PHP. You
are required to fulfill the following requirements.
Download the XAMPP server by following the link.
Download XAMPP (apachefriends.org)
1. Install XAMPP on your laptop/computer
2. Go to Kaggle Dataset or Google dataset search
https://www.kaggle.com/datasets
https://datasetsearch.research.google.com/
3. Download any dataset as a CSV file
4. Import CSV File into MySQL using PHP
5. Create an HTML form.
Description and Instructions
Pg. 02
6. Write PHP script for connecting to XAMPP and MySQL database.
7. Execute MySQL query from php using HTML form.
8. Create Dynamic Data Visualization with PHP and MySQL.
9. Create users Registration and Login System with PHP and MySQL.
Marking Criteria:
The program is error-free
/10
HTML form is designed correctly with proper interface
/20
The data is loaded into MySQL database properly
/20
The user registration and login system work properly
/20
Data visualization is achieved
/10
Output screenshots in the report
/10
The code is well documented (commented)
/10
Presentation
/50
Total
Final Grade
/150
/15
Answer
Pg. 03
Learning
Outcome(s):
LO3: Create web
databases using
MySQL.
LO4: Build web
applications using
PHP and MySQL
Answer
10 Marks for project + 5 marks for presentation
1. Brief description
Provide a brief description of your program in this section.
2. Program code
Put the code of your program in this section. Also, submit the source code in a
separate zip file. Do not forget to document (comment) on your code.
3. Screenshots
Put the different screenshots with a brief description in this section (at least 6
screenshots).
Pg. 04
Answer