时间戳

首页 > 解决方案 > 我在 nodejs 中的 mysql 查询有什么问题？

mysql - 我在 nodejs 中的 mysql 查询有什么问题？

问题描述

因此，我正在尝试使用 nodejs 将表单中的日期输入查询到我的数据库中的表中。整个交互的代码如下：

app.post('/register', checkNotAuthenticated, async (req, res) => {
    const firstname = req.body.first_name
    const lastname = req.body.last_name
    const email = req.body.email_id
    const hashedPassword = await bcrypt.hash(req.body.password, 10)
    try {
        res.redirect("/login")
    } catch {
        res.redirect('/register')
    }

    const sql = "INSERT INTO users (first_name, last_name, email, password) VALUES ('"+firstname+"', '"+lastname+"','"+email+"', '"+hashedPassword+"')"
     con.query(sql, function(err, result) {
        if (err) throw err
    console.log('New user registered: ' + users)
    })
})

其他一切似乎都很好，除了当我通过注册表单注册用户时，向终端抛出以下错误：

[nodemon] restarting due to changes...
[nodemon] starting `node server.js`
Connected to mysql database!
/Users/vaidiklapalikar/Desktop/current project/node_modules/mysql/lib/protocol/Parser.js:437
      throw err; // Rethrow non-MySQL errors
      ^

ReferenceError: users is not defined
    at Query.<anonymous> (/Users/vaidiklapalikar/Desktop/current project/server.js:83:43)
    at Query.<anonymous> (/Users/vaidiklapalikar/Desktop/current project/node_modules/mysql/lib/Connection.js:526:10)
    at Query._callback (/Users/vaidiklapalikar/Desktop/current project/node_modules/mysql/lib/Connection.js:488:16)
    at Query.Sequence.end (/Users/vaidiklapalikar/Desktop/current project/node_modules/mysql/lib/protocol/sequences/Sequence.js:83:24)
    at Query._handleFinalResultPacket (/Users/vaidiklapalikar/Desktop/current project/node_modules/mysql/lib/protocol/sequences/Query.js:149:8)
    at Query.OkPacket (/Users/vaidiklapalikar/Desktop/current project/node_modules/mysql/lib/protocol/sequences/Query.js:74:10)
    at Protocol._parsePacket (/Users/vaidiklapalikar/Desktop/current project/node_modules/mysql/lib/protocol/Protocol.js:291:23)
    at Parser._parsePacket (/Users/vaidiklapalikar/Desktop/current project/node_modules/mysql/lib/protocol/Parser.js:433:10)
    at Parser.write (/Users/vaidiklapalikar/Desktop/current project/node_modules/mysql/lib/protocol/Parser.js:43:10)
    at Protocol.write (/Users/vaidiklapalikar/Desktop/current project/node_modules/mysql/lib/protocol/Protocol.js:38:16)
[nodemon] app crashed - waiting for file changes before starting...

这个你能帮我吗。提前致谢。PS我是nodejs和mysql的初学者，所以如果可能的话，请相应地帮助我，因为我不知道为什么会产生这个错误。

标签： mysqlnode.js

解决方案

推荐阅读