Hello, I have a E-Portals Development IT405

Hello, I have a E-Portals Development IT405

I want a solution of my own and integrated to ensure the full degree. Please provide a Word and PDF file.

I want your words and your solution without copying.

College of Computing and Informatics
Assignment 2
Deadline: Thursday 30/11/2023 @ 23:59
[Total Mark for this Assignment is 8]
Student Details:
Name: ###
ID: ###
CRN: ###
“`
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.
Question One
Pg. 01
Learning
Outcome(s):
Create web
databases using
MySQL.
Question One
4 Marks
Suppose you want to build a web application for a new bookstore shop;
Therefore, you need to represent and save all information regarding the books.
To accomplish that, write a PHP script that:
1. Creates a database which is called BookstoreShop.
2. Within the previous database, creates a Book table to save books’
information: (Id, ProductName, Info, Price).
Important Notes:
o The primary key in Book table is Id.
o Use the following information when you create a connection with
MySQL in PHP:
▪
Use localhost as server name.
▪
Use your first name and last name (without
space between them) as username.
▪
User your own student ID as password.
o You should display appropriate errors message if occurring.
o Include the screenshots of the webpage output as a part of your
answer.
Question Two
Pg. 02
Learning
Outcome(s):
Question Two
2 Marks
By using the previous BookstoreShop database, write a PHP script as
Build web
applications using
PHP and MySQL.
follows:
1. Insert three books into the table Book.
2. Delete one book from the table Book.
Important Notes:
o You should make a connection with the database before conducting
previous operations in your script.
o You should display appropriate errors message if occurring.
o Include the screenshots of the webpage output as a part of your
answer.
Question Three
Pg. 03
Learning
Outcome(s):
Question Three
2 Marks
Write a PHP script that creates a contact form for the customers to let them
Build web
applications using
PHP and MySQL.
contact the bookstore shop by email. When a user clicks on the Send button,
an email will be sent to Bookstore Shop email.
Important Notes:
o You should display appropriate errors message if occurring.
o Use your own email as the Bookstore Shop email.
o Include the screenshots of the webpage output as a part of your
answer.