Advertisement
Guest User

Untitled

a guest
Nov 20th, 2016
85
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.46 KB | None | 0 0
  1. var mysql = require('mysql');
  2. var connection = mysql.createConnection(
  3. {
  4. host : 'hackteams.c6p7kpyzcymg.us-east-1.rds.amazonaws.com',
  5. user : 'test',
  6. password : 'password',
  7. database : 'hackteams'
  8. }
  9. );
  10.  
  11. // user's username:
  12. var user = 'bbob';
  13.  
  14. connection.query("SELECT * FROM users WHERE username = '" + user + "'", function(err, rows, field) {
  15. console.log(rows[0]);
  16. // do something... ex. rows[0].email
  17.  
  18. connection.end();
  19. });
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement