The variable resultString is expected to be updated after the query and return the result, but it actually is not updated and is returning nothing. What is happening here? Thanks.
function queryWord(word){
var resultString='';
const mysql = require('mysql');
var con = mysql.createConnection({
host: "127.0.0.1", // or localhost
database: "entries",
port: 3306,
user: "root",
password:"password",
});
con.connect(function(err) {
if (err) throw err;
console.log("Connected!");
var sql = `SELECT wordtype, definition FROM entries where word= '${word}'`;
con.query(sql, function (err, result) {
if (err) throw err;
resultString=result;
// console.log(result);
});
con.end();
});
return resultString;
}
var def= queryWord('king');
console.log(def);