shiyan/lite-sql-insert

Lightweight SQL insertion service.

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

MIT

• Mike Shiyan

• php
• sql
• OOP
• pdo
• insert
• lite

README

Very lightweight PHP service class for SQL INSERT queries abstraction.

Best suited for use as a Composer library.

Requirements

• PHP >= 7.1
• PDO extension

Installation

To add this library to your Composer project:

composer require shiyan/lite-sql-insert

Usage

$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();