var express = require('express');
var router = express.Router();
var mysql=require('mysql');
var con=mysql.createConnection({ host:"localhost",
user:"root",
password:"",
database:"dbnode"});
con.connect(function(err){if(err){console.log(err);}
else {

}});
/* GET home page. */
router.get('/', function(req, res, next) {

     fn=req.query["t1"];
     ln=req.query["t2"];
     sl=req.query["t3"];
  q="insert into tbemp(fname,lname,salary)values('"+fn+"','"+ln+"','"+sl+"');";
con.query(q,function(err){
if(err)
console.log(err);
else
console.log("record is added");}
);


  res.render('entervalues', { title: 'Expre', first:fn, last:ln, salary:sl });
});
module.exports = router;