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;
});
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;
});
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)
});