prepare("SELECT id, requesterId FROM friends WHERE :uid IN (requesterId, receiverId) AND :rid IN (requesterId, receiverId) AND status = 0"); $query->bindParam(":uid", $userid, PDO::PARAM_INT); $query->bindParam(":rid", $_POST['userID'], PDO::PARAM_INT); $query->execute(); $result = $query->fetch(PDO::FETCH_OBJ); if(!$query->rowCount()){ api::respond(400, false, "Friend request doesn't exist"); } if($result->requesterId == $userid){ api::respond(400, false, "Only the request receiver can accept the request"); } $query = $pdo->prepare("UPDATE friends SET status = 1 WHERE id = :id"); $query->bindParam(":id", $result->id, PDO::PARAM_INT); if($query->execute()){ api::respond(200, true, "OK"); } else{ api::respond(500, false, "Internal Server Error"); }