1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
|
var http = require('http');
var fs = require('fs');
var socketCount = 0;
var isInitNotes= false;
var server = http.createServer(function(req, res) {
fs.readFile('index.html', 'utf-8', function(error, content) {
res.writeHead(200, {"Content-Type": "text/html"});
res.end(content);
});
});
var io = require('socket.io').listen(server);
io.sockets.on('connection', function (socket) {
socketCount++;
io.sockets.emit('users connected', socketCount);
socket.on('disconnect', function() {
socketCount--;
io.sockets.emit('users connected', socketCount);
});
socket.on('SELVOL', function(data){
console.log(1);
var mysql = require('mysql')
console.log(2);
var db = mysql.createConnection({
host: MYHOST,
user: MYUSER,
password: MYPWD,
database: MBDD
})
console.log(3);
var ListfligthTab= new Array;
db.query('SELECT * FROM FLTINFO')
.on('result', function(Result){
ListfligthTab.push(Result);
})
.on('end', function(){
db.end();
console.log(4);
socket.emit('ENDSELVOL', ListfligthTab);
console.log(5);
})
});
socket.on('INSVOL', function(data){
var Data=[ data[0].DATA1,
data[0].DATA2,
data[0].DATA3]
var SQL='insert into FLTINFO set DATA1 = ?,'
+'DATA2= ?,'
+'DATA3= ?';
var mysql = require('mysql')
var db = mysql.createConnection({
host: MYHOST,
user: MYUSER,
password: MYPWD,
database: MBDD
})
db.query(SQL,Data);
db.end();
});
});
io.sockets.on('disconnect', function (socket) {
io.sockets.release();
});
server.listen(8080); |
