var express = require('express');
var app = express();
var mysql = require('mysql');

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

connection.connect(function(error) {
    if(!!error) {
        console.log('Error');
    } else {
        console.log('Connected');
    }
});

app.get('/', function(req, res) {
    connection.query("SELECT Name FROM chat", function(error, rows, fields) {
        if(!!error) {
            console.log('Error in the query');
        } else {
            console.log('SUCCESS!n');
            console.log(rows);
            res.send('Hello, ' + rows);
        }
    });
});

app.listen(1337);