There are 2 ways to insert data from the req.body
of a route:
Method #1
router.post('/', (req, res) => {
const userInfo = req.body;
const sql = "INSERT INTO users SET ?";
mysqlConnection.query(sql, userInfo, (err, rows, fields) => {
if (!err) {
res.send(rows);
} else {
console.log(err.message);
res.send(err);
}
})
});
Method #2
router.post('/', (req, res) => {
const { name, username } = req.body;
const sql = "INSERT INTO users (name, username) VALUES ('${name}', '${username}')";
mysqlConnection.query(sql, (err, rows, fields) => {
if (!err) {
res.send(rows);
} else {
console.log(err.message);
res.send(err);
}
})
});