| @@ -0,0 +1,34 @@ | ||
| var express = require('express'); | ||
| var router = express.Router(); | ||
|
|
||
| /* GET home page. */ | ||
| router.get('/', function(req, res, next) { | ||
|
|
||
| var mysql = require('mysql'); | ||
|
|
||
| var con = mysql.createConnection({ | ||
| database: "fitness", | ||
| host: "localhost", | ||
| user: "root", | ||
| password: "dataGod1996roflCopter" | ||
| }); | ||
|
|
||
| con.connect(function(err){ | ||
| if (err) throw err; | ||
| console.log("Connected!"); | ||
|
|
||
| con.query("SELECT * FROM log", function (err, results, fields) { | ||
| if (err) throw err; | ||
| //console.log(results); | ||
| var dataset = JSON.stringify(results); | ||
| //dataset = 5; | ||
| res.render('testtable', { data: dataset }); | ||
| }); | ||
|
|
||
| }); | ||
|
|
||
|
|
||
|
|
||
| }); | ||
|
|
||
| module.exports = router; |
| @@ -7,5 +7,6 @@ | ||
| <body> | ||
| <h1>{{ title }}</h1> | ||
| <p>Welcome to {{ title }}</p> | ||
|
|
||
| </body> | ||
| </html> | ||
| @@ -0,0 +1,18 @@ | ||
| <!DOCTYPE html> | ||
| <html><body>Welcome Home! | ||
|
|
||
|
|
||
| <br> | ||
|
|
||
|
|
||
| <table id="Log" border="1" cellpadding="7" cellspacing="0"> | ||
| <tr> | ||
| <th>Entry ID</th> | ||
| <th>Exercise</th> | ||
| <th>Sets</th> | ||
| </tr> | ||
|
|
||
|
|
||
|
|
||
| </table> | ||
| </body></html> |
| @@ -0,0 +1,47 @@ | ||
| 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 index = require('./routes/index'); | ||
| var users = require('./routes/users'); | ||
| var table = require('./routes/table'); | ||
|
|
||
| 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(path.join(__dirname, 'public', 'favicon.ico'))); | ||
| app.use(logger('dev')); | ||
| app.use(bodyParser.json()); | ||
| app.use(bodyParser.urlencoded({ extended: false })); | ||
| app.use(cookieParser()); | ||
| app.use(express.static(path.join(__dirname, 'public'))); | ||
|
|
||
| app.use('/', table); | ||
| 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 handler | ||
| app.use(function(err, req, res, next) { | ||
| // set locals, only providing error in development | ||
| res.locals.message = err.message; | ||
| res.locals.error = req.app.get('env') === 'development' ? err : {}; | ||
|
|
||
| // render the error page | ||
| res.status(err.status || 500); | ||
| res.render('error'); | ||
| }); | ||
|
|
||
| module.exports = app; |
| @@ -0,0 +1,90 @@ | ||
| #!/usr/bin/env node | ||
|
|
||
| /** | ||
| * Module dependencies. | ||
| */ | ||
|
|
||
| var app = require('../app'); | ||
| var debug = require('debug')('test:server'); | ||
| var http = require('http'); | ||
|
|
||
| /** | ||
| * Get port from environment and store in Express. | ||
| */ | ||
|
|
||
| var port = normalizePort(process.env.PORT || '3000'); | ||
| app.set('port', port); | ||
|
|
||
| /** | ||
| * Create HTTP server. | ||
| */ | ||
|
|
||
| var server = http.createServer(app); | ||
|
|
||
| /** | ||
| * Listen on provided port, on all network interfaces. | ||
| */ | ||
|
|
||
| server.listen(port); | ||
| server.on('error', onError); | ||
| server.on('listening', onListening); | ||
|
|
||
| /** | ||
| * Normalize a port into a number, string, or false. | ||
| */ | ||
|
|
||
| function normalizePort(val) { | ||
| var port = parseInt(val, 10); | ||
|
|
||
| if (isNaN(port)) { | ||
| // named pipe | ||
| return val; | ||
| } | ||
|
|
||
| if (port >= 0) { | ||
| // port number | ||
| return port; | ||
| } | ||
|
|
||
| return false; | ||
| } | ||
|
|
||
| /** | ||
| * Event listener for HTTP server "error" event. | ||
| */ | ||
|
|
||
| function onError(error) { | ||
| if (error.syscall !== 'listen') { | ||
| throw error; | ||
| } | ||
|
|
||
| var bind = typeof port === 'string' | ||
| ? 'Pipe ' + port | ||
| : 'Port ' + port; | ||
|
|
||
| // handle specific listen errors with friendly messages | ||
| switch (error.code) { | ||
| case 'EACCES': | ||
| console.error(bind + ' requires elevated privileges'); | ||
| process.exit(1); | ||
| break; | ||
| case 'EADDRINUSE': | ||
| console.error(bind + ' is already in use'); | ||
| process.exit(1); | ||
| break; | ||
| default: | ||
| throw error; | ||
| } | ||
| } | ||
|
|
||
| /** | ||
| * Event listener for HTTP server "listening" event. | ||
| */ | ||
|
|
||
| function onListening() { | ||
| var addr = server.address(); | ||
| var bind = typeof addr === 'string' | ||
| ? 'pipe ' + addr | ||
| : 'port ' + addr.port; | ||
| debug('Listening on ' + bind); | ||
| } |