查看文件: showtbjob.php

大小: 2.2 KB

类型: application/octet-stream

<?php require('system/login.php');  ?>
<?php require_once('../Connections/BE2.php'); ?>
<?php
 
if(isset($_GET['del_id']) && ( $_GET['del_id']>0 )){
// mysql_select_db($database_BE2, $BE2);
// $delete_SQL = sprintf("UPDATE tbjob SET jbck='C' WHERE cuid3=%s AND jb0='%s'",$_SESSION['login_id'],$_GET['del_id']);
// mysql_query($delete_SQL, $BE2) or die(mysql_error());
}
 
mysql_select_db($database_BE2, $BE2);
$query_Rt2 = "SELECT a.*,b.webname,b.weblen FROM tbjob as a, cuser as b where a.cuid3=b.cuid order by jb6 desc";
$Rt2 = mysql_query($query_Rt2, $BE2) or die(mysql_error());
$row_Rt2 = mysql_fetch_assoc($Rt2);
$totalRows_Rt2  = mysql_num_rows($Rt2); 
 
?>
  
  <table width="911" border="0" cellpadding="0" cellspacing="0">
    <tr>
      <th width="2%" nowrap="nowrap" class="font2">ID</th>
      <th width="11%" nowrap="nowrap" class="font2">徵才名稱</th>
      <th width="11%" nowrap="nowrap" class="font2">工作地點</th>
      <th width="20%" nowrap="nowrap" class="font2">條件要求</th>
      <th width="18%" nowrap="nowrap" class="font2">聯絡方式</th>
      <th width="16%" nowrap="nowrap" class="font2">發佈日期</th>
      <th nowrap="nowrap" class="font2">截止日期</th>
      <th nowrap="nowrap" class="font2">狀態</th>
      <th nowrap="nowrap" class="font2">單位行號</th>
    </tr>
    <?php 
	 if($totalRows_Rt2>0){ 
	  do { ?>
    <tr>
      <td align="center" class="font3">&nbsp;</td>
      <td align="center" class="font3"><?= $row_Rt2['jb1']; ?></td>
      <td align="center" class="font3"><?= $row_Rt2['jb2']; ?></td>
      <td align="center" class="font3"><?= $row_Rt2['jb3']; ?></td>
      <td align="center" class="font3"><?= $row_Rt2['jb4']; ?></td>
      <td align="center" class="font3"><?= $row_Rt2['jb6']; ?>...</td>
      <td width="11%" align="center" class="font3"><?= $row_Rt2['jb7']; ?></td>
      <td width="6%" align="center" nowrap="nowrap" class="font3"><?= $row_Rt2['jbck']?></td>
      <td width="5%" align="center" class="font3"><?= mb_substr( $row_Rt2['webname'],0,$row_Rt2['weblen'],"utf-8");?></td>
    </tr>
    <?php } while ($row_Rt2 = mysql_fetch_assoc($Rt2)); 
	 }
	  ?>

</table>

<?php
mysql_free_result($Rt2);
?>