Active Record / Data Mapper 模式中,根據對象屬性自動構建 INSERT 語句,減少手寫 SQL、適應模型變更。
<?php
abstract class BaseModel {
// 子類需定義對應表名或由命名規則推導
abstract protected static function tableName(): string;
}
class User extends BaseModel {
public $id; // 主鍵,通常自增不插入
public $username;
public $email;
public $created_at;
protected static function tableName(): string { return 'users'; }
}
class Repository {
private PDO $conn;
public function __construct(PDO $pdo) { $this->conn = $pdo; }
/**
* 插入模型對象
* @param BaseModel $model
* @param bool $returnId 是否返回自增 ID
* @return int|bool 影響行數或 lastInsertId
*/
public function insert(BaseModel $model, bool $returnId = false) {
$refClass = new ReflectionClass($model);
$props = $refClass->getProperties(ReflectionProperty::IS_PUBLIC);
$fields = [];
$placeholders = [];
$values = [];
foreach ($props as $prop) {
$name = $prop->getName();
// 跳過主鍵 id(假設自增)
if ($name === 'id') continue;
$fields[] = "`$name`";
$placeholders[] = '?';
$values[] = $prop->getValue($model); // 獲取屬性值
}
$sql = sprintf(
'INSERT INTO `%s` (%s) VALUES (%s)',
$model::tableName(),
implode(', ', $fields),
implode(', ', $placeholders)
);
$stmt = $this->conn->prepare($sql);
$stmt->execute($values);
return $returnId ? (int)$this->conn->lastInsertId() : $stmt->rowCount();
}
}
// 使用
$pdo = new PDO('mysql:host=localhost;dbname=test;charset=utf8mb4', 'root', '');
$repo = new Repository($pdo);
$user = new User();
$user->username = 'john';
$user->email = 'john@example.com';
$user->created_at = date('Y-m-d H:i:s');
$newId = $repo->insert($user, true);
echo "插入成功,ID: $newId";
ReflectionClass::getProperties(ReflectionProperty::IS_PUBLIC) 只取公開屬性,避免私有/受保護屬性誤入。? 佔位符 + prepare()/execute() 參數綁定,**完全防注入**。id 自動跳過,適用自增主鍵表。lastInsertId() 獲取自增 ID。#[Column(name='user_name')] 映射不同欄位名。updated_at 自動填充、軟刪除欄位過濾。Doctrine DBAL 或 Eloquent 等成熟 ORM 替代手寫。