Very lightweight PHP service class for SQL INSERT queries abstraction.
Best suited for use as a Composer library.
- PHP >= 7.1
- PDO extension
To add this library to your Composer project:
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();