코딩 안한지가 올해로 몇해이던가?

var express = require('express');

var app = express();

var handlebars = require('express-handlebars').create({defaultLayout: 'main'});

var maria = require('mariasql');

var db = new maria({

    user: 'sir_test',

    password: '******',

    db: 'sir_test',

    charset: 'utf8'

});

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

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

app

    .use(express.static(__dirname + '/public'))

    .engine('handlebars', handlebars.engine)

    .set('view engine', 'handlebars')

    .set('port', process.env.PORT || 8888);

app.get('/', function(req, res) {

    db.query('select * from g5_member', function(err, row) {

    res.render('home', {list: row});

    });

});

app.get('/user/register', function(req, res) {

    res.render('register');

});

app.post('/user/register_update', function(req, res) {

    console.log(req.body);

    var mb_id = req.body.mb_id;

    var mb_password = req.body.mb_password;

    var mb_email = req.body.mb_email;

    db.query('insert into g5_member set mb_id = ?, mb_password = password(?), mb_email = ?', [mb_id, mb_password, mb_email], function(err, result) {

        if (err) 

            throw err;

        console.log('Last insert ID:', result);

        res.redirect(303, '/user/register-ok');

    });

});

app.get('/user/register-ok', function(req, res) {

    res.render('register-ok');

});

app.use(function(req, res) {

    res.type('text/plane');

    res.status(404);

    res.send('404 - Not Found');

});

app.listen(app.get('port'), function() {

    console.log('Express started on http://localhost:' + 

        app.get('port') + '; press Ctrl-C to terminate.');

});