Pass data from node.js to sql query

Question

I've got some code for testing here:

bot.on('message', (msg) => {
    if (msg.text[3] === '#') {
        bot.sendMessage(msg.chat.id, "Added to DB, thanks!", {});
        connection.query('INSERT INTO botrequests (places_count, discount_count) VALUES (msg.text, msg.text)',
            function (error, results, fields) {
                if (error) throw error;
                console.log("Success");
            });
    }
})

What I wanna do is to insert msg.text twice into a table botrequests in columns places_count and discount_count. Tried using ' ' and " " but this never helped. What's the right way to pass a variable into a query statement?

Gonzalo.- · Accepted Answer · 2019-03-30 23:45:50Z

1

In order to pass values to your query, use bind parameters

connection.query('INSERT INTO botrequests (places_count, discount_count) VALUES (?, ?)',
    [msg.text, msg.text],
    function (error, results, fields) {
        if (error) throw error;
        console.log("Success");
    });

See docs

answered Mar 30, 2019 at 23:45

Gonzalo.-

12.7k5 gold badges53 silver badges84 bronze badges

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

2 Comments

lesha_ber Over a year ago

You made my day!

Gonzalo.- Over a year ago

that's great @lesha_ber ! Remember to set up as a correct answer if it answered your question

Collectives™ on Stack Overflow

Pass data from node.js to sql query

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related