php - 在 MySQL 中更新后不会回显消息

Question

我相信这段代码有效。但它不会回应确认或错误。

<?php

require 'config.php';

if($_SERVER["REQUEST_METHOD"] == "POST"){      

        $servername="localhost";
        $username="root";
        $conn=  mysql_connect($servername,$username)or die(mysql_error());

        mysql_select_db("web", $conn);

                    $mypassword=$_POST['pwd'];
                    $fname=$_POST['fname'];
                    $lname=$_POST['lname'];
                    $address=$_POST['address'];
                    $location=$_POST['location'];

                    $sqlsel="SELECT * FROM users WHERE username='$id' AND pwd='$mypassword' ";
                    $result=mysql_query($sqlsel,$conn) or die(mysql_error());  

                    $count=mysql_num_rows($result);

                    if($count==1){  
                        $sql="UPDATE users " .
                        "SET fname = '$fname', 
                        lname = '$lname',
                        address = '$address', 
                        location = '$location'" .
                        "WHERE pwd = '$mypassword'";

                        $res = mysql_query( $sql, $conn );
//IS THIS CORRECT TO REFRESH THE PAGE???
                        header("Location: edit.php?id=" . $id);
//IT WON'T ECHO....
                        echo 'Information updated.';
                        }

                    else {
//ALSO THIS ONE...
                    echo print "Invalid Password.";
                    }


                mysql_close($conn);
}
?>

它似乎适用于我的其他表单，但不适用于此编辑表单。

我该如何解决？

Answer 1

在 header 位置之后，任何东西都不起作用。你能做的是

header("Location: edit.php?id=" . $id . "&msg=1");

然后在 edit.php 上只需获取 $_GET["msg"] 即可

if isset($_GET["msg"])
echo 'Information updated.';