Question
You are continuing to build the website for the Daily Grind, a specialty coffee shop. Create a MySQL database to store the registration data about
You are continuing to build the website for the Daily Grind, a specialty coffee shop.
Create a MySQL database to store the registration data about your customers as well as a login, password, and two security questions for each customer.
Implement your design in MySQL, using any combination of phpMyAdmin and the command-line interface, but try to use both enough to enhance your familiarity with each. Provide screenshots to demonstrate that you used both the command-line interface and phpMyAdmin.
Add enough data to test your database until you are satisfied it is going to help you perform the necessary tasks required. Add one login of "customer" with a password of "customer" for testing.
Add the functionality to your website to save the customer registration data to MySQL. Be sure to validate the data.
Add the functionality to your website for a customer to login and logout of your website from the home page.
If a customer forgets their password, add the functionality for the customer to reset their password. Your reset should include both security questions and email reset options.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started