function itemLikeSum($itemID) { $re = UserLike::userlike_sum($itemID); $line = mysql_fetch_array($re); $data = array('id' => $itemID); $re2 = mysql_fetch_array(ItemInfo::ItemInfo_select($data, 1)); $water = $re2['stockNum']; //加水收藏 $sum = $line[0] + $water; return $sum; }
<?php //error_reporting(0); require_once '/var/www/git/application/models/data/ItemInfo.php'; $obj = new ItemInfo(); $arr = array('stockNum' => 0); $ids = array(); $r = $obj->ItemInfo_select($arr, 1000); while ($re = mysql_fetch_array($r)) { $id = $re['id']; $ids[$id] = rand(10, 50); } foreach ($ids as $id => $water) { $arr = array('stockNum' => $water); $condition = 'id =' . $id; $obj->iteminfo_update($arr, $condition); }
echo $res->show(200); } } exit; } elseif (isset($_POST['uid']) && isset($_POST['page'])) { $uid = $_POST['uid']; $page = $_POST['page'] < 0 ? 1 : $_POST['page']; $arr = array('userid' => $uid); $re = mysql_fetch_assoc($ul->userlike_select($arr, 1)); $re['items'] = trim($re['items'], ','); $items_id_arr = explode(',', $re['items']); $data = array(); $ii = new ItemInfo(); $it_num = 6; //一页几个 for ($i = ($page - 1) * $it_num; $i < $page * $it_num; $i++) { if ($items_id_arr[$i]) { $item_id = $items_id_arr[$i]; $arr_item = array('id' => $item_id); $tmp = mysql_fetch_assoc($ii->ItemInfo_select($arr_item, 1)); if ($tmp == false) { continue; } $tmp['islike'] = "1"; $data[] = $tmp; } } echo $res->show(200, $data); } else { echo $res->show(400); }