褰撳墠浣嶇疆錛?/span>
158鏈哄簥緗?/a>
- '>鏈哄簥浜у搧
锘??php require_once '../../WebSiteConfig.php'; $mysql = new Mysql(); $cityid = intval("86"); if (empty($cityid)) $cityid = intval($_GET['cityid']); $sql = "select * from city where id =" . $cityid; $pageinfo = $mysql->getRow($sql); if(empty($pageinfo)) exit("data not find"); $page = isset($_GET['page']) ? intval($_GET['page']) : 1; $pagesize = 20; $paging = new Paging(); $idstab = $mysql->tab("select id from product where ID>0 and cityid=" . $cityid . " order by id desc"); $pagedata = $paging->getPageIds($idstab, $page, $pagesize); $sql = "select * from product where ID in (" . implode(",", $pagedata["onePageIds"]) . ") order by ID desc"; $list = $mysql->getALL($sql); foreach ($list as $key => $value) { $list[$key]['url'] = '/product-detail/' . explode(".", $value['ID'] / 1000)[0] . '/' . $value['ID'] . '.html'; } $p = new Page($pagedata["totalNum"], 6, $page, $pagesize); $sql = "select ID,name,othername from city"; $city_list = $mysql->getAll($sql); $brand_list = array(); $sql = "select ID,name,pic1,othername from brand ORDER BY RAND() LIMIT 8"; $brand_list = $mysql->getAll($sql); ?>