本文目錄一覽:
怎樣用PHP寫一個簡單的論壇詳解
資料庫的創建
CREATE DATABASE GBOOK;
CREATE TABLE `gbook` (
`id` INT( 255 ) UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY ,
`name` VARCHAR( 10 ) NOT NULL ,
`sex` TINYINT( 1 ) UNSIGNED NOT NULL ,
`email` VARCHAR( 255 ) NOT NULL ,
`info` TEXT NOT NULL ,
`ip` VARCHAR( 15 ) NOT NULL ,
`time_at` DATETIME NOT NULL
)
主要頁面有:
input.html為初始頁
insert.php為把輸入內容送入資料庫
show.php顯示留言板內容
change.php修改留言板內容的界面
del.php刪除留言板內容
change_ok.php修改留言板內容並送入資料庫
input.html
html
head
meta http-equiv=”content-type” content=”text/html; charset=GB2312″ /
title留言版/title
/head
body
form name=”form1″ method=”post” action=”insert.php”
p你的名字:input type=”text” name=”name” size=”20″ //p
p你的性別:input type=”radio” value=”1″ name=”sex” checked=”checked” /男生 input type=”radio” value=”0″ name=”sex” /女生 /p
p你的E-mail:input type=”text” name=”email” size=”20″ //p
p你的留言內容:/p
ptextarea rows=”9″ name=”info” cols=”35″/textarea/p
pinput type=”submit” value=”提交” name=”B1″ /input type=”reset” value=”重設” name=”B2″ //p
/form
/body
/html
insert.php
?php
$mysql_server_name = “localhost”;
$mysql_username = “root”;
$mysql_password = “123456”;
$mysql_database = “gbook”;
$ip = getenv(‘REMOTE_ADDR’);
$conn = mysql_connect(“localhost”,”root”,”123456″);
mysql_select_db(“gbook”);
$sql = “INSERT INTO `gbook` ( `id` , `name` , `sex` , `email` , `info` , `ip` , `time_at` )
VALUES (NULL , ‘$name’, ‘$sex’, ‘$email’, ‘$info’, ‘$ip’, NOW( ))”;
$result = mysql_query($sql,$conn);
$id = mysql_insert_id();
mysql_close($conn);
?
p留言成功/p
pa href=”show.php”去留言頁 /a/p
show.php
?
$mysql_server_name = “localhost”;
$mysql_username = “root”;
$mysql_password = “123456”;
$mysql_database = “gbook”;
$sql = “SELECT * FROM gbook ORDER BY ‘id’ DESC”; //排序 後留言的在前面顯示
$conn = mysql_connect($mysql_server_name,$mysql_username,$mysql_password);
mysql_select_db($mysql_database,$conn);
$result = mysql_query($sql);
while($row = mysql_fetch_row($result))
{ // —-if語句判斷男女——
if($row[2]==1)
{ $gender = ‘男’;}
else
{ $gender = ‘女’; }
?
table width=”752″ border=”1″
tr
td height=”32″p?=$row[6]? ?=$row[5]? /p
p?=$row[1]?(?=$gender?) ?=$row[3]?/p/td
/tr
tr
td height=”45″?=nl2br($row[4])?pa href=”change.php?id=?=$row[0]?”[修改]/a a href=”del.php?id=?=$row[0]?”[刪除]/a/p/td
/tr
/table
hr /
?
}
mysql_free_result($result);
?
change.php
?
$mysql_server_name = “localhost”;
$mysql_username = “root”;
$mysql_password = “123456”;
$mysql_database = “gbook”;
$sql = “SELECT name, sex, email, info FROM gbook WHERE id = ‘$id’ “;
$conn = mysql_connect($mysql_server_name,$mysql_username,$mysql_password);
mysql_select_db($mysql_database,$conn);
$result = mysql_query($sql);
$row = mysql_fetch_row($result);
?
html
head
meta http-equiv=”content-type” content=”text/html; charset=GB2312″ /
title留言版/title
/head
body
form name=”form1″ method=”post” action=”change_ok.php?id?=$id?”
p你的名字:input type=”text” name=”name” size=”20″ value=”?=$row[0]?”//p
?
// —–if語句判斷男女 1為男 0為女——-
if($row[1]==1)
echo ‘ p你的性別:input type=”radio” value=”1″ name=”sex” checked=”checked” /男 input type=”radio” value=”0″ name=”sex” /女 /p’;
else
echo ‘ p你的性別:input type=”radio” value=”1″ name=”sex” /男 input type=”radio” value=”0″ name=”sex” checked=”checked” /女 /p’;
?
p你的E-mail:input type=”text” name=”email” size=”20″ value=”?=$row[2]?”//p
p你的留言內容:/p
ptextarea rows=”9″ name=”info” cols=”35″?=$row[3]?/textarea/p
pinput type=”submit” value=”提交” /input type=”reset” value=”重設” //p
/form
/body
/html
del.php
?
$mysql_server_name = “localhost”;
$mysql_username = “root”;
$mysql_password = “123456”;
$mysql_database = “gbook”;
$sql = “DELETE FROM gbook WHERE id = ‘$id’ “;
$conn = mysql_connect($mysql_server_name,$mysql_username,$mysql_password);
mysql_select_db($mysql_database,$conn);
$result = mysql_query($sql);
mysql_close($conn);
?
pa href=”show.php”[返回]/a/p
change_ok.php
?
$mysql_server_name = “localhost”;
$mysql_username = “root”;
$mysql_password = “123456”;
$mysql_database = “gbook”;
$sql = “UPDATE `gbook` SET `name` = ‘$name’,`sex` = ‘$sex’,`email` = ‘$email’,`info` = ‘$info’ WHERE `id` =’$id’ “;
$conn = mysql_connect($mysql_server_name,$mysql_username,$mysql_password);
mysql_select_db($mysql_database,$conn);
$result = mysql_query($sql);
mysql_close($conn);
?
pa href=”show.php”[返回]/a/p
關於PHP開發論壇詳細流程應怎樣設計?
首先論壇的主要特徵就是交互性,也就是話題都是用戶產生的,用戶圍繞著一個話題進行蓋樓評論,這是論壇的基本邏輯。
那麼如何設計開發一個論壇,流程如下:
1設計資料庫,分析需要哪些表,比如用戶表,帖子表,評論表,區塊表等等。
2選擇採用什麼框架進行開發,比如thinkphp還是laravel等。
3寫需求分析,做原型圖,確定需要哪些頁面。
4後台根據功能,開發各個功能模塊。
5前端根據設計圖做頁面。
6前後端整合
7測試
8發布代碼
怎麼建php論壇
就是 discuz了,ucenter+discuz
首先要配置php環境
然後下載ucenter ,discuz
先安裝ucenter 然後在用ucenter安裝discuz 就可以了
原創文章,作者:WLFX,如若轉載,請註明出處:https://www.506064.com/zh-tw/n/132418.html