php - 如何使用 PHP/MYSQLI 更新数据库记录并与传递的变量保持在同一页面上

Question

我已经搜索了一段时间了，但没有找到任何有用的东西。我的两个主要问题如下:

1) 更新记录2) 记录更新后，将同一条记录Post回页面。

PHP:

if (isset($_GET['id'])) { // checks for id
    if (isset($_POST['submit'])) { //check if submit is selected
        if (is_numeric($_POST['id'])) { //validates the id


            if ($stmt = $mysqli -> prepare($con,"UPDATE hdd_tracking Set 
            ticket = ?,
            serial = ?,
            vol_name = ?,
            drivetype = ?,
            project = ?,
            notes = ?,
            encrypt_date =?,
            encryption_password = ?,
            fedX_tracking = ?,
            fedX_rt_tracking = ?,
            where id = ?
            ")){
                $stmt -> bind_param(
                "issssssssss",
                $_POST['ticket'],
                $_POST['serial'],
                $_POST['vol_name'],
                $_POST['drivetype'],
                $_POST['project'],
                $_POST['notes'],
                $_POST['encrypt_date'],
                $_POST['encryption_password'],
                $_POST['fedX_tracking'],
                $_POST['fedX_rt_tracking']);

                $stmt ->execute();
                $stmt -> close();
            } else{
            die ("Error. Could not prepare SQL statement.");
            }
        }
        header('location:/pdsdashboard.com/it_services/hdd_tracking/index.php');
    }   
}

该表单是通用表单。

<form class="form-inline insertDrive" role="form" name="update" method="post" action="review.php">
<table style="border-collapse: separate; border-spacing: 10px;">
    <thead>
        <tr>
            <th colspan="4" border="0" style="background-color: #F1E7CD;">
                <label class="col-sm-2">ID: <?php echo $_GET['id'];?><label>                    
            </th>
        </tr>
    </thead>
    <tr align="left">
        <td>
            <label class="center">Ticket:</label>
        </td>
        <td>
            <input type="text" class="form-control" name="ticket" id="ticket" placeholder="Ticket">
        </td>
    </tr>
    <tr>
        <td>
            <label class="center">Volume Name:</label>
        </td>
        <td>
            <input type="text" class="form-control" name="vol_name" id="vol_name" placeholder="Volume Name">
        </td>
        <td>
            <label class="center">Type:</label>
        </td>
        <td>
            <input type="text" class="form-control" name="drivetype" id="drivetype" placeholder="Type">
        </td>
    </tr>

    <tr>
        <td>
            <label class="center">Project:</label>
        </td>
        <td>
            <input type="text" class="form-control" name="project" id="project" placeholder="Project">
        </td>
        <td>
            <label class="center">Encryption:</label>
        </td>
        <td>
            <input type="text" class="form-control" name="encryption_password" id="encryption_password" placeholder="Encryption">
        </td>
    </tr>

    <tr>
        <td>
            <label class="center">Date:</label>
        </td>
        <td>
            <input type="text" class="form-control" name="encrypt_date" id="encrypt_date" placeholder="Date">
        </td>
        <td>
            <label>Serial:</label>
        </td>
        <td>
            <input type="text" class="form-control" name="serial" id="serial" placeholder="Serial">
        </td>
    </tr>

    <tr>
        <td>
            <label class="center">Tracking:</label>
        </td>
        <td>
            <input type="text" class="form-control" name="fedX_tracking" id="fedX_tracking" placeholder="Tracking">
        </td>
        <td>
            <label class="center">Return:</label>
        </td>
        <td>
            <input type="text" class="form-control" name="fedX_rt_tracking" id="fedX_rt_tracking" placeholder="Return">
        </td>
    </tr>
    <tr>
        <td>
            <label class="center">Notes:</label>
        </td>
        <td colspan="3">
            <textarea type="text" class="form-control" name="notes" id="notes" placeholder="Notes" style="width:100%;"></textarea>
        </td>
    </tr>
    <tr>
        <td colspan="2">
            <button type="submit" class="btn btn-small btn-info" id="submit" name="submit">Submit</button>
        </td>

    </tr>
</table>
</form>

Answer 1

你的问题出在这里:

header('location:/pds029/pdsdashboard/it_services/hdd_tracking/');

您正在将用户发送到一个页面，但您没有告诉该页面传递 GET 参数。

尝试这样的事情:

header('location:/pds029/pdsdashboard/it_services/hdd_tracking/?id='.$_GET['id']);