留言板實作 | Notion

前端

<!DOCTYPE html>
<html lang="en">
<head>
    <meta charset="UTF-8">
    <meta name="viewport" content="width=device-width, initial-scale=1.0">
    <title>Document</title>
</head>
<body>
    
    <div class="container">
        <div class="title">留言內容</div>
        <form method="post" action="./form.php">
            <!-- name的值要跟$_POST["值"]一樣 -->
            <input type="text" name="userName" placeholder="輸入暱稱">
            <textarea name="userText" id="userText" cols="30" rows="10"></textarea>
            <div class="btn">
                <button type="submit">送出</button>
            </div>
        </form>
    </div>
    <div class="post-history">
        <?php   
            $host = "localhost";
            $account = "root";
            $passwd = "Aa082315!";
            $database = "user";
            $connect = new mysqli($host,$account,$passwd,$database);
            if ($connect->connect_error){
                echo '連線失敗';
            }
            echo '連線成功';
            echo '<h2>留言紀錄</h2>';
            $selectSql = "SELECT * FROM post";
            $postData = $connect->query($selectSql);
            $postNum = $postData->num_rows;
            print_r($postData);
            if ($postNum >0){
                echo '<h2>共'. $postNum. '條留言</h2>';
                while ($row = $postData->fetch_assoc()){
                    echo "<div class='table'>
                            <div class='delete'><a href='form.php?id={$row['id']}'>刪除</a></div>
                            <p class='num'>{$row['id']}   {$row['name']}</p>
                            <p class='text'>{$row['text']}</p>
                        </div>";
                }
            } else {
                echo '<h2>暫無留言</h2>';
            }
        ?>
    </div>
    
</body>
</html>

後端

<?php

$name = $_POST["userName"];
$text = $_POST["userText"];
$id = $_GET['id'];

echo $name . $text;
echo '<br/>';
$host = "localhost";
$account = "root";
$passwd = "Aa082315!";
$database = "user";
$connect = new mysqli($host,$account,$passwd,$database);
if ($connect->connect_error){
    echo '連線失敗';
}

echo '連線成功';
echo '<br/>';
$connect->query("SET NAMES 'utf8'");
// char型要加''符號 
if ($name && $text) {
    $addPost = "INSERT INTO post (name,text) VALUES ('$name','$text')";
    $status = $connect->query($addPost);
    if ($status){
        echo "新增成功";
        
    } else {
        echo  $connect->error;
    }
    
}

if ($id){
    $deletePost = "DELETE FROM post WHERE id = $id";
    $status = $connect->query($deletePost);
    if ($status){
        echo "刪除成功";
    } else {
        echo  $connect->error;
    }
}

//重定向瀏覽器 
header("Location: <http://localhost/userform.php>"); 
//確保重定向後，後續代碼不會被執行 
exit;