Login form with php/mySQL...

zaniam

I am trying to make a login form that when it submits goes to a submitlogin.php page, check the password from the database and then, if correct proceed to that user's page.

I have so far gotten it to go to the submit login form but I can't seem to get it to check it and then redirect it to the page, users.php?username=$username. I am not yet sure about the username bit, I read somewhere that I'm supposed to use a session_id but I'm not even very sure of what that is.

Can anyone help me or tell me where I can get an example of such a code to study!
Thanx
Zany

abhijeets

Try this in your submitlogin.php page

$query = "SELECT * FROM users where username = '$username' AND password = '$password'";

$result = mysql_query($query,$db);

$total = mysql_num_rows($result);

if(!$total)

{
header("Location:message.php?3"); //this redirects to a page which displays "Wrong Username or password"
}
else

{
header("Location:users.php?username=$username");

}

PhaZZed

basically you pass the $username and $password to the checklogin page. You select the data from the database using the where statement to check if the data exists.

If a match is found then you redirect to whatever page, the problem comes in when the other pages loads, and ppl see the address in the url bar in your explorer!

This is where sessions come in, and they are very important, but for now just use the code the person above me posted, should be sufficient!

ciao

chinni_77

This is something related to user-authentication.

http://www.zend.com/zend/tut/authentication.php

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

HTH