Using mysql client   create a database named supermarket   create a table named groceryitems in the supermarket database. Groceryitems table should have the following information : itemname, itemtype(i.e fruit, vegetable, pantry, meat, dairy etc), item description, price per unit, quantity available. Use appropriate data type for each of the columns. Itemname should be the primary key.   Create a php page through which you can connect to the grocery database and you can insert information into the grocery table.   The php page displays an interface , texboxes for itemname , textfield for item description, radio button for item type, text box for unit price , text box for quantity available and a submit button.   Once you click the submit button the php file should first validate the data types inserted.   After successfully adding a row of information the same php page should show a confirmation message about successful information in the table.   Make the radio buttons used for item-type sticky.

Using mysql client

create a database named supermarket

create a table named groceryitems in the supermarket database. Groceryitems table should have the following information : itemname, itemtype(i.e fruit, vegetable, pantry, meat, dairy etc), item description, price per unit, quantity available. Use appropriate data type for each of the columns. Itemname should be the primary key.

Create a php page through which you can connect to the grocery database and you can insert information into the grocery table.

The php page displays an interface , texboxes for itemname , textfield for item description, radio button for item type, text box for unit price , text box for quantity available and a submit button.

Once you click the submit button the php file should first validate the data types inserted.

After successfully adding a row of information the same php page should show a confirmation message about successful information in the table.

Make the radio buttons used for item-type sticky.