查看文件: body_showcard.php

大小: 2.76 KB

类型: application/octet-stream

<?php require_once('../Connections/BE2.php'); ?>
<? 
  if (!isset($_SESSION)){ session_start(); } 
 //if( isset($_SESSION['login_memid']) && $_SESSION['login_memid']>0 ){
   
  mysql_select_db($database_BE2, $BE2);
//  $query_Rt2 = "SELECT * FROM mdat2 where bc5='Y' ORDER BY bid desc";
  $query_Rt2 = sprintf("SELECT * FROM member_card WHERE muid='%s' order BY mindex ASC",$_SESSION['login_memid']);
 
  $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){
	mysql_free_result($Rt2);  
   for($i=1;$i<10;$i++){
	   //$n=sprintf("%04d",rand(0,9999);
	 mysql_select_db($database_BE2, $BE2);  
	 $img=date("YmdHis").sprintf("%04d",rand(1,9999));
	 $insert_R2 = sprintf("insert into member_card(muid,mindex,mpic,mflag)VALUES('%s','%s','%s','N')",$_SESSION['login_memid'],$i,$img);
	 mysql_query($insert_R2, $BE2) or die(mysql_error());  
	 
	 }	 
	  
  mysql_select_db($database_BE2, $BE2);
//  $query_Rt2 = "SELECT * FROM mdat2 where bc5='Y' ORDER BY bid desc";
  $query_Rt2 = sprintf("SELECT * FROM member_card WHERE muid='%s' order BY mindex ASC",$_SESSION['login_memid']);
 
  $Rt2 = mysql_query($query_Rt2, $BE2) or die(mysql_error());
  
  
  $row_Rt2 = mysql_fetch_assoc($Rt2);
  $totalRows_Rt2 = mysql_num_rows($Rt2);
	  
  }

// $member_lv=array("","VIP會員 NT$3,990(1,800PV)","金級會員 NT$18,000(10,800PV)","白金級會員NT$48,000(28,800PV)"); 
 ?>
					    
 <div class="main "> 
 
 <div class="row">
 <div class="col-lg-12">				    
<a style="cursor: pointer" ><b><font color="blue">雲明片</font></b></a></p>
<table width="560" class="table table-bordered">
				  <thead>
									  <tr>
										  <th width="59">ID</th>
										  <th width="96">圖檔</th>
                                          <th width="232">說明</th>
                                          <th width="75">使用</th>
										  <th width="74">編輯</th>
									  </tr>
								  </thead>   
								  <tbody>
                                  <?php 
										do { 
								 
								 ?>
			<tr>
			<td height="20" class="center">&nbsp;</td>
			<td><span class="center">
			  <?= $row_Rt2['mid']; ?>
			</span></td>
            <td><?= $row_Rt2['mdoc'];?>
              <?= $row_Rt2['mpic'];?></td>
            <td><?= $row_Rt2['mflag'];?></td>
			<td><a href="editcard-<?= $row_Rt2['mid']; ?>.html" target="_self"><img src="../icon/edit.jpg" width="45" height="45" /></a></td>
			 </tr>
              <?php } while ($row_Rt2 = mysql_fetch_assoc($Rt2)); ?>

</tbody>
						  </table>  
   	</div>
   </div> 
		</div>
<?php
mysql_free_result($Rt2);
  
?>