You use PHP and MySQL to develop an e-commerce web application and must follow the MVC pattern to implement the project. Brief requirements for the application are as follows.

The application must have at least three product categories. At least one category has at least 17 (different) products, and other categories contain at least 9 (different) products. Your group decides the categories, products and detail information, such as names, prices, images, etc. You must use a MySQL database to support your web application, and you design your database and tables, and provide the data

Sorting function

The application allows a user to sort the product records either by product name or by price in ascending order when clicking the corresponding column header (such as Name or Price) in the product table on the web page. If a user is on page two, and clicks price to sort by price, you decide on which page the user will be after the sorting – the user can be at either page one or page two.