// Register

app.post('/register', (req,res) => {
  let username = req.body.username
  let password = req.body.password

  db.one('INSERT INTO userinfo (username,password) VALUES($1,$2) RETURNING userid;',[username,password])
  res.render('login', {messageA: 'Thank you for registering! Please login below.'})
})


// Login

app.post('/login', (req,res) => {
  let username = req.body.username
  let password = req.body.password
  db.one('SELECT * FROM userinfo WHERE username = $1 AND password = $2', [username, password])
  .then((user) => {
    res.redirect('/index')
  }).catch(error => {
    res.render('login', {message: 'The User Name or Password is incorrect. Please try again!'})
  })
})