Monday, May 20, 2024
 Popular · Latest · Hot · Upcoming
46
rated 0 times [  53] [ 7]  / answers: 1 / hits: 19415  / 11 Years ago, tue, march 26, 2013, 12:00:00

I am trying get value from database. Trying it out with a demo example. But I am having problem to synchronize the calls, tried using callback function. I am beginner in node.js, so don't know if this is the right way.



FILE 1 : app.js



var data;

var db = require('./db.js');

var query = 'SELECT 1 + 1 AS solution';

var r = db.demo(query, function(result) { data = result; });

console.log( 'Data : ' + data);


FILE 2 : db.js



var mysql      = require('./node_modules/mysql');

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

module.exports.demo = function(queryString, callback) {
try {
connection.connect();
console.log('Step 1');

connection.query(queryString, function(err, rows, fields) {
console.log('Step 2');
if (err) {
console.log(ERROR : + err);
}
console.log('The solution is: ', rows[0].solution);

callback(rows[0].solution);

return rows[0].solution;
});
callback();

connection.end();
console.log('Step 3');
}
catch(ex) {
console.log(EXCEPTION : + ex);
}
};


OUTPUT :



Step 1
Step 3
Data : undefined
Step 2
The solution is: 2


Referred to this question also, but it didnt solve my problem :
nodeJS return value from callback


More From » mysql

 Answers
5

The issue is this:



var r = db.demo(query, function(result) { data = result; });

console.log( 'Data : ' + data);


The console.log will run before the callback function gets called, because db.demo is asynchronous, meaning that it might take some time to finish, but all the while the next line of the code, console.log, will be executed.



If you want to access the results, you need to wait for the callback function to be called:



var r = db.demo(query, function(result) { 
console.log( 'Data : ' + result);
});


This is how most code dealing with I/O will function in Node, so it's important to learn about it.


[#79355] Monday, March 25, 2013, 11 Years  [reply] [flag answer]
Only authorized users can answer the question. Please sign in first, or register a free account.
ravenl

Total Points: 338
Total Questions: 107
Total Answers: 112

Location: Belize
Member since Mon, Jun 20, 2022
2 Years ago
ravenl questions
Thu, Feb 18, 21, 00:00, 3 Years ago
Tue, Jan 12, 21, 00:00, 3 Years ago
Tue, Mar 17, 20, 00:00, 4 Years ago
;