Retrieving data from database in node.js

Question

If i have this table on dataBase.js file:

client.query(
'CREATE TEMPORARY TABLE IF NOT EXISTS '+USER+
'(username VARCHAR(255), '+
'password VARCHAR(255), '+
'name VARCHAR(255), '+
'picture VARCHAR(255), '+
'PRIMARY KEY(username))'
);

and lets say i want to check if i have a given user already in my dataBase,

how can i get the data after running the following query? :

function checkUser(username,password){
client.query('SELECT username, password FROM ' + USER + 'WHERE username=?', [username] , 'AND password=?', [password] 
function (err, results, fields) {
        if (err) {
            throw err;
        }
 });
}

if an error occurred, it will be handled but how can get the needed data?

any help will be much appreciated!

this is just an example from some site, what does results and fields hold? — Itzik984
– Itzik984, Commented Jan 24, 2012 at 3:06
@nicolaskruchten no because i cant compile it. im doing something wrong over there — Itzik984
– Itzik984, Commented Jan 24, 2012 at 4:23

Andrey Sidorov · Accepted Answer · 2012-01-24 07:10:27Z

2

if there is no errors, you have your data in the results

function checkUser(username,password,haveResult) {
    client.query('SELECT username, password FROM ' + USER + 'WHERE username=? AND password=?', [username, password],  
    function (err, results, fields) {
        if (err) {
            // problems
            throw err;
        } else {
            // do something with data - it is in results array
            var checkResult = true; // here something depending on query result
            haveResult(checkResult); // continue via callback
        }
    });
}


// use it
checkUser('bar', 'baz', function(isGood) {
    console.log('user is' + (isGood? 'good' : 'bad') );
});

answered Jan 24, 2012 at 7:10

Andrey Sidorov

25.6k5 gold badges65 silver badges78 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Retrieving data from database in node.js

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related