PHP code example of jarir-ahmed / data-converter

1. Go to this page and download the library: Download jarir-ahmed/data-converter library. Choose the download type require.

2. Extract the ZIP file and open the index.php.

3. Add this code to the index.php. 
    
        
<?php
require_once('vendor/autoload.php');

/* Start to develop here. Best regards https://php-download.com/ */

jarir-ahmed / data-converter example snippets


use JarirAhmed\DataConverter\ImportManager;

$import = new ImportManager();

$sql = $import->csvToSql('users.csv', 'users');    // CSV → SQL
$sql = $import->xlsxToSql('orders.xlsx', 'orders'); // XLSX → SQL
$sql = $import->jsonToSql('data.json', 'products'); // JSON → SQL

// Auto-detect by extension
$sql = $import->fileToSql('data.csv',  'my_table');
$sql = $import->fileToSql('data.xlsx', 'my_table');
$sql = $import->fileToSql('data.json', 'my_table');

// Direct DB insert via PDO
$pdo = new PDO('mysql:host=127.0.0.1;dbname=test-excel;charset=utf8mb4',
    'root', 'your_secure_password');
$import->csvToSql('data.csv', 'users', ['pdo' => $pdo]);


use JarirAhmed\DataConverter\ExportManager;

$pdo    = new PDO('mysql:host=127.0.0.1;dbname=test-excel', 'root', 'your_secure_password');
$export = new ExportManager();

$export->sqlToCsv('SELECT * FROM users', $pdo, 'users.csv');
$export->sqlToXlsx('SELECT * FROM orders', $pdo, 'orders.xlsx');
$export->sqlToJson('SELECT * FROM products', $pdo, 'products.json');

// Or from arrays:
$export->dataToCsv([...], 'out.csv');
$export->dataToXlsx([...], 'out.xlsx');
$export->dataToJson([...], 'out.json');


use JarirAhmed\DataConverter\Converter;

$conv = new Converter();

$conv->csvToXlsx('data.csv', 'data.xlsx');
$conv->xlsxToCsv('data.xlsx', 'data.csv');
$conv->csvToJson('data.csv', 'data.json');
$conv->jsonToCsv('data.json', 'data.csv');
$conv->xlsxToJson('report.xlsx', 'report.json');
$conv->jsonToXlsx('data.json', 'data.xlsx');