Project 2: foundcsu.net 2


This project will provide an introduction to using SQL with PHP. This project is due Friday April 11 at 11:55 PM. Your websites will be built under your Colvin accounts. Duplicate websites will appear under both partners' accounts so that Crystal can grade either one. Please feel free to post links to web resources you find useful on the RamCT Project discussion thread.


Partners:

  • Alaric Castain, Dan Hoyer
  • Nick Evans, Chris Schumacher, J Guadagnoli
  • Brandon Leroux, Joe Lessard
  • Denney Liptak, Aaron Hill
  • Ian Overgard, Matt DeSilvey
  • Josh Powers, Jared Rusch
  • Jill Siewert, Jason Shoemaker
  • Luke Lawyer, Chung-Ming Tien
  • William Springer

Description:

Project 2 will have the same functionality as in Project 1, except that you will be reading your input from an SQL data base instead of from an XML file. You will add a search capability to the website. The user will be able to search the SQL data base using a keyword entry. You will try to match the keyword to the names of the businesses. When a search is completed, the user either gets a "No matching business." or the website let's the user know the business was found. If the business is found, then the information for the matching business is displayed and the map changes to display all businesses in the category of the matching business.

Additionally, the user will be able to add, remove, or update the information for a business in the SQL data base. The option to add a business will appear near the category options. Removing and updating the business will be a little trickier. To remove or update a business, you will have to allow the user to select a business. The user selects a business by either selecting a category and clicking on a business in that category on the image map or searching for the business by keyword. When a business is selected, the remove and update options appear below the business' information.

Requirements:

  1. Read data from an SQL data base instead of from an XML file
  2. Search businesses by keyword (match to the business name)
  3. Add a business to the SQL data base
  4. Remove a business from the SQL data base
  5. Update information for a business in the SQL data base

A database you should be able to source and use. (Remember to change the database name to have your last name on the end so that everyone can work with their own database!) Business Database