I'm currently implementing a follow system using PHP and PDO. The code determines if the button "Follow" or "Unfollow" should show based on the inserted data. The database is updating correctly but for some reason the greater than or equal to operator is not working properly, or I'm not querying the database properly. (Not sure which) Anyone know what I'm doing wrong?
In followon.php:
if($row['userID'] && $row['userName']){
if($row['userID']!=$user_id){
$follow_userid = $row['userID'];
$stmt = $user_follow->runQuery("SELECT id FROM following WHERE user1_id=':user_id' AND user2_id=':follow_userid'");
$stmt->execute(array(":user_id"=>$user_id,":follow_userid"=>$follow_userid));
$follow = $stmt->fetch(PDO::FETCH_ASSOC);
if(!$follow >= 1){
$stmt = $user_follow->runQuery("INSERT INTO following(user1_id, user2_id) VALUES (?, ?)");
$stmt->bindValue(1,$user_id);
$stmt->bindValue(2,$follow_userid);
$stmt->execute();
$stmt = $user_follow->runQuery("UPDATE tbl_users SET following = following + 1 WHERE userID = ?");
$stmt->bindValue(1,$user_id);
$stmt->execute();
$stmt = $user_follow->runQuery("UPDATE tbl_users SET followers = followers + 1 WHERE userID = ?");
$stmt->bindValue(1,$follow_userid);
$stmt->execute();
}
header("Location: index.php?id=".$currentID);
}
}
In followoff.php:
if($row['userID'] && $row['userName']){
if($row['userID']!=$user_id){
$unfollow_userid = $row['userID'];
$stmt = $user_unfollow->runQuery("SELECT id FROM following WHERE user1_id=':user_id' AND user2_id=':unfollow_userid'");
$stmt->execute(array(":user_id"=>$user_id,":unfollow_userid"=>$unfollow_userid));
$follow = $stmt->fetch(PDO::FETCH_ASSOC);
if($follow >= 1){
$stmt = $user_unfollow->runQuery("DELETE FROM following WHERE user1_id= ? AND user2_id= ?");
$stmt->bindValue(1,$user_id);
$stmt->bindValue(2,$unfollow_userid);
$stmt->execute();
$stmt = $user_unfollow->runQuery("UPDATE tbl_users SET following = following - 1 WHERE userID = ?");
$stmt->bindValue(1,$user_id);
$stmt->execute();
$stmt = $user_unfollow->runQuery("UPDATE tbl_users SET followers = followers - 1 WHERE userID = ?");
$stmt->bindValue(1,$unfollow_userid);
$stmt->execute();
}
header("Location: index.php?id=".$currentID);
}
}
And in index.php (where button appears):
if($user_id){
if($user_id!=$id){
$query2 = $user_home->runQuery("SELECT id FROM following WHERE user1_id=':user_id' AND user2_id=':id'");
$query2->execute(array(":user_id"=>$user_id,":id"=>$id));
$query2result = $query2->fetch(PDO::FETCH_ASSOC);
if($query2result >= 1){
echo "<a href='followoff.php?id=$currentID' class='btn btn-default btn-xs'>Unfollow</a>";
}
else{
echo "<a href='followon.php?id=$currentID' class='btn btn-info btn-xs'>Follow</a>";
}
}
}
