编程开发 > PHP > 文章内容

PHP教程:php实现留言板功能(会话控制)

2017-9-16编辑:daibenhua

  本文实例为大家分享了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
<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
session_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
http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>无标题文档title>
head>
 
<body>
php
session_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
session_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
http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<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
session_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");

  以上就是本文的全部内容,希望对大家的学习有所帮助

PHP教程:php实现文件预览功能

热点推荐

登录注册
触屏版电脑版网站地图