Untitled

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<?php
ob_start();
$host="127.0.0.1"; // Host name
$username="root"; // Mysql username
$password=""; // Mysql password
$db_name="student"; // Database name
$tbl_name="student_login"; // Table name

// Connect to server and select databse.
mysql_connect("$host", "$username", "$password")or die("cannot connect");
mysql_select_db("$db_name")or die("cannot select DB");

// Define $myusername and $mypassword
$myusername=$_POST['Username'];
$mypassword=$_POST['Password'];

// To protect MySQL injection
$myusername = stripslashes($myusername);
$mypassword = stripslashes($mypassword);
$myusername = mysql_real_escape_string($myusername);
$mypassword = mysql_real_escape_string($mypassword);

$sql="SELECT * FROM $tbl_name WHERE username='$myusername' and password='$mypassword'";
$result=mysql_query($sql);

// Mysql_num_row is counting table row
$count=mysql_num_rows($result);
// If result matched $myusername and $mypassword, table row must be 1 row

if($count==1){
// Register $myusername, $mypassword and redirect to file "login_success.php"
$_SESSION['myusername'] = $myusername;
$_SESSION['mypassword'] = $mypassword;
//header("location:login_success.php");
//Print user login;
echo 'Logged in as '.$_SESSION['myusername'].' <a href="logout2.php">logout</a>';
}
else {
echo "Wrong Username or Password";
}

ob_end_flush(); ?>
        <html>
         <body>
        <form name="form1" method = "post" action="checklogin2.php">
    <table class="tableborder" align=center bgcolor="#f0f0f2">
        <tr>
      <td style="padding-bottom: 10px;" colspan="2" class="heading1"><b>Login Required</b></td>
    </tr>
        <tr>
          <td height="30">Username:</td>
          <td><input type="text" name="Username" style="width:15em;">
          </td>
        </tr>
        <tr>
          <td height="30">Password:</td>
          <td><input type="password" name="Password" style="width:15em;">
          </td>
        </tr>
        <tr><td height="30" align="right"><input class="submit" name="register" type="button" value="Register" onClick="window.location='register.php'"></td>
        <td><input name="submit" type="submit" value="Log-in" class="submit"></td></tr>
      </table>
        </form>
         </body>
        </html>