var express = require('express');
var router = express.Router();

var mysql = require('mysql');
var connection = mysql.createConnection({
  host: "localhost",
  user: "root",
  password: "",
  database: "projekt_1"
});

/* GET home page. */
router.get('/', function(req, res, next) {

  var results;

  connection.connect();

  connection.query('SELECT * FROM users', function (err, rows, fields) {
    if (err) console.log('Query failed!');
    else results = rows;
  });

  connection.end();

  console.dir(results); // Tu je chyba!

  res.render('index', { title: 'Users' });
});

module.exports = router;