Newbie Help: Create Register & Login Pages

I want to use PHP/MySQL/Apache to make a site which allows registration and login. So, I need to create a table in the MySQL database which has the fields for UserID (auto increment), UserName (person's first name), Password (selected by the user when registering) that a user submits to the database using the register.php page. The user then needs to be redirected to the index.php page and click the "Login" link to go to the login.php. Oh, they also need to be able to "Logout".

This sounds really simple, probably, to you guys. But I tried to use a tutorial and the MySQL insertion was out of date or something. It was for an older version of PHP or MySQL or both.

So, any tips or code examples to share with me?

 

Hay - this is a big project with many things to consider such as form validation and checking

as for the unique id, you could do this a few ways, the easiest would be something like

<?php

$unique_id = time(); //Gives a unique id based on timestamp

?>

PHP:

The likelyhood of someone registering at the exact millisecond is very unlikely

As for the rest of the code, doing a quick search on google for "php sql member login tutorial" produced many helpful results
Normally i don't like stating the obvious but as this is a specific thing i really feel its your 1st point of call.

 

Hi John, I have created one sample code to understand how things work. Please find attached login-register.zip.

Please create "test" database and and create dbUsers table in that database. Update db config in config.php file.

Please reply if you have any confusion. This is very basic example but in really it will be much complex.