1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27
| app.get('/user/login/',function(req,res){
io.on('connection',function(socket){
socket.on('userAuth',function(sReq){
var user = sReq;
toQuery = [sReq[0],sReq[1]];
connection.query('SELECT * FROM users WHERE `username` = ? AND `password` = ? ', toQuery , function(err,result){
if(result[0]==undefined){
socket.emit('authS','error')
}
else{
socket.emit('authS','success');
// HERE req.session.userID = 'HERE'
}
});
});
});
res.render('userAuth.ejs',{
titlePage : 'Se connecter'
});
}); |
Partager