Based on the mySQL database you developed for assignment 1 (database I have provided), write PHP pages (based on the procedures shown and examples provided in class) that will do the following:
• List news/updates info, newest at the top to oldest, in a single positioned div on an index.php page. List all of the news item info here and style it as necessary.
• List selected portions of the ‘about us/the team' info in a different div on the same index.php page; use, for example, a list of the first and last name and the position of each person (alphabetically by last name), with a ‘more' link to a detail page that shows all of the information for one person, laid out in multiple div containers. Be sure to provide a menu item or link back to the index.php page from this detail page.
• Allow searching of the portfolio information by category (web, graphics, print, etc), displayed as a list of relevant portfolio items on a ‘search results' page. The search can be a standard search box, but also can be a drop down menu or other workable form item.
• From the index page, provide a menu item or link to another PHP page that displays a list of (working) links to external sites that represent partners, client work, resource/ tutorial sites, etc. Hint: Use ‘target=_blank' in your link code to force the external site to open in a new tab/window.
Other static content and styling can be developed, but it only needs to be minimal for this assignment. If you are not integrating this scripting into an existing site (client site or portfolio), provide a CSS stylesheet for positioning and some minimal styling of the visible content; don't design and create a full layout but produce a clean, professional looking layout for each page.
Attachment:- 104726_2_db-media.rar