查看文件: setSignupman.php

大小: 5.71 KB

类型: application/octet-stream

<?php require_once('../Connections/BE2.php'); ?>
<?  require('system/login.php');  ?>
<?php
if ((isset($_GET['check_id'])) && ($_GET['check_id'] != "")) {
 //if($_SESSION['login_lv']>7){
  $deleteSQL = sprintf("DELETE FROM signupman WHERE randw=%s",$_GET['check_id']);
   mysql_select_db($database_BE2, $BE2);
  $Result1= mysql_query($deleteSQL, $BE2) or die(mysql_error());
 // }
}

$currentPage = "main.php?act=setSignupman"; $_SERVER["PHP_SELF"];

$maxRows_Rt2 = 60;
$pageNum_Rt2 = 0;
if (isset($_GET['pageNum_Rt2'])) {
  $pageNum_Rt2 = $_GET['pageNum_Rt2'];
}
$ck2=1;
if (isset($_GET['ck2'])) {
  $ck2 = $_GET['ck2'];
}

$startRow_Rt2 = $pageNum_Rt2 * $maxRows_Rt2;

mysql_select_db($database_BE2, $BE2);
//$query_Rt2 = "SELECT * FROM signup1 WHERE 1 ORDER BY sgid DESC";
$query_Rt2 = sprintf("SELECT a.*,b.sgname FROM signupman as a ,signup1 as b  WHERE a.sgid=b.sgid AND ma=0 AND ck2='%s' AND a.sgid='%s' ",$ck2,$_GET['editid']);
$query_limit_Rt2 = sprintf("%s LIMIT %d, %d", $query_Rt2, $startRow_Rt2, $maxRows_Rt2);
$Rt2 = mysql_query($query_limit_Rt2,  $BE2) or die(mysql_error());
$row_Rt2 = mysql_fetch_assoc($Rt2);
// echo $query_Rt2 ;//'媒體 17 活動 16 最新 15';

if (isset($_GET['totalRows_Rt2'])) {
  $totalRows_Rt2 = $_GET['totalRows_Rt2'];
} else {
  $all_Rt2 = mysql_query($query_Rt2);
  $totalRows_Rt2 = mysql_num_rows($all_Rt2);
}
$totalPages_Rt2 = ceil($totalRows_Rt2/$maxRows_Rt2)-1;

$queryString_Rt2 = "";
if (!empty($_SERVER['QUERY_STRING'])) {
  $params = explode("&", $_SERVER['QUERY_STRING']);
  $newParams = array();
  foreach ($params as $param) {
    if (stristr($param, "pageNum_Rt2") == false && 
        stristr($param, "totalRows_Rt2") == false) {
      array_push($newParams, $param);
    }
  }
  if (count($newParams) != 0) {
    $queryString_Rt2 = "&" . htmlentities(implode("&", $newParams));
  }
}
$queryString_Rt2 = sprintf("&totalRows_Rt2=%d%s", $totalRows_Rt2, $queryString_Rt2);

?> 
 
<div align="center" class="font16b">活動報名審核</div>
  <br>
<table width="80%" border="0" align="center" cellpadding="0" cellspacing="0" bordercolor="#99CCCC" class="font_box12x">
  <tr>
    <td colspan="9" bgcolor="#FFFFCC"><? // echo $query_Rt2 ;?></td>
  </tr>
  <tr>
    <td width="43" bgcolor="#FFFFCC" class="f12blue_gy">&nbsp;</td>
    <td width="294" align="center" bgcolor="#FFFFCC" class="f12blue_gy">活動名稱</td>
    <td width="114" align="center" bgcolor="#FFFFCC" class="f12blue_gy">姓名</td>
    <td width="106" align="center" bgcolor="#FFFFCC" class="f12blue_gy">身分證號</td>
    <td width="140" align="center" bgcolor="#FFFFCC" class="f12blue_gy">報名日期</td>
    <td width="153" align="center" bgcolor="#FFFFCC" class="f12blue_gy">連絡電話</td>
    <td width="134" align="center" bgcolor="#FFFFCC" class="f12blue_gy">手機</td>
    <td width="109" align="center" bgcolor="#FFFFCC" class="f12blue_gy">報名人數</td>
    <td width="31" align="center" bgcolor="#FFFFCC" class="f12blue_gy">&nbsp;</td>
    <?  $qr1='&ck2='.$ck2."&editid=".$_GET['editid'] ; ?>
  </tr>
  <? if($totalRows_Rt2 > 0 ){?>
  <?php do { ?>
    <tr>
      <td height="24" class="f12grey"><a href="javascript:if(confirm('確實要刪除嗎?'))location='<? echo $currentPage.$qr1."&check_id=".$row_Rt2['randw'] ;?>'"><img src="images/del.png" width="16" height="16" border="0" /></a></td>
      <td class="f12grey"><?php echo $row_Rt2['sgname']; ?></td>
      <td class="f12grey"><? echo $row_Rt2['s1']; ?></td>
      <td class="f12grey"><?php echo $row_Rt2['s2'] ; ?></td>
      <td class="f12grey"><?php echo $row_Rt2['sdate'] ; ?></td>
      <td class="f12grey"><?php echo $row_Rt2['s10'] ; ?></td>
      <td align="center" class="f12grey"><?php echo $row_Rt2['s9'] ; ?></td>
      <td align="center" class="f12grey"><?php echo $row_Rt2['cman'] ; ?></td>
      <td align="center" class="f12grey"><a href="edit_signupman.php<?php echo $qr1."&id=". $row_Rt2['s0']; ?>"><img src="images/edit.png" width="16" height="16" border="0" /></a></td>
    </tr>
	  <tr>
    <td colspan="9" class="font3"> </td>
    </tr>
    <?php } while ($row_Rt2 = mysql_fetch_assoc($Rt2)); ?>

<tr>
    <td colspan="9">
      <table border="0" width="50%" align="center">
        <tr>
          <td width="23%" align="center"><?php if ($pageNum_Rt2 > 0) { // Show if not first page ?>
                <a href="<?php printf("%s?pageNum_Rt2=%d%s", $currentPage, 0, $queryString_Rt2); ?>"><img src="../images/First.gif" border=0></a>
                <?php } // Show if not first page ?>          </td>
          <td width="31%" align="center"><?php if ($pageNum_Rt2 > 0) { // Show if not first page ?>
                <a href="<?php printf("%s?pageNum_Rt2=%d%s", $currentPage, max(0, $pageNum_Rt2 - 1), $queryString_Rt2); ?>"><img src="../images/Previous.gif" border=0></a>
                <?php } // Show if not first page ?>          </td>
          <td width="23%" align="center"><?php if ($pageNum_Rt2 < $totalPages_Rt2) { // Show if not last page ?>
                <a href="<?php printf("%s?pageNum_Rt2=%d%s", $currentPage, min($totalPages_Rt2, $pageNum_Rt2 + 1), $queryString_Rt2); ?>"><img src="../images/Next.gif" border=0></a>
                <?php } // Show if not last page ?>          </td>
          <td width="23%" align="center"><?php if ($pageNum_Rt2 < $totalPages_Rt2) { // Show if not last page ?>
                <a href="<?php printf("%s?pageNum_Rt2=%d%s", $currentPage, $totalPages_Rt2, $queryString_Rt2); ?>"><img src="../images/Last.gif" border=0></a>
                <?php } // Show if not last page ?>          </td>
        </tr>
      </table></td>
  </tr>
  <tr>
    <td colspan="9">&nbsp;</td>
  </tr>
  <? } ?>
</table>
 
<?php
mysql_free_result($Rt2);
?>