node.js pass array to mysql callback

Question

Is any possible to pass array into mysql callback like:

connection.query('SELECT count(id) as wynik FROM used where asset_id = 
  \''+asid+'\'', inventory[i],function(err,wiersze){
    console.log(inventory[i]);
});

Now inventory[i] is not avaible inside, but I need to have it.

What should inventory[i] be?Which mysql module are you using? Looking at the introduction in node-mysql, I'd guess you want connection.query('SELECT count(id) as wynik FROM used where asset_id = \''+asid+'\'', function(err,wiersze) { console.log(wiersze[0].wynik); }); — Narigo
– Narigo, Commented Jan 23, 2016 at 18:49

michael · Accepted Answer · 2016-01-24 22:37:46Z

1

Since you're inside a for-loop, you'll need to use an immediately-invoked-anonymous-function or a simple .forEach(). Both are provided as examples below.

Immediately-invoked-anonymous-function

for (var i = 0; i < inventory.length; i++) {
    (function(i) {
        if (inventory[i].market_hash_name == rows[j].real_name) {
            var asid = inventory[i].assetid;
            connection.query('SELECT count(id) as wynik FROM used where asset_id = \'' + asid + '\'', function(err, wiersze) {
                console.log(inventory[i]);
                process.exit(1);
                if (wiersze[0].wynik == 0) {
                    var employee = {
                        asset_id: asid,
                        trans_id: rows[j].tid
                    };
                    connection.query('INSERT INTO used SET ?', employee, function(err, res) {
                        if (err) throw err;
                        offer.addMyItem(inventory[i]);
                    });
                    licznik++;
                }

            });

        }
    })(i);
});

.forEach()

inventory.forEach(function(item) {
    if (item.market_hash_name == rows[j].real_name) {
        var asid = item.assetid;
        connection.query('SELECT count(id) as wynik FROM used where asset_id = \'' + asid + '\'', function(err, wiersze) {
            console.log(item);
            process.exit(1);
            if (wiersze[0].wynik == 0) {
                var employee = {
                    asset_id: asid,
                    trans_id: rows[j].tid
                };
                connection.query('INSERT INTO used SET ?', employee, function(err, res) {
                    if (err) throw err;
                    offer.addMyItem(item);
                });
                licznik++;
            }

        });

    }
});

edited Jan 24, 2016 at 22:37

answered Jan 23, 2016 at 19:50

michael

7584 silver badges10 bronze badges

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

4 Comments

Jensej Over a year ago

if I do like this, inventory is not avaible in query block. Return undefinited.

michael Over a year ago

Could you provide a larger code sample? There's something else going on with your code.

michael Over a year ago

Ah, you are inside a for-loop. That's what I thought was happening, but no worries. I've edited my answer with two different solutions for you.

Jensej Over a year ago

Thanks a lot. But I have 1 more question. How increment var licznik? I try sth like this but it is not working. pastebin.com/raw/KzeWyszf

Léo Martin · Accepted Answer · 2016-01-23 19:09:43Z

1

Pass your callback() directly after your string.

Try this :

connection.query("SELECT count(id) as wynik FROM used where asset_id = " + asid, function(err, rows){
     /* check errors here */
     console.log(rows);
 });

answered Jan 23, 2016 at 19:09

Léo Martin

7467 silver badges13 bronze badges

Collectives™ on Stack Overflow

node.js pass array to mysql callback

2 Answers 2

4 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

4 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related