Q$1.$

CLOIELO $12\mathrm{.}3/54/5$O$6$

$[2\mathrm{.}5$ points$]$

Using MySQL :

$1-$ Create a database "Customers"

$2-$ Create a table "customers Information" with $4$ columns as follow:

$1-$ customerld : type Integer, primary key.

$2-$ customerName varchar with $30$ characters in length.

$3-$ Adress varchar of length $40$ characters.

$4-$Level Decimal.

Q$2.$

CLO$/$PLO $12\mathrm{.}3/$S$4/$SO$6$

$[5$ points$]$

Write a Form "customersInfo.Html$"$ that allows you to enter the different information of customers. All fields are required.

When you click on the button "Save" the data are sent.

Write a php file "Insertcustomers.php$"$ that allows you to insert the data to the table and display the message "Save successfully" in case of successful insertion and "save failed" in case of rejection of insertion

Q$3.$

CLO$/$PLO $12\mathrm{.}3/$S$4/$SO$6$

$[7\mathrm{.}5$ points$]$

Write a "display" form that allows you to enter the ID of the customer whose information you want to display. When you click the button "Display", all of his or her information is displayed. If the ID is incorrect $($i$.$e$.$ the customer does not exist$),$ the system alerts the user.