gistfile1.txt

app.post('/api/users', (req, res) => {
  const { firstname, lastname, email } = req.body
  connection.promise().query(
    'INSERT INTO users(firstname, lastname, email) VALUES (?, ?, ?)',
    [firstname, lastname, email],)
    .then(result=>res.status(201).send('User successfully saved')
    .catch(err=>res.status(500).send('Error saving the user'))
    )
})

// If needed to check the result
app.get('/api/users', (req, res) => {
  connection.promise().query('SELECT * FROM users')
    .then(result=>res.status(200).json(result))
    .catch(err=>res.status(500).send('Error retrieving data from database'))
})