<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>无标题文档</title>
</head>
<body><?php
require_once("includes/init.php");
require_once("includes/connectdb.php");
//$sql='select * from news';
//$result=mysql_query($sql);
//$result=mysql_query($selectSQL);
//$row=mysql_fetch_assoc($result);
//mysql_data_seek($result,0);
/*echo "<hr>";
while($row = mysql_fetch_array($result) )
{
echo $row['ntitle']."<br>";
echo $row['ncontent']."<br>";
echo $row['ndate']."<br>";
echo "<hr>";
}
*/
if( isset($_GET['page']) ){
$page = intval( $_GET['page'] );
}
else{
$page =1;
}
// 每页数量
$page_size= 3;
// 获取总数据量
$sql = "select count(*) as amount from news";
$result = mysql_query($sql);
$row = mysql_fetch_array($result);
$amount = $row['amount'];
//echo $amount;
// 记算总共有多少页
if($amount){
if($amount<$page_size){$page_count=1;}
if($amount%$page_size){
$page_count = (int)($amount / $page_size) + 1; }
else{$page_count = $amount / $page_size;}
}
else{
$page_count = 0;
}
// 翻页链接
$page_string ='';
if( $page == 1 ){
$page_string .= '第一页|上一页|';
}
else{
$page_string .= '<a href=?page=1>第一页</a>|<a href=?page='.($page-1).'>上一页</a>|';
}
if( ($page == $page_count) || ($page_count == 0) ){
$page_string .= '下一页|尾页';
}
else{
$page_string .= '<a href=?page='.($page+1).'>下一页</a>|<a href=?page='.$page_count.'>尾页</a>';
}
echo $page_string;
// 获取数据,以二维数组格式返回结果
if($amount){
$sql = "select * from news order by nid desc limit ". ($page-1)*$page_size .", $page_size";
//$sql = "select * from news";
//echo $amount;
$result = mysql_query($sql);
//while($row = mysql_fetch_row($result)){
//$rowset[] = $row;}
while($row = mysql_fetch_array($result))
{ echo "<br>";
echo $row['ntitle']."<br>";
echo $row['ncontent']."<br>";
echo $row['ndate']."<br>";
//$rowset[] =$row;
echo "<hr>";
}}
else{$rowset = array();}
?>
<?php
mysql_close($con);
?>
</body>
</html>
loading