Convert static site to MYSQL driven site and add search

Hey, I have a new project if you are interested. The project is to convert the site: [[login to view URL]][1] to a database driven site. The main changes are to the product pages. Currently the site is static. I want the pages to be dynamically created. Also a search function needs to be added. You can see the parts of the product page at: [[login to view URL]][2] See full description below ## Deliverables Currently the site is static. I want the pages to be dynamically created. Also a search function needs to be added. You can see the parts of the product page at: [[login to view URL]][2] Each product should have: 1. Name 2. Meta Title 3. Meta keywords 4. Search keywords 5. Product Description (HTML) 6. Main Image Upload 7. Alt 8. Image upload (Thumbnails displayed below main image. JavaScript pop up when clicked) 9. Leather Code 10. Leather option selector (See below) 11. Whole Sale price (This will generate the pricing based on a formula like whole sale times 1.1 for 1000, .98 for 500 ect.) - one for each leather - If no price is added that row (Leather) should not show up for that product 12. Hidden ( Check box) if checked the product will not show up in search or in the side nav or category pages. 13 Category selector ( This will need a config section to add/edit/ remove categories) Leather Option selector should have main 3 options each with its own sub options: 1. Premium - Natural French Calfskin - Morocco Genuine Goatskin - Crocodile-Embossed Calfskin - Metallics 2. Genuine - Leather - Shine 3. Bonded & Synthetic - Bonded Leather - Synthetic Saffian These sections need to be configurable to add or remove swatches. The side nav should act the same as it does now except it should be dynamically driven and should not show a product if the hidden check box has been checked. Also when the category is clicked currently only the cat opens. It should open and you should be brought to a category page which displays the products in that category.