我无法使用Node JS和Nunjucks从HTML呈现的MySQL表中删除行。基本上,我希望能够从表中删除行,但是删除按钮不起作用。关于我应该尝试什么的任何想法?
HTML / Nunjucks代码:
<tr> {% for results in awards %}
<td>{{ results.awardtype }}</td>
<td>{{ results.awardeename }}</td>
<td>{{ results.email }}</td>
<td>{{ results.awardtime }}</td>
<td>{{ results.awardate }}</td>
<td>{{ results.comments }}</td>
<form action="/Delete_Award" method="post">
<td align="center">
<input type="submit" value="Delete">
</form>
</tr> {% endfor %}
JS:
app.post('/Delete_Award',function(request,response) {
var connection = request.app.get('pool');
if (request.session.loggedin) {
connection.query('DELETE FROM awards WHERE awardeename = ?',[request.body.awardeename],function(error,results,fields) {
if (error) {
throw error;
} else {
response.render('Delete_Award.html',{ msg: 'Successfully deleted!' });
}
});
}
});