README

一个简单的PHP库，用于使用活动记录模式访问数据库。

安装

composer require icehrm/php-active-record

使用方法

创建模型

• 假设您有这个示例表（来自IceHrm）

create table `Files` (
 `id` bigint(20) NOT NULL AUTO_INCREMENT,
 `name` varchar(100) NOT NULL,
 `filename` varchar(100) NOT NULL,
 `employee` bigint(20) NULL,
 `file_group` varchar(100) NOT NULL,
 `size` bigint(20) NULL,
 `size_text` varchar(20) NULL,
 primary key  (`id`),
 unique key `filename` (`filename`)
) engine=innodb default charset=utf8;

• 创建模型类

<?php
use MyORM\MySqlActiveRecord;

class File extends MySqlActiveRecord
{
    public $table = 'Files';
}

• 创建连接

$connection = new \MyORM\MySqlActiveRecord();
// Host, Username, Password, Database
$res = $connection->Connect('127.0.0.1:10012', 'root', 'root', 'phpactiverecord');

• 数据库操作

// Save a file
$file = new File();
$file->name = 'Test';
$file->filename = 'Test';
$file->file_group = 'Test';
$file->Save();

// Load saved file
$file = new File();
$file->Load('name = ?', ['Test']);

// Find all files
$files = $file->Find();

// Find first 5 files
$files = $file->Find('1=1 LIMIT 5');

// Find all files having name 'Test'
$files = $file->Find('name = ?', ['Test1']);

// Update file
$file = new File();
$file->Load('name = ?', ['Test']);
$file->file_group = 'New Group';
$file->Save();

// Delete file
$file = new File();
$file->Load('name = ?', ['Test']);
$file->Delete();

// Run row query
$file = new File();
$file->DB()->execute('DELETE FROM Files');

运行测试

设置

wget -O phpunit https://phar.phpunit.de/phpunit-9.phar
chmod +x phpunit

rm -rf ./test/db_data
docker compose up -d
./phpunit --configuration phpunit.xml
docker compose down