var http = require('http');
var mysql = require('mysql');
var express = require('express');
var app = express();
var bodyParser = require('body-parser');
app.use(bodyParser.urlencoded({extended: true}));
app.use(bodyParser.json());


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

console.log('MySQL Connection details  ');

app.get('/:id', function(request, response) {
    connection.query('SELECT * FROM employee WHERE id='+request.params.id, function(err, rows, fields) {
        console.log('Connection result error '+err);
        response.end("result"+JSON.stringify(rows))
    });
})


app.post('/insert',function(req, res) {
     var post  = req.body.name;
     console.log(post);
    var query =connection.query('INSERT INTO employee(name)VALUES("'+post+'")', function(err, result) {
        console.log(err);
        res.end();
    });
});

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

app.listen(8081);