function recommend($pageId, $uid = null) { $itemsNum = 4; //控制次调用返回的数据数量$itemsNum-1个 $from = $itemsNum * ($pageId - 1); $to = $itemsNum; $limit = ' ' . $from . ',' . $to . ' '; // 每页4条数据 if (isset($uid)) { $items = UserLikeModel::getUserItems($uid); $arr = array('isRecommend' => 1); $orderby = '`itemPic desc`'; $re = ItemInfo::iteminfo_select_ordby($arr, $orderby, $limit); $data = array(); while ($line = mysql_fetch_array($re, MYSQL_ASSOC)) { if (in_array($line['id'], $items)) { $line['isFavorite'] = 1; } else { $line['isFavorite'] = 0; } $data[] = $line; } return $data; } else { $arr = array('isRecommend' => 1); $orderby = '`itemPic desc`'; $re = ItemInfo::iteminfo_select_ordby($arr, $orderby, $limit); $data = array(); while ($line = mysql_fetch_array($re, MYSQL_ASSOC)) { $line['isFavorite'] = 0; $data[] = $line; } return $data; } }
function presentForHuman2($pageId = 1) { $itemsNum = 4; //控制次调用返回的数据数量 $from = $itemsNum * ($pageId - 1); $to = $itemsNum * $pageId - 1; $limit = ' ' . $from . ',' . $to . ' '; // 每页5条数据 $arr = array("isRecommend" => 1); $orderby = 'itemDate'; $re = ItemInfo::iteminfo_select_ordby($arr, $orderby, $limit); $data = array(); while ($line = mysql_fetch_array($re, MYSQL_ASSOC)) { $data[] = $line; } return $data; }
function newItems($pageId, $itemNum = null, $uid = 0) { $itemsNum = isset($itemNum) ? $itemNum : 6; //控制次调用返回的数据数量 $from = $itemsNum * ($pageId - 1); $to = $itemsNum; $limit = ' ' . $from . ',' . $to . ' '; $orderby = 'itemDate'; $arr = array('isTop' => 0); //第一页加上置顶内容 if ($pageId == 1) { $arr_top = array('isTop' => 1); $re1 = ItemInfo::iteminfo_select_ordby($arr_top, $orderby, null); $re2 = ItemInfo::iteminfo_select_ordby($arr, $orderby, $limit); $data = array(); $like = new UserLikeModel(); while ($line = mysql_fetch_array($re1, MYSQL_ASSOC)) { $line['islike'] = $like->checkUserLike($uid, $line['id']); $line['likesum'] = $like->itemLikeSum($line['id']); $data[] = $line; } while ($line = mysql_fetch_array($re2, MYSQL_ASSOC)) { $line['islike'] = $like->checkUserLike($uid, $line['id']); $line['likesum'] = $like->itemLikeSum($line['id']); $data[] = $line; } return $data; } else { $re = ItemInfo::iteminfo_select_ordby($arr, $orderby, $limit); $data = array(); $like = new UserLikeModel(); while ($line = mysql_fetch_array($re, MYSQL_ASSOC)) { $line['islike'] = $like->checkUserLike($uid, $line['id']); $line['likesum'] = $like->itemLikeSum($line['id']); $data[] = $line; } return $data; } }