Storing Json into MySQL database from Node.js

Question

I know this question has been asked numerous times, but after search ferociously, I can not seem to find the answer I am looking for. I have a script in *.js format that creates a json data array then stores it in a json file.

The array setup is:

var sessionState = {
    currentWalletNdx: 0,
    genesisBlockId: 0,
    genesisBaseTarget: 0,
    genesisBlockTimestamp: 0,
    current: {
        blockHeight: 0,
        baseTarget: 0,
        startTime: 0,
        totalShare: 0,
        submitters: 0,
        bestDeadline: 0,
        totalPayments: 0,
        netDiff: 0
    },
    prevBlocks: []
};

And to store the data in a json file the function is:

saveSession: function () {
    var jsonData = JSON.stringify(sessionState, null, 2);
    fs.writeFileSync('pool-session.json', jsonData);
},

My question is, how can I write it in this js file to store the saved json array in a mysql table using the json type so I view the data later using php & mysql?

Yes I am. I know how to make a connection in node js to a mysql db but am unsure as to handle to data and insert it — Tony Andrew Horton
– Tony Andrew Horton, Commented Sep 8, 2017 at 0:56

Piyin · Accepted Answer · 2017-09-08 01:13:53Z

0

Something like this should work:

var mysql = require('mysql');
var database = mysql.createConnection({
  host: 'host',
  user: 'user',
  password: 'password',
  database: 'database'
});
database.connect(function(connectionError){
  if(connectionError){
    throw connectionError;
  }
  var sql = "INSERT INTO table(column) VALUES ('" + jsonData + "')";
  database.query(sql, function(queryError, queryResult){
    if(queryError){
      throw queryError;
    }
  });
});

Change table for the name of your table and column for the name of the column where you want to insert the JSON. And, of course, the database connection information

answered Sep 8, 2017 at 1:13

Piyin

1,8341 gold badge18 silver badges24 bronze badges

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

2 Comments

Adam Over a year ago

Isn't this vulnerable to SQL injection though?

Piyin Over a year ago

Yes it is, but I assumed it was something fast to store the numbers and access them in another environment. I could be wrong though, so I upvoted your comment in case someone else comes looking for this

Collectives™ on Stack Overflow

Storing Json into MySQL database from Node.js

1 Answer 1

2 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related