php - $_POST 输入数组上的 foreach 返回重复字段

Question

我有一个大表，它根据数据库中的信息动态生成输入字段。提交后，表单数据通过 ajax 发送到另一个 php 文件。我需要检索特定输入字段的域 ID 来运行其他查询。如果我回显从查询中检索到的 ID，并且这些 ID 是“2”和“3”，则它会返回“2”、“2”。当页面刷新时，输入字段会变得彼此重复。

这些都是假值，因此可以安全地展示我正在使用的内容。 SOA 字段是静态的，但每个后续字段都是动态创建的。

甚至没有更改输入值，我单击更新，刷新页面，就会发生这种情况:

在“网络”选项卡(XHR 响应)上，这是在页面刷新/复制发生之前发回的数据。

"10""@""10""localhost""Success"

除了“成功”之外的一切都会在以后消失。我只是回显它们以进行调试。正如您所看到的，查询显示重复的域，而它们实际上应该是“10”和“11”。

我将从表格页面开始展示字段是如何动态生成的。为了简洁起见，我将仅显示 1 个 block (共有 5 个 block )。

<?php
$a_count = $db->count("SELECT * FROM records WHERE domain_id=? AND type=?", [$domain_id, $type['A']]);
if ($a_count > 0) : ?>
<!-- ALL OF THE LABELS ABOVE THE INPUTS -->
     <div class="row">
         <div class="col-sm-2 " style="font-weight:bold;">
             Host
         </div>
         <div class="col-sm-2" style="font-weight:bold;margin-left:30px;">
             IP
         </div>
         <div class="col-sm-2" style="font-weight:bold;margin-left:30px;">
             TTL
         </div>
         <div class="col-sm-2" style="font-weight:bold;margin-left:30px;">
            Timestamp
         </div>
         <div class="col-sm-2" style="height:20px;width:210px;"></div>
         <div class="col-sm-2" style="font-weight:bold;width:100px;margin-left:160px;">
            Delete
         </div>
     </div>
     <!-- GET THE RECORDS TO DISPLAY IN ONE ROW OF INPUTS -->
     <?php
     foreach ($records = $db->getRows("SELECT * FROM records WHERE domain_id=? AND type=?", [$domain_id, $type['A']]) as $record) {
         $rid_a = $record['id']; ?>

         <div class="row">
             <div class="col-sm-2">
                 <input type="text" class="form-control" name="A_host[]"
                                       value="<?php echo escape($record['name']); ?>">
            </div>
            <div class="col-sm-2" style="margin-left:30px;">
                                <input type="text" class="form-control" name="A_ip[]"
                                       value="<?php echo escape($record['content']); ?>">
            </div>
            <div class="col-sm-2" style="margin-left:30px;">
                                <input type="text" class="form-control" name="A_ttl[]"
                                       value="<?php echo escape($record['ttl']); ?>">
            </div>
            <div class="col-sm-2" style="margin-left:30px;">
                                <input type="text" class="form-control" name="A_timestamp[]"
                                       value="<?php echo escape($record['change_date']); ?>">
            </div>
            <div class="col-sm-2" style="height:20px;width:100px;"></div>
            <div class="col-sm-2" style="margin-left:80px;">
                                <input type="checkbox" style="margin-top:15px;margin-left:195px;" name="A_delete_checkbox" value="<?php echo escape($rid_a);?>">
            </div>
          </div>
          <?php }
       else:?>
       <!-- OTHERWISE, SHOW THERE ARE NO RECORDS -->
           <div class="row">
                NO A RECORDS AVAILABLE
           </div>
      <?php endif; ?>

这是我的 jQuery 提交表单的部分:

