When I press a specific button in express, I want to modify mysql data and then load the modified page.

main.js
app.post('/count', function(req, res){
    var num_ = Object.keys(req.body)[0];
    var sql = 'select times from db where num=?'
    conn.query(sql, [num_], function(err, rows){
        if(err){
            console.log(err);
            res.status(500).send('Internal Server Error');
        } } else{
            var times_ = rows[0].times
            var sql='update db set times=? where num=?';
            conn.query(sql, [times_+1, num_], function(err, rows_){
                if(err){
                    console.log(err);
                    res.status(500).send('Internal Server Error');  
                } } else {
                }
            })
        }
    })
})

output.jade
                form(action='/count' method='post')
                    input(type='submit', value='+', name=i.num, onclick='window.location.reload()')

If you press the button, the data in the db is modified and the modified data is printed on the page. When you refresh in your browser, the page reloads properly, but when you reload through the click event Ronclick='window.location.reload()'s, the page does not load. What should I do?

node.js express jade

2022-09-21 20:20

1 Answers

It is not recommended to hand over the submit button by giving the onClick event or a separate name attribute. I carefully predict that you should do this.

??.jade

    form(action='/count' method='post')
        input(type='hidden', name='num', value=i.num)
        input(type='submit', value='+')

main.js

app.post('/count', function (req, res) {
    var num_ = req.param.num;
    var sql = 'select times from db where num=?'
    conn.query(sql, [num_], function (err, rows) {
        if (err) {
            // Run on selection query failure
            // Let's skip...
        } } else {
            // Run Update Query
            // Let's skip...
                if (err) {
                    // Run on Update Query Error
                    // Let's skip...
                } } else {
                    // Redirect here if all is successful
                    return res.redirect(req.get('referer'))
                }
            })
        }
    })
})

2022-09-21 20:20

If you have any answers or tips

Popular Tags

python x 4647

android x 1593

java x 1494

javascript x 1427

c x 927

c++ x 878

ruby-on-rails x 696

php x 692

python3 x 685

html x 656