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

var connection=mysql.createConnection({
host:'localhost',
user:'root',
password:'a',
database:'node'
});

var app = express();
app.use(session({
    secret:'secret',
    resave:true,
    saveUninitialized:true
}));
app.use(bodyParser.urlencoded({extended:true}));
app.use(bodyParser.json());
app.get('/register', function(request, response)
{
    response.sendFile(path.join(__dirname + '/register.html'));
});

app.post('/register?true', function(request,response)
{
    var username=request.body.username;
    var password=request.body.password;
    var email=request.body.email;
    if(username && password && email)
    {
        connection.query("INSERT INTO `accounts` (`id`, `username`, `password`, `email`) VALUES (null, ?,?,?)", [username,password,email], function(error,results,fields)
        {
            if(results.lenght > 0)
            {
                response.send("Registrazione effettuata con successo!");
            }
            else
            {
                response.send("Oops, c'è stato un errore durante la registrazione..");
            }
            response.end();
        });
    }
});

app.listen(3000);