Answer Happy

Question 21 (15 pts) Given that the database server is "localhost", the name of the database is "productdb" and your database username is your first name and your password is your last name, do the following: a) Write the PHP statement to connect to that database. b) Write the PHP statement to create that database. c) Write the PHP statement to create the table productinfo in that database: this table has a field named "name" (15 characters) another one named "quantity" (3-digit integer) and another one named "price" (space decimal value with two digits after the decimal point). d) Write a PHP statement to add the record (Apple 125 1.75) to the table productinfo. e) Write a PHP statement to delete from the table productInfo every record with price greater than $1.00. a