编辑“︁PHP数据库模式”︁（章节）

=== 活动记录(Active Record)模式 ===
每个数据库表对应一个类，类的实例对应表中的一行。

<syntaxhighlight lang="php">
<?php
class User {
    private $pdo;
    public $id;
    public $name;
    public $email;
    
    public function __construct(PDO $pdo) {
        $this->pdo = $pdo;
    }
    
    public function save() {
        if ($this->id) {
            // 更新
            $stmt = $this->pdo->prepare("UPDATE users SET name=?, email=? WHERE id=?");
            $stmt->execute([$this->name, $this->email, $this->id]);
        } else {
            // 插入
            $stmt = $this->pdo->prepare("INSERT INTO users (name, email) VALUES (?, ?)");
            $stmt->execute([$this->name, $this->email]);
            $this->id = $this->pdo->lastInsertId();
        }
    }
    
    public static function find(PDO $pdo, $id) {
        $stmt = $pdo->prepare("SELECT * FROM users WHERE id = ?");
        $stmt->execute([$id]);
        $userData = $stmt->fetch(PDO::FETCH_ASSOC);
        
        if ($userData) {
            $user = new User($pdo);
            $user->id = $userData['id'];
            $user->name = $userData['name'];
            $user->email = $userData['email'];
            return $user;
        }
        return null;
    }
}

// 使用示例
$pdo = new PDO("mysql:host=localhost;dbname=database", "username", "password");

// 创建新用户
$newUser = new User($pdo);
$newUser->name = "Alice";
$newUser->email = "alice@example.com";
$newUser->save();

// 查找用户
$user = User::find($pdo, 1);
echo $user->name; // 输出: John Doe
?>
</syntaxhighlight>