萬盛學電腦網

您现在的位置: 萬盛學電腦網 >> 程式設計 >  >> 網路程式設計 >> PHP 程式設計

PHP 基于 MySQL 实现轻量级对象持久层(ORM 雏形)

设计思路

利用 PHP 反射 (ReflectionClass) 自动映射对象属性到数据表字段,实现基本的 save()、find()、delete() 操作,类似简易版 ActiveRecord。

核心文件结构

config.php      // 数据库连接常量
database.php    // 简易 DB 封装
Model.php       // 基础模型类(持久层核心)
User.php        // 业务模型示例

关键代码片段

1. 数据库封装

<?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;
}

2. 基础模型类

<?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;
    }
}

3. 业务模型示例

<?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(预处理防注入)。
  • 不支持关联关系、事务、事件钩子、验证器等高级特性。
  • 生产建议直接使用成熟 ORM:Doctrine、Eloquent、Yii ActiveRecord。
copyright © 萬盛學電腦網 all rights reserved