CODEWITHSUNDEEP
javascriptmysqlnode.js
Sabin Gautam
Sabin Gautam

Reputation: 11

Nodejs Mysql null value inserted on database

app.post('', (req, res) => {
    pool.getConnection((err, connection) => {
        if (err) throw err
        console.log('connected as id' + connection.threadID)
        const params = req.body
        var name = params.name
        var tagline = params.tagline
        var description = params.description
        var image = params.image

        connection.query('INSERT INTO beers (name, tagline, description, image) VALUES (name,tagline,description,image)',
            (err, rows) => {
                connection.release()

                if (!err) {
                    res.send('Successfully added record of name' + params.name)
                } else {
                    console.log(err)
                }
            })

        console.log(req.body)
    })
})

Upvotes: 1

Views: 859

Answers (1)

lpizzinidev
lpizzinidev

Reputation: 13274

As @derpirscher suggested, you should add the parameter values to the query.

Try to change your code like this:

    const { name, tagline, description, image } = req.body.params; 
    connection.query(
      'INSERT INTO beers (name, tagline, description, image) VALUES (?, ?, ?, ?)',
      [name, tagline, description, image],
      (err, rows) => {
        connection.release();

        if (!err) {
          res.send('Successfully added record of name' + params.name);
        } else {
          console.log(err);
        }
      }
    );

Upvotes: 1

Related Questions