Learning Goal: I’m working on a php multi-part question and need the explanation and answer to help me learn.

Question 1:

Suppose you want to build a web application for a new perfume shop; Therefore, you need to represent all information regarding the products and save it; To accomplish that, write a PHP code that:

  • Creates a database which is called PerfumeShop.
  • Within the previous database, creates a Product table to save products information: (Id, ProductName, Price).

Question 2:

By using the previous PerfumeShop database, write a PHP code that inserts three products to the table Product.

Question 3:

By using the previous PerfumeShop database, write a PHP code that deletes one product from the database.

Question 4:

Write a PHP code that creates a contact form for the customers to let them contact the Perfume shop by email.

When a user clicks on the Send! button, an email will be sent to Perfume Shop email.

Note:

  • You should take 2 screenshots.
  • Use your own email as the Perfume Shop email.
  • Fill the form as a customer(Screenshot number 1) and show the received message in your email (Screenshot number 2)

———-

Requirements:

  • No plagiarism.