正在尝试访问已.emit但无法访问的数组数据

Trying to access array data that has been .emit and unable to

本文关键字:访问 数据 数组 emit      更新时间:2023-11-09

在我的网站负载上,我查询数据库并检索行。

但是我无法访问此评论数据

function onLoad(socket) {
    var connection = mysql.createConnection(db_access);
    connection.connect(function(err){
      if(err){
        console.log('Error connecting to Db');
        return;
      }
      console.log('Connection established');
    });
    var q = "SELECT * FROM (SELECT * FROM chat ORDER BY id DESC LIMIT 8) chat ORDER BY id ASC";
    connection.query(q, function (err, results) {
        if (err) throw err;
        //io.sockets = emit to all
        io.sockets.emit("onLoad_comment", {
            load_comment_data: new Array(results[0],results[1],results[2],results[3],results[4],results[5],results[6],results[7])
        });
        connection.end();
    });
}

我用处理数据

socket.on('onLoad_comment', function (data) {
    for (i=0; i< data.load_comment_data.length; i++) {
        alert(data.load_comment_data[0].nick);
        //var content = '<div class="msgln"><div class="chat_prof_pic"><a href="' + data.comment_data[i].url + '"><img src="' + data.comment_data[i].pic + '"></a></div><div class="chat_msg"><b>' + data.comment_data[i].nick + '</b>';
        //content += ' ' + data.comment_data[i].comment + '</div></div><hr>';
        //$('#chatbox').append(content);
        //content = '';
    }
});

我试过

  1. data.load_comment_data[0].nick
  2. data.load_comment_data[0][0]

但我就是查不到这些号码。。但是,将data.load_comment_data.length作为for循环的一部分会返回正确的数字,因此正在发送"something"。

如果我做

console.log(Array(results[0],results[1],results[2],results[3],results[4],results[5],results[6],results[7]));

我得到:

[ { id: 3,
    sender: 'K1LzR',
    sender_pic: 'https://steamcdn-a.akamaihd.net/steamcommunity/public/images/avatars/d8/d85a3b326846fa2b0f6e59acdbaa0cfef307bd87_full.jpg',
    sender_url: 'http://steamcommunity.com/profiles/76561198124567784/',
    message: ''n3',
    created_at: Thu Mar 31 2016 10:49:51 GMT-0700 (PDT) },
  { id: 4,
    sender: 'K1LzR',
    sender_pic: 'https://steamcdn-a.akamaihd.net/steamcommunity/public/images/avatars/d8/d85a3b326846fa2b0f6e59acdbaa0cfef307bd87_full.jpg',
    sender_url: 'http://steamcommunity.com/profiles/76561198124567784/',
    message: ''n4',
    created_at: Thu Mar 31 2016 10:49:51 GMT-0700 (PDT) },
  { id: 5,
    sender: 'K1LzR',
    sender_pic: 'https://steamcdn-a.akamaihd.net/steamcommunity/public/images/avatars/d8/d85a3b326846fa2b0f6e59acdbaa0cfef307bd87_full.jpg',
    sender_url: 'http://steamcommunity.com/profiles/76561198124567784/',
    message: ''n5',
    created_at: Thu Mar 31 2016 10:49:52 GMT-0700 (PDT) },
  { id: 6,
    sender: 'K1LzR',
    sender_pic: 'https://steamcdn-a.akamaihd.net/steamcommunity/public/images/avatars/d8/d85a3b326846fa2b0f6e59acdbaa0cfef307bd87_full.jpg',
    sender_url: 'http://steamcommunity.com/profiles/76561198124567784/',
    message: ''n6',
    created_at: Thu Mar 31 2016 10:49:52 GMT-0700 (PDT) },
  { id: 7,
    sender: 'K1LzR',
    sender_pic: 'https://steamcdn-a.akamaihd.net/steamcommunity/public/images/avatars/d8/d85a3b326846fa2b0f6e59acdbaa0cfef307bd87_full.jpg',
    sender_url: 'http://steamcommunity.com/profiles/76561198124567784/',
    message: ''n7',
    created_at: Thu Mar 31 2016 10:49:52 GMT-0700 (PDT) },
  { id: 8,
    sender: 'K1LzR',
    sender_pic: 'https://steamcdn-a.akamaihd.net/steamcommunity/public/images/avatars/d8/d85a3b326846fa2b0f6e59acdbaa0cfef307bd87_full.jpg',
    sender_url: 'http://steamcommunity.com/profiles/76561198124567784/',
    message: ''n8',
    created_at: Thu Mar 31 2016 10:49:53 GMT-0700 (PDT) },
  { id: 9,
    sender: 'K1LzR',
    sender_pic: 'https://steamcdn-a.akamaihd.net/steamcommunity/public/images/avatars/d8/d85a3b326846fa2b0f6e59acdbaa0cfef307bd87_full.jpg',
    sender_url: 'http://steamcommunity.com/profiles/76561198124567784/',
    message: 'test',
    created_at: Thu Mar 31 2016 11:25:16 GMT-0700 (PDT) },
  { id: 10,
    sender: 'Denilsonjvv',
    sender_pic: 'https://steamcdn-a.akamaihd.net/steamcommunity/public/images/avatars/fe/fef49e7fa7e1997310d705b2a6158ff8dc1cdfeb_full.jpg',
    sender_url: 'http://steamcommunity.com/profiles/76561198294181499/',
    message: 'fesfse',
    created_at: Thu Mar 31 2016 12:48:56 GMT-0700 (PDT) } ]

您的结果数据中没有nick。请尝试使用sender