How to use session variable with NodeJs?

Question

I have the following NodeJS code:

  let sql = `SELECT box_id, cubby_id, occupied, comport
           FROM box
           WHERE longestDimension = ?
           AND LOWER(box_id) = LOWER(?)`;

    connection.query(sql, [boxSelectedDimension, boxSelectedValue] , function(err, rows, fields) {
        if (!err) {
            for(var i=0; i< rows.length; i++) {
                // Make the comparaison case insensitive
                if (rows[i].occupied == `unoccupied`) {
                    console.log("free");

                    var comport = rows[i].comport;
                    var command = "open" + rows[i].cubby_id;

Essentially i would like to store the value of the comport and command variable in a session variable so that the value of these variable could be used in another router page in nodejs.

I am not sure how to store and retrieve the session variable.

are you using express?

Satish Patel
– Satish Patel

2016-11-23 03:46:17 +00:00
Commented Nov 23, 2016 at 3:46 — Satish Patel
– Satish Patel, Commented Nov 23, 2016 at 3:46
yes i am using express

code_legend
– code_legend

2016-11-23 03:48:47 +00:00
Commented Nov 23, 2016 at 3:48 — code_legend
– code_legend, Commented Nov 23, 2016 at 3:48

Satish Patel · Accepted Answer · 2021-12-31 09:42:12Z

32

Install express-session and use as follows:

var express = require('express');
var session = require('express-session');
var app = express();
app.use(session({secret:'XASDASDA'}));
var ssn ;
app.get('/',function(req,res){
    ssn=req.session;
   /*
   * Here we have assign the 'session' to 'ssn'.
   * Now we can create any number of session variable we want.    
   * Here we do like this.
   */
   // YOUR CODE HERE TO GET COMPORT AND COMMAND
   ssn.comport; 
   ssn.command; 
});

Following code explain simple login and logout using session. The session we initialize uses secret to store cookies. Hope this helps.

var ssn;
app.get('/',function(req,res) { 
  ssn = req.session; 
  if(ssn.email) {
    res.redirect('/admin');
  } else {
    res.render('index.html');
  }
});
app.post('/login',function(req,res){
  ssn = req.session;
  ssn.email=req.body.email;
  res.end('done');
});
app.get('/admin',function(req,res){
  ssn = req.session;
  if(ssn.email) {
    res.write('<h1>Hello '+ssn.email+'</h1>');
    res.end('<a href="+">Logout</a>');
  } else {
    res.write('<h1>login first.</h1>');
    res.end('<a href="+">Login</a>');
  }
});
app.get('/logout',function(req,res){
  req.session.destroy(function(err) {
    if(err) {
      console.log(err);
    } else {
      res.redirect('/');
    }
  });
});

edited Dec 31, 2021 at 9:42

answered Nov 23, 2016 at 4:05

Satish Patel

1,8741 gold badge28 silver badges40 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

code_legend Over a year ago

Thank you. What would be the purpose of app.use(session({secret:'XASDASDA'})); and how do i set the variables values?

Satish Patel Over a year ago

secret is used for cookie handling etc and we put some secret to use express session and normally for different views we authenticate the session before routing to he views based on the condition and requirement.

code_legend Over a year ago

okay perfect thanks for that, but how i would i define the session value of comport and command to be use in that page?

Collectives™ on Stack Overflow

How to use session variable with NodeJs?

1 Answer 1

3 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related