var mysql = require('mysql');

// setup mysql
var dbcon = mysql.createConnection({
    host: 'localhost',
    database: 'test',
    user: 'flip',
    password: 'flop'
});

dbcon.connect(function (err) {
    if (err) throw err;
    console.log("Connected to db");
});
module.exports = dbcon;

var dbcon = require('../db');
.
.
router.post('/signup', function (req, res) {
    console.log(req.body);
   /* knex('users').insert( {
        user_id: 1,
        password: req.body.su_password,
        u_firstname: req.body.su_firstname,
        u_lastname: req.body.su_lastname,
        u_gender: req.body.su_gender,
        u_dob: req.body.su_date,
    }).then(function(arg){
        console.log(arg);
    });
    */
    dbcon.connect(function (err) {
        var sqlv = {
            user_id: 1,
            password: req.body.su_password,
            u_firstname: req.body.su_firstname,
            u_lastname: req.body.su_lastname,
            u_gender: req.body.su_gender,
            u_dob: req.body.su_date
        };

        /*var sql = "insert into `users` values (?,??,??,??,??,??,??);";
        var sqlv = [1,req.body.su_email, req.body.su_password, req.body.su_firstname, req.body.su_lastname, req.body.su_gender, req.body.su_date];
        sql = mysql.format(sql,sqlv);
        */
        //var sql ="insert into usertmp (`username`,`password`) values ('"+req.body.su_email+"','"+req.body.su_password+"');";
        dbcon.query("insert into users values ? ;", sqlv, function (err, result) {
            if (err) {
                console.log(err);
                throw err;
            }
            console.log("inserted into users " + result);
        });
    });
res.redirect('/');
});

{ su_firstname: 'user',
  su_lastname: 'virus',
  su_email: 'user@mail.com',
  su_gender: 'm',
  su_date: '1999-01-01',
  su_password: 'passowrd00' }