|
<script>function StorePage(){d=document;t=d.selection?(d.selection.type!='None'?d.selection.createRange().text:''):(d.getSelection?d.getSelection():'');void(keyit=window.open('http://www.365key.com/storeit.aspx?t='+escape(d.title)+'&u='+escape(d.location.href)+'&c='+escape(t),'keyit','scrollbars=no,width=475,height=575,left=75,top=20,status=no,resizable=yes'));keyit.focus();}</script> <link href="css/style.css" rel="stylesheet">
<?php
include("conn/conn.php");
%导入数据库连接文件
?>
<table width="563" height="587" border="0" cellpadding="0" cellspacing="0">
<tr>
<td width="563" height="587" valign="top" bgcolor="#FFFFFF"><table width="563" border="0" cellspacing="0" cellpadding="0">
<tr>
<td width="563" height="27" background="Images/fufei.gif"> </td>
</tr>
<tr>
<td height="96" align="center" valign="top"><br>
<?php
$date1=date("Y-m-d");
%获取当前时间
$sgsql=mysql_query("select * from tb_leaguerinfo where type='招聘信息' and showday>='$date1' and checkstate=1 ");
%查询信息
$sginfo=mysql_fetch_array($sgsql);
%获取查询结果
if($sginfo){
do{
?>
<table width="540" border="0" cellspacing="0" cellpadding="0">
<tr>
<td height="26"><span class="style1">『招聘信息』</span><span class="style8"> <?php echo $sginfo[title];?> </span><span class="style6"> <?php echo $sginfo[edate];?></span></td>
</tr>
<tr>
<td height="26"> <span class="style5"> <?php echo $sginfo[content];?></span></td>
</tr>
<tr>
<td height="26"> <span class="style8">联系人:<?php echo $sginfo[linkman];?> 联系电话:<?php echo $sginfo[tel];?></span></td>
</tr>
<tr>
<td height="3" background="Images/line1.gif"></td>
</tr>
</table>
<?php
}while($sginfo=mysql_fetch_array($sgsql));
%展示信息
}else{
?>
<table width="540" border="0" cellspacing="0" cellpadding="0">
<tr>
<td align="center">暂无招聘信息资源!</td>
</tr>
</table>
<?php
}
?></td>
</tr>
<tr>
<td align="center" valign="top"><table width="560" border="0" cellspacing="0" cellpadding="0">
<tr>
<td height="87" background="Images/guanggao.gif"> </td>
</tr>
</table></td>
</tr>
<tr>
<td height="27" background="Images/mian.gif"> </td>
</tr>
<tr>
<td height="140" align="center" valign="top">
<br>
<?php
$sql=mysql_query("select count(*) as total from tb_info where type='招聘信息' and checkstate=1");
%查询字符串
$info=mysql_fetch_array($sql);
%获取结果
$total=$info[total];
%获取结果总数
$pagesize=4;
%每页显式4个结果
if ($total<=$pagesize){
$pagecount=1;
%不足4个结果,就显式1页
}
if(($total%$pagesize)!=0){
$pagecount=intval($total/$pagesize)+1;
%若不能整除,则取商再加1
}else{
$pagecount=$total/$pagesize;
%否则直接去商
}
if(($_GET |
|
|