We are concerned about students sharing an enrollment key so want to create a unique key that will be sent to each student on a postcard. They will need use this key in order to be able to access the registration page. Once they've registered they won't need to use this initial password again.
We will be printing 9,000 keys (although we don't expect anything like that number of users).
I do have some experience of php (although I'm far from really knowing what I'm doing) and creating new tables in the database etc so my plan was to create a new table in the database which contains all these new passwords, then get php to check against this list and deactivate the password once it has been used so that it can't be used by more than one person.
My questions are:
1. has anybody done anything like this before?
2. does my methodology seem reasonable and workable/safe?
3. how on earth do I go about creating 9000 passwords in the database?
Thanks for any help that anyone can offer