Extract, Transform and Load data using PHP.
In your application's folder, run:
composer require marquine/php-etl
Documentation can be found here.
In the example below, we will extract data from a csv file, trim two columns and load the data into database:
use Marquine\Etl\Job;
Job::start()->extract('csv', 'path/to/file.csv')
->transform('trim', ['columns' => ['name', 'email']])
->load('table', 'users');
or
use Marquine\Etl\Job;
$job = new Job;
$job->extract('csv', 'path/to/file.csv')
->transform('trim', ['columns' => ['name', 'email']])
->load('table', 'users');
PHP ETL is licensed under the MIT license.