//jobresume.php
<!-- #BeginTemplate "/Templates/zhaopin.dwt" -->
<!-- #BeginEditable "doctitle" -->
<title>生活168 －求职招聘－个人简历中心</title>
<SCRIPT language=JavaScript>
function view(Url)
{
popup=window.open(Url,"Displaywindow","left=100,top=30,
width=700,height=400,toolbar=no,location=no,directories=no,
status=no,menubar=no,scrollbars=yes, resizable=no");
}
</SCRIPT>
<!-- #EndEditable -->
<body bgcolor="#FFFFFF">
<table width="95%" border="1" cellspacing="0" cellpadding="0"
height="610" align="center" bordercolorlight="#FFFFFF"
bordercolordark="#FF9966">
<tr>
<td width="24%" height="62" bgcolor="#FF9933">
<p><b><font color="#FFFFFF" size="5">WitiTech
</font></b></p>
<p><font color="#00FF00"><b><font size="5">
求职招聘专栏</font></b></font></p>
</td>
<td width="76%" height="62">
<div align="right">【插入滚动的广告】</div>
</td>
</tr>
<tr bgcolor="#CCCCFF">
<td colspan="2" height="51">
<div align="right">[旅游交通] [生活百事][旅游交通]
[生活百事][旅游交通] [生活百事] [娱乐咨询] [合肥介绍]
[...] [...] .......</div>
</td>
</tr>
<tr>
<td colspan="2" height="500">
<div align="left">
<table width="100%" border="0" cellspacing="0"
cellpadding="0" height="504">
<tr>
<td width="19%" valign="top" bgcolor="#FFFFCC">
<p> </p>
<p><a href="index.php">[首页]</a></p>
<p><a href="jobsearch.php">[职位查询] </a></p>
<p><a href="jobcompany.php">[公司名录]</a></p>
<p><a href="jobresume.php">[简历中心]</a></p>
<p><a href="jobparttime.php">[兼职特区]</a></p>
<p><a href="jobstudent.php">[应届生区]</a></p>
<p>[求职论坛]</p>
<p><a href="JOBREG.PHP"><font size="2">
[新职位登录]</font></a></p>
<p><font size="2"><a href="resumereg.php">
[简历登录]</a></font></p>
</td>
<td width="81%" valign="top" align="right">
<!-- #BeginEditable "content" -->
<table width="100%" border="1" cellspacing="0"
cellpadding="1" bordercolordark="#FFFFFF"
bordercolorlight="#FF6633"
height="50">
<tr bgcolor="#FF9999">
<td><b><font size="2" color="#FFFFFF">
个人简历查询</font></b></td>
</tr>
<tr>
<td height="79"> <?
if ($restype==NULL)
{
?>
<p>欢迎使用个人简历查询系统，请在相关表格里填入你
感兴趣的内容，然后点击[确认] </p>
<?
}
else
{
//查询然后显示结果
include("DB_MYSQL.INC");
$db = new DB_Sql;
if ($i==NULL) $i=0;
$j=$i+10;
$condition="resume_col12 like '%$resmajor%'
and resume_col9 like '%$resshool%' and resume_col17
like '%$reshistory%' ";
switch ($restype)
{
case 2:
$q1="select resume_id from resume where $condition";
$q2="select resume_id, resume_col1, resume_col22,resume_col20
from resume where $condition ORDER BY resume_id limit $i,$j";
break;
case 1:
$q1="select resume_id from resume where resume_col22=1 and $condition";
$q2="select resume_id, resume_col1, resume_col22,resume_col20
from resume where resume_col22 and $condition ORDER BY resume_id limit $i,$j";
break;
case 3:
$q1="select resume_id from resume where resume_col22=0 and $condition";
$q2="select resume_id, resume_col1, resume_col22,resume_col20
from resume where resume_col22=0 and $condition ORDER BY resume_id limit $i,$j";
break;
default:
echo "error input";
exit(3);
break;
}
$db->query($q1);
$totalnumber=$db->num_rows();//获得兼职职位总条目数
?>
<table width="100%" border="1" cellspacing="0"
cellpadding="1"
bordercolordark="#FF9999" bordercolorlight="#FFFFFF">
<tr>
<td>查询结果：一共找到<? echo $totalnumber ?>
个相匹配的结果</td>
</tr>
<tr>
<td>
<table width="100%" border="1" cellspacing="0"
cellpadding="1" height="50"
bordercolordark="#FFFFFF"
bordercolorlight="#FF9900">
<tr>
<td width="19%" height="18">
<font size="2"><b>
<font color="#006600">
用户id</font></b></font></td>
<td width="62%" height="18">
<font size="2"><b>
<font color="#006600">求职类别</font>
</b></font></td>
<td width="19%" height="18"><font
size="2"><b>点击次数</b></font></td>
</tr>
<?
//查询出第i条到第i+10条
$db->query($q2);
$nowget=$db->num_rows();
?> <?while($db->next_record()):?>
<tr>
<td width="19%" height="18">
<font size="2"> <a href="javascript:view
('resumeview.php?resume_id=<? echo $db->f(0)?>')">
<?echo $db->f(1); ?></a> </font> </td>
<td width="62%" height="18"><font size="2">
<?
if ($db->f(2) == 1)
echo "兼职";
else
echo "全职"
?>
</font></td>
<td width="19%" height="18"><font size="2">
<? echo $db->f(3) ?></font></td>
</tr>
<? endwhile ?>
</table>
</td>
</tr>
<tr>
<td><font size="2"><b>一共<? echo
$totalnumber ?>条记录，目前显示的是第<? echo $i+1 ?>
到第<? echo $i+$nowget ?>条
<?
if(($totalnumber-$i-10)>0)
{
?> <a href="jobresume.php?i= <? echo $i+11 ?>">
下10条</a>
<? } ?> <? if(($i-10)>=0)
{
?> <a href="jobresume.php?i= <? echo $i-11 ?>">
前10条</a>
<? } ?> </b></font></td>
</tr>
</table>
<? } ?> </td>
</tr>
</table>
<table width="100%" border="1" cellspacing="0" cellpadding="1"
bordercolordark="#FFFFFF" bordercolorlight="#FF6666">
<tr bgcolor="#FF6666">
<td height="11"><font color="#FFFFFF"><b>
<font size="2">查询表格</font></b></font></td>
</tr>
<tr>
<td>
<form name="form1" method="post" action="jobresume.php">
<p>求职类别
<select name="restype">
<option value="2">任意</option>
<option value="1">兼职</option>
<option value="3">全职</option>
</select>
</p>
<p>主修专业（包含关键字）
<input type="text" name="resmajor">
(不填写，表示任意，下同）</p>
<p>毕业院校 （包含关键字）
<input type="text" name="resschool">
</p>
<p>工作经历(包含关键字）
<input type="text" name="reshistory">
</p>
<p>
<input type="submit" name="Submit" value="Submit">
<input type="reset" name="Submit2" value="Reset">
</p>
</form>
</td>
</tr>
</table>
<!-- #EndEditable --></td>
</tr>
</table>
</div>
</td>
</tr>
<tr>
<td colspan="2">
<div align="center"><font size="2" color="#333300"><b>
<font color="#006600">版权所有
- WitiTech Studio, 2000</font></b></font></div>
</td>
</tr>
</table>
<!-- #EndTemplate -->
如果您对本文有任何疑问或者建议，请到讨论区发表您的意见:
>>
论坛入口 <<
上一篇：用PHP+MySQL构建一个招聘网站（10）
下一篇：用PHP+MySQL构建一个招聘网站（12）
【文章评论】
【收藏本文】
【推荐好友】
【打印本文】
【我要投稿】 【论坛讨论】
更多相关文章
|
|
