project final

College of Computing and Informatics

Project
Deadline: Tuesday 03/12/2024 @ 23:59
[Total Mark is 14]
Student Details:

CRN:

Name:
Name:
Name:
Name:

ID:
ID:
ID:
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.

Restricted – ‫مقيد‬

Project Instructions

Pg. 01

Project Instructions
•

The work on this project must be performed by a group (minimum 3 and
maximum 4 students).

•

Each group leader must send an email with the team member’s
details (name & id) on 03/12/2024 (midnight). Note each group should
needs to be approved by your instructor.

•

The work should be your own; copying from students or other
resources will result in ZERO marks.

•

Submit the source code and all your application-related files in a
separate zip file. Do not forget to document (comment) on your code.

•

Work should be your own, copying from students or other resources
will result in ZERO marks.

•

You MUST show all your application code as text, code must not be
converted into an image.

•

You are advised to make your work clear and well-presented; marks may
be reduced for poor presentation. This includes filling in your information
on the cover page.

•

This project is worth 14 marks.

Project Overview:
In this project, you need to build a website based on your chosen idea. The
Website must cover all aspects of the course (Form handling, Sticky forms,
MySQL DB, sending email and handling file uploads, Sessions and Cookies,
prevent XSS attacks and SQL injection attacks) as follows:

Restricted – ‫مقيد‬

Project Instructions

Pg. 02

Introduction

Explain the idea of the project and the different
functionalities offered by the web application

1

The web application should contain at least one
Form
Handling

form handling. Be sure to validate all the elements
of the form. (1.5 marks)

2

The web application should contain at least one
sticky form (0.5 mark)
MYSQL DB

Create and populate a database in MySQL (at least
3 tables).

2

Select records from MySQL database using PHP
(at least 3 requests). Display the results using
different methods (Table, Lists,…) (3 marks)
SQL + PHP

Insert records into MySQL database using PHP (at

6

least 2 requests) (1.5 marks)
Update records into MySQL database using PHP
(at least 2 requests) (1.5 marks)
Sessions
Use sessions and cookies in your web application
and Cookies

1

prevent XSS attacks (1 mark)
Security
prevent SQL injection attacks (1 mark)
Total

Restricted – ‫مقيد‬

2
14

Project Instructions

Pg. 03
Important Notes:
•

The number of Web pages within the Website must be at least 8 web
pages.

•

The Website must connect to a database (3 Select + 2 Insert + 2 Update
queries)

•

The project needs to be submitted in BB (as an assignment) by the
Leader of the group members. Your project must be original work. The
project will be checked using a plagiarism tool. Any matching with an
online project or another/previous student project will be given ZERO.

Each student/group has to prepare
1. IT405_Project.zip
The zip file contains all the files of the web application
2. IT405_Project.docx + IT405_Project.pdf:
a. The student must use the same file (IT405_Project.docx) to
prepare group answers. He should add an introduction where he
explains the project idea and the different functionalities offered by
the web application.
b. For the Form handling part, the student must copy and paste, for
each web page, his/her HTML script and add a screenshot of the
output with a brief explication. The screenshots must cover
different scenarios.
c. For the MYSQL DB part, the student must copy and paste the SQL
code used to create and populate the database and add a
screenshot of the different tables of the created database in
MYSQL.

Restricted – ‫مقيد‬

Project Instructions

Pg. 04

d. For the part SQL + PHP, 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.
e. For the Sessions + cookies part, the student should explain how
the sessions and cookies have been used in the web application.
f. For the Security part, the student must copy and paste, his/her
code and add a screenshot of the output (of different scenarios)
with a brief explication.

Restricted – ‫مقيد‬

Introduction

Pg. 05
Learning
Outcome(s):
CLO1: Describe
methods and
tools in designing
a creative and
dynamic website

Restricted – ‫مقيد‬

Introduction

1 mark

Form Handling

Pg. 06
Learning
Outcome(s):
CLO1: Describe
methods and
tools in designing
a creative and
dynamic website
CLO4: Build web
applications using
PHP and MySQL

Restricted – ‫مقيد‬

Form Handling

2 marks

MySQL DB

Pg. 07
Learning
Outcome(s):
CLO3: Create
web databases
using MySQL

Restricted – ‫مقيد‬

MySQL DB

2 marks

SQL + PHP

Pg. 08
Learning
Outcome(s):
CLO4: Build web
applications using
PHP and MySQL

Restricted – ‫مقيد‬

SQL + PHP

6 marks

Sessions and Cookies

Pg. 09
Learning
Outcome(s):
CLO1: Describe
methods and
tools in designing
a creative and
dynamic website
CLO4: Build web
applications using
PHP and MySQL

Restricted – ‫مقيد‬

Sessions and Cookies

1 mark

Security

Pg. 10
Learning
Outcome(s):
CLO1: Describe
methods and
tools in designing
a creative and
dynamic website
CLO4: Build web
applications using
PHP and MySQL

Restricted – ‫مقيد‬

Security

2 marks

Purchase answer to see full
attachment