var username = request.body.username;
var password = request.body.password;
if (username && password) {
    connection.query('SELECT * FROM users WHERE username = ? AND password = ?', [username, password], function(error, results, fields) {
        console.log(results);
        if (results.length > 0) {
            request.session.loggedin = true;
            request.session.username = username;
            // request.session.w_id = us;
            response.redirect('/');
            next();
        } else {
            response.render('login', {layout: 'login',error:'Invalid Username Or Password'});
        }
        response.end();
    });
} else {
    response.render('login', {layout: 'login',error:'Please Enter Username And Password'});
    response.end();
}