[SOLVED] Newbie-ish - Registration / Login - Please Help!!!

[mfallon]

OK, I'm a newbie but I do have some coding experience and plenty of DB experience. I have my database schema and I know exactly what I want to do.

 

To explain, I am trying to put together a site for someone who runs a website, http://www.englishskeet-osc.co.uk/ out of the goodness of his heart to recognise the achievements of others. He spends 5 or 6 hours a week, phoning people, updating spreadsheets, and updating the website manually with the new information. This guy is not getting any younger and myself and a friend are hoping to put something simple in place which will make his life a lot easier.

 

I'll deal with my issues 1 at a time.

 

In order to register on the site users must have attained a certain level of sporting achievement. This has to be validated by the governing body, or the venue where they made the achievement.

 

I have seen a registration and login system which allows users to register, login to the site and maintain their details, however it doesn't do exactly what I would like it to do.

 

http://www.olate.co.uk/articles/185

 

I want users to be able to register but for them not to appear in the list of members until they have been confirmed by the site administrator.

 

Once a member they will have access to modify their details and nothing more.

 

The site administrator should also be able to modify these details as well as disable users.

 

Can anyone advise on any code snippets or similar solutions which I can copy to do this, how to modify an existing solution, or even how to create it from scratch.

 

Any help is greatly appreciated, even if it is pointing me in the right direction, I'm quite happy to spend the time fine tuning, or doing the leg work to pull suggestions together.

 

Many Thanks, Matt.

[jackpf]

Uhh well...I doubt anyone on here will actually write you the entire code...

 

But registration/loing forms are simple enough, you can probably find some decent tutorials on google.

 

As for the "not displaying on the members list" until they're a proper member, you could just have a column in your database which states whether they're a proper member. For the members script, something like this-

 

$sql = mysql_query("SELECT * FROM table WHERE status='registered' ORDER BY ID DESC") or die(mysql_error());

 

Anyways, good luck. I hope this is somewhat helpful. If you have any specific problems, feel free to message me.

[mfallon]

Thanks Jack, definitely helpful. Like I said, not looking for someone to do the coding for me, just give me an idea of how to get there.

 

Adding a column for whether they have been validated seems simple enough, as well as adding the WHERE element to my queries so should do the trick.

 

Will give it a go.

 

Thanks. Matt

[jackpf]

Cool, no problem.

 

Yeah, if you have any problems, feel free to message me.

 

Hope all goes well.