$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; } }