node.js mysql result,Node.js返回MySQL查询结果

I have the following function that gets a hexcode from the database

function getColour(username, roomCount)

{

connection.query('SELECT hexcode FROM colours WHERE precedence = ?', [roomCount], function(err, result)

{

if (err) throw err;

return result[0].hexcode;

});

}

My problem is that I am returning the result in the callback function but the getColour function doesn't return anything. I want the getColour function to return the value of result[0].hexcode.

At the moment when I called getColour it doesn't return anything

I've tried doing something like

function getColour(username, roomCount)

{

var colour = '';

connection.query('SELECT hexcode FROM colours WHERE precedence = ?', [roomCount], function(err, result)

{

if (err) throw err;

colour = result[0].hexcode;

});

return colour;

}

but of course the SELECT query has finished by the time return the value in colour

解决方案

You have to do the processing on the results from the db query on a callback only. Just like.

function getColour(username, roomCount, callback)

{

connection.query('SELECT hexcode FROM colours WHERE precedence = ?', [roomCount], function(err, result)

{

if (err)

callback(err,null);

else

callback(null,result[0].hexcode);

});

}

//call Fn for db query with callback

getColour("yourname",4, function(err,data){

if (err) {

// error handling code goes here

console.log("ERROR : ",err);

} else {

// code to execute on data retrieval

console.log("result from db is : ",data);

}

});