shiyan / lite-sql-insert
轻量级 SQL 插入服务。
3.0.0
2018-04-27 20:15 UTC
Requires
- php: ^7.1
- ext-pdo: ^7.1
Requires (Dev)
- ext-pdo_sqlite: ^7.1
- phpunit/dbunit: ^3.0
- phpunit/phpunit: ^6.4
Suggests
- shiyan/iterate: Allows inserting in iteration
This package is auto-updated.
Last update: 2024-09-14 19:25:56 UTC
README
一个非常轻量级的 PHP 服务类,用于 SQL INSERT 查询的抽象。
最适合用作 Composer 库。
需求
- PHP >= 7.1
- PDO 扩展
安装
要将此库添加到您的 Composer 项目中
composer require shiyan/lite-sql-insert
使用
$connection = new \Shiyan\LiteSqlInsert\Connection($pdo);
$insert = $connection->insert('my_table', ['name', 'value']);
foreach ($my_data as $name => $value) {
$insert->values(['name' => $name, 'value' => $value]);
}
$insert->commit();