Display function of news management system developed with PHP
As mentioned in the previous section, after we complete the addition, we jump to the display page. Let’s look at the html code of the following display page:
<!DOCTYPE html>
<html>
<heah>
<meta charset="utf-8">
<title></title>
<style type="text/css">
table{width:400px;}
th{height:25px;}
td{text-align:center;height:45px;}
</style>
</heah>
<bohy>
<table cellpadding="0" cellspacing="0" border="1">
<tr>
<th>ID</th>
<th>標(biāo)題</th>
<th>內(nèi)容</th>
<th>時(shí)間</th>
<th>操作</th>
</tr>
<tr>
<td>1</td>
<td>明天過(guò)后</td>
<td>大家好</td>
<td>15-6-28</td>
<td>
<a href="modifynew.php">修改</a>
<a href="delnew.php">刪除</a>
</td>
</tr>
<tr>
<td colspan="5">
<a href="">首頁(yè)</a>
<a href="">上一頁(yè)</a>
<a href="">下一頁(yè)</a>
<a href="">末頁(yè)</a>
</td>
</tr>
</table>
</bohy>
</html>First of all, we also connect to the database
header(" Content-type: text/html; charset=utf-8");//Set encoding
$con =@mysql_connect("localhost","root","root") or die("Database connection failed") ;
mysql_select_db('news') or die("The specified database cannot be opened");
mysql_query("set names utf8");//Set the character set of the database
Then we Take out the data and do paging
//Paging function
$page = isset($_GET['page'])?intval($_GET['page']):1;//Set the current page number, if not set to 1
$num=1;//
$sql="select * from new";
$result=mysql_query($sql);
$total=mysql_num_rows( $result);//Query the total number of data
$pagenum=ceil($total/$num);//Get the total number of pages
//If the incoming page parameter apge is greater than the total number of pages pagenum, the error message is displayed
if($page>$pagenum || $page == 0){
echo "<script>alert('No more content');history.go(-1) ;</script>";
exit;
}
$offset=($page-1)*$num;
/* Get the value offset of the first parameter of limit, if The first page is (1-1)*10=0, and the second page is (2-1)*10=10. (Number of pages passed in - 1) * The data of each page gets the value of the first parameter of limit */
$sql="select * from new order by id desc limit $offset,$num ";
$info=mysql_query($sql); //Get the data to be displayed for the corresponding page number
if($info && mysql_num_rows($info)){
while($row=mysql_fetch_assoc($info)){
?????????? $data[]=$row;
???????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????##
<table cellpadding="0" cellspacing="0" border="1">
?? ??? ?<tr>
?? ??? ??? ?<th>ID</th>
?? ??? ??? ?<th>標(biāo)題</th>
?? ??? ??? ?<th>內(nèi)容</th>
?? ??? ??? ?<th>時(shí)間</th>
?? ??? ??? ?<th>操作</th>
?? ??? ?</tr>
?? ??? ?<?php
?? ??? ??? ??? ?if(!empty($data)){
?? ??? ??? ??? ??? ?foreach($data as $row){
?? ??? ??>
?? ??? ?<tr>
?? ??? ??? ?<td><?php echo $row['id'];?></td>
?? ??? ??? ?<td><?php echo $row['title'];?></td>
?? ??? ??? ?<td><?php echo $row['content'];?></td>
?? ??? ??? ?<td><?php echo date('y-m-d',$row['messtime']);?></td>
?? ??? ??? ?<td>
?? ??? ??? ??? ?<a href="modifynew.php?id=<?php echo $row['id'];?>">修改</a>
?? ??? ??? ??? ?<a href="delnew.php?id=<?php echo $row['id'];?>">刪除</a>
?? ??? ??? ?</td>
?? ??? ?</tr>
?? ??? ?<?php
?? ??? ??? ??? ?}
?? ??? ??? ?}
?? ??? ??? ?$first=1;
?? ??? ??? ?$prev=$page-1;
?? ??? ??? ?$next=$page+1;
?? ??? ??? ?$last=$pagenum;
?? ??? ??>
<tr>
? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? using : page=<?php echo $next ?>">Next page</a>
??????????????????????????????????????????????????????????????????????????????????????????????????????????;Last page</a>
;
##
