Q1) write a PHP script that:
1- Creates a database which is called BookstoreShop
Q1) 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).
The primary key in Book table is Id.
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.
You should display appropriate errors message if occurring.
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.
You should display appropriate errors message if occurring.
o
Include the
screenshots of the webpage output as a part of your answer.
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.
Include the screenshots of the webpage output as a
part of your answer
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:
You should display appropriate error message if occurring
Use the following email for the bookstore shop email: Zainab. mohd@outlook.sa
Include the screenshots of the webpage output as a part of your answer.