PHP：页面未重定向回登录页面

Question

我有一个login.html文件，带有一个表单，具有用户名和密码字段，在提交按钮上，它用mysql检查表单中的值
我的PHP代码在不同的文件称为login.php


问题是，当我输入正确的用户名和密码时，它可以正常工作。但是如果我输入了错误的信息或是将它们保留为空，那么如果我重定向到登录，就可以了。html页面，它重定向到登录。php页面。

登录。php


<?php

 ### Check if the Submit button is clicked
        if (isset($_POST['btnSubmit']))
         {
            # code...
            //$uname=$_POST['uname'];
            //$pswd=$_POST['pswd']; 

    #### Connection to mySQL ####
    $conn=mysqli_connect("localhost","root","","vishal") or die("Unable to connect to MySQL");



            if (mysqli_connect_errno())
            {
                echo "Failed to connect to MySQL: " . mysqli_connect_error();
            }

            $result = mysqli_query($conn,"SELECT * FROM login where username = '$_POST[uname]' AND password = '$_POST[pswd]'") or die(mysql_error());

            $row = mysqli_fetch_array($result) or die(mysql_error());

                    $username=$row['username'];
                    $password=$row['password'];


                    if (!empty($username) AND !empty($password)) 
                    {   # code...
                        //$_SESSION['username'] =$password;
                        header('location:welcome.html');
                    }

                    else //(empty($username) AND empty($password))
                    {   # code...
                        header('location:login.html');
                        die();
                    }  

}

?>


登录。html

<form action="login.php" name="login_form" method="post" enctype="multipart/form-data" target="_self">
    <fieldset style="width:300px; margin:auto; margin-top:100px; border:solid 2px #900; background-color:#CCC; border-radius: 50px">    
        <h1 style="color:#306;"> <center> Login Form </center></h1> <br> <br>
        <div style="margin-left:30px;">

         <table>
         <tr>   
            <td align="right"> <label for="uname"> <strong>Username :</strong> </label> </td>
            <td>        <input type="text" title="Username" id="uname" name="uname" placeholder="Username" />   </td>
          </tr>
          <tr><td>  </td><td> </td> </tr>
          <tr>   
            <td align="right"> <label for="pswd"> <strong>Password :</strong> </label>  </td>
            <td>        <input type="password" title="Password" id="pswd" name="pswd" placeholder="Password" />     </td>
          </tr>
          <tr><td><br /> </td><td> <br /></td>  </tr>
          <tr>
            <td></td>
            <td>        <input type="submit" title="Submit" name="btnSubmit" id="btnSubmit" value="Submit"  style="width:100px; height:26px; font-weight:bold;" />  </td>
            </tr>
           <tr><td><br /> </td><td> <br /></td> </tr>         
        </table>
        </div>
    </fieldset>
</form>




Answer 1

你必须这样做在login.php

<?php

 ### Check if the Submit button is clicked
if (isset($_POST['btnSubmit']))
{

    $conn=mysqli_connect("localhost","root","","vishal") or die("Unable to connect to MySQL");
    if (mysqli_connect_errno()){
        echo "Failed to connect to MySQL: " . mysqli_connect_error();
    }

    if(!empty($_POST['uname']) && !empty($_POST['pswd'])) {
        $result = mysqli_query($conn,"SELECT * FROM login where username = '$_POST[uname]' AND password = '$_POST[pswd]'") or die(mysql_error());
        $row_count = mysqli_num_rows($result);
        if($row_count==1) {
           $row = mysqli_fetch_array($result) or die(mysql_error());
           $username=$row['username'];
           $password=$row['password'];
           header('location:welcome.html');
        } else {
           header('location:login.html');
           die();
        }
    } else {
        header('location:login.html');
        die();
    } 
}

?>

Answer 2

使用此代码：

$result = mysqli_query($conn,"SELECT * FROM login where username = '$_POST[uname]' AND password = '$_POST[pswd]'") or die(mysql_error());
$row_count = mysql_num_rows($result);
if($row_count==1) {
    $row = mysqli_fetch_array($result) or die(mysql_error());
    $username=$row['username'];
    $password=$row['password'];
     header('location:welcome.html');
} else {
    header('location:login.html');
    die();
}