lundi 4 avril 2016

Login authentication in node.js using sqlite3 - bookshelf

I'm trying to create a very simple login authentication in node.js, using bookshelf and sqlite3.

Yes i know there are many many examples on the internet, but none really uses either sqlite or bookshelf, they are all mostly based on passport and mongoose.

When i try to check the login, i get the error data.

This is my code

Login.js

var express = require('express');
var router = express.Router();
var knex = require('knex')(require('../knexfile.js').development);
var bookshelf = require('bookshelf')(knex);
var app = express();

var User = bookshelf.Model.extend({
tableName: 'users'
});

router.get('/', function (req, res) {
res.render('Login');
});

router.post('/', function (req, res) {

var userName = req.body.user_ime;
var pw = req.body.password;
var user_name = User.user_name;
var password = User.password;

if (userName == user_name && pw == password)
{
    console.log("Success!");
}
else
{
    console.log("Error!");
}
});
module.exports = router;

Login.ejs

<h2>Login</h2>
<form method="post">
<label>User name</label><br>
<input type="text" name="user_name" id="user_name"/><br><br>
<label>Password</label><br>
<input type="password" name="password" id="password"/><br><br>
<input type="submit" value="Login"/>
</form>

Any ideas, why it is not working? If we manage to fix that, i would also like to create a session for a logged in user. Any suggestions?

Thank you very much!

Aucun commentaire:

Enregistrer un commentaire