<?php
$tempquery = mysql_query ("Select Dpb,facejtype from zgy_member_p_d_basic where DPB = ' $city ' and facejtype like '% $k eyword% ' ");
$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% of ' 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");
$date 1 = $rs [' Birth '];
Echo sdate ($date, $date 1);
?> </td>
<td><?= $rs [' Sex ']? ' Male ': ' Female '; ></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" > Total: <span class= "f-red" ><?= $count? >/Strip < /SPAN> <?= $pagesize?> per page The current <span class= "f-red" ><?= $page >/<?= $pagecount? ></span > Page <a href= "jobs.php?keyword=<?= $keyword? >&city=<?= $city?>&page=<?=1?>" class= " Col-blu "> Home </a><a href=" jobs.php?keyword=<?= $keyword >&city=<?= $city? >&page= <?= $page-1;? > "class=" Col-blu "> Previous </a><span class=" Col-blu "> <a href=" jobs.php?keyword=<?= $keyword? >&city=<?= $city >&page=<?= $page +1;? > "class=" Col-blu > Next </a></span><a href= "#" class= "Col-blu" ><a href= "jobs.php?keyword=" <?= $keyword >&city=<?= $city >&page=<?= $count; > "class=" Col-blu "> last page </a> goto
<input name= "page" type= "text" id= "page" size= "3"/>
<input name= "City" type= "hidden" value= "<?= $city;? > "/>
<input name= "keyword" type= hidden "value=" <?= $keyword;? > "/>
Page
<input type= "Submit" name= "Submit" value= "OK"/>
</form>
</div>
</div>
</td>
</tr>
?
}
Else
{
?>
<tr>
<TD colspan= "6" > Sorry, you want to find content temporarily does not exist!</td>
</tr>
<?php
}
?>
</table>
</div>