$data['phone'] = $row['phone'];
$data['about-user'] = $row['about'];
$data['name'] = ucwords(trim($row['N']));
$data['profilePic'] = $row['DP'];
$data['comment'] = $row['C'];
$data['lessonID'] = $row['TID'];
$date = ago($row['date'], -1);
$data['timeStamp'] = $date;
$data['comment_id'] = $row['comment_id'];
$data['memberID'] = $row['SID'];
$data['date_joined'] = ago($row['date_joined'], -1);
$cid = $row['church_id'];
$data['CID'] = $cid;
$data['cover'] = "NOT_SET";
$data['friends'] = loadFriendsCount($data['memberID']);
$data['churchName'] = getchurchName($cid);
$data['churchprofilePic'] = getchurchlogo($cid);
if ($memberID != $data['memberID']) {
$data['isConnected'] = isConnected($memberID, $data['memberID']);
$data['connection'] = loadFriendsCount($data['memberID']);
} else {
$data['isConnected'] = 5;
//My records
$data['connection'] = -1;
}
//name memberID comment_id timeStamp comment profilePic
$content['DevotionComment'][] = $data;
}
echo json_encode($content);
} else {
echo 'No Comment Found.';
function getUserDetails($userID, $myID = 0)
{
//echo $userID.$myID;
$query = "SELECT CONCAT(`first_name`,' ',`last_name`) as 'N'\n\t,church_member_id,`church_id`,`userdp` as 'DP',`email` as 'email',\n\t`phone_number` as 'phone',date_joined,about\n\n\n\tfrom\n\tchurch_members where church_member_id='{$userID}'";
$results = mysql_query($query) or die(mysql_error());
$mutualFriend = 0;
if ($results && mysql_num_rows($results) >= 1) {
$data = array();
while ($row = mysql_fetch_assoc($results)) {
$dataItem['id'] = $row['church_member_id'];
$dataItem['memberID'] = $dataItem['id'];
$dataItem['cover'] = loadUserCoverPix($dataItem['id']);
$dataItem['name'] = ucwords(trim($row['N']));
$dataItem['profilePic'] = $row['DP'];
$dataItem['email'] = $row['email'];
$dataItem['phone'] = $row['phone'];
$dataItem['about-user'] = $row['about'];
$dataItem['date_joined'] = ago($row['date_joined'], -1);
$cid = $row['church_id'];
$dataItem['churchName'] = getchurchName($cid);
$dataItem['friends'] = loadFriendsCount($userID);
$dataItem['CID'] = $cid;
$data['connection'] = loadFriendsCount($userID);
if ($userID != $myID) {
$dataItem['isConnected'] = isConnected($dataItem['id'], $myID);
if ($dataItem['isConnected'] == 1) {
$mutualFriend = $mutualFriend + 1;
}
$dataItem['mutualFriends'] = countMutualFriends($dataItem['id'], $myID);
} else {
$dataItem['isConnected'] = -10;
// This ID is mine so dont check Connection
$dataItem['mutualFriends'] = 0;
}
$dataItem['churchprofilePic'] = getchurchlogo($cid);
//$dataItem['Friends']= loadFriendsCount($userID);;
$data = $dataItem;
}
// echo json_encode($data);
return $data;
}
}
