app.post('/customTask', function(request, response) {
if (request.session.loggedin && request.session.isAdmin) {
let username = request.body.name
let taskid = parseInt(request.body.taskid)
taskid = Math.trunc(taskid)
let taskDescription = request.body.taskName
let pointVal = parseInt(request.body.customPointVal)
pointVal = Math.trunc(pointVal)
let status = parseInt(request.body.status)
status = Math.trunc(status)
if(status == 0){
var boolStatus = false
} else if(status ==1){
var boolStatus = true
}
console.log("Inserting task...")
connection.query("INSERT INTO tasks (user, taskid, taskdescription, status, points) VALUES (?, ?, ?, ?, ?)", [username, taskid, taskDescription, boolStatus, pointVal], function(error, results, fields) {
if (error) throw error;
console.log(results)
console.log('Task inserted successfully!')
response.redirect('/admin')
})
}})
#difficulty with sql database "INSERT INTO" query
3 messages · Page 1 of 1 (latest)