Skip to content
PHP 8.1+ Open source Developer documentation
Tools Packagist
Docs v2.0.6
Documentation versions v2.0.6Current v2.0.5Maintenance v2.0.4Maintenance v2.0.3Maintenance v2.0.0Initial v2 Compare versions →
MNB PHPExcelDeveloper Guide
AI
Standalone Database package

PHP Database Import Library for PDO Mapping & Validation

Use the standalone MNB PHPExcel Database package when your application already has iterable rows and needs format-neutral PDO imports with mapping, validation, batching, duplicate handling, domain presets, manifests, or failed-row reporting.

Feature matrix API reference
Composer
composer require mnb/mnb-phpexcel-database:^2.0
Package
mnb/mnb-phpexcel-database
Entry API
Mnb\PHPExcel\Import\SqlImporter
Runtime
PHP 8.1+
Format
Iterable rows → PDO

Choose your Database workflow#

01
Connect PDO and import iterable rowsCreate database connections, batch inserts or updates, choose duplicate behavior, and import arrays, generators, cursors, or format sessions.
02
Map and validate source recordsPreview headers, map source keys to database columns, normalize values, validate rows, and retain original source row numbers.
03
Use domain import presetsStart from users, products, orders, inventory, students, contacts, locations, and other application-oriented import profiles.
04
Operate large or resumable importsUse batches, manifests, progress, failed-row output, transaction boundaries, and replay-safe duplicate strategies.

Use the right Database API#

TaskPrimary APIChoose it when
Import iterable rows into PDOSqlImporter::importRows()You already have normalized rows and need mapping, validation, batching, inserts/updates, and duplicate handling.
Run a domain-oriented importDomainImporter::create()Application presets, aliases, validation rules, previews, templates, or domain-specific defaults should sit above the generic SQL engine.
Build a PDO connectionDatabaseConnectionFactory::make()Configuration values need to become a consistent PDO connection with package-level defaults.
Stream very large XLSX directly to PDOLargeExcelDatabaseImportEngineUse the separate mnb/mnb-phpexcel-database-xlsx bridge when XLSX chunk orchestration itself belongs to the job.

What the standalone Database package covers#

Import

Format-neutral PDO writes

  • Arrays, generators, cursors, and normalized format sessions
  • Batched inserts and update strategies
  • Prepared statements and transaction controls
  • Duplicate skip/update behavior with unique keys
Quality

Mapping and validation

  • Explicit source-to-column maps and aliases
  • Normalization, defaults and validation rules
  • Preview/dry-run workflows before writes
  • Original source-row tracking and failed-row reports
Operations

Production import workflows

  • Domain presets and reusable application profiles
  • Progress callbacks, manifests and resume state
  • Batch sizing and replay-safe strategies
  • No spreadsheet-format dependency unless you add one

Package boundary: mnb/mnb-phpexcel-database owns format-neutral PDO workflows. Add CSV, XLS, XLSX, JSON, XML, or ODS separately only when this package must open that source format. Use the monolithic package instead when one application intentionally owns the complete toolkit.