Sync data with a remote MySQL database about esp-rfid HOT 3 CLOSED

var mysql = require('mysql');
var connection = mysql.createConnection({
  host: 'localhost',
  user: 'admin',
  password: '1',
  database: 'tek_servis'
});

const WebSocket = require('ws');
const wss = new WebSocket.Server({
  port: 8080
});

wss.broadcast = function broadcast(data) {
  wss.clients.forEach(function each(client) {
    if (client.readyState === WebSocket.OPEN) {
      client.send(data);
    }
  });
};

function sorgula(data) {
  connection.query("select c.hesapkodu, c.cariadi, c.tipi, c.cinsi, c.marka, c.model, c.tamadi, c.sfiyat, c.afiyat, c.ptipi, c.barkod, (case when 1=1 then(SELECT sum(coalesce(d.miktar,0)*m.gc) FROM stokgcm m, stokgcd d WHERE m.gcsno=d.gcsno and m.aktif=1 and d.hesapkodu=c.hesapkodu) else 0 end) as Kalan from cariler c where c.hesapkodu like '153%' and c.bayino=1 and c.aktif=1 and (c.barkod='" + data + "') or (c.tamadi like '%" + data + "%')", function(error, results, fields) {
    if (error) throw error;
    wss.broadcast(JSON.stringify(results));
  });
}

wss.on('connection', function connection(ws) {
  ws.on('message', function incoming(message) {
    var obj = JSON.parse(message);
    if (obj.type === "sorgu") {
      sorgula(obj.data);
    }
  });
});