查看文件: show5.php

大小: 1.67 KB

类型: application/octet-stream

<?php require_once('../Connections/BE2.php'); ?>
<?php
 
$menu1=isset($_GET['menu'])?$_GET['menu']:'禾聯家電';
 
//$exmenu=explode("-",htmlspecialchars($menu1));
//$mem_auto=$exmenu[1];
//
  
mysql_select_db($database_BE2, $BE2);
$query_Rt2 =sprintf("SELECT a.* FROM product_data as a,company as b WHERE a.company_num=b.mid AND b.company_name='%s' ",$menu1); 
$Rt2 = mysql_query($query_Rt2, $BE2) or die(mysql_error());
$row_Rt2 = mysql_fetch_assoc($Rt2);
$totalRows_Rt2 = mysql_num_rows($Rt2);

$menuc1=array();
$i=0;
do { ?>
  <? 
   $i++;
   if($i==1){?>
    <section class="container g-pb-20  d-sm-block">
      <div class="row no-gutters align-items-center">
       
  <? }?>

<? if($row_Rt2['p_new']==1){
			$imagepath = "/admin/upload2_image/".sprintf("%07d",$row_Rt2['company_num']).'/'.$row_Rt2['meta_img'].'.'.$row_Rqr1['p_tag'];  
				
			} else { $imagepath = "/admin/upload_image/".$row_Rt2['meta_img'];}
		 ?>

<div class="col g-mr-10">
      <div class="thumbnail">  
			<a href="/categoryDetail-<?= $row_Rt2['mem_auto'] ?>.html" ><img class="img-fluid" src="<?= $imagepath ?>" title="<?= $row_Rt2['p_title']; ?>" width="100%"></a>
           <? /*  <span class="g-color-black g-font-weight-400 g-font-size-14"><?=$row_Rt2['p_title']; ?></span> */ ?>
        </div>
          <div class="multy"><?= substr($row_Rt2['p_title'],0,16) ?>..</div>
           <div class="multy">$NT <?= number_format($row_Rt2['p_money'],0, '.', ',');?>元</div> 
        </div>
<?   
     if($i>4){
 		$i=0;
	   ?>  
          </div>
    </section>  
   <? } ?>
  <? } while ($row_Rt2 = mysql_fetch_assoc($Rt2));
 mysql_free_result($Rt2);
  
?>