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

//creating mysql connection
var con = mysql.createConnection({
  host: "localhost",
  user: "root",
  password: "hariomsbko",
  database: "popular"
});
con.connect(function(err){
        if(err) throw err;
    });

var app= express();

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

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

app.use(express.static('ui'));

app.get('/',function(req, res){
    res.sendFile(__dirname+ '/ui'+ '/home.html');
});
app.post('/profile_login', function(req, res){
    res.sendFile(__dirname+ '/ui/profile.html');

});
app.post('/new_signup', function(req, res){

    //Queries

    console.log('Here it redirects!');
    res.redirect('/sample');

});

app.get('/sample', function(req, res){
    console.log('blah!');
    res.render('sample');
});

var listener= app.listen(8009);
console.log("server running on port %s", listener.address().port);