本文实例为大家分享了php留言板功能的具体代码，供大家参考，具体内容如下
数据库用到的三张表
一.登录界面 （denglu.php login.php）
1.denglu.php
|
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
|
<!doctype html><html><head><meta charset="utf-8"><title></title></head><body><h1>开发部内部留言板</h1><form action="login.php" method="post"><div>用户名：<input type="text" name="username" /></div><div>口令：<input type="password" name="password" /></div><input type="submit" value="登录" /><a href="denglu.php" style="text-decoration:none"><input type="button" value="复位" /></a></form></body></html> |
2.login.php
|
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
|
<?phpsession_start();$username = $_post["username"];$password = $_post["password"];require "dbda.class1.php";$db = new dbda();$sql = "select password from yuangong where username = '{$username}'";$arr = $db->query($sql);if(count($arr)){ if($arr[0][0] == $password && !empty($password)) { //存储用户名 $_session["username"] = $username; header("location:main.php"); }}else{ header("location:denglu.php");} |
二.主界面（main.php tuichu.php）
1.main.php
|
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
|
<!doctype html public "-//w3c//dtd xhtml 1.0 transitional//en" "http://www.w3.org/tr/xhtml1/dtd/xhtml1-transitional.dtd"><html xmlns="http://www.w3.org/1999/xhtml"><head><meta http-equiv="content-type" content="text/html; charset=utf-8" /><title>无标题文档</title></head><body><?phpsession_start(); // 防止绕过登陆直接进入主界面if(empty($_session["username"])){ header("location:denglu.php"); exit;} require "dbda.class1.php";$db = new dbda();$username = $_session["username"];?><div><a href="fabu.php">发布信息</a><a href="tuichu.php">退出系统</a></div><br /><br /><h1>留言信息：</h1><table width="100%" border="1" > <tr> <td>发送人</td> <td>发送时间</td> <td>接收人</td> <td>信息内容</td> </tr> <?php //显示接收者是我的，或者是所有人的 $sql = "select * from liuyan where recever='{$username}' or recever='suoyou'"; $arr = $db->query($sql); foreach($arr as $v) { echo "<tr> <td>{$v[1]}</td> <td>{$v[3]}</td> <td>{$v[2]}</td> <td>{$v[4]}</td> </tr>"; } ?> </table></body></html> |
2.tuichu.php
|
1
2
3
4
|
<?phpsession_start();unset($_session["username"]);header("location:denglu.php"); |
三.发送页面（fabu.php fabuchuli.php）
1.fabu.php
|
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
|
<!doctype html public "-//w3c//dtd xhtml 1.0 transitional//en" "http://www.w3.org/tr/xhtml1/dtd/xhtml1-transitional.dtd"><html xmlns="http://www.w3.org/1999/xhtml"><head><meta http-equiv="content-type" content="text/html; charset=utf-8" /><title>无标题文档</title></head><body><div><a href="main.php">查看信息</a><a href="tuichu.php">退出系统</a></div><h1>信息发送：</h1><form action="fabuchuli.php" method="post"><div>接收人：<select name="jsr"> <option value="suoyou">所有人</option> <?php session_start(); $username = $_session["username"]; require"dbda.class1.php"; $db = new dbda(); //方法一 $sql = "select friend.friend,yuangong.name from friend,yuangong where friend.friend = yuangong.username and friend.me = '{$username}'"; $arr = $db->query($sql); foreach($arr as $v) { echo "<option value='{$v[0]}'>{$v[1]}</option>"; } //方法二 /*$sql = "select friend from friend where me ='{$username}'"; $arr = $db->query($sql); foreach($arr as $v) { $v[0]; $sname = "select name from yuangong where username = '{$v[0]}'"; $aname = $db->query($sname); echo"<option value='{$v[0]}'>{$aname[0][0]}</option>"; }*/ ?> </select></div><div>信息内容：<textarea name="neirong"></textarea></div><input type="submit" value="发送" /><a href="fabu.php" style="text-decoration:none"><input type="button" value="复位" /></a></form></body></html> |
2.fabuchuli.php
|
1
2
3
4
5
6
7
8
9
10
11
12
13
|
<?phpsession_start();$username = $_session["username"];$jsr = $_post["jsr"];$nr = $_post["neirong"];$times = date("y-m-d h:i:s");require"dbda.class.php";$db = new dbda();$sql = "insert into liuyan values('','{$username}','{$jsr}','{$times}','{$nr}')";$db->query($sql,0);header("location:fabu.php"); |
以上就是本文的全部内容，希望对大家的学习有所帮助，也希望大家多多支持服务器之家。
