在我的网站负载上,我查询数据库并检索行。
但是我无法访问此评论数据
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 = '';
}
});
我试过
- data.load_comment_data[0].nick
- 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
。