Untitled

<!DOCTYPE html>
<html>
<head>
     <title>LMA Enterprises</title>
</head>

<body>
     <center>
          <h1>LMA Enterprises</h1>
          <a href = "index.html">Home</a>
          <a href = "login.php">Login</a>
          <a href = "register.php">Register</a>
          <a href = "search.php">Search</a>
          <br><br><br>
          <?php
               $host = 'localhost';
               $user = 'root';
               $pass = '';
               $conn = mysql_connect($host, $user, $pass);

               if(! $conn ) {
                    die('Could not connect: ' . mysql_error());
               }

               mysql_select_db("lma");

               $empid = $_POST["empid"];
               $pass = $_POST["pass"];

               $sql = "select * from employee";
               $retval = mysql_query($sql, $conn);
               $found = false;

               while($row = mysql_fetch_array($retval, MYSQL_ASSOC))
               {
                    if ($row['empid'] == $empid && $row['pass'] == $pass)
                    {
                         echo "<br><u><h2>User Details<h2></u>";
                         echo "<h3>Name : {$row['empname']}</h3>";
                         echo "<h3>Department : {$row['dept']}</h3>";
                         echo "<h3>DOB : {$row['dob']}</h3>";
                         $found = true;
                         break;
                    }
               }

               if (!$found)
                    echo "<br><br>Invalid username or password";

               mysql_close($conn);

               //echo "hello".$_POST["empid"]."<br>";
               //echo "Your mail is".$_POST["pass"];
          ?>
     </center>
</body>
</html>