How can I pass mysql result in object using node js?

Question

Can anyone knows how can I pass MySQL result to a JSON object using NodeJS?

// my code
var mysql = require('mysql');
var records = {};

var connection = mysql.createConnection({
  host: 'localhost',
  user: 'root',
  password: ''
});

connection.query('USE MyDB');

function getRecords() {
  connection.query("select * from records where id = ?", id, function(err, result) {
    if (err) {
        return done(err);
    }

    records = result;
    return records;
  });
}

From these code, I want to use the return records in other operations in my project. Can anyone help me to pass MySQL result to JSON object so I can use the data outside the function?

Thank you.

xShirase · Accepted Answer · 2014-10-07 02:41:43Z

3

It is already an object (more precisely an array of objects).

Let's say your table structure is : 'field1, field2, field3'

Your result object will look like :

[
  { //that's result[0], and contains the values of your first result row
    field1 : row0value1,
    field2 : row0value2,
    field3 : row0value3
  },
  { //then result[1], contains the next row, etc...
    field1 : row1value1,
    field2 : row1value2,
    field3 : row1value3  
  },
   ...
]

So you can access result as a normal array, and each field as a property of result[i]

Then, you need to know that as everything else in Node, the query will be ran asynchronously. Therefore, you can use a callback to get your value.

Add a callback to your function :

function getRecords(cb) {
  connection.query("select * from records where id = ?", id, function(err, result) {
    if (err) throw(err); 
    cb(result);
  });
}

Then, when you need the result, you can use :

getRecords(function(res){
  records = res;
});

edited Oct 7, 2014 at 2:41

answered Oct 7, 2014 at 2:31

xShirase

12.4k4 gold badges55 silver badges86 bronze badges

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

3 Comments

jun_mich0327 Over a year ago

Thank you @xShirase, how can I pass these array on the variable as a result?

jun_mich0327 Over a year ago

As you can see in my code sample, I wrote 'return records' at the end of the function. I need to use those function in other methods and when I call that function, it returns undefined value. I wanna know to use the function returning JSON object. Thanks

jun_mich0327 Over a year ago

Yes, need to use callback to use the query result, now I can use the sql query result in my process. Thank you! However, is there any way to store the SQL result into a variable?

Collectives™ on Stack Overflow

How can I pass mysql result in object using node js?

1 Answer 1

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related