CODEWITHSUNDEEP
mysqlnode.jsexpress
Anon
Anon

Reputation: 35

MySQL query works with POST but not with GET (Node/Express)

POST works but GET doesn't work.

This works:

app.post('/POSTexample', function(req, res) {
        connection.query('SELECT * FROM users WHERE username = ?', req.session.username, function(error, results, fields) {
            #using query results
            response.redirect('/account');
        });
    res.redirect('/account');
});

But this doesn't work (gets stuck and never loads):

app.get('/GETexample', function(req, res) {
        connection.query('SELECT * FROM users WHERE username = ?', req.session.username, function(error, results, fields) {
                #using query results
        });
    res.redirect('/account');
});

What are the possible solutions to this issue?

Upvotes: 0

Views: 103

Answers (1)

O. Jones
O. Jones

Reputation: 108641

Put your res.redirect() calls in the callback function from your MySql queries. The way you have it, you're redirecting before the queries complete.

asynchronous coding takes some getting used to, doesn't it?

Upvotes: 1

Related Questions