Part -1
- Create a profile page where a login user has to update their profile
o If they log in and their profile is incomplete, they are taken directly to the profile page
- Do not let them create reminders unless their profile is complete (this needs to be checked in a controller)
- Birthdate, phone number, first name, last name, email address are all required
o Email must be a valid email format
o Birthdate must be at least 18 years ago
- This information needs to be stored in another table (personalDetails)
- The form needs to be in a modal
- When the form is submitted, an indicator must show up (success or alert)
- Provide me with an SQL file to create your database and tables
Part -2
Make new reports that use JOINS to join the users table with the notes table, with the user details table
- Report should list username, email/phone/name/etc, last login date, and COUNT() for how many notes they have
- Create an api.php page that allows data to be exported in json format
o cosc/api/function/param1/param2/param3
- Provide me with an SQL file to create your database and tables