Assignment 2 - List/Details PHP pages for Non-Relational Database - 10%

Assignment 2 - List/Details PHP pages for Non-Relational  Database - 10%

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.

Submission

Please submit a properly (lastname_firstname_section) labeled ZIPPED FILE (NO other file types will be

accepted). Please submit all web files, assets and a single SQL file. Assignment due date TBD