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 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();PHP ETL is licensed under the MIT license.