利用PHP实现简单留言板

跟随bilibili教学视频一步一步实现简单的PHP留言板。

• 第一个代码文件item.php，创建了一个Message，并连接了数据库。

<?php
class Message
{
    var $name;
    var $time;
    var $content;

    function __construct($n, $t, $c)
    {
        $this->name = $n;
        $this->time = $t;
        $this->content = $c;
    }
    function show()
    {
        echo "名字:" . $this->name . "<br>";
        echo "时间:" . $this->time . "<br>";
        echo "内容:" . $this->content . "<br>";
        echo "=================================" . "<br>";
    }
}
class DB
{
    var $database = null;
    function __construct()
    {
        $dbhost = "localhost";
        $account = "wang";
        $password = "123456";
        $dataform = "db_messages";

        $this->database = mysqli_connect($dbhost, $account, $password, $dataform);
        // if($this->database)
        // {
        //     echo "连接数据库成功";
        // }
    }
    function __destruct()
    {
        mysqli_close($this->database);
    }
}

• 第二个代码文件messageBoard.php，将上面那个部分引用进来，并且做出相应的工作。

<?php
include_once('item.php'); //引入一次item.php
class MessageBoard extends DB //让DB类可以执行下去
{
    var $messages = array();

    function __construct()
    {
        parent::__construct(); //DB的构造子
        $this->receiveMessage(); //接收并保存数据
        $this->loadData(); //在加载数据库里已经有的数据到一个数组里面
        $this->showAllMessages(); //展示数组里所有东西到页面中
        $this->showForm(); //展示表单
    }
    function receiveMessage()
    {
        if (count($_POST) != 0) {
            $this->saveData($_POST['userName'], date("Y-m-d h:i:s", time()), $_POST['content']);
        }
        //总秒数time()
    }
    function loadData()
    {
        $query = "SELECT * FROM `all_messages`";
        $result = mysqli_query($this->database, $query);
        while ($row = mysqli_fetch_array($result)) {
            $temp = new Message($row['name'], $row['time'], $row['content']);
            array_push($this->messages, $temp);
        }
    }
    function saveData($u, $t, $c)
    {
        $query = "INSERT INTO `all_messages`( `name`, `time`, `content`) VALUES ('$u','$t','$c')";
        mysqli_query($this->database, $query);
    }
    function showAllMessages()
    {
        foreach ($this->messages as $m) {
            $m->show();
        }
    }
    function showForm()
    {
        echo "<form action='' method='POST'>";
        echo "名字:" . "<input type='text' name='userName'>" . "<br>";
        echo "内容:" . "<input type='text' name='content'>" . "<br>";
        echo "<input type='submit' value='提交'>";
        echo "</form>";
    }
}
$mb = new MessageBoard();

大家可以试一下，就是一个简易的留言板，包括数据的输入，到数据库的存储，然后数据库的提取，最后到显示，一个比较完整的流程，适合新手参考。有问题可以shi'liao