NodeJS和MySQL,处理行(NodeJS and MySQL, dealing with rows)
我是NodeJS的初学者,目前我正在使用node,express和mysql包。 我试图检查该人是否已经注册。
如果是这样,则应执行以下代码:
req.session.user = user; req.flash('success_notification', 'You are logged in'); console.log("creating session :" ,req.session.user);
但是,当我尝试检查它是否设置为true时,
authenticated
始终保持'假'。if (authenticated === true)
有谁知道我做错了什么?
这是我处理登录尝试的代码:
router.post('/login', function (req, res) { var user = req.body.username; var password = req.body.password; var authenticated = false; var query = "Select * from user where username = \'" + user + "\'" + " AND pw = \'" + password + "\'"; connection.query(query, function (err,rows,fields) { if (err) console.log(err); else if (rows.length) { authenticated = true; console.log(authenticated); } else { console.log('False Password or Username'); } }); console.log(authenticated); if (authenticated === true) { req.session.user = user; req.flash('success_notification', 'You are logged in'); console.log("creating session :" ,req.session.user); } res.redirect('/'); });
I am beginner with NodeJS and I am currently using the node, express, and mysql packages. I'm trying to check whether the person is already registered or not.
If so, the following code should be executed:
req.session.user = user; req.flash('success_notification', 'You are logged in'); console.log("creating session :" ,req.session.user);
However,
authenticated
always remains 'false' when I try to check if it was set to true.if (authenticated === true)
Does anyone know what I am doing wrong?
This is my code to handle login attempts:
router.post('/login', function (req, res) { var user = req.body.username; var password = req.body.password; var authenticated = false; var query = "Select * from user where username = \'" + user + "\'" + " AND pw = \'" + password + "\'"; connection.query(query, function (err,rows,fields) { if (err) console.log(err); else if (rows.length) { authenticated = true; console.log(authenticated); } else { console.log('False Password or Username'); } }); console.log(authenticated); if (authenticated === true) { req.session.user = user; req.flash('success_notification', 'You are logged in'); console.log("creating session :" ,req.session.user); } res.redirect('/'); });
原文:https://stackoverflow.com/questions/41613643
更新时间:2022-04-29 10:04