MySQL查询需要额外的页面刷新才能显示UPDATE更改

Why does this not show the changes after submit? The page has to be refreshed AFTER submission to see the changes.

$full_path = 'users/'.$_SESSION['user_id'].'/images/'.$name;

if($query = mysql_query("UPDATE user_info
                         SET user_image = '$full_path'
                         WHERE user_id = '".$_SESSION['user_id']."' AND
                         username = '".$_GET['username']."'
                         "))
                        {

    if(move_uploaded_file($tmp_name, '/Applications/XAMPP/xamppfiles/htdocs/'.$full_path)) {
        echo 'Got it!';
        }

    }

So, if I upload / click submit, the query is successful, but you can't see the changes until an additional page refresh.

Make sure that your update query is before your select for your data in the execution of the PHP page.

You need to fix your SQL, you are just leaving yourself open for SQL injection, with using $_GET['username'] directly in your SQL query.

Please look at utilizing parameterization, also keep in mind that order counts when you develop these things. TOP -> DOWN.

If you have a display SQL call BEFORE your UPDATE call, then you will have to refresh again to see changes from the UPDATE SQL call.

You should do a GET redirect after POST request anyway.