Lab: Database - Individual Homework

Research

Research into how mySQL database is created and configured in your hosting solution.

Description

Based on the company web site you created. Perform the following:

• Create a mySQL database for your company web site
• Create a buyer table that contains at least first name, last name, email, home address, home phone and cell phone.
• Based on the last lab.
  • Add a new buyer registation feature.
  • Modify the buyer account section to read all the information off from the database created above. Just like the last lab, user is allowed access to the account section after login using the correct userid and password. You can keep the existing authentication scheme or reimplement it using database.

Grading

• Send the new buyer registration link AND the buyer account section link (via login) to coolprofsinn@gmail.com for grading by end of Sunday.