Untitled

<body>

<form method="POST">
 username:<input type="text" name="username" /><br>
 password:<input type="password" name="pwd" /><br>
 <input type="submit" name="login" >

 <?php

 if(isset($_POST['login'])){
    $user= $_POST['username'];
    $con = mysqli_connect("localhost", "root", "", "banking");
    $rs = $con->query("select cname, from customer ");

        while($row = $rs->fetch_row()){
        if($user==$row)
        {
                header(Location:"log.html");
         }
        else
        {
                echo "Login Failed";
        }
 }
 }
 $rs->free();
 $con->close();