How can I insert request body into a MySQL database using express js?

Question

So I am trying to make a small api with MySQL and Express JS, after following a small tutorial online on how to use MySQL with Express I tried to make this api and send requests with the postman, to insert the data I sent using postman I used in my code the req.body.data syntax, I tried using tha classic SQL syntax of INSERT INTO table (col1, col2) VALUES (val1, val2) using interpolation for the request body and I also tried the SET ? as I saw in the tutorial I watched. When trying to send the request with postman I keep getting the Cannot read property 'title' of undefined error. How can I insert data that I send to the table with postman?

JavaScript

app.get('/addtodo' , (req, res) => {
    let sql = 'INSERT INTO todo SET ?'
    let post = {
        title: req.body.title,
        body : req.body.body,
        date: req.body.date,
        importance: req.body.importance
    }
    db.query(sql, post, (err, res) => {
        if(err) throw err;
        console.log('success');
        console.log(res);
    });
});

virender nehra · Accepted Answer · 2019-09-17 05:51:37Z

3

Use Post method instead get because you can not pass body in get method

app.post('/addtodo' , (req, res) => {
    let sql = 'INSERT INTO todo SET ?'
    let post = {
        title: req.body.title,
        body : req.body.body,
        date: req.body.date,
        importance: req.body.importance
    }
    ...
});

edited Sep 17, 2019 at 5:51

answered Sep 16, 2019 at 10:16

virender nehra

6228 silver badges16 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Vengleab SO · Accepted Answer · 2019-09-16 10:07:07Z

0

GET request has no body, it contains only query or params

answered Sep 16, 2019 at 10:07

Vengleab SO

8165 silver badges14 bronze badges

Comments

user11216850 · Accepted Answer · 2019-09-16 10:15:27Z

0

change app.get(...) to app.post(...) in javascript code..

in this case send POST request through postman

answered Sep 16, 2019 at 10:15

user11216850

Collectives™ on Stack Overflow

How can I insert request body into a MySQL database using express js?

3 Answers 3

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related