Login via MySql

[alisam]

hi,

i would like to write a login script which is based on php and mysql. I've tried to code it by myself, but all i did it did not want to work the way i want it to. so i am trying to find help here again.

I want a form where i can type in a username and a password. (no prob). But then i need a script which looks in my db if there is a username which is the same as the entered username. if not it says "wrong username". If the password is not correct for the user it says "password wrong".

If both things are right it says "login successful".

It should not be very hard, but i have just startet coding in php, so it is very hard for me as a newbie.

Would be glad if someone could help me

thanls in advance

ali

[Anon]

contact meon AIM or AOL screen name= Trex005

[Anon]

i wrote a script like that for my website... ill post it:

<pre>
<?
function LoggedIn($u2,$p2,$e2,$f2,$l2,$i2,$c2,$t2,$m2,$v2,$n2,$s2,$w2)
{
$TodayIs = Date("m/d/y");
//print ($TodayIs);
$Query = "UPDATE users " .
"SET lastvisit = '$TodayIs' " .
"WHERE username = '$u2'";
$result = mysql_db_query('mysql-dbname', $Query);
if ($Genre_CK != "")
{
print ("<hr size=\"1\" color=\"black\"><b>$u2: &lt;$Genre_CK&gt;</b><hr size=\"1\" color=\"black\">");
} else {
print ("<hr size=\"1\" color=\"black\"><b>$u2: &lt;Map:Net&gt;</b><hr size=\"1\" color=\"black\">");
}
print ("Thank you $f2 $l2.\n");
if(!$result)
{
$error = mysql_error();
print("<br><br><b>" . $error . "</b>\n");
} else {
print ("<script language=\"javascript\">");
if (isset($w2))
{
print ("document.location = \"in.php?Info=" . $u2 . "&Var=User_CK&ToGo=$w2\"");
} else {
print ("document.location = \"in.php?Info=" . $u2 . "&Var=User_CK&ToGo=myindex.php\"");
}
print ("</script>");
}
}
?>
<?
include ("header.php");
$dbLink = mysql_connect("localhost", "mysql-dbname", "mysql-password");
$Query = "SELECT username, password, email, fname, lname, icq, country, timezone, comments, lastvisit, postnumber, uservalue, pending " .
"FROM users";
$dbResult = mysql_db_query('mysql-dbname', $Query);
while ($row = mysql_fetch_row($dbResult))
{
// print ("$row[0], $row[1]<br>\n"); // $row[0] = Username; $row[1] = password
if (strtolower($row[0]) == strtolower($username))
{
if ($row[1] == $password)
{
$u = $row[0];
$p = $row[1];
$e = $row[2];
$f = $row[3];
$l = $row[4];
$i = $row[5];
$c = $row[6];
$t = $row[7];
$m = $row[8];
$v = $row[9];
$n = $row[10];
$s = $row[11];
$registered = $row[12];
if ($registered == "true")
{
print ("<hr size=\"1\" color=\"black\"><b>Error: &lt;Map:Net&gt;</b><hr size=\"1\" color=\"black\">");
print("You must confirm this account before you can sign up, to do this read the email sent to you by Map:Net.");
} else {
LoggedIn($u,$p,$e,$f,$l,$i,$c,$t,$m,$v,$n,$s,$whereto);
}
break;
} else {
print ("<hr size=\"1\" color=\"black\"><b>Error: &lt;Map:Net&gt;</b><hr size=\"1\" color=\"black\">");
print("Incorrect Password.");
}
} else {
print ("<hr size=\"1\" color=\"black\"><b>Error: &lt;Map:Net&gt;</b><hr size=\"1\" color=\"black\">");
print("Incorrect Username or Username not found in directory.");
}
}
mysql_close;
include ("footer.php");
?>
</pre>