查看文件: discover.php

大小: 2.49 KB

类型: application/octet-stream

<?php require_once('../Connections/BE2.php'); ?>
 <?

$showpage=2; 
  //https://skybni.com/discover/台北市_文湖線.html video_master vid,youvideo vkid
  $co1=isset($_GET['menu'])?$_GET['menu']:'-1'; //  $co1 CITY 
  $act=isset($_GET['act'])?$_GET['act']:$co1;
 // if($act==''){ $act=$col ;}
  if (!strpos($act,'探索網')){
	  
	 $act .='探索網'; 
	  }
  mysql_select_db($database_BE2, $BE2);
 // $query_Rt2 = sprintf("SELECT * FROM video_master as a , youvideo as b WHERE a.vdoc='%s' AND a.vid=b.ykid AND b.yflag='Y' AND a.vflag='Y' AND a.vkid like '%s' AND  a.vzone like '%s' order by a.vindex,a.vid,b.yindex", $act,'%VIP會員網%', '%'.$co1.'%') ; 
  $query_Rt2 = sprintf("SELECT * FROM video_master as a , youvideo as b WHERE a.vdoc='%s' AND a.vid=b.ykid AND b.yflag='Y' AND a.vflag='Y' order by a.vindex,a.vid,b.yindex", $act) ;

$Rt2 = mysql_query($query_Rt2, $BE2) or die(mysql_error());
  $row_Rt2 = mysql_fetch_assoc($Rt2);
  $totalRows_Rt2 = mysql_num_rows($Rt2);
  // echo $query_Rt2;
  $title=""; 
  $i=0;
    ?>

<div class="container" style="margin-top:20">
<? 
   //\video_img\logo\
   $img="/products/000830284715.jpg";
   //$img='/video_img/logo/dis'.sprintf("%04d",$row_Rt2['vid']).$row_Rt2['vimg2'].'.png'; 
   $img2='/video_img/logo/dis'.sprintf("%04d",$row_Rt2['vid']).$row_Rt2['vimg2'].'.png'; 
   if(file_exists("/www2/skybni".$img2)){
	  $img=$img2;  
	 }
 
?>  
 <row class="thumbnail" ><a href="<?= $row_Rt2['vlink']; ?>"><img src="<?= $img; ?>" width="100%" alt="" /></a> 
   <div style="text-align:center"><?= $row_Rt2['vdoc'] ?></div> 
  </row>
  <div class="clearfix"> </div>
 
<?   
 
  $i=0;
  $vid='';
  do { 
   $logo_image=sprintf("%04d",$row_Rt2['vid']).$row_Rt2['vimg'].'.png';
    if($row_Rt2['video']=='Y'){?> 
     <div class="col-4">
         <div class="embed-responsive embed-responsive-16by9" style=" margin-right:15px; margin-top:20px">
          <iframe class= "embed-responsive-item"  width="90%" src="https://www.youtube.com/embed/<?= $row_Rt2['ylink']  ?>" allowfullscreen></iframe>
        </div><span style="font-size:0.875em"> <?= mb_substr($row_Rt2['ydoc'], 0, 5, "UTF-8") ; ?></span>
     </div>
     <? } else{?>  
     <a href="<?= $row_Rt2['ylink']  ?>"><img src="/video_img/logo/<?= $row_Rt2['yimage'];?>"  title="<?= $row_Rt2['vdoc']?>" width="130" height="108" /></a>
     <? }  ?>
  <? } while ($row_Rt2 = mysql_fetch_assoc($Rt2));     
	  
 mysql_free_result($Rt2); ?>
 
 
 <? 
  
   ?>

</div>
</div>