include ("config.php");
$catsn=$_GET['catsn'];
$catsn2=$_GET['catsn2'];
$Page=$_GET['Page'];
$PageSelect=$_GET['PageSelect'];
$sn=$_GET['sn'];
//選取產品相關設定
$sql = "select * from $data_worksSet";
$rs = mysql_query($sql,$link);
list($index,$pic,$account,$web1,$web2,$web3,$width,$height,$show_pro,$show33_pro,$show22_pro,$show11_pro,$titleName)=mysql_fetch_row($rs);
//沒有傳第一層分類序號進來的情形
if($catsn==""){
$sql = "select * from $data_worksCat1 order by aOrder desc";
$rs = mysql_query($sql,$link);
list($catsn,$order,$CatName1)=mysql_fetch_row($rs);
$sql = "select aCatSn2,aName from $data_worksCat2 where aCatSn='$catsn' order by aOrder desc";
$rs = mysql_query($sql,$link);
list($catsn2,$CatNameB)=mysql_fetch_row($rs);
$catsn_Show=$catsn2;
//判斷第一層分類底下是否有產品資料
$sql = "select aCatSn2 from $data_worksCat where aCatSn2='$catsn'";
$rs = mysql_query($sql,$link);
$nT_CAT = mysql_num_rows($rs);
if($nT_CAT >0){
list($catsn_Show)=mysql_fetch_row($rs);
}
}
//有傳第一層分類序號進來的情形
else{
//防止亂傳參數,判斷所傳之第一層分類的序號是否正確
$sql = "select * from $data_worksCat1 where aCatSn='$catsn'";
$rs = mysql_query($sql,$link);
$nT = mysql_num_rows($rs);
if($nT< 1){
header("location:show-room-list.php");
exit;
}
list($catsn,$order,$CatName1)=mysql_fetch_row($rs);
//沒有傳第二層分類序號進來的情形 B---------if/else
if($catsn2==""){
//判斷第一層分類底下是否有產品資料
$sql = "select aCatSn2 from $data_worksCat where aCatSn2='$catsn'";
$rs = mysql_query($sql,$link);
$nT_CAT = mysql_num_rows($rs);
//第一層分類底下有資料的情形 C---------if/else
if($nT_CAT >0){
list($catsn_Show)=mysql_fetch_row($rs);
}
//第一層分類底下沒有資料的情形,就抓取第一層分類的序號當成要顯示的序號 C---------if/else
else{
$catsn_Show=$catsn;
}
}
//有傳第二層分類序號進來的情形 B---------if/else
else{
$sql = "select * from $data_worksCat2 where aCatSn2='$catsn2'";
$rs = mysql_query($sql,$link);
list($catsn_Show,$catsnSSS,$order,$CatNameB)=mysql_fetch_row($rs);
if($catsn_Show=="") $catsn_Show=$catsn;
}
}
?>
echo $MAIN_TITLE; ?> » echo $titleName; ?>
if($index=="66" && $pic!=""){
?>
//======================================= FLASH 的顯示 START ======================================================//
if($pic=="swf"){
?>
}
//======================================= FLASH 的顯示 END ======================================================//
//======================================= 一般圖片的顯示 START ======================================================//
else{
//不連結
if($web1=="66"){
?>
}
//有連結
else{
//一般網站
if($web1=="11"){
?>
" >
}
//電子郵件
if($web1=="22"){
?>
}
//加密網站
if($web1=="33"){
?>
" >
}
//FTP
if($web1=="44"){
?>
" >
}
//自訂
if($web1=="55"){
?>
" >
}
}
}
//======================================= 一般圖片的顯示 END ======================================================//
?>
}
?>
$sql = "select * from $data_worksCat1 where aOrder!='0' order by aOrder desc";
$rs = mysql_query($sql,$link);
$nT = mysql_num_rows($rs);
for($i=0;$i< $nT;$i++){
list($catSn,$order,$catname)=mysql_fetch_row($rs);
if($catsn==$catSn){
?>
$sql2 = "select * from $data_worksCat2 where aCatSn='$catsn' and aOrder!='0' order by aOrder desc";
$rs2 = mysql_query($sql2,$link);
$nT2 = mysql_num_rows($rs2);
if($nT2>0){
?>
for($j=0;$j< $nT2;$j++){
list($catSn2,$catSn,$order,$catname2)=mysql_fetch_row($rs2);
?>
echo $catname2; ?>
if($catSn2==$catsn2 && $catsn!=$catsn_Show){
?>
}
?>
}
echo "
";
if($j!=$nT2-1 && $i!=$nT-1) include("../include/left-menu-division.php");
}
else{
if($i!=$nT-1) include("../include/left-menu-division.php");
}
}
else{
?>
}
} //forj
?>
$sql_ad = "select * from $data_ad where aOrder!='' order by aOrder desc";
$rs_ad = mysql_query($sql_ad, $link);
$nT_ad = mysql_num_rows($rs_ad);
if($nT_ad >0){
?>
for($i=0;$i< $nT_ad;$i++){
list($adSn,$order,$title,$content,$account,$pic,$web1,$web2,$web3,$width,$height)=mysql_fetch_row($rs_ad);
?>
//========================================== 顯 示 圖 片 或 FLASH START ====================================================//
if($pic!=""){
?>
}
//========================================== 顯 示 圖 片 或 FLASH END ====================================================//
?>
}
?>
}
?>
$sql = "select aName from $data_worksCat1 where aCatSn='$catsn'";
$rs = mysql_query($sql,$link);
list($CatName1)=mysql_fetch_row($rs);
if($catsn!=$catsn_Show){
$sql = "select aName from $data_worksCat2 where aCatSn2='$catsn2'";
$rs = mysql_query($sql,$link);
list($CatName2)=mysql_fetch_row($rs);
}
?>
echo $CatName1; ?>
if($CatName2!=""){
?>
echo $CatName2; ?>
}
?>
//=========================================== 換頁程式第一部分 START ============================================//
//======== 接收前頁傳來的 $Page,以決定本頁顯示的資料
$now_Page=$Page;
if ( $now_Page == "" ) $now_Page=0;
// 每頁顯示 5 筆
$show_num = 8;
// 本頁之起始指標
$record_begin = $now_Page * $show_num;
// 本頁實際顯示筆數
$record_show = $show_num;
//======== 計算資料總筆數
$sql = "select * from $data_worksCat where aCatSn2='$catsn_Show' and aOrder!='' and aOrder!=0 order by aOrder desc";
$rs = mysql_query($sql, $link);
$nTotal = mysql_num_rows($rs);
// 本頁之實際顯示筆數不可大於總筆數
if (( $record_begin + $record_show ) > $nTotal )
$record_show = $nTotal - $record_begin;
//=================== 若該主分類沒有內容,就自動跳到次分類 SATRT =======================//
if($nTotal< 1 && strlen($catsn_Show)==4){
$sql3 = "select aCatSn from $data_worksCat1 where aCatSn='$catsn'";
$rs3 = mysql_query($sql3,$link);
$nT3 = mysql_num_rows($rs3);
list($catsn)=mysql_fetch_row($rs3);
if($nT3>0){
$sql3 = "select aCatSn2 from $data_worksCat2 where aCatSn='$catsn' order by aOrder desc";
$rs3 = mysql_query($sql3,$link);
$nT3 = mysql_num_rows($rs3);
if($nT3>0){
list($catsn2)=mysql_fetch_row($rs3);
?>
}
}
exit;
}
//=================== 若該主分類沒有內容,就自動跳到次分類 END =======================//
//=========================================== 換頁程式第一部分 END ============================================//
if($show_pro=="33"){
if($show33_pro=="1") include("list4.php");
else include("list4-nopic.php");
}
elseif($show_pro=="22"){
if($show22_pro=="1") include("list2.php");
else include("list2-nopic.php");
}
else{
if($show11_pro=="1") include("list1.php");
else include("list1-nopic.php");
}
//include("division-01.php");
?>
//=========================================== 換頁程式第二部分 START ============================================// ?>
// 計算總頁數
$PageTotal = ceil($nTotal/$show_num);
?>
//========== 第一頁 START ==========//
if ( $now_Page > 0 ) {
?>
}
else{
}
//========== 第一頁 END ==========//
?>
//========== 上一頁 START ==========//
if ( $now_Page > 0 ) {
?>
}
else{
}
//========== 上一頁 END ==========//
?>
第 頁(共 頁、 筆資料)
//========== 下一頁 START ==========//
if ( $PageTotal > ($now_Page + 1) ) {
?>
}
else{
}
//========== 下一頁 END ==========//
?>
//========== 最後一頁 START ==========//
if ( $PageTotal > ($now_Page + 1) ) {
?>
}
else{
}
//========== 最後一頁 END ==========//
?>
//=========================================== 換頁程式第二部分 END ============================================// ?>
$sql = "select * from $data_footSet";
$rs = mysql_query($sql,$link);
list($company,$rows)=mysql_fetch_row($rs);
?>
$a = $_SERVER['HTTP_REFERER'];
$a = substr($a, strrpos($a, "/") + 1);
//echo $a;
?>