How do I send a variable from ajax call to mysql using node.js, so that query can be done using that variable and data send back to client
/* javascript code in .ejs file*/
<script type="text/javascript">
$(document).ready(function(req, res){
$('#empName').keyup(function(event){
if (event.keyCode === 13){
var empname = document.getElementById('empName').value;
alert(empname);
$.ajax({
url: "/autoFill",
dataType: "json",
type: "get",
data: {empname: empname},
success: function(data){
console.log(data);
}
})
}
});
});
</script>
/* route code in index.js at server */
const autoFill = require('../controller/autocomplete1');
router.get('/autoFill', autoFill.autoFill);
/* mysql code in autocomplete1.js file */
module.exports.autoFill = function(req, res){
var a = req.body.empname;
var qa = `select lastName, gender, designation, emailID from empMasterData where firstName = "${a}"`;
database.query(qa, function (err, results) {
if(err) throw err;
var r = JSON.parse(JSON.stringify(results));
console.log(results);
console.log(r);
}
)
};