查看文件: search_products.php

大小: 1.41 KB

类型: application/octet-stream

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

$menu2=isset($_GET['keyword'])?$_GET['keyword']:'-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); 
$query_Rt2 =sprintf("SELECT * FROM product_data WHERE p_title like '%s' ",'%'.$menu2.'%'); 
$Rt2 = mysql_query($query_Rt2, $BE2) or die(mysql_error());
$row_Rt2 = mysql_fetch_assoc($Rt2);
$totalRows_Rt2 = mysql_num_rows($Rt2);
?>
 
<?
do { ?>
  <? 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="row" style="border-width:1px;border-style:solid;border-color:#ccc;padding:15px;width:100%;margin-bottom:10px;">
    <div class="col-1">
     <a href="/categoryDetail-<?= $row_Rt2['mem_auto'] ?>.html" >
     <img class="img-fluid" src="<?= $imagepath ?>" title="<?= $row_Rt2['p_title']; ?>" width="100%">
     </a>
    </div>
    <div class="col-11">
     <span><?=  $row_Rt2['p_title'] ?></span><br>
     <span style="margin-bottom:0px;" >$ <?= number_format($row_Rt2['p_money'],0, '.', ',');?> </span>
    </div>
  </div>
    
  <? } while ($row_Rt2 = mysql_fetch_assoc($Rt2)); ?>
  
  
<?  
  
 mysql_free_result($Rt2);
  
?>