belguinan/csv-simple-reader

A lightweight, zero-dependency PHP library for reading, writing, and exporting CSV files. Works with PHP 5.4 and above.

v1.1.3 2024-10-30 02:38 UTC

This package is auto-updated.

Last update: 2025-04-29 01:03:00 UTC


README

A lightweight, zero-dependency PHP library for reading, writing, and exporting CSV files. Works with PHP 5.4 and above.

License: MIT

Features

  • 🚀 Simple and intuitive API
  • 📖 Memory-efficient reading of large files
  • 💾 Export data to CSV files
  • ⬇️ Direct CSV downloads
  • 🔒 Secure file handling
  • 0️⃣ Zero dependencies
  • ✅ PHP 5.4+ compatible

Installation

Install via Composer:

composer require belguinan/csv-simple-reader

Quick Start

use Belguinan\CsvExporter;

// Initialize
$csv = new CsvExporter();

// Read CSV file
foreach ($csv->readFrom('path/to/file.csv') as $row) {
    var_dump($row);
}

Usage Guide

Reading CSV Files

$csv = new CsvExporter();

// Read file line by line (memory efficient)
foreach ($csv->readFrom('input.csv') as $row) {
    // $row is an array containing the CSV columns
    var_dump($row);
}

Creating CSV Files

// Your data as array
$data = array(
    array('John', 'Doe', 'john@example.com'),
    array('Jane', 'Smith', 'jane@example.com')
);

// Optional headers
$headers = array('First Name', 'Last Name', 'Email');

// Create CSV exporter
$csv = new CsvExporter($data, $headers);

// Process and save
$csv->process()->save('output.csv');

Downloading CSV Files

// Create and force download
$csv = new CsvExporter($data, $headers);
$csv->process()->download('users-export');

Chaining Operations

// Process, download, and save in one go
$csv->process()
    ->download('export-file')
    ->save('backup/export.csv');

Error Handling

The library throws Exception for various error conditions. It's recommended to wrap operations in try-catch blocks:

try {
    $csv = new CsvExporter($data);
    $csv->process()->save('output.csv');
} catch (\Exception $e) {
    echo "Error: " . $e->getMessage();
}

Common Exceptions

  • File not found
  • File not readable
  • Directory not writable
  • Invalid CSV data structure
  • Memory stream errors

Best Practices

  1. Reading Large Files

    // Good - Memory efficient
    foreach ($csv->readFrom('large.csv') as $row) {
        processRow($row);
    }
  2. Setting Headers

    // Explicit headers
    $headers = array('ID', 'Name', 'Email');
    $csv = new CsvExporter($data, $headers);
    
    // Auto-generated headers from data keys
    $csv = new CsvExporter($data);
  3. Error Handling

    try {
        $csv->readFrom('file.csv');
    } catch (\Exception $e) {
        log_error($e->getMessage());
        // Handle error appropriately
    }

Examples

Export Users Table

// Fetch users from database
$users = $db->query('SELECT id, name, email FROM users');

// Convert to array
$data = array();
while ($row = $users->fetch_assoc()) {
    $data[] = $row;
}

// Export
$csv = new CsvExporter($data);
$csv->process()->download('users-export');

Process CSV in Chunks

$csv = new CsvExporter();
$chunk = array();

foreach ($csv->readFrom('large-file.csv') as $index => $row) {
    $chunk[] = $row;
    
    // Process in chunks of 1000
    if (count($chunk) >= 1000) {
        processChunk($chunk);
        $chunk = array();
    }
}

// Process remaining rows
if (!empty($chunk)) {
    processChunk($chunk);
}

License

MIT License - feel free to use this library in your projects.

Contributing

Contributions are welcome! Please feel free to submit a Pull Request.

Support

For bugs and feature requests, please use the GitHub issue tracker.