下面是我的代码
我正在将数据对象从客户端 javascript 发送到此函数 数据打印其值
内部套接字
和
inside socket.on -> connection.query(sql,[], function(err,rows({data prints here}(
和
inside socket.on -> connection.query(sql,[], function(err,rows({data prints here}(-> connection.query(sql,[], function(err,rows({data prints undefined}(
socket.on('sendmessage', function (data) {
var data = JSON.parse(data);
console.log(data);
if (data.cuserid != '' && users_connected.hasOwnProperty(data.cuserid) && fs.existsSync(users_connected[data.cuserid]['sessionfile'])) {
sql = "update hired set echat='Y' where eid=? and jobid=? and jid=? and status in ('given','finished')";
connection.query(sql, [data.cuserid, data.jobid, data.userid], function (err, rows) {/*console.log(this.sql);*/ });
sql = "insert into chat_messages(fromid,toid,jobid,message,received_date) select ?,?,?,?,NOW() from hired where echat='Y' and jchat='Y' and jobid=? and jid in(?,?) and eid in(?,?) and status in ('given','finished')";
connection.query(sql, [data.cuserid, data.userid, data.jobid, data.message, data.jobid, data.cuserid, data.userid, data.cuserid, data.userid], function (err, rows) {
console.log("dataretrieved : ", data); if (!err && users_connected[data.userid] != '') {
socid = users_connected[data.userid]['socket'];
sql = "select id as userid,username, userphoto from us_signup where id=?";
connection.query(sql, [data.userid], function (err, rows) {
console.log(data); //prints undefined
if (!err) {
var data = {
'userphoto': rows[0].userphoto,
'username': rows[0].username,
'userid': rows[0].userid,
'cuserid': data.cuserid,
'message': data.message,
'jobid': data.jobid
}
io.to(socid).emit('message', JSON.stringify(data));
}
})
}
});
}
})
您正在最深的级别创建一个新作用域data
:
if (!err) {
var data = { ... }
...
}
此变量被提升到包含函数的顶部,因此代码变得等效于以下内容:
var data; // clobbers the existing `data` variable...
console.log(data); // ...so here it will log `undefined`...
if (!err) {
data = { ... } // ...because it receives a value here.
...
}
解决 方案:
- 不要在那里使用
var
- 开始使用
let