$_POST输入数组上的foreach返回重复的字段
$_POST输入数组上的foreach返回重复的字段
提问于 2018-06-03 01:44:02
我有一个很大的表，它根据数据库中的信息动态地生成输入字段。提交后，表单数据通过ajax发送到另一个php文件。我需要检索域的in，这些域是运行其他查询的特定输入字段。如果我回显从查询中检索到的it，并且it是"2“和"3"，则返回"2”、"2“。当页面刷新发生时，输入字段变成彼此重复的字段。
这些都是假值，所以可以安全地显示我正在处理的内容。SOA字段是静态的，但后续的每个字段都是动态创建的。
在不更改输入值的情况下，我单击update，刷新页面，然后就会发生这种情况：
在Network选项卡(XHR Response)上，这是在页面刷新/复制发生之前发回的数据。
"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...
}如果我循环遍历$_POST数组，为什么我的id是重复的？如果id不重复，我的问题就解决了。我在一个测试页面上作为一个独立的代码块尝试了这个函数，它正确地返回了信息。我的foreach($_POST)有些不对劲，我就是不知道是什么。
回答 1
Stack Overflow用户
回答已采纳
发布于 2018-06-03 03:16:53
您没有在输入中使用记录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;
}
}对于其余的输入，依此类推。
页面原文内容由Stack Overflow提供。腾讯云小微IT领域专用引擎提供翻译支持
原文链接：
https://stackoverflow.com/questions/50659575
复制相关文章
相似问题