Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- var express = require('express');
- var router = express.Router();
- var session = require('express-session');
- var app = express();
- //init seesion
- function setCookie(){
- app.set('trust proxy', 1) ;
- app.use(session({
- secret: 'My Secret Key',
- resave: false,
- saveUninitialized: true,
- cookie: { id: 0 }
- }));
- }
- //init connection
- var conn = require('./cfg');
- conn = conn.connection;
- app.use(session({ secret: 'keyboard cat',resave: false, saveUninitialized: true, cookie: { maxAge: 60000 }}))
- //page request TODO POST at the moment put 'real' username and password
- router.get('/', function(req, res) {
- //setCookie();
- if (req.session.cookie.id) {
- conn.query('SELECT * FROM users WHERE username=? AND password=?',["admin", "123"], function(err, rows, fields) {
- if (err) { throw err; }
- if(rows.length){
- var id = rows[0].password;
- sess.id = id;
- }
- });
- if(sess.id){
- res.write('Hello User! ');
- }
- } else {
- sess.views = 1
- res.end('welcome to the session demo. refresh!')
- }
- res.send('HomePage');
- });
- module.exports = router;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement