Managing Data Import and Export with PortPHP

• Support for Multiple Data Formats: PortPHP offers extensive support for a wide range of data formats, including CSV, Excel, JSON, XML, and more. This versatility allows you to import data from various sources and export it in formats suitable for different applications.
• Database Interactions: The library facilitates seamless communication with databases, enabling developers to import and export data between different database systems like MySQL, PostgreSQL, SQLite, and more. This feature is particularly beneficial for applications that require periodic data synchronization or data migration.
• Data Validation and Transformation: PortPHP provides built-in mechanisms for data validation and transformation during the import process. You can apply custom validation rules, clean and sanitize data, and modify it as needed to ensure consistency and accuracy.
• Scalability and Performance: With a focus on efficiency, PortPHP is designed to handle large datasets efficiently. Its performance optimization allows you to process substantial volumes of data without compromising on speed and responsiveness.
• Easy Configuration and Extensibility: The library boasts a user-friendly configuration system, making it simple to adapt to specific data sources and destinations. Additionally, you can extend its functionality by creating custom importers and exporters to cater to unique requirements.

$ composer require portphp/steps

<?php
require 'vendor/autoload.php';

use Port\Reader\ArrayReader;
use Port\Writer\PDOWriter;
use Port\Steps\StepAggregator;
use Port\Filter\ValidatorFilter;
use Port\Filter\HeaderFilter;
use Port\Filter\NullFilter;

$pdo = new PDO('mysql:host=localhost;dbname=mydatabase', 'username', 'password');
$csvFile = 'employees.csv';

$workflow = new StepAggregator([
    new HeaderFilter(),
    new ValidatorFilter(),
    new NullFilter(),
    new PDOWriter($pdo, 'employees'),
]);

$reader = new ArrayReader(iterator_to_array(new \League\Csv\Reader($csvFile)));

$workflow->process($reader);

<?php
require 'vendor/autoload.php';

use Port\Reader\PDOReader;
use Port\Writer\ExcelWriter;
use Port\Steps\StepAggregator;
use Port\Filter\HeaderFilter;

$pdo = new PDO('mysql:host=localhost;dbname=mydatabase', 'username', 'password');
$excelFile = 'employees_export.xlsx';

$workflow = new StepAggregator([
    new PDOReader($pdo, 'SELECT * FROM employees'),
    new HeaderFilter(),
    new ExcelWriter($excelFile),
]);

$workflow->process();