Web programming project

The following tasks are built around creating an online website to explore data related to sports, specifically track and road cycling at the London Olympics. You will be working with a given read- only database containing two tables (Country and Cyclist), which will be used for the majority of the tasks. There are four tasks in total; the first three being tightly specified and the fourth one allowing you room to design your own solution. Please read the individual task details and also the "Further Details" section that follows before starting your programming. For Tasks 1, 2 and 3 you are provided with htm pages ([login to view URL], [login to view URL], [login to view URL]) containing forms which will provide the input to your php pages. You are to ensure that your solutions work with these test pages. You should not modify these htm files, all your coding should go into your php files. ------------------------------------------------------------------------------------------------------------------------------------- Task 1 (15%) Write a php script ([login to view URL]) to produce an html page as result which contains an html table of BMI (Body Mass Index) values, based on the input of 4 values as follows: ‘min_weight’, ‘max_weight’ (input in kg) ‘min_height’, ‘max_height’ (input in cm) The finished table will have rows headed by ‘min_weight’ to ‘max_weight’ (incremented in steps of 5), and columns headed by ‘min_height’ to ‘max_height’ (incremented in steps of 5). You may assume the input values are multiples of 5 and you should produce output to 3 decimal places. The formula you should use to calculate the BMI is: