Advertisement
GarryLaly

Bad Query? - Node.js

Jul 1st, 2014
325
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. app.get("/user/:id", function (req, res) {
  2.     connection.query("SELECT * FROM tbl_user WHERE id_user='" + req.params.id + "'", function(err, row, fields){
  3.         connection.query("SELECT * FROM tbl_user_follow WHERE follower='" + req.params.id + "' AND following='" + req.cookies.idUser + "'", function(err, rowFollowStat, fields){
  4.             connection.query("SELECT COUNT(follower) AS followerCount FROM tbl_user_follow WHERE follower='" + req.params.id + "'", function(err, rowFollower, fields){
  5.                 connection.query("SELECT COUNT(following) AS followingCount FROM tbl_user_follow WHERE following='" + req.params.id + "'", function(err, rowFollowing, fields){
  6.                     var followStat = "";
  7.                     var followUrl = "";
  8.                    
  9.                     if (rowFollowStat.length > 0) {
  10.                         followStat = "Unfollow";
  11.                         followUrl = "/unfollow/" + row[0].id_user;
  12.                     }else {
  13.                         followStat = "Follow";
  14.                         followUrl = "/follow/" + row[0].id_user;
  15.                     }
  16.                    
  17.                     res.render("user", {
  18.                         title: "User",
  19.                         name: row[0].username,
  20.                         email: row[0].email,
  21.                         followUrl: followUrl,
  22.                         followStat: followStat,
  23.                         follower: rowFollower[0].followerCount,
  24.                         following: rowFollowing[0].followingCount
  25.                     });
  26.                 });
  27.             });
  28.         });
  29.     });
  30. });
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement