PHP script for member admin approval
2 answers
The knee jerk reaction is to add a boolean column to the users table with a default value of false. However, the best route is probably the CHAR (1) column with the default "P" to wait. Then when the admin makes a choice, they can approve (set to "Y") or reject (set to "N"), they don't have to look at everything (just list all users where column = 'P')
+3
source to share
- Enter an "approved" column in the user table that indicates if the account is approved.
- Provide an interface to administrators to view a list of such accounts and toggle their approval status.
- Update the existing authentication code to validate this column and prevent the use of "unapproved" accounts
+1
source to share