这是我要创建留言板的,不知道怎么让它分页显示留言记录,每页显示五行留言,请会的师傅们帮帮忙,谢谢了
<?php
/*
* Created on 2011-3-21
*
* To change the template for this generated file go to
* Window - Preferences - PHPeclipse - PHP - Code Templates
*/
include("conn.php");
echo "留言板"; echo "<hr>"; $page_size = 5;//每页显示5行留言 $sql = "select * from my_lyb"; // 从表中提取信息的sql语句 mysql_query("set names 'gb2312'"); //乱码修改 $result = mysql_query($sql,$conn); // 执行sql查询 echo "<table>"; while($row = mysql_fetch_array($result) and $page_size>0){ // 获取查询结果和$page_size>0同时成立时 echo "<tr>"; echo "<td>".(6-$page_size)."、留言姓名:".$row[0]."</td><td>留言标题:".$row[1]."</td><td>留言时间:".$row[3]."</td>"; echo "</tr><tr><td>留言内容:".$row[2]."</td></tr>"; echo "</tr>"; $page_size--; //6-$page_size 就会增加,就有列表序号
}
echo "</table>";?><hr><form action="lyb_do.php" method="post">
留言姓名:<input type="text" name="na"><br> 留言标题:<input type="text" name="title"><br> 留言内容:<br> <?php include("fhedit/fckeditor.php");//FCKeditor已存放在此目录下
$oEditor = new FCKeditor ("content"); //对应于一个input控件,相当于是一个name=content的textarea
$oEditor -> BasePath = 'fhedit/'; //配置基本信息
$oEditor -> Width = '50%';
$oEditor -> Height = '200';
$oEditor -> ToolbarSet = 'mini';
$oEditor -> Value = $list['content']; //若是修改文章,则将原文章内容放进编辑部
$oEditor -> Create(); //创建编辑器 ?> <input type="submit" value="我写好了"></form>
<?php
/*
* Created on 2011-3-21
*
* To change the template for this generated file go to
* Window - Preferences - PHPeclipse - PHP - Code Templates
*/
include("conn.php");
echo "留言板"; echo "<hr>"; $page_size = 5;//每页显示5行留言 $sql = "select * from my_lyb"; // 从表中提取信息的sql语句 mysql_query("set names 'gb2312'"); //乱码修改 $result = mysql_query($sql,$conn); // 执行sql查询 echo "<table>"; while($row = mysql_fetch_array($result) and $page_size>0){ // 获取查询结果和$page_size>0同时成立时 echo "<tr>"; echo "<td>".(6-$page_size)."、留言姓名:".$row[0]."</td><td>留言标题:".$row[1]."</td><td>留言时间:".$row[3]."</td>"; echo "</tr><tr><td>留言内容:".$row[2]."</td></tr>"; echo "</tr>"; $page_size--; //6-$page_size 就会增加,就有列表序号
}
echo "</table>";?><hr><form action="lyb_do.php" method="post">
留言姓名:<input type="text" name="na"><br> 留言标题:<input type="text" name="title"><br> 留言内容:<br> <?php include("fhedit/fckeditor.php");//FCKeditor已存放在此目录下
$oEditor = new FCKeditor ("content"); //对应于一个input控件,相当于是一个name=content的textarea
$oEditor -> BasePath = 'fhedit/'; //配置基本信息
$oEditor -> Width = '50%';
$oEditor -> Height = '200';
$oEditor -> ToolbarSet = 'mini';
$oEditor -> Value = $list['content']; //若是修改文章,则将原文章内容放进编辑部
$oEditor -> Create(); //创建编辑器 ?> <input type="submit" value="我写好了"></form>
$query = mysql_query("select * from my_lyb");
$maxclou = mysql_num_rows($query);
算出总页数,
$maxpage = ceil($maxclou/5);用get方法获得当前页(如果为空,默认第一页),算出上页 下一页
提供一个SQL语句:
select top 5 * from table where Tid not in
(select top [count] * from table order by updateTime)
order by updateTime其中:count=当前页数*5
<?php
class Page {
private $total; //数据表中总记录数
private $listRows; //每页显示行数
private $limit;
private $uri;
private $pageNum; //页数
private $config=array('header'=>"个记录", "prev"=>"上一页", "next"=>"下一页", "first"=>"首 页", "last"=>"尾 页");
private $listNum=8;
/*
* $total
* $listRows
*/
public function __construct($total, $listRows=10, $pa=""){
$this->total=$total;
$this->listRows=$listRows;
$this->uri=$this->getUri($pa);
$this->page=!empty($_GET["page"]) ? $_GET["page"] : 1;
$this->pageNum=ceil($this->total/$this->listRows);
$this->limit=$this->setLimit();
} private function setLimit(){
return "Limit ".($this->page-1)*$this->listRows.", {$this->listRows}";
} private function getUri($pa){
$url=$_SERVER["REQUEST_URI"].(strpos($_SERVER["REQUEST_URI"], '?')?'':"?").$pa;
$parse=parse_url($url); if(isset($parse["query"])){
parse_str($parse['query'],$params);
unset($params["page"]);
$url=$parse['path'].'?'.http_build_query($params);
} return $url;
} private function __get($args){
if($args=="limit")
return $this->limit;
else
return null;
} private function start(){
if($this->total==0)
return 0;
else
return ($this->page-1)*$this->listRows+1;
} private function end(){
return min($this->page*$this->listRows,$this->total);
} private function first(){
if($this->page==1)
$html.='';
else
$html.=" <a href='javascript:setPage(\"{$this->uri}&page=1\")'>{$this->config["first"]}</a> "; return $html;
} private function prev(){
if($this->page==1)
$html.='';
else
$html.=" <a href='javascript:setPage(\"{$this->uri}&page=".($this->page-1)."\")'>{$this->config["prev"]}</a> "; return $html;
} private function pageList(){
$linkPage="";
$inum=floor($this->listNum/2);
for($i=$inum; $i>=1; $i--){
$page=$this->page-$i; if($page<1)
continue; $linkPage.=" <a href='javascript:setPage(\"{$this->uri}&page={$page}\")'>{$page}</a> "; }
$linkPage.=" {$this->page} ";
for($i=1; $i<=$inum; $i++){
$page=$this->page+$i;
if($page<=$this->pageNum)
$linkPage.=" <a href='javascript:setPage(\"{$this->uri}&page={$page}\")'>{$page}</a> ";
else
break;
} return $linkPage;
} private function next(){
if($this->page==$this->pageNum)
$html.='';
else
$html.=" <a href='javascript:setPage(\"{$this->uri}&page=".($this->page+1)."\")'>{$this->config["next"]}</a> "; return $html;
} private function last(){
if($this->page==$this->pageNum)
$html.='';
else
$html.=" <a href='javascript:setPage(\"{$this->uri}&page=".($this->pageNum)."\")'>{$this->config["last"]}</a> "; return $html;
} private function goPage(){
return ' <input type="text" onkeydown="javascript:if(event.keyCode==13){var page=(this.value>'.$this->pageNum.')?'.$this->pageNum.':this.value;setPage(\''.$this->uri.'&page=\'+page+\'\')}" value="'.$this->page.'" style="width:25px"><input type="button" value="GO" onclick="javascript:var page=(this.previousSibling.value>'.$this->pageNum.')?'.$this->pageNum.':this.previousSibling.value;setPage(\''.$this->uri.'&page=\'+page+\'\')"> ';
}
function fpage($display=array(0,1,2,3,4,5,6,7,8)){
$html[0]=" 共有<b>{$this->total}</b>{$this->config["header"]} ";
$html[1]=" 每页显示<b>".($this->end()-$this->start()+1)."</b>条,本页<b>{$this->start()}-{$this->end()}</b>条 ";
$html[2]=" <b>{$this->page}/{$this->pageNum}</b>页 ";
$html[3]=$this->first();
$html[4]=$this->prev();
$html[5]=$this->pageList();
$html[6]=$this->next();
$html[7]=$this->last();
$html[8]=$this->goPage();
$fpage='';
foreach($display as $index){
$fpage.=$html[$index];
} return $fpage; }
}
告诉你一个可以下载的地方,
http://bbs.php100.com/read-htm-tid-58295-keyword-%B7%D6%D2%B3.html希望对你有所帮助
$strSQL="select count(*) from tablename";
$result=mysql_query($strSQL);
while($row=-mysql_fetch_arry($result)){
echo '记录数'.$row[0];
}