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"); //设置编码
$page=isset($_GET['page']) ?$_GET['page'] :1 ;//接收页码
$page=!empty($page) ? $page :1;
$F=$_GET['F'];
// 创建连接
$conn = mysqli_connect("localhost", "root", "root", "mybbs");
mysqli_set_charset($conn,'utf8'); //设定字符集
$table_name="tiopic";//查取表名设置
$perpage=5;//每页显示的数据个数
//最大页数和总记录数
$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];//获取最大页码数
$total_page = ceil($total/$perpage);//向上整数
//临界点
$page=$page>$total_page ? $total_page:$page;//当下一页数大于最大页数时的情况
//分页设置初始化
$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">发布新帖</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
new file
<?php
session_start();
header("Content-type:text/html;charset=utf-8"); //设置编码
$page=isset($_GET['page']) ?$_GET['page'] :1 ;//接收页码
$page=!empty($page) ? $page :1;
$F=$_GET['F'];
// 创建连接
$conn = mysqli_connect("localhost", "root", "root", "mybbs");
mysqli_set_charset($conn,'utf8'); //设定字符集
$table_name="tiopic";//查取表名设置
$perpage=5;//每页显示的数据个数
//最大页数和总记录数
$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];//获取最大页码数
$total_page = ceil($total/$perpage);//向上整数
//临界点
$page=$page>$total_page ? $total_page:$page;//当下一页数大于最大页数时的情况
//分页设置初始化
$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">发布新帖</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>
Preview
Clear
- Course Recommendations
- Courseware download
![Getting Started with PHP Practical Development: PHP Quick Creation [Small Business Forum]](https://img.php.cn/upload/course/000/000/035/5d27fb58823dc974.jpg)
The courseware is not available for download at the moment. The staff is currently organizing it. Please pay more attention to this course in the future~
Students who have watched this course are also learning
Let's briefly talk about starting a business in PHP
Quick introduction to web front-end development
Large-scale practical Tianlongbabu development of Mini version MVC framework imitating the encyclopedia website of embarrassing things
Getting Started with PHP Practical Development: PHP Quick Creation [Small Business Forum]
Login verification and classic message board
Computer network knowledge collection
Quick Start Node.JS Full Version
The front-end course that understands you best: HTML5/CSS3/ES6/NPM/Vue/...[Original]
Write your own PHP MVC framework (40 chapters in depth/big details/must read for newbies to advance)