www.gusucode.com > citySHOP B2C商城系统 进销存 2.0.6码程序 > upload/search.php
<?php include './include/common.inc.php'; if (!isset($keyword)) { showmessage('undefined_action'); } if ($keyword == '') { showmessage('请输入搜索关键字。'); } $headlinks = showlinks('css','style'); $jslinks = showlinks('js','common'); $pagetitle = urldecode($keyword); $tpp = $tpps['goodslist']; $page = max(1, intval($page)); $start_limit = ($page - 1) * $tpp; $cate3 = isset($cate3)?intval($cate3):0; $wher = ''; $where = "WHERE g.selling='1' AND g.gid=ga.gid AND gi.gid=g.gid "; $keyword = htmlspecialchars(filter_tags(urldecode($keyword))); $gdid = is_numeric($keyword)?intval($keyword):0; if(!$gdid){ $keystr = preg_replace("/([".chr(0xa1)."-".chr(0xff)."]{2})/"," \\1 ",$keyword); $keystr = preg_replace("/[\s]+/",' ',$keystr); $keyarr = explode(' ',trim($keystr)); $keystr = change_chinese($keystr); $subarr = explode(' ',$keystr); $keystr = $dot = ''; foreach($subarr as $v){ $v = str_pad($v, 4, '_'); $keystr .= $dot.'+'.$v; $dot = ' '; } $where .= "AND (MATCH (gi.subject) AGAINST ('$keystr' IN BOOLEAN MODE)) "; }else{ $where .= "AND g.gid='".($gdid-$goods_start_number)."'"; } if($cate3){ $where .= " AND g.category3='$cate3' "; } $viewstyle = isset($viewstyle) ? intval($viewstyle) : 2; $ordertype = isset($ordertype) ? intval($ordertype) : 1; $gorder = $goodsrank[$ordertype]; $wher .= $where . ' ORDER BY g.' . $gorder[0] . ' ' . $gorder[1]; $where .= ' ORDER BY g.' . $gorder[0] . ' ' . $gorder[1]; $query = $db->query("SELECT g.gid FROM {$tablepre}goods g,{$tablepre}goodsattr ga,{$tablepre}goodsindex gi $wher"); $countnum = $db->num_rows($query); $multipage = multi($countnum, $tpp, $page, "search.php?viewstyle=$viewstyle&ordertype=$ordertype&keyword=$keyword"); $query = $db->query("SELECT g.*,ga.* FROM {$tablepre}goods g,{$tablepre}goodsattr ga,{$tablepre}goodsindex gi $where LIMIT $start_limit,$tpp"); $goods = array(); $cate3arr = array(); while ($arr = $db->fetch_array($query)) { $arr['photos'] = unserialize($arr['photos']); $arr['zsold'] = $arr['sold']+$arr['zsold']; $arr['zprice'] = number_format($arr['eprice'] * ($arr['discount'] / 10), 2); in_array($arr['category3'],$cate3arr) or $cate3arr[] = $arr['category3']; $goods[] = $arr; } /** * 3级分类筛选 */ if(!empty($cate3arr)){ $cate3ids = isset($cates)?$cates:implode(',',$cate3arr); $query = $db->query("SELECT * FROM {$tablepre}category WHERE categoryid IN ($cate3ids) ORDER BY `order` DESC,categoryid ASC"); $catechose = ''; while($arr = $db->fetch_array($query)){ $chked = $arr['categoryid'] == $cate3 ? 'class="hov"' : ''; $catechose .= "<li><a $chked href=\"search.php?keyword=".urlencode($keyword)."&cate3=$arr[categoryid]&cates=$cate3ids\">$arr[name]</a></li>"; } } //rank $rankstr = ''; foreach ($goodsrank as $s => $rk) { $hoves = ''; if ($ordertype == $s) { $hoves = 'class="hove"'; } $rankstr .= "<a href=\"search.php?viewstyle=$viewstyle&ordertype=$s&page=$page&keyword=$keyword\" $hoves>$rk[2]</a> "; } //pagebtn $pageprev = $pagenext = ''; $realpages = @ceil($countnum / $tpp); $pages = $tpps['maxpage'] && $tpps['maxpage'] < $realpages ? $tpps['maxpage'] : $realpages; $prev = $page <= 1 ? 0 : ($page - 1); $next = $page >= $pages ? 0 : ($page + 1); $pageprev = "search.php?viewstyle=$viewstyle&ordertype=$ordertype&page=$prev&keyword=$keyword"; $pagenext = "search.php?viewstyle=$viewstyle&ordertype=$ordertype&page=$next&keyword=$keyword"; $viewhistorys = viewhistory(); include (template('search')); ?>