留言本php
① 求用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>
<p><textarea rows="9" name="info" cols="35"></textarea></p>
<p><input 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>
<p><a 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])?><p><a 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>
<p><textarea rows="9" name="info" cols="35"><?=$row[3]?></textarea></p>
<p><input 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);
?>
<p><a 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);
?>
<p><a href="show.php">[返回]</a></p>
② 如何用php做出登陸注冊留言板
用php做出登陸注冊留言板:
<form id="form1" name="form1" method="post" action="<?php echo site_url()."/publish/user_message"?>">
<textarea rows="5" cols="50" name="huifu" <?php if($uere_name == "0"){echo "disabled";}?> >
<?php
if($uere_name == "0")
{echo "抱歉你還沒登錄不能進行留言";}
?>
</textarea>
<input class="wole" name="author" value="<?php echo $author;?>" /><!--接受方帖子作者-->
<input class="wole" name="news_id" value="<?php echo $news_idx;?>" /><!--文章id-->
<input type="submit" name="Submit"/>
</form>
<script language="javascript">
function updateinfo(){
if(<?php echo $uere_name;?> == 1){
document.form1.Submit.value = "留言";
document.form1.Submit.disabled = false;
}
else{
document.form1.Submit.value = "還未登錄";
document.form1.Submit.disabled = "disabled";
}
}
updateinfo();
</script>
回復帖子:
<p>這里是<?php echo $is;?>樓 用戶:<?php echo $sel->receiver_author;?> <br />留言內容:<?php echo $sel->content?>
<a onClick="showdiv('contentid<?php echo $is;?>','showtext<?php echo $is;?>')" href="javascript:void(0)">回復</a>
<div id="contentid<?php echo $is;?>" class="none">
<?php
$query = $this->db->query("select * from message where son_id ='$sel->id' order by id");//獲取指定父id的子回復
$revis = $query->result();
foreach($revis as $row){?>
<p><?php if($row->sender_author == $row->receiver_author){echo $row->sender_author;}
else{ echo $row->sender_author."回復了:".$row->receiver_author;}?>
內容是:<?php echo $row->content?></p>
<?php }?>
<form action="<?php echo site_url()."/publish/son_message"?>" method="post">
<input name="son_idx" class="wole" value="<?php echo $sel->id?>" />
<input name="receiver_author" class="wole" value="<?php echo $sel->receiver_author;?>" />
<input class="wole" name="news_id" value="<?php echo $news_idx;?>" /><!--文章id-->
<textarea rows="5" cols="50" name="huifux"></textarea>
<br><input type="submit" name="sub" value="回復"></form></div></p>
<script language="JavaScript" type="text/JavaScript">
<!--
function showdiv(targetid,objN){
var target=document.getElementById(targetid);
var clicktext=document.getElementById(objN)
if (target.style.display=="block"){
target.style.display="none";
clicktext.innerText="回復";
} else {
target.style.display="block";
clicktext.innerText='收起';
}
}
-->
</script>
效果圖:
③ php文件操作之小型留言本實例
本文實例講述了php文件操作之小型留言本。分享給大家供大家參考。具虛態體如下:
Index.php文件如下:
<鉛鋒?php
$path
=
"DB/";
//定義路徑
$dr
=
opendir($path);
//打開目錄
while($filen
=
readdir($dr))
//循環讀取目錄中的文件
{
if($filen
!=
"."
and
$filen
!=
"..")
{
$fs
=
fopen($path.$filen,
"r");
echo
"<B>標題:</B>".fgets($fs)."<BR>";
echo
"<B>作者:</B>".fgets($fs)."<BR>";
echo
"<B>內容:</B><PRE>".fread($fs,
filesize($path.$filen))."</PRE>";
echo
"<HR>";
fclose($fs);
}
}
closedir($dr)
//關閉目錄
?>
Post.php文件如下:
<?php
$path
=
"DB/";
$filename
=
"S".date("YmdHis").".dat";
$fp
=
fopen($path.$filename,
"w");
fwrite($fp,
$_POST["title"]."/n");
fwrite($fp,
$_POST["author"]."/n");
fwrite($fp,
$_POST["content"]."/n");
fclose($fp);
echo
"留言發表成功!";
echo
"<a
href="Index.php"
mce_href="Index.php">返回首頁</a>";
?>
<!DOCTYPE
HTML
PUBLIC
"-//W3C//DTD
HTML
4.01
Transitional//EN"
"http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<title>發表新的留言</title>
<meta
http-equiv="Content-Type"
content="text/html;
charset=gb2312">
</head>
<body>
<H1><p
align="center">發表新的留言</p></H1>
<form
name="form1"
method="post"
action="Post.php">
<table
width="500"
border="0"
align="center"
cellpadding="0"
cellspacing="0">
<tr>
<td>標題</td>
<td><input
name="title"
type="text"
id="title"
size="50"></td>
</槐譽晌tr>
<tr>
<td>作者</td>
<td><input
name="author"
type="text"
id="author"
size="20"></td>
</tr>
<tr>
<td>內容</td>
<td><textarea
name="content"
cols="50"
rows="10"
id="content"></textarea></td>
</tr>
</table>
<p
align="center">
<input
type="submit"
value="Submit">
<input
type="reset"
value="Reset">
</p>
</form>
</body>
</html>
希望本文所述對大家的php程序設計有所幫助。
④ php留言板的回復怎麼做
首先得設計好資料庫,留言一個表,回復一個表,然後把留言表中關鍵字ID關聯到回復表中。
比如:
留言表:message
id
contents
user
time
回復表:reply
id
m_id 關聯留言表中的id
contents
user
time
然後程序方面把對應的留言、回復保存到相應的表中,讀取的時候先遍歷留言表,然後通過留言表id再讀取對應的回復數據。