leomarquine / php-etl

Extract, Transform and Load data using PHP.
MIT License
178 stars 81 forks source link

PHP ETL

Build Status Latest Stable Version Latest Unstable Version License

Extract, Transform and Load data using PHP.

Installation

In your application's folder, run:

composer require marquine/php-etl

Documentation

Documentation can be found here.

Example

In the example below, we will extract data from a csv file, trim white spaces from the name and email columns and then insert the values into the users table:

use Marquine\Etl\Etl;

$etl = new Etl;

$etl->extract('csv', '/path/to/users.csv')
    ->transform('trim', ['columns' => ['name', 'email']])
    ->load('insert', 'users')
    ->run();

License

PHP ETL is licensed under the MIT license.