Hi all,
I am working on my project. I have to create a user regestration page and a
login page. I am done with registration page but when I tried to code the
login page its not working. Below is the code. Please take a look at script
and let me know where am I going wrong.
<?php
$username=$_POST['username'];
$password=$_POST['password'];
if($username&&$password)
{
$connect= mysql_connect("localhost","root","") or die("couldn't connect");
mysql_select_db("phplogin") or die("no db in the list");
$query = mysql_query("SELECT * FROM users WHEER username='$username'");
$numrows = mysql_num_rows($query);
if ($numrows!=0)
{
echo "user dosen't exist";
while ($row = mysql_fetch_assoc($query))
{
$dbusername = $row['username'];
$dbpassword = $row['password'];
}
if ($username==$dbusername && $password==$dbpassword)
{
echo "you are in";
}
else
echo "incorrent username and password";
else
die("user dosent exitst");
}
else
die("please enter a username and a password");
}
?>
--
Guru Prasad
Ubuntu Voice GTK+ Forum