verification system

redrock

Hiya all..I need some help..I have a members form for an a gaming club.I have the forms all setup an working great..Here is where i need help.I have several admins that help me that would only mess things up if they actually got into the database.What i am wanting to do is when we recieve an app have the form pull all there info on a page an to be able to accept them,deny them,or put them on a waiting list.If we accept them i want it to automatically send them an email with instructions on what they do to confim their registration an move them to a different table with the Database that i have setup so it will show their info on a webpage.If they are denied i want a form to come up where we put in the reason they was declined an emailed to them.I would appreciate any help

dalecosp

<?php

# members form for an a gaming club
# by "redrock"



#we recieve an app have the form pull all there info

#accept them

#deny them


#put them on a waiting list.

#If we accept them i want it to automatically send them an email

#with instructions on what they do to confim their registration 

#move them to a different table with the Database

#will show their info on a webpage.

#If they are denied i want a form to come up 
#where we put in the reason they was #declined 

#an emailed to them.

?>

drag0n

Well, yous hould do your database design first, then do the code, it is alot easier that way.
For example, you put fields such as "activated"(1 or 0) and "level"(level of access, admin or whatever) in the users table and then in the one where you pull out the info. you just pull out all the info WHERE activated = 1 meaning it will onyl pull out the users that HASNT been actviated and when you do click activate, it will set it to 1 or if you want to deny, you can delete it. But whenever a user registers, the admin should get an email containing a link to a page such as "http://www.mydomain.com/members.php?action=activate&uid=6 " so it will pull up that persons info and give you the options, but you should secure all the pages.
Hope this helps

drawmack

no first you should design your user interface that will let you know what fields to put in the database.

BTW: I recommend using a flat file system for this instead of an actual database. It'll be a lot harder, take a lot longer to program, run more slowly and be more prone to errors but it'll be more fun.