<form action="loginpage.php" method="post">

<div id="loginhere"><h2>Login In your Account</h2></div>
 <table>

   
   
    <tr>
      <td><br/><strong>Username</strong>&nbsp&nbsp</td>
      <td> <br/><input type="text" name="username" size="20" placeholder="User name"></td>
    </tr>
           
   
   
    <tr>
    <td> <br/><strong>Password</strong>&nbsp&nbsp</td>
    <td><br/><input type="password" name="password" size="20" placeholder="Password"></td >
    </tr>

     <tr>
       <td><br/><input type="submit"value= "Login" name="submit" id="Login">   </td>
       <td><br/><input type="reset" value="Reset" name="reseter" > </td>
      
       
      
     </tr>
 </table>
</form>





---------------------------------------------------------php-------------------------------------------

<?php

$link = mysql_connect('localhost', 'root', '');
if (!$link)


{
    die('Not connected : ' . mysql_error());
}

$db_selected = mysql_select_db('signup_db', $link);
if (!$db_selected)


 {
    die ('connection failed : ' . mysql_error());
 }

if(isset($_POST['submit']))
{
$username = $_POST['username']; //Get username from login form
$password = $_POST['password']; //Get password from login form

$username = stripslashes($username); //Makes string safe
$password = stripslashes($password); //Makes string safe
$username = mysql_real_escape_string($username); //Makes string safer
$password = mysql_real_escape_string($password); //Makes string safer

$sql = "SELECT * FROM signup_tb WHERE username='$username' and password1='$password'"; //SQL Query
$result = mysql_query($sql); //Executes Query

$rows = mysql_num_rows($result); //Count rows selected (1 if a username/password combo can be found)

if($rows == 1)

{


$query  = "SELECT * FROM signup_tb WHERE username='$username' and password1='$password'";
$result = mysql_query($query);


while($row = mysql_fetch_array($result))
   {
  echo "<script> alert('Hi ..welcome!! ')</script>";

echo "<script> window.open('testpannel.php','_self')</script>";

   }


}
else
{
echo "<script> alert('Invalid Username Or Password !! ')</script>";
}
}
?>