kZM9Uk7x

1Retrieving data from database in node.js
2client.query(
3'CREATE TEMPORARY TABLE IF NOT EXISTS '+USER+
4'(username VARCHAR(255), '+
5'password VARCHAR(255), '+
6'name VARCHAR(255), '+
7'picture VARCHAR(255), '+
8'PRIMARY KEY(username))'
9);
10	
11function checkUser(username,password){
12client.query('SELECT username, password FROM ' + USER + 'WHERE username=?', [username] , 'AND password=?', [password] 
13function (err, results, fields) {
14        if (err) {
15            throw err;
16        }
17 });
18}
19	
20function checkUser(username,password,haveResult) {
21    client.query('SELECT username, password FROM ' + USER + 'WHERE username=? AND password=?', [username, password],  
22    function (err, results, fields) {
23        if (err) {
24            // problems
25            throw err;
26        } else {
27            // do something with data - it is in results array
28            var checkResult = true; // here something depending on query result
29            haveResult(checkResult); // continue via callback
30        }
31    });
32}
33
34
35// use it
36checkUser('bar', 'baz', function(isGood) {
37    console.log('user is' + (isGood? 'good' : 'bad') );
38});