IN JAVASCRIPT

Hello, i have a table called patients in mySQL Workbench, and a field called patient_labResults that is of type LONGBLOB.

How can I using knex fetch the file uploaded in the database and display it in the html file so the user can access the file only (download it).

Modify this Html code:

Lab Results

<%=info.patient_labResults %>

This is the Get method that updates the file to the database.

exports.editLabResults = async (req, res) => {

let labResultsName = req.files.lab.name;

const labResults = req.files.lab;

if (labResultsName && labResults) {

await knexClient('patients')

.from("patients")

.where('patient_id', id)

.update('patient_labResultsName', labResultsName, 'patient_labResults', labResults)

.then(() => {

console.log("Lab Results has been added successfully!")

res.redirect(req.get('referer'));

})

.catch(err => console.log(err));

} else {

console.log("Lab Results cannot be added!");

res.redirect(req.get('referer'));

}

}