Thursday, 13 April 2017

How to render multiple sql query and data in Nodejs

I am having problems rendering multiple data query to page.I have done a lot of research but getting an error like Failed to look up view my code is following:

app.get('/xem', function(req,res){
pool.query("SELECT * FROM phim WHERE slider = '1' ORDER BY id DESC Limit 9", function (error, result, client){
    if (!!error){
        console.log('Error query');
    } else {
        res.render('xem', {slider:result});
    }
});
pool.query("SELECT * FROM phim WHERE new = '1'", function (error, result, client){
    if (!!error){
        console.log('Error query');
    } else {
        res.render('xem', {new:result});
    }
}); 
});

When run it code i give error:

82|     <!-- END HEAD -->

83| <h1> ok </h1>

>> 84| <%= new %>

85| 

new is not defined

How to fix it?



via John Kerim

No comments:

Post a Comment