node.js mysql count rows get value

Question

Hi everyone i am using React-Native front end with Node.js with Mysql back end , I am counting the number of rows with particular id everything is good in the query, i got the value from the query but i am unable to use the value because it is in the the form of "res_Count":[{"count(*)":2}] . function i want it in the string format . Once check my query and the result

router.get('/get_Following_Count/:user_id', (req, res, next) => {
  connection.query("SELECT count(*) FROM followers WHERE followers.follower_id=? ORDER BY id DESC  ", [req.params.user_id], (err, results, fields) => {
    if (!err) {
      // res.send(rows);
      following_Count = JSON.parse(JSON.stringify(results));
      return res.json({ "status": 200, "error": null, "res_Count": following_Count });
    } else {
      console.log(err);
      return res.status(404).send('Sorry user_id does not exits');
    }
  })
});

Output:

{"status":200,"error":null,"res_Count":[{"count(*)":2}]}

Please give me any suggestions to change the count(*) value

MaksymK · Accepted Answer · 2019-11-29 13:13:12Z

2

try to change your query from

"SELECT count(*) FROM followers WHERE followers.follower_id=? ORDER BY id DESC"

to

"SELECT count(*) as followersCount FROM followers WHERE followers.follower_id=? ORDER BY id DESC"

and the use, for example

return res.json({ "status": 200, "error": null, "res_Count": following_Count[0].followersCount });

answered Nov 29, 2019 at 13:13

MaksymK

4013 silver badges7 bronze badges

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

Comments

Leonardo Drici · Accepted Answer · 2019-11-29 13:09:05Z

You could do this inside the route in express

router.get('/get_Following_Count/:user_id', (req, res, next) => {
  connection.query("SELECT count(*) FROM followers WHERE followers.follower_id=? ORDER BY id DESC  ", [req.params.user_id], (err, results, fields) => {
    if (!err) {
      // res.send(rows);
      // CHANGES 
      following_Count = JSON.parse(JSON.stringify(results))[0];
      -> REPLACE THIS COUNT(FIRST ONE) WITH WHATEVER YOU'D LIKE -> following_Count['count'] = following_Count['count(*)'];
      delete following_Count['count(*)'];
      //END CHANGES
      return res.json({ "status": 200, "error": null, "res_Count": following_Count });
    } else {
      console.log(err);
      return res.status(404).send('Sorry user_id does not exits');
    }
  })
}

The output will be

{"status":200,"error":null,"res_Count": {"count": 2} }

If you want the array back just delete the [0] and loop through each element and apply the logic of renaming the key

Collectives™ on Stack Overflow

node.js mysql count rows get value

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related