php - MySQL更新记录，但页面显示不显示新数据

我正在为crud用户详细信息编写一个应用程序。我首先查询用户表，然后使用数据填充页面中的各种表单元素（并检查重复项）。所有表单提交都提交到同一页。
添加、删除和修改记录按预期工作-但更关键的是，一旦提交更改，页面上显示的数据不会相应更新-我必须重新访问页面才能看到相关更改。

try{
    $user_sql = "SELECT user_ID, user_firstname,user_surname,user_email,user_type FROM users";
    $user_stmt = $db->prepare($user_sql);
    $user_stmt->execute();
    $user_data = $user_stmt->fetchAll(PDO::FETCH_NAMED);
    $i++;
}catch(PDOException $e){
    echo "Error: cannot retrieve user data from the data base";
}

/*
 * DELETE USER
 */
if(isset($_POST['deleteUser'])){
$_SESSION['deleteUser']=true;
}
if(isset($_POST['submitDeleteUserConfirm'])){
//process query
    if($_POST['deleteUserConfirm']=='yes'){
        $deleteRange=implode(',',$_POST['deleteUser']);
        $deleteSql = 'DELETE FROM users WHERE ID_users IN (' . $deleteRange . ')';

        try{$q = $db->prepare($deleteSql);
        $q->execute();
         }
        catch(PDOException $e){
            echo '<p>System Error: '. $e->getMessage() .'</p>';
            }
        }
//once confirmation has been processed:
//remove session trigger to hide confirmation form
    if(isset($_SESSION['deleteUser'])){
        unset($_SESSION['deleteUser']);
    }
}
if(isset($_SESSION['deleteUser'])){
?>
    <fieldset class="radiobox">
        <legend>Confirm</legend>
        <div>
            <label for="deleteUserYes">Yes</label>
            <input type="radio" class="radio" name="deleteUserConfirm" id="deleteUserYes" value="yes">
        </div>
        <div>
            <label for="deleteUserNo">No</label>
            <input type="radio" class="radio" name="deleteUserConfirm" id="deleteUserNo" value="no" checked>
        </div>
    <input type="submit" name="submitDeleteUserConfirm" value="Confirm">
    </fieldset>
<?php
 }
//small function to output all the elements of an array as checkboxes
$delStudentRollOpts = array(
    'key'=>'users',
    'sticky'=>true,
    'data'=>array(
        'values'=>$user_data,# USES DATA FROM START OF SCRIPT - NOT UPDATING ON PAGE REFRESH/FORM SUBMISSION
        'name'=>array('user_firstname','user_surname')
    ),
    'element_name'=>'delStudRoll_'.$n,
    'types'=>array('checkbox'=>array('title'=>'&nbsp;',
                                 'name'=>'deleteUser',
                                 'index'=>'ID_users'
        ))
    );
echo $GA_form->generateRoll($delStudentRollOpts);
echo '<input type="submit" class="submit" name="submitDeleteUser_'.$n.'" value="Delete">';
echo '</fieldset>';
echo '</form>';

这是一项正在进行的工作，因此需要进行大量的重构…
从用户的角度来看：
1:输入新数据
2:提交表单
3:从MySQL控制台检查数据库-插入新数据
4:没有显示新数据
5:再次访问页面-出现新数据（刷新将触发尝试重新提交重复值的错误）
有人知道发生了什么事吗？目前，我正在玩弄的想法，重定向回一个页眉页…

最佳答案

if(form_submitted) {
    update_database()
}

fetch_data();

<form></form>

关于php - MySQL更新记录，但页面显示不显示新数据，我们在Stack Overflow上找到一个类似的问题：https://stackoverflow.com/questions/2128692/