<?php
$tempquery = mysql_query("select dpb,facejtype from zgy_member_p_d_basic where dpb = '$city' and facejtype like '%$keyword%' ");
$count = mysql_num_rows( $tempquery );
if( $count )
{
$page=isset($_GET['page'])?$_GET['page']:1;
$pagesize=20;
$pagecount=($count % $pagesize)?(int)($count / $pagesize) +1:$count / $pagesize;
$page=($page>$pagecount || $page<1)?$page=1:$page;
$start=$pagesize*($page-1);
$sql = "Select
dpb,
truename,
uid,
sex,
birth,
education,
experience,
facejkind,
facejtype,
id
from
zgy_member_p_d_basic
where
dpb = '$city' and
facejtype like '%$keyword%' group by uid order by id desc limit $start,$pagesize";
$query = mysql_query( $sql ) or die( mysql_error() );
while( $rs = mysql_fetch_array( $query ) )
{
?>
<tr>
<td><a href="/index.php/display/resume/<?=$rs['id']?>.html" class="col-blu" target="_blank"><?=$rs['truename']?></a></td>
<td>
<?
$date = date("Y-m-d");
$date1 = $rs['birth'];
echo sdate($date,$date1);
?> </td>
<td><?= $rs['sex'] ? '男' : '女' ;?></td>
<td><?= $rs['education']?> </td>
<td><?= $rs['experience']?></td>
<td><?= $rs['facejkind']?></td>
</tr>
<?php
}
?>
<tr>
<td colspan="6">
<div class="listPage"><form action="jobs.php?keyword=<?=$keyword?>&city=<?= $city?>" method="get" enctype="application/x-www-form-urlencoded" >總數:<span class="f-red"><?=$count?>/條</span> 每頁<?=$pagesize?>條 當前第<span class="f-red"><?=$page?>/<?=$pagecount?></span>頁 <a href="jobs.php?keyword=<?=$keyword?>&city=<?= $city?>&page=<?=1?>" class="col-blu"> 首頁 </a><a href="jobs.php?keyword=<?=$keyword?>&city=<?= $city?>&page=<?=$page-1;?>" class="col-blu">上一頁 </a><span class="col-blu"> <a href="jobs.php?keyword=<?=$keyword?>&city=<?= $city?>&page=<?=$page+1;?>" class="col-blu">下一頁 </a></span><a href="#" class="col-blu"><a href="jobs.php?keyword=<?=$keyword?>&city=<?= $city?>&page=<?=$count;?>" class="col-blu">尾頁 </a>轉到 第
<input name="page" type="text" id="page" size="3" />
<input name="city" type="hidden" value="<?=$city;?>" />
<input name="keyword" type="hidden" value="<?=$keyword;?>" />
頁
<input type="submit" name="Submit" value="確定" />
</form>
</div>
</div>
</td>
</tr>
<?
}
else
{
?>
<tr>
<td colspan="6">對不起,您要尋找內容暫時不存在!</td>
</tr>
<?php
}
?>
</table>
</div>