Guest User

Untitled

a guest
Jul 13th, 2016
47
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.70 KB | None | 0 0
  1. function login (email, password, callback) {
  2. var connection = mysql({
  3. host : 'sql13.cpt4.host-h.net',
  4. user : 'prodxhqtgj_4_r',
  5. password : 'uk4itiK8',
  6. database : 'bmgworld'
  7. });
  8.  
  9. connection.connect();
  10.  
  11. var query = "SELECT email, password " +
  12. "FROM customer WHERE email = ?";
  13.  
  14. connection.query(query, [email], function (err, results) {
  15. if (err) return callback(err);
  16. if (results.length === 0) return callback();
  17. var user = results[0];
  18.  
  19.  
  20.  
  21. callback(null, {
  22. id: user.customer_id.toString(),
  23. nickname: user.firstname,
  24. email: user.email
  25. });
  26.  
  27. return callback();
  28.  
  29. });
  30.  
  31. }
Add Comment
Please, Sign In to add comment