使用Node JS从MySQL数据库删除行

我无法使用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!' });
                }
            });
        }
    });

https://pasteboard.co/IG55dUp.png

ling5090 回答:使用Node JS从MySQL数据库删除行

暂时没有好的解决方案,如果你有好的解决方案,请发邮件至:iooj@foxmail.com
本文链接:https://www.f2er.com/3127910.html

大家都在问