Pagination approach in NodeJS Express

Question

Pagination approach in NodeJS Express

I have the following code:

app.post('/pepe/query/', function(req, res) {
  var query = "SELECT * FROM mutations";
  if (req.body.start.length !== 0) { //From an HTML form
    query = query + " WHERE pos>=" + req.body.start;
  }
  app.get('/pepe/query/:number', function(req2, res2) {
    var pages = 10 * req.param2("number") - 10;
    query2 = query + " LIMIT " + pages + ", 10";
    if (req.body.output == 1) {
      pool.query(query2, function select(error, results, fields) {
        res.render('index.html',{data:results, error:null});
      });
    } else if (req.body.output == 2) {
      query2 = "SELECT count(*) FROM (" + query + ") AS table1";
      pool.query(query2, function select(error, results, fields) {
        res.send(results);
      });
    }
  });
});

However, this approach does not work, cause I send information from a form via POST to /pepe/query, but it does not work.

My aim would be to go to /pepe/query/3 for example, and go to page 3 (results 21-30).

javascript
node.js
express

Answer 1

Something like this:

app.get('/pepe/query/', function(req, res) {
    var start = req.query.start;
    var number = req.query.number;
    //Logic here.
    res.send(results);
});

<form method="GET" action="/pepe/query/">
   <input name="start" type="text" id="search" />
   <input name="number" type="text" id="number"  />
</form>