php实现待办

PHP 实现待办事项功能

数据库设计

创建一个简单的待办事项表，包含基本字段如 ID、标题、描述、状态和创建时间。

CREATE TABLE todos (
    id INT AUTO_INCREMENT PRIMARY KEY,
    title VARCHAR(255) NOT NULL,
    description TEXT,
    status ENUM('pending', 'completed') DEFAULT 'pending',
    created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP
);

连接数据库

使用 PDO 或 MySQLi 连接数据库，确保连接安全。

$host = 'localhost';
$dbname = 'todo_app';
$username = 'root';
$password = '';

try {
    $pdo = new PDO("mysql:host=$host;dbname=$dbname", $username, $password);
    $pdo->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
} catch (PDOException $e) {
    die("Connection failed: " . $e->getMessage());
}

添加待办事项

创建一个表单提交待办事项，并将数据插入数据库。

if ($_SERVER['REQUEST_METHOD'] === 'POST' && isset($_POST['add_todo'])) {
    $title = $_POST['title'];
    $description = $_POST['description'];

    $stmt = $pdo->prepare("INSERT INTO todos (title, description) VALUES (?, ?)");
    $stmt->execute([$title, $description]);
}

显示待办事项

从数据库中查询并显示待办事项列表。

$stmt = $pdo->query("SELECT * FROM todos ORDER BY created_at DESC");
$todos = $stmt->fetchAll(PDO::FETCH_ASSOC);

foreach ($todos as $todo) {
    echo "<div class='todo-item'>";
    echo "<h3>" . htmlspecialchars($todo['title']) . "</h3>";
    echo "<p>" . htmlspecialchars($todo['description']) . "</p>";
    echo "<span>Status: " . $todo['status'] . "</span>";
    echo "</div>";
}

更新待办事项状态

提供按钮或链接来更新待办事项的状态。

if ($_SERVER['REQUEST_METHOD'] === 'POST' && isset($_POST['update_status'])) {
    $id = $_POST['id'];
    $status = $_POST['status'];

    $stmt = $pdo->prepare("UPDATE todos SET status = ? WHERE id = ?");
    $stmt->execute([$status, $id]);
}

删除待办事项

实现删除功能，从数据库中移除待办事项。

if ($_SERVER['REQUEST_METHOD'] === 'POST' && isset($_POST['delete_todo'])) {
    $id = $_POST['id'];

    $stmt = $pdo->prepare("DELETE FROM todos WHERE id = ?");
    $stmt->execute([$id]);
}

前端界面

创建一个简单的 HTML 表单和列表界面，与后端交互。

<form method="POST">
    <input type="text" name="title" placeholder="Title" required>
    <textarea name="description" placeholder="Description"></textarea>
    <button type="submit" name="add_todo">Add Todo</button>
</form>

<div id="todo-list">
    <?php foreach ($todos as $todo): ?>
        <div class="todo-item">
            <h3><?php echo htmlspecialchars($todo['title']); ?></h3>
            <p><?php echo htmlspecialchars($todo['description']); ?></p>
            <form method="POST">
                <input type="hidden" name="id" value="<?php echo $todo['id']; ?>">
                <select name="status">
                    <option value="pending" <?php echo $todo['status'] === 'pending' ? 'selected' : ''; ?>>Pending</option>
                    <option value="completed" <?php echo $todo['status'] === 'completed' ? 'selected' : ''; ?>>Completed</option>
                </select>
                <button type="submit" name="update_status">Update</button>
                <button type="submit" name="delete_todo">Delete</button>
            </form>
        </div>
    <?php endforeach; ?>
</div>

安全性考虑

确保输入数据经过验证和转义，防止 SQL 注入和 XSS 攻击。

$title = filter_input(INPUT_POST, 'title', FILTER_SANITIZE_STRING);
$description = filter_input(INPUT_POST, 'description', FILTER_SANITIZE_STRING);

完整示例

将上述代码整合到一个完整的 PHP 文件中，确保逻辑清晰且功能完整。