We need 2 PHP files to be created.
1) [url removed, login to view]: This file will be used to upload data from a CSV file to a MySQL database and generate data for a UUID field.
2) This file needs to get data from a table.
User receives an email with a link [url removed, login to view] and after clicking the link a file opens and pulls data from DB. This file also needs to update two fields in the DB. 1) flag the user with "1" (viewed) 2) update user's row with a timestamp.
All you need to do is write the PHP. NO DESIGN, NO CSS, NO FORMATING!!! We will do that part.