PDA

View Full Version : A small login database using MySQL



Rockonmetal
09-28-2007, 08:38 PM
Hello! I was wondering if someone could make me a login database using MySQL...
I have absolutely no experience with MySQL so unless its clearly explained like below:


//Below is the code for users!
CODE Stuff for users!
//This is where it stops!
//Copy the code above to add more user...
Basically I want to this to happen...
When a user enters information from a form on login.php. Then information is validated and if valid then it goes to a page called mail.php. On this page I want the value of this input:

<input type="text" name="UserEmail" value="" />
To be replaced with the email of the respected client
So...
username: user1
password: password
email: user@clientdomain.whatever
name: User's Name
//End of User 1's info
If the username and password match the same user1 data then it replaces the value of the input UserEmail with User1's email address. If the username and password match the user2's password then it replaces the value of the input UserEmail with User2's email address and so on...
Don't worry about making a register form for me because My user's are my clients and I only will have about 5 clients at a time *at most if even 1 at a time*
What the form is doing:

The form basically allows the user to email me via my site to let me know of change or anything that has come up.
Thanks to all that help!