Implementing async/await and promises in Node.js with MySQL

Asked Oct 12 '20 at 16:50

Active Oct 12 '20 at 16:50

Viewed 17 times

function CalculateCuts(query, rank) {
    // query = a user input variable, rank = data the program knowns about the user
    let cut;
    const sql = `SELECT ${query} FROM spartan.cuts WHERE id = ${rank};`;
    con.query(sql, function(err, result) {
        if (err) throw err;
        cut = result[0][query];
    });
    return cut;
}

This function keeps returning as undefined. I've done some digging and I've come to the conclusion that it is due to my function returning before cut is assigned to result[0][query], but I've been unable to successfully implement a solution. I've seen some examples with callbacks and promises, but none that used node.js syntax and I had a bit of trouble following them.

asked Oct 12 '20 at 16:50

Joshua Broussard

Beware, your code is [vulnerable to SQL injection](https://bobby-tables.com/). – VLAZ Oct 12 '20 at 16:52
Thanks so much, I went ahead and added mysql.escape() to counteract that! – Joshua Broussard Oct 12 '20 at 17:07
better use prepared statements with parameters https://stackoverflow.com/questions/15778572/preventing-sql-injection-in-node-js – nbk Oct 12 '20 at 17:10

Implementing async/await and promises in Node.js with MySQL

0 Answers0