利用 PHP 反射 (ReflectionClass) 自动映射对象属性到数据表字段,实现基本的 save()、find()、delete() 操作,类似简易版 ActiveRecord。
config.php // 数据库连接常量
database.php // 简易 DB 封装
Model.php // 基础模型类(持久层核心)
User.php // 业务模型示例
<?php // database.php
include 'config.php';
function db_connect() {
$c = mysql_connect(DBHOST, DBUSER, DBPSWD);
mysql_set_charset('utf8', $c);
mysql_select_db(DBNAME, $c);
return $c;
}
function db_query($sql) {
$c = db_connect();
$r = mysql_query($sql, $c);
mysql_close($c);
return $r;
}
function db_fetch_all($sql) {
$c = db_connect();
$r = mysql_query($sql, $c);
$rows = array();
while ($row = mysql_fetch_assoc($r)) $rows[] = $row;
mysql_close($c);
return $rows;
}
<?php // Model.php
abstract class Model {
protected static $table = '';
protected static $pk = 'id';
protected $data = array();
public function __set($name, $value) { $this->data[$name] = $value; }
public function __get($name) { return isset($this->data[$name]) ? $this->data[$name] : null; }
// 保存(新增或更新)
public function save() {
$fields = $vals = $sets = array();
foreach ($this->data as $k => $v) {
if ($k == static::$pk && $v) continue; // 自增主键不插入
$fields[] = "`$k`";
$vals[] = "'" . mysql_real_escape_string($v) . "'";
$sets[] = "`$k` = '" . mysql_real_escape_string($v) . "'";
}
if (isset($this->data[static::$pk]) && $this->data[static::$pk]) {
$sql = "UPDATE `".static::$table."` SET ".implode(',', $sets)." WHERE `".static::$pk."` = {$this->data[static::$pk]}";
} else {
$sql = "INSERT INTO `".static::$table."` (".implode(',', $fields).") VALUES (".implode(',', $vals).")";
}
db_query($sql);
if (!isset($this->data[static::$pk])) {
$this->data[static::$pk] = mysql_insert_id();
}
return true;
}
// 静态查找
public static function find($id) {
$sql = "SELECT * FROM `".static::$table."` WHERE `".static::$pk."` = ".intval($id);
$row = db_fetch_all($sql);
if ($row) {
$obj = new static();
$obj->data = $row[0];
return $obj;
}
return null;
}
// 条件查询
public static function where($condition) {
$sql = "SELECT * FROM `".static::$table."` WHERE $condition";
$rows = db_fetch_all($sql);
$objs = array();
foreach ($rows as $row) {
$obj = new static();
$obj->data = $row;
$objs[] = $obj;
}
return $objs;
}
public function delete() {
if ($this->data[static::$pk]) {
db_query("DELETE FROM `".static::$table."` WHERE `".static::$pk."` = {$this->data[static::$pk]}");
return true;
}
return false;
}
}
<?php // User.php
class User extends Model {
protected static $table = 'users';
protected static $pk = 'id';
}
// 使用
$user = new User();
$user->name = '张三';
$user->email = 'zhang@example.com';
$user->save(); // INSERT
$user = User::find(1);
$user->email = 'new@example.com';
$user->save(); // UPDATE
$users = User::where("status = 1 ORDER BY id DESC LIMIT 10");
mysql_* 函数,应升级为 mysqli 或 PDO(预处理防注入)。