Odyssey Homer 04

const express = require('express')
const router = express.Router();

const connection = require('../../helpers/db.js');

router.use(express.urlencoded({ extended: false }));
router.use(express.json());

router.post('/signup', function(req, res, next) {
    const answer = req.body;
    console.log(answer)
    console.log(req.body.email)
    connection.query('INSERT INTO users (email, password, name, lastname) VALUES (?,?,?,?)', [req.body.email, req.body.password, req.body.name, req.body.lastname], function (error, results, fields) {
        if (error) {
            console.log(error)
            res.status(500).send("Error, see error message in server console")
        } else {
            res.status(200).send("")
        }
    });
});

module.exports = router;


/*

mysql> SELECT * from users;
+----+--------------------+------------+-------+----------+
| id | email              | password   | name  | lastname |
+----+--------------------+------------+-------+----------+
|  1 | my@email.com       | myPassw0rd | James | Bond     |
|  3 | mysecond@email.com | myPassw0rd | James | Bond     |
|  4 | mythird@email.com  | myPassw0rd | James | Bond     |
+----+--------------------+------------+-------+----------+
3 rows in set (0.00 sec)

mysql>


*/