How to render multiple sql query and data in Nodejs

Question

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?

strah · Accepted Answer · 2017-04-13 15:33:30Z

There are two issues with your approach:

res.render() ends the http request, therefore it will fail when called more than once.
You are executing two asynchronous functions and you don't take care of the order of execution

Try this:

var async = require('async');
app.get('/xem', function(req,res){
    var final = {};
    async.series({
        slider: function(cb) {
            pool.query("SELECT * FROM phim WHERE slider = '1' ORDER BY id DESC Limit 9", function (error, result, client){
                cb(error, result);
            })
        },
        new: function(cb){
            pool.query("SELECT * FROM phim WHERE new = '1'", function (error, result, client){
                cb(error, result)
            })
        }
    }, function(error, results) {
        if (!error) {
            res.render('xem', results);
        }
    });
});

I don't know if your pool uses promises, so just in case this code uses async approach

abdulbari · Accepted Answer · 2017-04-13 14:28:32Z

0

The code which you have written is not correct for both queries.

You will get always first query result in response and in first query result you are sending slider as key and expecting name in response

res.render('xem', {slider:result});

change it with

res.render('xem', {new:result});

Since you are giving name key is in second query result which is not reachable in your case

answered Apr 13, 2017 at 14:28

abdulbari

6,2625 gold badges41 silver badges65 bronze badges

Comments

strah · Accepted Answer · 2017-04-13 15:47:29Z

0

Thank you everyone. I had it working, sample code:

app.get('/xem', function(req,res){
    pool.query("SELECT * FROM phim WHERE slider = '1' ORDER BY id DESC Limit 9", function (error, result, client){
        var result1 = result;
        link('https://drive.google.com/file/d/0BxG6kVC7OXgrQ1V6bDVsVmJMZFU/view?usp=sharing', function(data){
            var dataxem = data;
            pool.query("SELECT * FROM user", function (error, result, client){
                var user = result;
                res.render('xem', {slider:result1, link:data, user:user});
            });
        });
    });
})

edited Apr 13, 2017 at 15:47

strah

6,7404 gold badges35 silver badges45 bronze badges

answered Apr 13, 2017 at 15:37

John Kerim

75 bronze badges

Comments

Linux · Accepted Answer · 2018-08-25 08:36:24Z

0

app.use('/', (req,res) => {
    connection.query('select * from users', function(err, rows, fields){
      if(err) return;
      console.log(rows[0]);
      res.send(rows);
  });
});

answered Aug 25, 2018 at 8:36

Linux

3534 silver badges10 bronze badges

1 Comment

scopchanov Over a year ago

Probably an explanation would be also helpful.

Collectives™ on Stack Overflow

How to render multiple sql query and data in Nodejs

4 Answers 4

Comments

Comments

Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

Comments

Comments

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related