我有一个动态插入表单,如果把它插入到数据库中,它应该将值附加到表中。所以,我用了如下javascript / jquery函数:
else{
var data = 'action=insert&porcab=' + porcAbandoned + '&porcan=' + porcAnswered;
data = data + '&secab=' + secAbandoned + '&secan=' + secAnswered + '&name=' + name;
$.ajax({
type: "POST",
url: "manager.php",
async: false,
data: data,
cache: false,
success: function(response){
var result = Number(response);
var row = '<tr id="'+result+'"><td class="edit porcAbandoned '+result+'>'+name+'</td>';
row = row + '<td style="text-align: center;" class="edit porcAbandoned '+result+'>'+porcAbandoned+' %</td>';
row = row + '<td style="text-align: center;" class="edit secAbandoned '+result+'>'+secAbandoned+'</td>';
row = row + '<td style="text-align: center;" class="edit porcAnswered '+result+'>'+porcAnswered+' %</td>';
row = row + '<td style="text-align: center;" class="edit secAnswered '+result+'>'+secAnswered+'</td>';
row = row + '<td style="text-align: center;">-</td>';
row = row + '<td style="text-align: center;"><a class="delete" href="#"><img src="assets/delete.png" /></a></td></tr>';
$('#clients > tbody:last').append(row);
}
});
}
先前的IF只是验证,如果未通过验证,则不执行AJAX调用。我试图警告该行,不过即使存储的数据正确,表中仍不显示任何数据。此外,返回的响应是插入的表的ID,因此可以将其删除。这是怎么了?
What about this test jsfiddle. This works and adds a row. However, the used variables must be handed to the functions using the "context" property, see here: jQuery.ajax
You didn't close the class attribute, f.ex:
row = row + '<td style="text-align: center;" class="edit porcAbandoned '+result+'>'+porcAbandoned+' %</td>';
is:
row = row + '<td style="text-align: center;" class="edit porcAbandoned '+result+'">'+porcAbandoned+' %</td>';
________________________________________________________________________________/\