attachment_1 (40)

College of Computing and Informatics 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. Assignment 2 Deadline: Thursday 30/11/2023 @ 23:59 [Total Mark for this Assignment is 8] E-Portals Development IT405 Student Details: Name: ### CRN: ### ID: ### ```

Pg. 1 Question TwoQuestion Two Question One 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. 4 Marks Learning Outcome(s): Create web databases using MySQL.

Pg. 3 Question TwoQuestion Two Question Two By using the previous BookstoreShop database, write a PHP script as 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. 2 Marks Learning Outcome(s): Build web applications using PHP and MySQL.

Pg. 4 Question TwoQuestion Two Question Three Write a PHP script that creates a contact form for the customers to let them 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. 2 Marks Learning Outcome(s): Build web applications using PHP and MySQL.