数据库表行更新功能失效求助：表单提交无响应

// 表格中的编辑按钮修改
echo "<a class='click open-updateModal' data-id='".$row['MemberID']."' href='javascript:void(0)'> 
        <span class='material-icons-sharp'>edit</span>
      </a>";

// 模态框表单修改
<form method="post">
    <!-- 新增隐藏字段存储MemberID -->
    <input type="hidden" name="member_id" id="member_id">
    <div class="fillup-form">                               
        <div class="block-1">
            <label for="firstname">First Name:</label><br>
            <input type="text" name="firstname" id="firstname" required><br><br>
            <label for="lastname">Last Name:</label><br>
            <input type="text" name="lastname" id="lastname" required><br><br>
            <label for="birthdate">Date Of Birth:</label><br>
            <input type="date" name="birthdate" id="birthdate" required><br><br>
            <label for="gender">Gender:</label><br>
            <input type="text" name="gender" id="gender" required><br><br>
            <label for="address">Address:</label><br>
            <input type="text" name="address" id="address" required><br><br>
            <label for="phone">Phone Number:</label><br>
            <input type="text" name="phone" id="phone" required><br><br>
                    
        </div>
    </div>
    <div class="buttons">
        <button class="click close-updateModal">Cancel</button>
        <button class="click submit-updateModal" name="update_submit">Submit</button>  
    </div>                                
</form>

2. 更新JavaScript逻辑，实现表单数据预填充

点击编辑按钮时，不仅打开模态框，还要传入MemberID并通过AJAX加载用户原有数据：

const modal2 = document.querySelector('.update-modal');
const open_updateModals = document.querySelectorAll('.open-updateModal');
const close_updateModal = document.querySelector('.close-updateModal');

// 编辑按钮点击逻辑
for (let open_updateModal of open_updateModals) {
    open_updateModal.addEventListener('click', async () => {
        const memberId = open_updateModal.getAttribute('data-id');
        // 填充隐藏字段的MemberID
        document.getElementById('member_id').value = memberId;
        
        // AJAX获取用户详情并填充表单
        try {
            const response = await fetch(`get_member_details.php?id=${memberId}`);
            const member = await response.json();
            document.getElementById('firstname').value = member.FirstName;
            document.getElementById('lastname').value = member.LastName;
            document.getElementById('gender').value = member.Gender;
            document.getElementById('birthdate').value = member.DateOfBirth;
            document.getElementById('address').value = member.Address;
            document.getElementById('phone').value = member.PhoneNumber;
        } catch (error) {
            console.error('加载用户数据失败:', error);
        }
        
        modal2.showModal();
    });
}

close_updateModal.addEventListener('click', () => {
    modal2.close();
})

新建get_member_details.php文件用于返回用户JSON数据：

<?php
include("update-form.php"); // 引入数据库连接文件
$id = $_GET['id'];

// 使用预处理语句防止SQL注入
$stmt = mysqli_prepare($con, "SELECT FirstName, LastName, Gender, DateOfBirth, Address, PhoneNumber FROM tbl_members WHERE MemberID = ?");
mysqli_stmt_bind_param($stmt, "i", $id);
mysqli_stmt_execute($stmt);
$result = mysqli_stmt_get_result($stmt);
$member = mysqli_fetch_assoc($result);

echo json_encode($member);
?>

3. 修正PHP更新逻辑，使用安全的预处理语句

修改更新数据的PHP代码，正确获取ID并避免SQL注入：

<?php 
if(isset($_POST['update_submit'])){
    // 从POST获取正确的MemberID
    $id = $_POST['member_id'];
    $fName = $_POST['firstname'];
    $lName = $_POST['lastname'];
    $gender = $_POST['gender'];
    $birthDate = $_POST['birthdate'];
    $address = $_POST['address'];
    $phone = $_POST['phone'];
    
    // 使用预处理语句执行更新
    $stmt = mysqli_prepare($con, "UPDATE tbl_members SET FirstName=?, LastName=?, Gender=?, DateOfBirth=?, Address=?, PhoneNumber=? WHERE MemberID=?");
    mysqli_stmt_bind_param($stmt, "ssssssi", $fName, $lName, $gender, $birthDate, $address, $phone, $id);
    $edit_query = mysqli_stmt_execute($stmt);

    if($edit_query){
        echo "<meta http-equiv='refresh' content='0'>";
    } else {
        echo "更新失败: " . mysqli_error($con);
    }
} else {
?>
<!-- 模态框代码（已修改表单部分） -->
<dialog class="update-modal" id="modal">
    <div class="modal-form" method="dialog">
        <div class="head">
            <span class="material-icons-sharp">
                edit
            </span>
            <h1> EDIT INFO </h1>
        </div>
        <!-- 这里是修改后的表单代码 -->
        <form method="post">
            <input type="hidden" name="member_id" id="member_id">
            <div class="fillup-form">                               
                <div class="block-1">
                    <label for="firstname">First Name:</label><br>
                    <input type="text" name="firstname" id="firstname" required><br><br>
                    <label for="lastname">Last Name:</label><br>
                    <input type="text" name="lastname" id="lastname" required><br><br>
                    <label for="birthdate">Date Of Birth:</label><br>
                    <input type="date" name="birthdate" id="birthdate" required><br><br>
                    <label for="gender">Gender:</label><br>
                    <input type="text" name="gender" id="gender" required><br><br>
                    <label for="address">Address:</label><br>
                    <input type="text" name="address" id="address" required><br><br>
                    <label for="phone">Phone Number:</label><br>
                    <input type="text" name="phone" id="phone" required><br><br>
                            
                </div>
            </div>
            <div class="buttons">
                <button class="click close-updateModal">Cancel</button>
                <button class="click submit-updateModal" name="update_submit">Submit</button>  
            </div>                                
        </form>
    </div>                                                   
</dialog>
<?php } ?>