allow verified users to insert or update?

I've successfully implemented the double opt in registration on my site, showcased in a WA video.

My scenario:

I have two catgories of user, i'll call them 'type 1 and 2'. A 'type' is selcted by the user during registration.

As part of the site functionality, type 2 (only) users are allowed to edit a portfolio.


Im considering one of two approaches to create a user portfolio;

1. add a record insert triggered on a type 2 users verifying their registration email
2. place a button on the user update page, which if clicked will insert a single record.

In each case however, only one record must exist (per registered verified email) - no dupes.

When created, thereafter, the verified type 2 user can and update their portfolio only, no inserting new records permitted.

Suggestions, welcome.

Paul

I'd just have all of the fields available in the same registration table and restrict access on the update page to users that don't have a type 2 account. That way you wouldn't need a separate table or insert.

Thought id share my decision.

I opted for the 'trigger an insert on email verification by user' approach!

A single record insert is triggered only if 3 conditions were met;

Does a record exist for user
Is users type account = 2
Has the email been verified email = 1

I used INNER JOIN in mysql query to pull two tables together and validate the condition above. The query would return either an exisit or not exist result to work with.

If exist, the record insert option is removed and if not exist, the insert record option is presented for the user to insert!

And it works perfectly.