通过以下链接搜索 
sy / mysql
MySQL 数据库层
3.7.2
2023-11-01 15:34 UTC
Requires
- php: >=7.4.0
- psr/simple-cache: ^1
- sy/db: ^1
- sy/template: ^2
Requires (Dev)
- phpunit/phpunit: ^10
README
MySQL 数据库层
安装
使用以下命令安装最新版本
$ composer require sy/mysql
基本用法
对于生产环境，建议将数据库连接设置存储在只有有限权限的 .ini 文件中。例如，my_setting.ini
host = 127.0.0.1
dbname = my_database
username = my_username
password = my_password
<?php use Sy\Db\MySql\Crud; $crud = new Crud('user'); $crud->setConfig(parse_ini_file('my_setting.ini')); // Create $crud->create(['firstanme' => 'John', 'lastname' => 'Doe']); $crud->createMany([ ['firstanme' => 'John', 'lastname' => 'Doe'], ['firstanme' => 'John', 'lastname' => 'Wick'], ]); // Retrieve $user = $crud->retrieve(['id' => 3]); $users = $crud->retrieveAll(['LIMIT' => 10]); $users = $crud->retrieveAll(['LIMIT' => 10, 'OFFSET' => 10]); // Update $crud->update(['id' => 3], ['firstname' => 'Jane']); // Delete $crud->delete(['id' => 3]);