$('#edit_zone_form').submit(function (e) {
        e.preventDefault();
        var isEmpty = false;
        $(':input:not(:button):not(:checkbox)').each(function () { //First, check if any inputs are empty. If empty, show dialog.
            if ($(this).val() === "") {
                var error_text = $('#dialog p').text("All fields are required");
                $('#dialog').html(error_text);
                $('#dialog').dialog('option', 'title', 'Error').dialog('open');
                isEmpty = true;
                console.log("Submitted form. isEmpty = " + isEmpty);
                return false;
            }
        });
        if(!isEmpty) {
            console.log("Passed if(!isEmpty) " + isEmpty);
            var error_text = $('#dialog_confirm p').text("Please confirm your update\nbefore proceeding."); //Confirm they want to do that
            error_text.html(error_text.html().replace(/\n/g, '<br/>'));
            $('#dialog_confirm').dialog('open');
        }
        $('#confirm_button').click(function () { //Confirm button becomes a 'submit' button for ajax
            $.ajax({
                url: 'domain-edit-check.php?id=' + <?php echo json_encode($domain_id);?>, //domain_id used in destination file
                type: 'post',
                dataType: 'json',
                data: $('#edit_zone_form').serialize(),
                success: function (response) {
                    if(response === "Success") {
                        var success_text = $('#dialog p').text("Domain Successfully Updated.");
                        $('#dialog').html(success_text);
                        $('#dialog').dialog('option', 'title', 'Success').dialog('open');
                        $('#dialog').on('dialogclose', function() {
                            setTimeout(function() {
                                location.replace('domain-edit2.php?init=1&edit_domain=' + <?php echo json_encode($edit_domain);?>);
                            }, 500)
                        });
                    }
                   //THE REST OF THE CONDITIONS (error, etc)
            });
        });
    });

最后，执行处理的 php(注意 - $db->getRow 是一个自定义函数，并且在此之前一直在整个应用程序中工作):

//domain-edit-check.php

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

    $CLIENT_IP = $_SERVER['REMOTE_ADDR'];
    $DATE_TIME = date('Y-m-d H:i:s');
    $domain_id = $_GET['id']; //domain_id passed from ajax url string

    //There are no duplicates of these. They are static inputs
    $SOA_content_field = array($_POST['SOA_NS'], $_POST['SOA_Contact'], $_POST['SOA_Serial'], $_POST['SOA_Refresh'], $_POST['SOA_Retry'], $_POST['SOA_Expire']);
    $SOA_content_param = implode(" ", $SOA_content_field);
    $SOA_update = $db->updateRow("UPDATE records SET content=?, ttl=?, change_date=? WHERE domain_id=? AND type=?", [$SOA_content_param, $fields['SOA_TTL'], $DATE_TIME, $domain_id, 'SOA']))

    //After the top inputs, check all of the dynamic inputs with the update_ok function.
    //Send back results based on the outcome.
    if (update_ok($domain_id) === true) {
        echo json_encode("Success");
        $db->disconnect();

    } else {
        echo json_encode("Failure");
        $db->disconnect();
    }
}

function update_ok($domain_id)
{
    $passed = false;
    $db = new DB();

    //The different types of records for queries
    $types = array(
        'A' => 'A',
        'NS' => 'NS',
        'MX' => 'MX',
        'CNAME' => 'CNAME',
        'TXT' => 'TXT'
    );
    //CHECK ALL OF THE DYNAMIC INPUTS FROM THE FORM
    //THIS IS WHERE THE PROBLEM BEGINS
    foreach ($_POST['A_host'] as $key => $value) {

        //GET THE ID FOR ALL OF THE INPUTS AND MAKE UPDATES BASED ON THAT UNIQUE ID

        if($result = $db->getRow("SELECT id FROM records WHERE domain_id=? AND type=?", [$domain_id, $types['A']])) {
            $id = $result['id'];
            //echo json_encode($id);
            //echo json_encode($value);
            if ($update = $db->updateRow("UPDATE records SET name=? WHERE id=?", [$value, $A_host_result['id']])) {
            $passed = true;
            }
        }
    }
    //DO THE SAME FOR THE REST OF THE INPUTS (Minimum of 15 more. Some have 2-5 of each)
    foreach ($_POST['A_ip'] as $key => $value) {

    }
    foreach(etc etc as $etc => $etc) {
        //etc etc etc...
    }

如果我循环遍历 $_POST 数组，为什么我的 id 会重复？如果id不重复，我的问题就解决了。我已在测试页上尝试将此函数作为独立的代码块，并且它正确返回信息。我的 foreach($_POST) 有点奇怪，我只是不知道是什么。

Answer 1

您没有在输入中使用记录 ID。

在 HTML 中:

<input type="text" class="form-control" name="A_host[<?php echo $rid_a?>]" 
       value="<?php echo escape($record['name']); ?>">

在 PHP 中:

foreach ($_POST['A_host'] as $id => $value) {
    if ($update = $db->updateRow("UPDATE records SET name=? WHERE id=?", [$value, $id])) {
        $passed = true;
    }
}

其余输入依此类推。