(Solved): Q2. Use HTML and CSS to design the layout given below. PHP/MySql Connect Create DB Insert Table Ins ...

Q2. Use HTML and CSS to design the layout given below. PHP/MySql Connect Create DB Insert Table Insert Record Additional Information: 1. Use HTML and CSS for the design of the layout. 2. Use the Java Script to change the Green button to the Grey button when the mouse is click. 3. Use PHP and SQL codes to do the following: For button Connect using SQL code : . When you click, it will check the connection to the server. • Display "Connection Successful For button Create DB using SQL code: • When you click the first time, it will create a Database in the webserver. Name your Database with yournameDB (example: azlazDB) Display "Database azlazDB Successful created" Second and more click, will check if the database already exist or not. • Display "Database azlazDB already exists" For button Insert Table: • When you click the first time, it will create a Table in the database you created. • Name your Table as FinalExam. . Add the fields as follows: examld int (10) not null primary key varchar (20) not null course studentname varchar(50) not null • Display "Table Successful created" . Second and more click, will check if the table already exist or not. . Display "Table FinalExam already exists" For button Insert Records: • When you click the first time, it will create a Records in the database you created. Name your Table as FinalExam. • Add two(2) records follows: 12345 Web Asma 12678 Math Shahad Display "Records Successful added" Second and more click, will check if there is a duplicate record. Check by entering the value: 12345 Database Sara • • Display "Error-Duplicate entry 12345 for key Primary" Connected Succesfully PHP/MySql Connect Create DB Insert Table Insert Record PHP/MySql Create DB Insert Table Insert Record Table Succes Sample Output: Successfully create alar Database PHP/MySql Connect Create D Insert Table Insert Record E-Tablettable lady PHP/MySql Connect Insert Table -No Rey 1234 PRIMARY PHP/MySql Connect Create DB Insert Tab Imert Recond Database are already exist PHP/MySql Connect Create DB Insert Table Insert Record New Record Success PHP/MySql Connect Create DB Insert Table Insert Record Instructions: • The output should be the same as in the given picture. • Save your all file with your name and the last three digit of your id (eg: azla223.html) Compress in one zip file and upload on the blackboard for submission Save all your files in your folder (name + last 3 digit of your id). QI.Use HTML, CSS, Java Script and PHP to design the calculator as shown in the given diagram below: (12 Marks) PHP Calculator Num 1: Num 2: Result: Add Subtract Multiply Divide Sample Output, when click Add and Divide PHP Calculator PHP Calculator 20 000 Num 1: Num 1: Num 2: 5 Num 2: Result: 25.00 Result: Add Subtract Multiply Divide Add Subtract Multiply Divide Additional information: Use fieldset and legend Style the fieldset, legend and the result textbox. . Result textbox color is LightGrey, font color and border color is blue. . Use Java script validation to check the input that can only accept numbers and cannot be empty • Use PHP to do the Add, Subtract, Multiply and Divide operations. 20 4.00