foreach on$\u post input array返回重复字段

j9per5c4  于 2021-06-20  发布在  Mysql
关注(0)|答案(1)|浏览(322)

我有一个大表,它根据数据库中的信息动态生成输入字段。提交时,表单数据通过ajax发送到另一个php文件。我需要检索作为特定输入字段的域的id来运行其他查询。如果我回显从查询中检索到的id,并且id是,例如,“2”和“3”,它将返回“2”、“2”。当页面刷新发生时,输入字段彼此重复。
这些都是假值,所以可以安全地显示我的工作内容。soa字段是静态的,但是每个后续字段都是动态创建的。

即使不更改输入值,我也会单击“更新”,刷新页面,然后发生以下情况:

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

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

除“成功”之外的一切都将在以后消失。我只是回发回去调试。如您所见,查询显示了重复的域,而实际上它们应该是“10”和“11”。
我将从表页开始,展示如何动态生成字段。为了简洁起见,我只显示一个块(这个有5个块)。

<?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...
    }

如果我在$\u post数组上循环,为什么我的id会被复制?如果身份证没有重复,我的问题就解决了。我在一个测试页上作为一个独立的代码块尝试了这个函数,它正确地返回了信息。我的foreach($\u post)有点不稳定,我只是不知道是什么。

ggazkfy8

ggazkfy81#

输入中没有使用记录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;
    }
}

其余的输入也是如此。

相关问题