How to easily create a message board using php

php implements message board function

This small message board function is suitable for discussions, conversations and messages within the class or within the company. It is very convenient, and more importantly, it does not require a network. It is suitable for company management. It is very common for layers.

The following is how to write this message board:

1 First is the login page:

 1 <form action="chuli.php" method="post"> 
 2     <p style="margin-left: 500px; margin-top: 200px; 
 3      height: 250px; width: 250px">/*为了把登录表放到页面中间，比较美观*/ 
 4         <h1 id="公司内部留言板">公司内部留言板</h1> 
 5     <p style="margin-top: 20px">用户名：<input type="text" name="username"/></p><br/> 
 6     <p>密   码：<input type="password" name="password"/></p><br/> 
 7     <p><input type="submit" value="登录"/></p> 
 8     </p> 
 9 </form>

2 After completing the login page, you need to log in. The page is processed, that is, the chuli.php

 1 <?php 
 2 session_start(); // 登录之后要把所包含登录的页面连接起来，开启session 
 3 include("DADB.class.php"); 
 4 
 5 $db=new DADB(); 
 6 
 7 $user=$_POST["username"]; 
 8 $pwd=$_POST["password"]; 
 9 
10 $sql="select password from yuangong where username=&#39;{$user}&#39;";
11 
12 $arr=$db->Query($sql);
13 
14 if($arr[0][0]==$pwd && !empty($pwd))
15 {
16     $_SESSION["username"]=$user;
17     header("location:main.php");
18 }
19 else
20 {
21     echo"登录失败";
22 }
23 
24 ?>

submitted above is shown in the figure, which is the login page

3. After the login is completed, the main page is entered, which is displayed The conversation content I received, the following is the designed database table and the code of the main page:

<br/>

发布信息       
    退出系统
 

<br/><br/>
留言信息：

Query($sql);    
    foreach($arr as $v)
    {   
    $fjr=uname($v[1]);        
    $jsr=uname($v[2]);        
    echo" //发送人和接收人要用到姓名，所以这里我们调用了一个方法
        ";
    }    
    function uname($user)   //运用了uname方法    
    {        
    global $db;      //要想方法里面也可以用$db 这里用了全局变量        
    if($user=="all")
       {        
       return "所有人";
       }else
    {        
    $sql1="select name from yuangong where username='{$user}'";        
    $att=$db->Query($sql1);        
    return $att[0][0];}
    }
    ?>

    

        
发送人
        
接收人
        
发送时间
        
信息内容
    
    

        
{$fjr}
{$jsr}
        
{$v[3]}
        
{$v[4]}
    

4 After writing the code here, the more important part is completed. The next step is to enter the release information page, which is equivalent to writing before The processing page of the added page is no different from the previous one. The difference is that the current processing page is operated when the user is logged in. You need to use session to connect all the login pages.

 1 <h1 id="发布信息">发布信息</h1> 
 2 <a href="main.php">主页面</a> 
 3 <br /> 
 4 <br /> 
 5 
 6 <?php 
 7 session_start(); 
 8 if(empty($_SESSION["username"])) 
 9 {
 10     header("location:login.php");
 11     exit;12 }13 
14 $user = $_SESSION["username"];
15 
16 include("DADB.class.php");
17 $db = new DADB();
18 
19 $shaoyou = "select * from firend where me=&#39;{$user}&#39;";
20 $ahaoyou = $db->Query($shaoyou);
21 
22 ?>
23 
24 <form action="fabuchuli.php" method="post">
25     <p>接收人：
26         <select name="jsr">
27             <option value="all">所有人</option>
28             <?php
29             foreach($ahaoyou as $v)
30             {
31                 $name = uname($v[2]);
32                 echo "<option value=&#39;{$v[2]}&#39;>{$name}</option>";
33             }
34             ?>
35         </select>
36     </p>
37     <br />
38     <p
39         信息内容：<textarea name="neirong"></textarea>
40     </p><br />
41     <input type="submit" value="发送" />
42 </form>
43 <?php
44 function uname($user)
45 {
46     global $db;
47 
48     if($user=="all")
49     {
50         return "所有人";
51     }
52     else
53     {
54         $sql1 = "select name from yuangong where username=&#39;{$user}&#39;";
55         $att = $db->Query($sql1);
56 
57         return $att[0][0];
58     }
59 }
60 ?>
61 </body>

//这是发布页面的代码  和添加页面的代码相似
<?php <?php
session_start();

$re=$_POST["jsr"];
$comment=$_POST["neirong"];
$time=date("Y-m-d H:i:s"); //获取当前时间

$_SESSION["username"]=$user;
include("DADB.class.php");
$db=new DADB();

$sql="insert into liuyan VALUES (&#39;&#39;,&#39;{$user}&#39;,&#39;{$jsr}&#39;,&#39;{$time}&#39;,&#39;{$comment}&#39;,false)";
if($db->Query($sql,0))
{        header("location:main.php");
}
else{    
echo"发布失败";
}
?>
?>

A simple message board has been completed, When exiting, you need to clear the session and return to the login page

//退出页面代码
<?php session_start();
unset($_SESSION["username"]);
header("location:login.php");
?>

The above is the detailed content of How to easily create a message board using php. For more information, please follow other related articles on the PHP Chinese website!