www.gusucode.com > 4127网博士成品网站管理系统 PHP网站源码程序 > 4127/4127/shop/module/ShopBrandQuery.php
<?php /* [插件名称] 品牌检索 [适用范围] 专用 */ function ShopBrandQuery(){ global $msql,$fsql,$tsql; $coltitle=$GLOBALS["PLUSVARS"]["coltitle"]; $shownums=$GLOBALS["PLUSVARS"]["shownums"]; $target=$GLOBALS["PLUSVARS"]["target"]; $pagename=$GLOBALS["PLUSVARS"]["pagename"]; $tempname=$GLOBALS["PLUSVARS"]["tempname"]; $picw=$GLOBALS["PLUSVARS"]["picw"]; $pich=$GLOBALS["PLUSVARS"]["pich"]; $fittype=$GLOBALS["PLUSVARS"]["fittype"]; include(ROOTPATH."includes/pages.inc.php"); $pages=new pages; //模版解释 $Temp=LoadTemp($tempname); $TempArr=SplitTblTemp($Temp); $str=$TempArr["start"]; //只显示指定分类品牌 if($_GET["catid"]!="" && $_GET["catid"]!="0"){ $catid=$_GET["catid"]; $totalnums=TblCount("_shop_brandcat","id","catid='$catid'"); $pages->setvar(array("catid" => $catid)); $pages->set($shownums,$totalnums); $pagelimit=$pages->limit(); $fsql->query("select brandid from {P}_shop_brandcat where catid='$catid' limit $pagelimit"); while($fsql->next_record()){ $brandid=$fsql->f('brandid'); $tsql->query("select * from {P}_shop_brand where id='$brandid' "); if($tsql->next_record()){ $brand=$tsql->f('brand'); $src=$tsql->f('logo'); $url=$tsql->f('url'); $intro=$tsql->f('intro'); $xuhao=$tsql->f('xuhao'); $tj =$tsql->f('tj'); $intro=strip_tags($intro); $link=ROOTPATH."shop/class/?showbrandid=".$brandid; if($src==""){$src="shop/pics/nologo.gif";} $src=ROOTPATH.$src; //模版标签解释 $var=array ( 'link' => $link, 'target' => $target, 'intro' => $intro, 'url' => $url, 'src' => $src, 'picw' => $picw, 'pich' => $pich, 'brand' => $brand ); $str.=ShowTplTemp($TempArr["list"],$var); } } //不限制分类的品牌检索 }else{ $totalnums=TblCount("_shop_brand","id","id!='0'"); $pages->setvar(array("key" => $key)); $pages->set($shownums,$totalnums); $pagelimit=$pages->limit(); $tsql->query("select * from {P}_shop_brand order by xuhao limit $pagelimit"); while($tsql->next_record()){ $brandid=$tsql->f('id'); $brand=$tsql->f('brand'); $src=$tsql->f('logo'); $url=$tsql->f('url'); $intro=$tsql->f('intro'); $xuhao=$tsql->f('xuhao'); $tj =$tsql->f('tj'); $intro=strip_tags($intro); $link=ROOTPATH."shop/class/?showbrandid=".$brandid; if($src==""){$src="shop/pics/nologo.gif";} $src=ROOTPATH.$src; //模版标签解释 $var=array ( 'link' => $link, 'target' => $target, 'intro' => $intro, 'url' => $url, 'src' => $src, 'picw' => $picw, 'pich' => $pich, 'brand' => $brand ); $str.=ShowTplTemp($TempArr["list"],$var); } } $str.=$TempArr["end"]; $pagesinfo=$pages->ShowNow(); $var=array ( 'fittype' => $fittype, 'showpages' => $pages->output(1), 'pagestotal' => $pagesinfo["total"], 'pagesnow' => $pagesinfo["now"], 'pagesshownum' => $pagesinfo["shownum"], 'pagesfrom' => $pagesinfo["from"], 'pagesto' => $pagesinfo["to"], 'totalnums' => $totalnums ); $str=ShowTplTemp($str,$var); return $str; } ?>