app.js

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

var htmlController = require('./controllers/htmlController');

var port = process.env.PORT || 3007;

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

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

app.use('/', function (req, res, next) {
	console.log('Request Url:' + req.url);
	
	var con = mysql.createConnection({
		host: "localhost",
		user: "root",
		password: "root",
		database: "addressbook",
		port: 8889
	});
	
	con.query('SELECT People.ID, Firstname, Lastname, Address FROM People INNER JOIN PersonAddresses ON People.ID = PersonAddresses.PersonID INNER JOIN Addresses ON PersonAddresses.AddressID = Addresses.ID',
		function(err, rows) {
			if(err) throw err;
			console.log(rows);
		}
	);
	
	next();
});

htmlController(app);


app.listen(port);