Advertisement
Guest User

Untitled

a guest
Sep 5th, 2017
68
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.68 KB | None | 0 0
  1. var mysql = require('mysql');
  2. var pool = mysql.createPool({
  3. connectionLimit: 100,
  4. host: "localhost",
  5. user: "...user...",
  6. password: "...pw...",
  7. database: "...db..."
  8. });
  9.  
  10. app.get('/*', function(req, res) {
  11.  
  12.  
  13. var sql = mysql.format("SELECT * FROM test_rest WHERE location=? LIMIT 2", [user_input]);
  14.  
  15.  
  16. pool.getConnection(function(err,connection) {
  17. if (err) throw err;
  18. connection.query(sql, function (err, result, fields) {
  19. connection.release();
  20. if (err) throw err;
  21.  
  22.  
  23. });
  24. });
  25.  
  26.  
  27. var jsonResponse = [];
  28. var obj = {};
  29. obj["text"] = 'hi this is' + user_nsew_1;
  30.  
  31. jsonResponse.push(obj);
  32. res.send(jsonResponse);
  33. });
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement