users.post('/register', (req, res) => { let user = req.body.user; conn.query("SELECT username from users WHERE username = ?", [user], (err, rows) => { if(err) throw err; console.log(rows[0]['username']); if(user === rows[0]['username']) { res.status(409).send("Username already exists. Please try again."); } else { bcrypt.hash(req.body.password, saltRounds, (err, hash) =>{ console.log(user); let password = hash; conn.query("INSERT INTO users (username, password) values (?, ?)", [user, password], (err, rows) => { if(err) throw err; console.log(rows); res.send("User successfully created."); }); }); } }); });