Here is my code in routes
router.get('/chkjson', function(req, res, next) {
req.getConnection(function(err,connection){
var ItemArray = [];
var myset = [];
var query = connection.query('SELECT `db_name` FROM `database`',function(err,rows)
{
ItemArray.push({
allDb : []
});
var k=0;
for (var i in rows) {
retset = JSON.stringify(rows[i]);
var jsonset = JSON.parse(retset);
console.log(ItemArray);
console.log("========");
myset.push(ItemArray);
ItemArray[0].allDb.push(jsonset.db_name);
}
});
console.log(myset); //blank array
console.log("-----");
console.log(ItemArray); //blank array
console.log("-----");
res.render( 'new/post-select-table',
{
title: 'Select Database',
session_store:req.session,
});
});
});
I'm getting blank array when I'm trying to print array outside for loop. Can anyone help me where im going wrong.
via sunshine
No comments:
Post a Comment