How do I retrieve volume and temperature values and put it into the database? add-device.html Volume: var volumeslider = document.getElementById(volume); var volumeoutput = document.getElementById(volumeslider); volumeoutput.innerHTML

How do I retrieve volume and temperature values and put it into the database?

add-device.html

Volume:

Temperature:

main.js

app.get("/add-device", function (req, res) {

res.render("add-device.html");

});

app.post("/device-added", function (req, res) {

// saving data in database

let sqlquery = "INSERT INTO devices (name, type, turned_on, open, volume, temp) VALUES (?,?,?,?,?,?)";

// execute sql query

let newrecord = [req.body.name, req.body.type, req.body.turned_on, req.body.open, req.body.volume, req.body.temp];

db.query(sqlquery, newrecord, (err, result) => {

if (err) {

return console.error(err.message);

} else

res.send(req.body.name + " has been added to the database");

});

});