当前位置：首页 > PHP

php实现待办

2026-02-14 19:00:10PHP

PHP 实现待办事项功能

使用 PHP 实现待办事项功能需要结合数据库操作和前端交互。以下是一个简单的实现方法：

数据库设计

创建一张 todos 表，包含以下字段：

id: 主键，自增
task: 任务内容
completed: 完成状态，默认为 0
created_at: 创建时间

CREATE TABLE todos (
    id INT AUTO_INCREMENT PRIMARY KEY,
    task VARCHAR(255) NOT NULL,
    completed TINYINT DEFAULT 0,
    created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP
);

连接数据库

$host = 'localhost';
$dbname = 'todo_db';
$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("数据库连接失败: " . $e->getMessage());
}

添加待办事项

if (isset($_POST['add_task'])) {
    $task = trim($_POST['task']);

    if (!empty($task)) {
        $stmt = $pdo->prepare("INSERT INTO todos (task) VALUES (:task)");
        $stmt->execute([':task' => $task]);
    }
}

显示待办事项

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

标记完成/未完成

if (isset($_GET['toggle'])) {
    $id = $_GET['toggle'];
    $stmt = $pdo->prepare("UPDATE todos SET completed = 1 - completed WHERE id = :id");
    $stmt->execute([':id' => $id]);
    header("Location: index.php");
    exit();
}

删除待办事项

if (isset($_GET['delete'])) {
    $id = $_GET['delete'];
    $stmt = $pdo->prepare("DELETE FROM todos WHERE id = :id");
    $stmt->execute([':id' => $id]);
    header("Location: index.php");
    exit();
}

前端示例

<form method="post">
    <input type="text" name="task" placeholder="添加新任务..." required>
    <button type="submit" name="add_task">添加</button>
</form>

<ul>
    <?php foreach ($todos as $todo): ?>
    <li>
        <span style="<?= $todo['completed'] ? 'text-decoration: line-through' : '' ?>">
            <?= htmlspecialchars($todo['task']) ?>
        </span>
        <a href="?toggle=<?= $todo['id'] ?>"><?= $todo['completed'] ? '未完成' : '完成' ?></a>
        <a href="?delete=<?= $todo['id'] ?>">删除</a>
    </li>
    <?php endforeach; ?>
</ul>