Guest User

Untitled

a guest
Nov 22nd, 2017
88
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.69 KB | None | 0 0
  1. router.post('/', function(req, res){
  2. var mysql = req.app.get('mysql');
  3. var sql = "INSERT INTO pokemon (pokemonname, evolutionlevel) VALUES(?,?)";
  4. var sql2 = "INSERT INTO location (locationname) VALUES(?, ?)";
  5. var inserts = [req.body.pokemonname, req.body.evolutionlevel, req.body.locationname];
  6. sql = mysql.pool.query(sql, sql2, inserts, function(error, results, fields){
  7. if(error){
  8. res.write(JSON.stringify(error));
  9. res.end();
  10. } else{
  11. res.redirect('/location');
  12. }
  13. });
  14. });
Add Comment
Please, Sign In to add comment