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

var app= express();
app.use (bodyParser.json());
app.use (bodyParser.urlencoded({ extended: true }) );

var server=app.listen(process.env.PORT||8000, function(err){
    if(err)throw err;
    console.log('Connected to port 8000');
});

var conn=mysql.createConnection({
    host: 'localhost',
    user: 'root',
    password: 'rootpass',
    database: 'mydb'
   });
conn.connect(function(err){
     if(err)throw err;
     console.log('Connected');
    });
/*
conn.query ('CREATE DATABASE mydb', function(err, res){
       if(err)throw err;
       console.log(res);
    });
conn.query('CREATE TABLE IF NOT EXISTS laptop\
           (  ID                INT NOT NULL,\
              procesor          VARCHAR(30) NOT NULL,\
              placa video       VARCHAR(30) NOT NULL,\
              RAM               INT,\
              spatiu stocare    INT,\
              rezolutie         VARCHAR(30) NOT NULL)',
              function(err, res){
              if(err) throw err;
              console.log(res);
              }
    );
*/
app.get('/insert.html',function(req,res){
    res.sendFile(__dirname + '/insert.html');
});
app.post('/insert',function(req,res){
    var arr= [[req.body.id, req.body.procesor, req.body.placavideo,
               req.body.ram, req.body.spatiustocare, req.body.rezolutie]];
});