posts.js - routes - server - get posts by category - Instagram Clone React Node

posts.js

app.post('/posts/categories', (req, res) => { 
  const { userId, postCategory } = req.body;
  if (!userId || !postCategory) {
    res.status(200).jsonp({ message: 'Cannot load your posts, please try again' });
  }
  const getPostsSql = "SELECT * FROM post WHERE post_created_by = ? AND post_category = ? ORDER BY post_created_date DESC";
  dbConn.query(getPostsSql, [userId, postCategory], function (error, posts) {
    if (posts) {
      res.status(200).jsonp(posts);
    } else {
      res.status(200).jsonp({ message: 'Cannot get your posts, please try again' });
    }
  });
});