Save xml file text in databse using node.js

Question

I am trying to save xml string to MySQL database here is my code:- I am using MySQL module for manage database;

   //I am reading the xml file from path using this code
   var stream = fs.createReadStream(path);
   stream.setEncoding('utf8');
   stream.on('data', function (chunk) {
     var text=chunk.toString('utf8');
     //here is the error i.e invalid syntax in MySQL query
     con.query('insert into table_name(text) values("'+text+'")',function(err,data){
         //allways getting error.
     });         
   });

I know the error because of invalid characters in text variable. So how I can concatenate or escape the string please help me.

Thanks

Andrey Sidorov · Accepted Answer · 2014-08-06 07:49:18Z

1

Build your query from parameters like this:

 con.query('insert into table_name(text) values(?)', [text], function(err,data){
    //...
  })

this way text is escaped automatically by mysql client library

answered Aug 6, 2014 at 7:49

Andrey Sidorov

25.6k5 gold badges65 silver badges78 bronze badges

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

Collectives™ on Stack Overflow

Save xml file text in databse using node.js

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related