var express = require('express');
var ejs = require('ejs');
var bodyParser = require('body-parser');
var mysql = require('mysql');

var connect = mysql.createConnection({
    host: "localhost",
    user: "root",
    password: "",
    database: "artbook"
});

var app = express();
app.set('view engine', 'ejs');
app.use(bodyParser.urlencoded({
    extended: true
}));
app.get('/', function(req, res){
    res.render('./index');
});
app.post('/', function(req, res){
   connect.connect(function(err){
        if(err) throw err;
        var sql = 'SELECT imie FROM konta WHERE imie = "'+req.body.login+'" AND nazwisko = "'+req.body.password+'";'
        connect.query(sql, function (rows, fields, err){
            if(err) throw err;
            for(var i in rows) {
                if(req.body.login === rows[i].imie && req.body.password === rows[i].nazwisko){
                    res.render('./login')
                }
            }
        });
    });
});
app.listen(3000);
console.log('Port serwera: 3000');