Prob in login Page
Posted: Thu Mar 22, 2012 1:20 am
In login page required dropdown option it means admin can select username,password and select the admin from dropdown then go for home page. I have written php code but it is not workin pls sir help me.the code is
Code: Select all
<?php
include("connection.php");
if($_POST['submit'])
{
$myusername = $_POST['username'];
$mypassword = $_POST['password'];
$myadmin = $_POST['admin'];// ok
if($myusername && $mypassword && $myadmin)
{
$sql = mysql_query("select * from login");
while($getrows = mysql_fetch_array($sql))
{
$dbuser = $getrows['Username'];
$dbpass = $getrows['Password'];
$dbrole = $getrows['Role'];
}
if(($myusername == $dbuser) && ($mypassword == $dbpass) && ($dbrole-->"Admin"))
{
header("location:Home.php");
}
else if(($myusername == $dbuser) && ($mypassword == $dbpass) && ($dbrole-->"Member"))
{
header("location:Home.php");
}
else
{
echo "Login Failed......";
}
}
else
{
echo "username and password failed";
}
}
?>