Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- 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>
- */
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement