Creating a member database typa thing...

PHP programming forum. Ask questions or help people concerning PHP code. Don't understand a function? Need help implementing a class? Don't understand a class? Here is where to ask. Remember to do your homework!

Moderator: General Moderators

Post Reply
Jim
Forum Contributor
Posts: 238
Joined: Fri Apr 19, 2002 5:26 am
Location: Near Austin, Texas

Creating a member database typa thing...

Post by Jim »

I would like to create something where people can join my site and forums at the same time (http://www.maxxxtorque.com/prodigy).

I'd like it to be somewhat like evilwalrus.com, where you become a member of the site as well as the forums. I'd like there to be a memberlist that is updated as each member is added, and I'd like these members to become forum members, as well, with the same username and password.

Do you have any idea what I'd need to do this, or where I might look to gain some insight on this whole deal?

*edit*

I guess I could at least tell you what I think I'll have to do, right?

I figure this:

I can use a MySQL db to create at LEAST 3 tables.

One table stores usernames.
One stores passwords.
One stores email addresses.

On the page I want to use to display members and emails, I can just print those tables on to a page, right? And that way the list will always update, right?

What I'd like to know is how I would check the login of members.

And of course where I'd learn how to do all the stuff I just said I thought I'd need to do...

If that's actually what I need to do.
jason
Site Admin
Posts: 1767
Joined: Thu Apr 18, 2002 3:14 pm
Location: Montreal, CA
Contact:

Post by jason »

I only have a few minutes, so excuse the brevity of this post.
One table stores usernames.
One stores passwords.
One stores email addresses.
Rather, I suggest creating 1 table that stores the username, the password, and the email address, along with any other important details.

Probably a good place to start is here:
http://www.webmasterbase.com/article/228

This article pretty much covers the full creation of a website using PHP and MySQL.

Also, my own tutorial:

http://www.webmasterbase.com/article.php?pid=0&aid=378

I hope this helps somewhat.
Post Reply