alert("請輸入查詢字串"); history.go(-1); '; exit; }else{ $srchStr = GetStr_Only_Alpha_Num($_GET['srchStr']); $srchStr = addslashes($srchStr); $_url = '?srchStr='.$srchStr; } $_title = '得邑生活購物網-'.$_GET['srchStr']; if(isset($_GET['vMod']) && intval($_GET['vMod']) > 0){ $num = intval($_GET['vMod']); $vmod = ' AND vMod='.$num; $_urlmod = 'vMod='.$num; }else{ $vmod = ' And vMod > 0'; $_urlmod = ''; } if(isset($_GET['num']) && intval($_GET['num']) > 0){ $num = intval($_GET['num']); $wStr = ' AND MainType='.$num; $_urlmt = 'num='.$num; }else{ $wStr = ''; $_urlmt = ''; } if($_urlmod != ''){ $_url .= $_urlmod; if($_urlmt != ''){ $_url .= $_urlmt; } }else{ if($_urlmt != ''){ $_url .= $_urlmt; } } if(isset($_GET['q']) && GetStr_Only_Alpha_Num($_GET['q']) != ''){ $num = GetStr_Only_Alpha_Num($_GET['q']); switch($num){ case '1000': $qStr = " AND Price <= 1000"; $sorPrice = ' Price, '; $sortActive = 'price'; break; case '2000': $qStr = " AND Price > 1000 And Price <= 2000"; $sorPrice = ' Price, '; $sortActive = 'price'; break; case '3000': $qStr = " AND Price > 2000"; $sorPrice = ' Price, '; $sortActive = 'price'; break; default: $qStr = 0; $sorPrice = ''; $sortActive = ''; } if($_url == ''){ $_url = 'q='.$num; } }else{ $qStr = ''; $sorPrice = ''; } $sql = "select * from a0_srch where Srch='".$srchStr."'"; $rs_bs = $gDbManager->DbGetRow($sql); if(count($rs_bs) > 0){ $hints = $rs_bs['hints'] + 1; $sqlStr[0] = array('hints'); $sqlStr[1] = array($hints); $hostStr = "a0_srch"; $whereStr = " Srch='".$srchStr."'"; $status = DbUpdate($hostStr, $sqlStr, $whereStr); }else{ $sqlStr[0] = array('Srch', 'hints'); $sqlStr[1] = array($srchStr, 1); $hostStr = "a0_srch"; $status = DbNew($hostStr, $sqlStr); } $sql = "select count(*) as NumCnt from a0_product where vMod > 0 AND isShow=1 AND Name like '%".$srchStr."%'"; $rs_cnt = $gDbManager->DbGetRow($sql); $numCnt = $rs_cnt['NumCnt']; if(isset($_GET['page']) && intval($_GET['page'])){ $page = intval($_GET['page']); }else{ $page = 1; } $limit = 40; $start = ($page - 1) * $limit; $pages = ceil($numCnt / $limit); $sql = "select * from a0_product where vMod > 0 AND isShow=1 AND Name like '%".$srchStr."%' Order By Num Limit ".$start.",".$limit; $rec_member = $gDbManager->DbGetAll($sql); include '../_top.html'; ?>

全部商品

查看更多

0){ foreach($rec_member as $a){ ?>

$

0){?>

可折紅利點數

贈送紅利點數