我在我的Express應用程序中使用Mysql

使用此代碼:

// register

router.post("/register", async (req, res) => {

const hashed = await bcrypt.hash(req.body.pass, 10);

const user = {

uname: req.body.uname,

phone: req.body.phone,

pass: hashed

};

let sql = "INSERT INTO user SET ? ";

db.query(sql, user, (err, result) => {

if (err) throw err;

console.log(`${user.uname} INSERTED INTO users`);

});

});

// GET USERS

router.get("/users", (req, res) => {

db.query("SELECT * FROM user", (err, results) => {

if (err) {

return res.send(err);

} else {

return res.json({

data: results

});

}

});

});

但是,當我想登錄用戶并讓bcrypt將請求的pass與用戶pass進行比較時,它將給出以下錯誤:

SyntaxError: Unexpected identifier

// loggin

router.post("/login", async (req, res) => {

var username = req.body.uname;

var password = req.body.pass;

db.query(

"SELECT pass FROM user WHERE uname = ?",

[username],

(err, result, fields) => {

try {

if (await bcrypt.compare(password, result)) {

console.log('Success')

}

} catch {

console.log('catched')

}

}

);

});

總結

以上是生活随笔為你收集整理的mysql未找到bcrypt_使用mysql和bcryptjs时出现意外的标识符语法错误的全部內容，希望文章能夠幫你解決所遇到的問題。

如果覺得生活随笔網站內容還不錯，歡迎將生活随笔推薦給好友。