查看文件: submarket.php

大小: 2.05 KB

类型: application/octet-stream

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

$submarket=isset($_GET['menu'])?$_GET['menu']:'-1';

mysql_select_db($database_BE2, $BE2);
$query_Rt2 = sprintf("SELECT a.*,b.* FROM marketstreet as a left join marketmaster as b on  a.mname =b.msname where a.mname='%s' order by a.mind",$submarket);
$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 ;
 
?>
<section class="container"> 
<? if($totalRows_Rt2>0){?>
<h3 style="text-align: center; font-weight: bold; color:#00F"><?= $submarket  ?></h3> 
<div class="row">  
 <?   if($row_Rt2['msid']<>''){ ?>
       <div class="col-12 align-self-center"> 
	
           <a href="<?= $row_Rt2['mslink'] ?>"><img alt="" src="/products/<?= $row_Rt2['mspic'] ?>" style="width: 100%;" title="<?= $row_Rt2['msname'] ?>" /></a>
   
				<div class="clearfix"></div>
	   </div>
 <?   }   ?>

<? 
 $i=0;
 do { 
  if($i%3==0){ ?> <div class="clearfix"> </div> <?  } ?>
 
 <div class="col-md-4 col-xs-4 col-sm-4">
                
             <div class="mt thumbnail">
               <? 
			   //台北市,南港區,市民大道8段
			   $doc1=explode(",",$row_Rt2['maddress_name']) ; ?>
                      <a href="/search.html?search2=街道網店商城&keyword=<?= $doc1[0].$doc1[2].$row_Rt2['mside']?>" target="_self"><img src="/submarket/images/<?=$row_Rt2['mpic']?>" alt="<?= $doc1[0].$doc1[2].$row_Rt2['mside']?>網店商城" title="<?= $doc1[0].$doc1[2].$row_Rt2['mside']?>網店商城" /></a>
                         
                     </div>
             <div style="text-align:center;color:#06C">
			 
			 <? 
			   //if(count($doc1)==3){
				 echo $doc1[2].$row_Rt2['mside'];
			     //echo $row_Rt2['maddress_name'] ;//$doc1[2].$row_Rt2['mside']; 
			  //}
			  ?></div> 
             </div>
             
 <?php } while ($row_Rt2 = mysql_fetch_assoc($Rt2));  ?>   
 <div class="clearfix"> </div>
</div>
<? }?>
</section>         
<?php
mysql_free_result($Rt2);