index.js

//
// sys_server.js
//

//Import module
var express = require('express'),
    app = express(),
    server = require('http').createServer(app),
    io = require('socket.io').listen(server);
var mysql = require('mysql');
var path = require('path');
var fs = require('fs');

app.use(express.static('public'));

// index
app.get('/',function(req,res){
  res.sendFile( __dirname + '/' + 'index.html');
});
//wyciaganie danych z forms
app.get('/signIn', function (req, res) {
    var getLOGIN = req.query.formLoginName;
    var getPASS = req.query.formLoginPass;

    console.log(getLOGIN);
    console.log(getPASS);

    var connMySQL = connON.connect(function(err){
    if(err){
        logs('mysqlConn_F'); //conn false
        return;
    }else{
        logs('mysqlConn_T'); //conn true

        var queryStringTL = 'SELECT name FROM user';
        var queryStringTP = 'SELECT pass FROM user';

//        SELECT name FROM user

        var checkTrueLOGIN = connON.query(queryStringTL, function (err, results, fields){
            if (err){
                console.log('LOG_Błąd przy wykonaniu zapytania: checkTrueNAME');
            }else{
                return results[0].solution;
            }});
        var checkTruePASS = connON.query(queryStringTP, function (err, results, fields){
            if (err){
                console.log('LOG_Błąd przy wykonaniu zapytania: checkTruePASS');
            }else{
                return results[0].solution;
            }});
        console.log(checkTrueLOGIN);//test
        console.log(checkTruePASS);//test

//        if(getLOGIN == checkTrueLOGIN && getPASS == checkTruePASS){
//            //login true
//        }else{
//            //login false
//        }

        console.log(getLOGIN);//test
        console.log(getPASS);//test
    }});
});

//server.listen
var host = '127.0.0.1';
var port = 80;
server.listen(port, host, (err) => {
    if(err){
        logs('serverStatus_F');
    }else{
        logs('serverStatus_T');
        //
    }
});

//connect mysql db
var cHost = ('mysql2.ph-hos.osemka.pl');
var cUser = ('1493645577_f@192.168.30.208');
var cPass = ('Admin12345');
var cDB =   ('user');
var db_access = {
    host     : cHost,
    user     : cUser,
    password : cPass,
    database : cDB
};
var connON = mysql.createConnection(db_access);
var connOFF = connON.end();

////////////////////////////////////////////
//console.log - wszystkie monity - logs('');
function logs(l) {
    switch(l){
        case 'serverStatus_T':
            console.log('');
            console.log('LOG_Server - ON');
            console.log("LOG_Host: http://%s:%s", host, port);
            console.log('');
            break;
        case 'serverStatus_F':
            console.log('');
            console.log('LOG_Server - OFF');
            console.log('LOG_Błąd: Nie można włączyć serwera');
            console.log('');
            break;
//
        case 'mysqlConn_T':
            console.log('LOG_Status połączenia do bazy danych: POŁĄCZONO');
            break;
        case 'mysqlConn_F':
            console.log('LOG_Status połączenia do bazy danych: NIE POŁĄCZONO');
            break;
//
            case 'loginF':
            console.log('LOG_Złe hasło / login!');
            break;
//

//
        default:
            console.log('LOG_Nie znaleziono takiego błędu!');
    }
    return l;
};