Massachusetts Institute of Technology Mysql Html And PHP Questions

1. Write the SQL command for the following tasks:

Listing the databases on the MySQL server host

i) Access/change database

ii) Showing the current selected database

iii) Showing tables in the current database

iv) Showing the structure of a table

v) Create a user

vi) Remove a user

vii) Give “guest” permission to view the World database:

viii) Create a table

2. State the main PHP errors types.

3. Write HTML Form and PHP code to upload multiple any-type files

4. Write HTML Form and PHP code to Calculate BMI(Body Mass Index).