關于“
”
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