关于“
”
query($sqlstr1);
$mynum1=mysqli_num_rows($query1);
if($mynum1!=0)//有中类
{
$i=1;
while($myrows1=mysqli_fetch_assoc($query1))
{
$sqlstr2="select ID from ls_products where subcateID =".$myrows1['ID']." ";
$query2=$opendb->query($sqlstr2);
$mynum2=mysqli_num_rows($query2);
if($mynum2!=0) //有小类
{
while($myrows2=mysqli_fetch_assoc($query2))
{
if($i==1)
{
$productID.=" productID=".$myrows2['ID'];
}
else
{
$productID.=" or productID=".$myrows2['ID'];
}
$i++;
}
}
else //没有小类
{
if($i==1)
{
$productID.=" productID=".$myrows1['ID'];
}
else
{
$productID.=" or productID=".$myrows1['ID'];
}
$i++;
}
}
$products_sql.=" and ".$productID;
}
else
{
$products_sql.=" and productID=".$cateid;
}
}
//中类
if($cateid!="" && $midcateid!="" && $subcateid=="")
{
//中类下有小类
$displaycatename=$midcatename;
$sqlstr="select ID from ls_products where subcateID =".$midcateid." ";
$query1=$opendb->query($sqlstr);
$mynum=mysqli_num_rows($query1);
if($mynum!=0)
{
$i=1;
while($myrows=mysqli_fetch_assoc($query1))
{
if($i==1)
{
$productID.=" productID=".$myrows['ID'];
}
else
{
$productID.=" or productID=".$myrows['ID'];
}
$i++;
}
// echo $productID."
";
$products_sql.=" and ".$productID;
}
else
{//中类下没有小类
$products_sql.=" and productID=".$midcateid;
}
}
//小类
if($cateid!="" && $midcateid!=""&& $subcateid!="")
{
$displaycatename=$subcatename;
$products_sql.=" and productID=".$subcateid;
}
if($searchproductName!="")
{
$products_sql.=" and (productName like '%".$searchproductName."%' or productItemNo like '%".$searchproductName."%') ";
}
if($productid!="" && $productid!="allProducts")
{
$products_sql.=" and productID=".$productid."";
}
if($showOn==1)
{
$products_sql.=" and (showOn=2 or showOn=1) ";
}
if($showOn==2)
{
$products_sql.=" and showOn=2 ";
}
$products_sql.=" order by Num asc ";
$sql.=$products_sql;
//echo "products sql".$sql."
";
//$sql = "select * from ls_products where cateName is null and cateFolders is null and cateTitle is null and cateKeywords is null and cateDescription is null and catePagePic is null and catePagePicWidth is null and catePagePicHeight is null and cateBrief is null and subcateName is null and subcateFolders is null and subcateBrief is null and subcateID is null order by Num desc";
$result=$opendb->query($sql);
/********************************************************************************/
// ȡ
$row = mysqli_num_rows($result);
$amount = $row;
//文章统计
$PageSize2 = $fenyePageSize;
$newssql = "SELECT * FROM ls_article WHERE articleTitle LIKE '%".$searchproductName."%' or articleText LIKE '%".$searchproductName."%'";
$news_sql = "SELECT * FROM ls_article WHERE articleTitle LIKE '%".$searchproductName."%' or articleText LIKE '%".$searchproductName."%' order by Num DESC limit ". ($page2-1)*$PageSize2 .",".$PageSize2." ";
$news_query=$opendb->query($news_sql);
$result2=$opendb->query($newssql);
$row2 = mysqli_num_rows($result2);
?>
全站：产品
个，文章
个。
"; exit;
$products_query=$opendb->query($products_sql);
/*\***************************************************************************\*/
/*\ ѯݿ \*/
/*\***************************************************************************\*/
if($displaycatename!="")
{echo "
".$displaycatename."
";}
if($brief!="")
{echo "
"."Brief: ".$brief."
";}
?>
-
query($pic_sql);
$pic_myrows=mysqli_fetch_assoc($pic_query);
if($pic_myrows['subcateFolders']=="")
{
if($pic_myrows['midcateFolders']=="") //产品在大类下
{
$picsrc=$pic_myrows['cateFolders']."/".$SmallFoldersProducts."/".$products_rows['productPic'];
$piclink=$pic_myrows['cateFolders']."/".$showproductsFolders."/".trim(str_replace(substr($products_rows['productPic'],-4),"",$products_rows['productPic'])).".html";
}
else//产品在中类下
{
$pic_sql="select * from ls_products where ID=".$pic_myrows['midcateID']."";
$pic_query=$opendb->query($pic_sql);
$pic_myrows2=mysqli_fetch_assoc($pic_query);
$picsrc=$pic_myrows2['cateFolders']."/".$pic_myrows['midcateFolders']."/".$SmallFoldersProducts."/".$products_rows['productPic'];
$piclink=$pic_myrows2['cateFolders']."/".$pic_myrows['midcateFolders']."/".$showproductsFolders."/".trim(str_replace(substr($products_rows['productPic'],-4),"",$products_rows['productPic'])).".html";
}
}
else//产品在小类下
{
$pic_sql="select * from ls_products where ID=".$pic_myrows['subcateID']."";
$pic_query=$opendb->query($pic_sql);
$pic_myrows2=mysqli_fetch_assoc($pic_query);
$pic_sql="select * from ls_products where ID=".$pic_myrows2['midcateID']."";
$pic_query=$opendb->query($pic_sql);
$pic_myrows3=mysqli_fetch_assoc($pic_query);
$picsrc=$pic_myrows3['cateFolders']."/".$pic_myrows2['midcateFolders']."/".$pic_myrows['subcateFolders']."/".$SmallFoldersProducts."/".$products_rows['productPic'];
$piclink=$pic_myrows3['cateFolders']."/".$pic_myrows2['midcateFolders']."/".$pic_myrows['subcateFolders']."/".$showproductsFolders."/".trim(str_replace(substr($products_rows['productPic'],-4),"",$products_rows['productPic'])).".html";
}
?>
?>)
'>
(
)
$PageSize){
echo "
".$page_string."
";
}
$new_str ="
";
while($my_rows=mysqli_fetch_assoc($news_query)){
if($my_rows['cateName']){
$str = $my_rows['cateName'];
}else{
$str = $my_rows['functionName'];
}
$page_string = getSearchPages($row2, $page, $page2, $PageSize2, $searchproductName, "list");
if($my_rows['articleTitle'] != ""){
$new_str .= "- [".$my_rows['articleDate']."]".$my_rows['articleTitle']."
";
}
}
$new_str .= "
";
if($row2 != 0){
echo $new_str;
}else{
//echo "没有找到相关的文章信息！";
}
?>
$fenyePageSize) {echo $page_string;}?>
' ;
echo $hotword ;
?>
15533636303，17778236030