Login with php

Step:1 create table with mysql database
CREATE TABLE /*!32312 IF NOT EXISTS*/ `admin ` (
`admin_id` int(11) NOT NULL auto_increment,
`admin_username` varchar(50) default NULL,
`admin_password` varchar(50) default NULL,
`company_name` varchar(100) default NULL,
`address` text,
`currency` varchar(50) default NULL,
`emailid` varchar(100) default NULL,
PRIMARY KEY (`admin_id`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;

Step- 2 Create page page (index.php)
</p> <form action="indexsubmit.php" method="post" id="form1”> <table width="45%" border="0" align="center" cellpadding="5" cellspacing="1"> <tr> <td colspan="2" align="center"><?php echo $msg;?></td> </tr> <tr> <td width="37%"><strong>UserName</strong></td> <td width="63%"> <input name="username" type="text" id="username" /> </td> </tr> <tr> <td><strong>Password</strong></td> <td> <input name="password" type="password" id="password" /></td> </tr> <tr> <td colspan="2" align="center"> <input name="SIGNIN" type="submit" class="button" id="SIGNIN" value="Sign In" /> </td> </tr> </table></form> <p>

Step-3 create indexsubmit.php

define("NAME","mydatabase");
define("USER",'root');
define("PASSWORD",'');
define("HOST","localhost");
$link = mysql_connect(HOST,USER,PASSWORD);
if (!$link) {
die('Could not connect: ' . mysql_error());
}

$db_selected = mysql_select_db(NAME,$link);
if (!$db_selected) {
die ('Can\'t use foo : ' . mysql_error());
}

// Function that will redirect the page with given arguments.
function page_redirect($page)
{

print "";
header ("Location : $page");
}
if($_POST["SIGNIN"]!="")
{
$sql="select * from admin where admin_username='".$_POST["username"]."'";
$res=mysql_query($sql);
if(mysql_num_rows($res)>0)
{
if($row=mysql_fetch_array($res))
{
if($row["admin_password"]==$_POST["password"])
{
$_SESSION["admin_id"]=$row["admin_id"];
page_redirect("welcome.php");
}
else
{
$msg="Invalid Username and password";
}

}
else
{
$msg="Invalid Username and password";
}
}
else
{
$msg="Invalid Username and password";
}
page_redirect("index.php?msg=".$msg);

}
?>

Step-3 create welcome.php

// Function that will redirect the page with given arguments.
function page_redirect($page)
{

print "";
header ("Location : $page");
}

if($_SESSION["admin_id"]=="")
{
page_redirect("index.php");
}
Echo “login success”;
?>