Project Phase 2

Deadline: Tuesday 13/04/2021 @ 23:59
[Total Mark for this Assignment is 5]

Web Technologies

IT230

College of Computing and Informatics

Project
5 Marks

Learning Outcome(s):

2. Design and manipulate web databases.
5. Build web applications using PHP or similar languages.

In the Phase II, the same website will be extended by adding dynamic content using PHP, and MYSQL server. (5 Marks)

SQL

Create and populate a new database in MySQL (2 or 3 tables).

1

PHP+DB

Select records from MySQL database using PHP

1

Insert records into MySQL database using PHP.

1.5

Update records into MySQL database using PHP

1.5

Total

5

Important Notes:

· The number of PHP pages must be at least 3
· The Website must connect to a database (1 Select+ 1 Insert+ 1 Update queries)
· Use the same theme across the website.

Each student/group has to prepare

1.
IT230_Project x:

a. The student must use the same file(IT230_Project_Phase_2 x) to prepare his answer.
b. For the SQL part, the student must copy and paste the SQL code used to create the Database and add a screenshot of the different tables of the created database in MYSQL.
c. For the part PHP +DB, the student must copy and paste the PHP code and add screenshots of the output with a brief explication of each functionality of the web application.
For the insertion and the update of the records, the student must also add screenshots of the modified tables before and after the execution of the PHP code.
d. Prepare a PDF version of this file.
2.
Project.zip:
contains all the files of the whole project (HTML, CSS, JS, PHP, and SQL).

Student will upload:

1. IT230_Project_Phase_2 x
2. IT230_Project_Phase_2
3. Project_Phase_2.zip
SQL
1 Mark

Learning Outcome(s):
2. Design and manipulate web databases.

PHP+DB (SELECT)
1 Mark

Learning Outcome(s):
2. Design and manipulate web databases.
5. Build web applications using PHP or similar languages.

PHP+DB (INSERT)
1.5 Marks

Learning Outcome(s):
2. Design and manipulate web databases.
5. Build web applications using PHP or similar languages.

PHP+DB (UPDATE)
1.5 Marks

Learning Outcome(s):
2. Design and manipulate web databases.
5. Build web applications using PHP or similar languages.