正确的身份验证 NodeJS Express MySQL

Question

所以我有这个查询，我对逻辑的工作原理有点困惑。 我正在创建一个新的用户注册方法，其中有一个检查用户是否使用相同的电子邮件的方法。 我在发布查询时使用 POSTMAN。

第一个查询工作正常，电子邮件检查方法和注册新查询，而对于第二个查询，电子邮件检查有效，但注册新电子邮件不起作用，POSTMAN 一直加载到一分钟左右，直到它说"无法得到回复"。

第一个(作品(

exports.postContact = router.post("/api/users/new", (req, res) => {
var today = new Date();
var users = {
"first_name": req.body.first_name,
"last_name": req.body.last_name,
"email": req.body.email,
"password": req.body.password,
"created": today,
"modified": today
}
var email = req.body.email;
mySQL.query('SELECT * FROM users WHERE email = ?', [email], function (err, results, fields) {
if (results.length > 0) {
if (results[0].email == email) {
res.send({
"code": 204,
"status": 'Failed',
"message": "This email address is already registered, please login instead"
});
}
}
else {
mySQL.query("INSERT INTO users SET ?", users,
(err, results, fields) => {
if (err)
res.send({
"code": 400,
"status": 'Failed',
"message": 'Something wrong with the connection'
})
res.send({
"code": 400,
"status": 'Success',
"message": 'User is successfully registered'
})
}
);
}
});
});

第二个(不起作用(

exports.postContact = router.post("/api/users/new", (req, res) => {
var today = new Date();
var users = {
"first_name": req.body.first_name,
"last_name": req.body.last_name,
"email": req.body.email,
"password": req.body.password,
"created": today,
"modified": today
}
var email = req.body.email;
mySQL.query('SELECT * FROM users WHERE email = ?', [email], function (err, results, fields) {
if (results.length > 0) {
if (results[0].email == email) {
res.send({
"code": 204,
"status": 'Failed',
"message": "This email address is already registered, please login instead"
});
}
else {
mySQL.query("INSERT INTO users SET ?", users,
(err, results, fields) => {
if (err)
res.send({
"code": 400,
"status": 'Failed',
"message": 'Something wrong with the connection'
})
res.send({
"code": 400,
"status": 'Success',
"message": 'User is successfully registered'
})
}
);
}
}
});
});

Answer 1

可能需要刷新 SQL 语句。
我相信这是正确的：

INSERT INTO users SET ?

MySQL 的正确插入查询：

INSERT INTO table
(column1, column2, ... )
VALUES
(expression1, expression2, ... ),
(expression1, expression2, ... )

这里有一个参考链接。