PHP development small forum tutorial forum details
Click to enter a forum from our homepage, and you can see all the posts posted in this forum
## This page mainly transfers data from our "tiopic" table, and then creates a paging. The code is as follows
<?php
session_start();
header("Content-type:text/html;charset=utf-8"); //設(shè)置編碼
$page=isset($_GET['page']) ?$_GET['page'] :1 ;//接收頁碼
$page=!empty($page) ? $page :1;
$F=$_GET['F'];
// 創(chuàng)建連接
$conn = mysqli_connect("localhost", "root", "root", "mybbs");
mysqli_set_charset($conn,'utf8'); //設(shè)定字符集
$table_name="tiopic";//查取表名設(shè)置
$perpage=5;//每頁顯示的數(shù)據(jù)個數(shù)
//最大頁數(shù)和總記錄數(shù)
$total_sql="select count(*) from $table_name";
$total_result =mysqli_query($conn,$total_sql);
$total_row=mysqli_fetch_row($total_result);
$total = $total_row[0];//獲取最大頁碼數(shù)
$total_page = ceil($total/$perpage);//向上整數(shù)
//臨界點
$page=$page>$total_page ? $total_page:$page;//當下一頁數(shù)大于最大頁數(shù)時的情況
//分頁設(shè)置初始化
$start=($page-1)*$perpage;
$sql="select * from tiopic order by id desc limit $start ,$perpage";
$que=mysqli_query($conn,$sql);
$sum=mysqli_num_rows($que);
?>
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="UTF-8">
<title>帖子</title>
<style>
.cen{
border: none;
width: 600px;
margin: 0 auto;
height: 40px;
background-color: rgba(34, 35, 62, 0.08);
}
.left{
width: 535px;
float: left;
}
.right{
width: 65px;
height: 30px;
background-color:#B10707 ;
float: left;
margin-top: 8px;
}
.title{
background-color: #B10707;
color: white;
}
.list{
margin-left: 12px;
}
</style>
</head>
<body>
<div class="cen">
<div class="left">
<?php
$sql1="select forum_name from forums where id='$F'";
$squ1=mysqli_query($conn,$sql1);
$row=mysqli_fetch_array($squ1);
$forum_name=$row['forum_name'];
echo "當前論壇為：<a href=\"index.php\">$gb_name</a>-->>$forum_name";
?>
</div>
<div class="right"><a style="color: white" href="addnew.php">發(fā)布新帖</a> </div>
</div>
<table width="600px" border="1" cellpadding="8" cellspacing="0" align="center">
<tr class="title">
<td colspan="3">帖子列表 <span class="list">[<a style="color: white" href="index.php">返回</a> ]</span></td>
</tr>
<tr>
<td width="280px">主題列表</td>
<td width="160px" >作者</td>
<td width="160px">最后更新</td>
</tr>
<?php
if($sum>0) {
while($row=mysqli_fetch_array($que)) {
?>
<tr>
<td width="280px"><div><a href="thread.php?id=<?php echo $row['id']?>"</a><?php echo $row['title']?></div> </td>
<td width="160px"><?php echo $row['author'] ?></td>
<td width="160px"><?php echo $row['last_post_time']?></td>
</tr>
<tr>
<td colspan="3">
<?php }
}
else{
echo "<tr><td colspan='5'>本版塊沒有帖子.....</td></tr>";
} ?>
</td>
</tr>
<tr>
<td colspan="5">
<div id="baner" style="margin-top: 20px">
<a href="<?php
echo "$_SERVER[PHP_SELF]?page=1"
?>">首頁</a>
<a href="<?php
echo "$_SERVER[PHP_SELF]?page=".($page-1)
?>">上一頁</a>
<!-- 顯示123456等頁碼按鈕-->
<?php
for($i=1;$i<=$total_page;$i++){
if($i==$page){//當前頁為顯示頁時加背景顏色
echo "<a style='padding: 5px 5px;background: #000;color: #FFF' href='$_SERVER[PHP_SELF]?page=$i'>$i</a>";
}else{
echo "<a style='padding: 5px 5px' href='$_SERVER[PHP_SELF]?page=$i'>$i</a>";
}
}
?>
<a href="<?php
echo "$_SERVER[PHP_SELF]?page=".($page+1)
?>">下一頁</a>
<a href="<?php
echo "$_SERVER[PHP_SELF]?page={$total_page}"
?>">末頁</a>
<span>共<?php echo $total?>條</span>
</div>
</td>
</tr>
</table>
</body>
</html>In order to make the page beautiful, we have made CSS styles and layoutsWe are now' tiopic 'There is no data in the table, so it will display 'There are no posts in this section...'We have made a link to publish new posts, and now we will make a page to add posts
![Getting Started with PHP Practical Development: PHP Quick Creation [Small Business Forum]](https://img.php.cn/upload/course/000/000/035/5d27fb58823dc974.jpg)
