mysql query wont push values to array

Question

trying to gather some titles from my roles table and put them into an array so i can loop over them later but when i run the function it doesn't give me a array with the values I'm guessing

function setRoles() {
    let roleSet = [];

    let sql = "SELECT * FROM role";
    connection.query(sql, function(err, res) {
        if (err) throw err;
        for (let i = 0; i < res.length; i++) {
            roleSet.push(res[i]);

        }



    });
    console.log(roleSet);
    return roleSet;

}

here is the code the only thing i get back is a empty array and ive tried putting the array init outside the function and that doesnt work either

Simply, replace console.log and return statement in connection.query. You can make connection.query as async function and get with await. — Zem
– Zem, Commented Apr 5, 2021 at 2:12

Zem · Accepted Answer · 2021-04-05 02:36:28Z

1

How about change console.log after query?
It maybe not return anything.

You can change setRoles function as async, but I can't make async/await code perfectly.

So, I reference another module(async) for use mysql.

function setRoles() {
    let roleSet = [];

    let sql = "SELECT * FROM role";
    connection.query(sql, function(err, res) {
        if (err) throw err;
        for (let i = 0; i < res.length; i++) {
            roleSet.push(res[i]);
        }
        console.log(roleSet);
        //return roleSet;
    });
    //console.log(roleSet);
    //return roleSet;
}

connection.query('SELECT * FROM some_table', (err, rows) => {
    // do something with the results here
});
// the following code is executed *before* the query is executed

I reference stackoverflow answer code.

answered Apr 5, 2021 at 2:36

Zem

4741 gold badge3 silver badges15 bronze badges

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

Collectives™ on Stack Overflow

mysql query wont push values to array

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related