Error while Inserting record through node into MySQL database

Question

I am new in Node and trying to develop some initial apps. I am currently inserting record into database(MySQL) through Node. My post method is like

router.post('/add',function(req,res){
    connection.connect();
    var firstName = req.body.FirstName;
    var lastName = req.body.LastName;
    students.push({
        //id: studentList.length+1,
        FirstName: firstName,
        LastName: lastName
    });
    var post  = {FirstName: firstName, LastName: lastName};
    connection.query('INSERT INTO tblstudent VALUES ? ', post,function(err,result){
        if (err) {
                res.send("There was a problem adding the information to the database.");
            }
    });
    res.redirect('/');
    connection.end();
});

where Id is another column but auto incremented, so I trying to insert record. I'm having the following error.

Please look into this: stackoverflow.com/questions/7042340/… — Dhruv
– Dhruv, Commented Sep 8, 2015 at 9:37

Alexandr Lazarev · Accepted Answer · 2015-09-08 10:30:13Z

1

Error: Can't set headers after they are sent

This error means that headers where already set but one more is trying to be set up.

In your case, you have called res.redirect(), making the response finished. Then your code threw an error because query has failed, and you`ve tried to set a response: "res.send("There was a problem adding the information to the database.");".

In order to fix the problem you should move res.redirect('/'); in to callback function of the query.

connection.query('INSERT INTO tblstudent VALUES ? ', post,function(err,result){
    if (err) {
            res.send("There was a problem adding the information to the database.");
        } else {
            res.redirect('/');
        }
});

edited Sep 8, 2015 at 10:30

answered Sep 8, 2015 at 9:18

Alexandr Lazarev

13k4 gold badges40 silver badges47 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Error while Inserting record through node into MySQL database

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related