signup.js.save.1

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

var router=express.Router();

const bodyParser = require('body-parser');
var connection = mysql.createConnection({
host:'localhost',
user:'root',
password: 'vishal',
database: 'airline'
});


router.post('/',function(req,res){
connection.connect(function(err) {
  if (err) throw err;
  console.log("Connected!");
});

var uid = Math.random()* (10000 -1000)+1000; 

var sql = "insert into users values('" "','"+req.body.uname+"','"+req.body.email+"','"+req.body.pwd+"','"req.body.email"','"+req.body.phno+"')"
console.log(req.body);
connection.query(sql, function (err, result) {
    if (err) throw err;
else{
    console.log("1 record inserted");
        console.log(result);
       res.redirect('http://35.154.64.95:8080/login');
    }

connection.end();
});
});

module.exports=router;