JS node-mysql bools 表现得很奇怪

JS node-mysql bools acting weird

本文关键字:node-mysql bools JS      更新时间:2023-09-26

我有这个函数,我需要返回真或假。 问题是,它似乎没有正确运行。 如果它确实返回 false,它不会断开客户端的连接,如果它确实返回 true,它仍然会执行"console.log('断开客户端...')"我完全迷失了。 :( 这是针对node.js mysql和 socket.io

法典:

if(!client_to_server_00(header,data,len)){
    // should send the server a packet to terminate the connection on
               their end...
    // It should send 0x00 SERVER->CLIENT (will implement later)
    console.log('Disconnecting client...'); // This always shows no matter what
    client.emit('disconnect');  // **This does not work!
}else{
    console.log('ID VERIFIED!  WELCOME!');
 }
=====================================================================================================================================================================================================================================================

===

// LOGIN INFORMATION
function client_to_server_00(header, data, len){
// We are already connected to the database
var z = decodeFromHex(data);    // find the username
z = returnvalue(z,1,len);       // the code was a little off (ill fix it later)
console.log(z);                 // make sure we have this correct
// In this example.  The database returns 'oh'  And z = 'oh'
client.query('USE '+TEST_DATABASE);
client.query(
 'SELECT * FROM '+TEST_TABLE,
function selectCb(err, results, fields) {
if (err) {
  throw err;
}
var first = results[0];
console.log('USRNAME: ['+first['name']+']');  // Make sure we have it
if(first['name'] == z){
console.log('Correct');
return true;                    // I need client_to_server_00 function to return true if correct
}else{
console.log('Incorrect');
return false;                   // I need client_to_server_00 function to return false if incorrect
}
})
};

这是非常常见的错误。你缺少异步编程的基本概念 - 你必须将回调传递给你的client_to_server_00函数,并在完成异步操作(在本例中为数据库连接)时调用它。