Please help

saint4

hi all,
i am totally new to php coding, i have used mysql before and phpmyadmin.

I'm trying to build a website which will use some instance of php and mysql.

I would like to find out how i would do a login page which gets the users username and checks their password from the mysql database and also how to go about doing a registration page, where it'll check if username has been taken already. if not then adds to the database etc.

Thanks for any help.

Hope i explained properly.

kcgame

Hi,

In order to create register page, you would need form validation, to check for any illegal entries from the user. Most php/MySQL books have a good section on this. A brief how-to can be found at:

http://www.webmasterworld.com/forum88/1324.htm

phpbuilder Code Library also contain codes for verifying E-mail address:

http://www.phpbuilder.com/snippet/browse.php?by=cat&cat=16

After user clicks "Register" button, this is where your PHP/MySQL queries comes in. Using SELECT query to determine if any existing records in your database and INSERT upon no matching records found.
Next would be the log in form. Check for log-in button pressed, using the same query SELECT to find matching record. If there's a match, redirect user to Main.php, the member area (just an example).
At the start of the Main.php, start session. Webmonkey has a good intro on session management:

http://webmonkey.wired.com/webmonkey/00/05/index2a.html?tw=programming

You can choose to use cookies or sessions, but i prefer session thou. Refer to the following link for a short discussion on this topic.

http://www.phpbuilder.com/board/showthread.php?s=&threadid=10245251

The above is a general concept of the flow, most answers can actually be found in this forum.
Happy reading 🙂

saint4

thanks for your help