0

Example: How to get the value of the var idMedico outside of the connection brackets?

connection.query("SELECT idmedicos FROM medicos WHERE nome = '" + medico + "'", function (err, result) {
        var idMedico = result[0].idmedicos;
    });

1 Answers1

0
function query(name, callback) {

    connection.query("SELECT idmedicos FROM medicos WHERE nome = '" + name + "'", function (err, result) {
        var idMedico = result[0].idmedicos;
        callback(idMedico);
    });

}


query('medico', function(result){
    console.log('result : ' + result)
});
Biranchi
  • 16,120
  • 23
  • 124
  • 161