function getReview() { $reviewId=$_GET['rid']; $reviewQuery = "SELECT review_header, review_content, landing_url, u.first_name, u.id, rfl.affiliate_key, rfl.affiliate_id from review_content rc join user u on (u.username=rc.user_created) left join ref_affiliate_link rfl on (rfl.affiliate_site=rc.parent_site) where rc.is_deleted=0 and rc.id=$reviewId"; // execute $numresultsRQ=mysql_query($reviewQuery); $numrowsRQ=mysql_num_rows($numresultsRQ); if ($numrowsRQ < 0) { // Return error for invalid reviewID } else { $resultRQ = mysql_query($reviewQuery) or die(mysql_error()); $rowRQ = mysql_fetch_array($resultRQ); $hitCount=getViews($reviewId); $arr=array("ReviewContent"=> array("Comments"=>getReviewComment($reviewId), "Images"=>getReviewPiks($reviewId), "description"=>$rowRQ['review_content'], "hits"=>"$hitCount", "landingUrl"=>generateLandingUrl($rowRQ['landing_url'], $rowRQ['affiliate_key'], $rowRQ['affiliate_id'], $reviewId), "Reviewer"=>array("name"=>$rowRQ['first_name'], "id"=>$rowRQ['id']) )); echo json_encode($arr); } }
function getMainFeed() { $startId = $_GET['sid']; $query = "SELECT rc.*, hc.cnt, rfl.affiliate_key, rfl.affiliate_id FROM review_content rc LEFT JOIN (SELECT COUNT(*) cnt, review_id FROM review_hits GROUP BY review_id) hc ON (rc.id = hc.review_id) LEFT JOIN ref_affiliate_link rfl on (rfl.affiliate_site=rc.parent_site) "; $whereClause = ""; $includeWhere = 0; if ($startId > 0) { $whereClause .= " where rc.id < $startId"; $includeWhere = 1; } if (isset($_SESSION['user'])) { unset($_SESSION['id']); $user = $_SESSION['user']; if ($includeWhere == 1) { $whereClause .= " and "; } else { $whereClause .= " where "; } $whereClause .= " rc.user_created='$user'"; $includeWhere = 1; } else if (isset($_SESSION['id'])) { unset($_SESSION['user']); $id = $_SESSION['id']; if ($includeWhere == 1) { $whereClause .= " AND "; } else { $whereClause .= " WHERE "; } $whereClause .= " rc.user_created IN (select username from user where id=$id)"; $includeWhere = 1; } if (isset($_SESSION['tag'])) { $tag = $_SESSION['tag']; if ($includeWhere == 1) { $whereClause .= " and "; } else { $whereClause .= " where "; } $whereClause .= " rc.id IN (select review_id from hashtags where hash_tag = '#$tag') "; $includeWhere = 1; } if ($includeWhere) { $query .= $whereClause; } $query .= " order by rc.id desc LIMIT 0 , 8"; //echo $query; mysql_query($query) or die(mysql_error()); $numresults=mysql_query($query); $numrows=mysql_num_rows($numresults); $result = mysql_query($query) or die("Couldn't execute query"); $arrFeed=array(); if ($numrows == 0) { array_push($arrFeed, array("Feed"=>array())); } else { $contentArr=array(); $i=0; while($i < $numrows) { $row = mysql_fetch_array($result); $rowArr=array("id"=>$row['id'], "description"=>preg_replace('/#(\w+)/', ' <a href="./search.php?tag=$1">#$1</a>', $row['review_content']), "coverPik"=>$row['cover_pic'], "landingUrl"=>generateLandingUrl($row['landing_url'], $rowRQ['affiliate_key'], $rowRQ['affiliate_id'], $row['id']), "views"=>defaultViewsIfNull($row['cnt'])); array_push($contentArr, $rowArr); $i++; } array_push($arrFeed, array("Feed"=>$contentArr)); } echo json_encode($arrFeed); }