var express = require('express');
var app = express();
var bodyParser = require('body-parser')
var url = bodyParser.urlencoded({ extended: false })

// var session = require('express-session');
// app.use(session({secret: 'ssshhh'}));
// var sess;

var cors = require('cors');
app.use(cors());

const mysql = require('mysql');
const crypto = require('crypto');
const secret = 'abcdefg';

const db = mysql.createConnection({
  host : 'localhost',
  port: '3307',
  user : 'root',
  password : 'usbw',
  database : 'user'
});
db.connect();

app.listen(8000);

app.post('/Register', url, (req, res) => {

  var FullName = req.body.fullname
  var Username = req.body.username
  var Email = req.body.email
  var Password = req.body.password

  console.log(FullName);
  console.log(Username);
  console.log(Email);
  console.log(Password);

  const encpass = crypto.createHash('sha256', secret).update(Password).digest('hex');

  var sql = "INSERT INTO newusers (FullName, Username, Email, Password) VALUES ('"+FullName+"','"+Username+"','"+Email+"','"+encpass+"')";
  db.query(sql, (err, result) => {
    if(err) throw err;
    // console.log(result);
  });
})