问题是这样的
我现在做一个作业，
搜索 client 之后多页显示出搜索结果。
－－－－－－－－－－－－－－－－－－－－－－－－－－－－－－－
以下这些code是成功显示所有client的资料也多页显示成功。最近一直在做搜索searchclient.php 但不成功。
文件叫 showclient.php
复制内容到剪贴板
代码:
<?php
include '../Connections/database.php';
// 设定显示多少rows
$rowsPerPage = 15;
$pageNum = 1;
if(isset($_GET['page'])){$pageNum = $_GET['page'];}
$offset = ($pageNum - 1) * $rowsPerPage;
// sql 结果
$result = mysql_query("SELECT ClientReferral, ClientGivenName, ClientSurname, ClientSuburb, ClientHPhone, ClientEmail, ClientComments, ClientNo FROM Client LIMIT $offset, $rowsPerPage") or die('Error, query failed');
//显示结果
echo "<table width=100% border=1>";
echo "<tr><td>ClientReferral</td> <td>GivenName</td><td>Surname</td><td>Suburb</td><td>Phone(Home)</td><td>Email</td><td>Comments</td><td>Client No</td></tr>";
while(list($ClientReferral, $ClientGivenName, $ClientSurname, $ClientSuburb, $ClientHPhone, $ClientEmail, $ClientComments, $ClientNo) = mysql_fetch_array($result)){
echo "<tr><td>$ClientReferral</td><td><a href='details.php?cid=$ClientNo'>$ClientGivenName</a></td><td>$ClientSurname</td><td>$ClientSuburb</td><td>$ClientHPhone</td><td>$ClientEmail</td><td>$ClientComments</td><td>$ClientNo</td></tr>";
}
echo "</table>";
echo '<br>';
//多少rows找到了
$numrows = mysql_num_rows(mysql_query("SELECT ClientReferral FROM Client"));
$maxPage = ceil($numrows/$rowsPerPage);
//显示first prev next last links
$self = $_SERVER['PHP_SELF'];
if ($pageNum > 1){
$page = $pageNum - 1;
$prev = " <a href=\"$self?page=$page\"><u>Prev</u></a> ";
$first = " <a href=\"$self?page=1\"><u>First</u></a> ";
}
else{
$prev = ' Prev '; // we're on page one, don't enable 'previous' link
$first = ' First '; // nor 'first page' link
}
if ($pageNum < $maxPage){
$page = $pageNum + 1;
$next = " <a href=\"$self?page=$page\"><u>Next</u></a> ";
$last = " <a href=\"$self?page=$maxPage\"><u>Last</u></a> ";
}
else{
$next = ' Next '; // we're on the last page, don't enable 'next' link
$last = ' Last '; // nor 'last page' link
}
?>
//显示links
<table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr><td><?php echo $nav; ?></td>
<td><div align="right"><?php echo "Results ". "<b>".$pageNum."</b>". " - "."<b>".$rowsPerPage."</b>". " of "."<b>".$numrows."</b>"."<br>";?>
</div><div align="right">
<?php echo " Page <b>$pageNum</b> of <b>$maxPage</b>";?></div></td>
</tr>
<tr>
<td colspan="2"><div align="center"><?php echo $first . $prev . $next . $last;?>
</div></td>
</tr>
</table>
[
Last edited by 房间 on 2005-10-6 at 16:33 ]
