I am learning node.js. Writing this code for fetching result from DB and trying to add it in global array . The result get added using array.push or array[index]=object, But it is not accessible outside the connection.query scope. Here is my script.
var userData = [];
var query = 'SELECT * FROM user_registration limit 5';
connection.query(query, function(err, rows) {
if (err) throw err;
for (var i in rows) {
userData[i]=[];
userData[i]=rows[i];
//console.log(userData);
}
//console.log(userData);
});
console.log("Printing Query result");
console.log(userData);
var name='';
var numArr=[];
var query = 'SELECT * FROM user_registration limit 5';
connection.query(query, function(err, rows) {
for(var j = 0; j < 5;j++){
numArr[j]=[];
numArr[j]=j;
}
name="Tasleem";
});
console.log("Printing Simple Array");
console.log(numArr);
console.log("Name :"+name);