mikeshiyan / lite-sql-insert
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: 2022-02-01 13:10:54 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();