var express = require('express');

var app = express();

var path = require("path");

var mysql      = require('mysql');

app.use(express.static(__dirname + "/public"));



var server = app.listen(3000, function(){

   var host = server.address().address

    var port = server.address().port

    console.log("Toimii", host, port)

})





/*var express = require('express');

var path = require('path');

var favicon = require('serve-favicon');

var logger = require('morgan');

var cookieParser = require('cookie-parser');

var bodyParser = require('body-parser');

var mysql      = require('mysql');



var routes = require('./routes/index');

var users = require('./routes/users');



var app = express();



// view engine setup

app.set('views', path.join(__dirname, 'views'));

app.set('view engine', 'jade');



// uncomment after placing your favicon in /public

//app.use(favicon(__dirname + '/public/favicon.ico'));

app.use(logger('dev'));

app.use(bodyParser.json());

app.use(bodyParser.urlencoded({ extended: false }));

app.use(cookieParser());

app.use("/public", express.static(__dirname, '/public'));



app.use('/', routes);

app.use('/users', users);



// catch 404 and forward to error handler

app.use(function(req, res, next) {

  var err = new Error('Not Found');

  err.status = 404;

  next(err);

});



// error handlers



// development error handler

// will print stacktrace

if (app.get('env') === 'development') {

  app.use(function(err, req, res, next) {

    res.status(err.status || 500);

    res.render('error', {

      message: err.message,

      error: err

    });

  });

}



// production error handler

// no stacktraces leaked to user

app.use(function(err, req, res, next) {

  res.status(err.status || 500);

  res.render('error', {

    message: err.message,

    error: {}

  });

});



*/

var mysql      = require('mysql');

var connection = mysql.createConnection({

  host     : 'localhost',

  user     : 'root',

  password : 'perkele',

  database : 'URL'

});





document.getElementById("hae").addEventListener("click", toiminto());



function toiminto(){



connection.connect();



connection.query('SELECT UUSI from LINKIT where ALKUPERAINEN = "www.facebook.com" ', function(err, rows, fields) {

  if (!err) {

    console.log('/', rows);

  }

  else {

    connection.query('INSERT INTO LINKIT (ALKUPERAINEN) VALUES ("WWW.FACEBOOK.COM"); ' , function(err, rows, fields) {

  if (!err) {

    connection.query('SELECT UUSI from LINKIT where ALKUPERAINEN = "www.facebook.com" ', function(err, rows, fields) {

      if (!err) {

          console.log('/', rows);

        }

      else

        //syotto.innerHTML = 'ERROR!';

        document.getElementById('syotto').value = 'ERROR!';

      });

  }

  else

    //syotto.innerHTML = 'ERROR!';

    document.getElementById('syotto').value = 'ERROR!';

}

);

};



connection.end();



}



//module.exports = app;