查看文件: search_ecard.php

大小: 1.34 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 member WHERE mem_user2 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);
?>
 
<?
if($totalRows_Rt2>0){
do { ?>
 <div class="clearfix"> </div>

<div class="row" style="border-width:1px;border-style:solid;border-color:#ccc;padding:5px;width:100%;margin-bottom:5px;">
    <div class="col-xs-6 col-sm-6 col-md-6 col-lg-2 col-xl-2"> 
     <a href="/ecard/<?= $row_Rt2['scode'] ?>" >
     <img class="img-fluid" src="/ecard/img/<?= "user_".sprintf("%07d",$row_Rt2['mem_auto']).'.'.$row_Rt2['mem_logo2']; ?>" title="<?= $row_Rt2['mem_user2']; ?>" width="100%">
     </a>
    </div>
    <div class="col-xs-6 col-sm-6 col-md-6 col-lg-10 col-xl-10">
     <span  style="text-align:center"><br><br><a href="/ecard/<?= $row_Rt2['scode'] ?>" ><?= $row_Rt2['mem_user2']; ?></a></span>
    </div>
  </div>
    
  <? } while ($row_Rt2 = mysql_fetch_assoc($Rt2)); ?>
  
  
<?   } 
  
 mysql_free_result($Rt2);
  
?>