Send db-query-result to client

Question

Trying to send results from a node-mysql database query to the client.

Code:

io.on('connection', function(socket){
    socket.on('admin', function() {
        [...]
        locations = getUserInfo(function(e,c){...});
        [...]
    });
});

function getUserInfo(callback) {
    var json = '';
    connection.query('SELECT * from locations WHERE loc_id = 1', function(err, results, fields) {
        if(err)
           return callback(err, null);

        console.log('The query-result is: ', results[0]);

        json = JSON.stringify(results);

        console.log('JSON-result: ', json);
        callback(null, json);
    });
};

getUserInfo(function(e,c){
    console.log(c);
});

This is working as expected.

But I don't want to write it to the console but send it to the client (with socket.io). How can I do this? All my attempts ended in getting undefined as result.

Outside of the function. But I'm not sure if I get your question right. — drhirn, Mar 09 '15 at 14:47
How are you sending it back? Also, `locations` will always be undefined, since getUserInfo isn't returning anything. — cviejo, Mar 09 '15 at 15:21
Why isn't getUserInfo returning anything? How could I make it returning something and store the result in a variable? — drhirn, Mar 10 '15 at 10:38

cviejo · Accepted Answer · 2015-03-09T15:36:18.583

0

You might be sending the locations object back, which is always undefined. Try:

io.on('connection', function(socket){
  socket.on('admin', function() {
      getUserInfo(function(e,c){
        if(!e){
            socket.emit('locations', c);
        }
      });
  });
});

edited Mar 09 '15 at 15:36

answered Mar 09 '15 at 15:28

cviejo

4,388
19
30

This is working. But I'm not understanding why. See question in comments above. Thx! – drhirn Mar 10 '15 at 10:39

Send db-query-result to client

1 Answers1