新闻列表显示(List.php)
显示详细的新闻内容(View.php)
添加新闻(news_add.html news_add.php)
//connect.php连接到数据库
$db_host='localhost';
$db_user='root';
$db_pass='';
$conn=mysql_connect($db_host,$db_user,$db_pass)or die(mysql_error()."failed to connect to database!"); //连接数据库;
$db=mysql_select_db('news1',$conn);
?>
//List.php
include "connect.php";
$page=$_GET["page"]+0;
$page=$page<=0?1:$page;
$page_size=10;
$query="SELECT id from news";
$result=mysql_query($query,$conn);
$total_records=mysql_num_rows($result);
$total_page=ceil($total_records/$page_size);
$page=$page>$total_page?$total_page:$page;
$offset=($page-1)*$page_size;
$query="SELECT * from news ORDER by id desc Limit $offset,$page_size";//第一个参数指定第一个返回记录行的偏移量,第二个参数指定返回记录行的最大数目
$result=mysql_query($query,$conn);
while($row=mysql_fetch_array($result)){
echo "
";
echo "
"; echo "".$row["title"].""; echo " | ";"; echo "[".$row["author"]."]"; echo " | ";"; echo "[".$row["date"]."]"; echo " | ";"; echo "修改信息"; echo " | ";
$prev_page=$page-1;
$next_page=$page+1;
if ($page<=1){
echo "首页|";
}
else{
echo "首页|";
}
if($prev_page<1){
echo "上一页|";
}
else{
echo "上一页|";
}
if ($next_page>$total_page){
echo "下一页|";
}
else{
echo "a href=$_SERVER[PHP_SELF]?page=$next_page>下一页|";
}
if ($page>=$$total_page){
echo "最后一页
\n";}
else{
echo "最后一页";
}
?>