Format-neutral PDO import, validation, and mapping features.

The Database library accepts iterable rows or rows supplied by an installed format reader. It owns mapping, validation, previews, prepared SQL batches, duplicate strategies, domain presets, manifests, and failed-row output.

Package: 1
Capabilities: 13
Feature groups: 8

Updated August 1, 2026

LevelAll levelsReading time5 minPackagemnb/mnb-phpexcel-database

What you will learn

Understand which workflows are format-neutral.
Separate Database features from format-reader responsibilities.
Choose the mapping, validation, domain, or resume guide.

What this library includes

This page is limited to mnb/mnb-phpexcel-database. Features from the monolithic package or another individual library are not mixed into this list.

Installcomposer require mnb/mnb-phpexcel-database:^2.0

Primary APIMnb\PHPExcel\Import\SqlImporter

ScopeIndividual libraryFocused dependency and package-local API

Package linksGitHub repository ↗Packagist package ↗

Package quick start

The example uses the individual-library API documented by this feature page.

<?php

require __DIR__ . '/vendor/autoload.php';

use Mnb\PHPExcel\Import\SqlImporter;

$importer = new SqlImporter($pdo);
$result = $importer->import($rows, 'products', [
    'mapping' => ['SKU' => 'sku', 'Price' => 'price'],
    'unique_by' => ['sku'],
    'duplicate_strategy' => 'update',
]);

Supported capabilities

Search the capabilities owned by this package and open the matching package-specific guide.

Connections1 capabilities

Feature	What it does	Typical use	Support	Guide
PDO connection helpers	Create and validate supported PDO connections using explicit configuration.	Import services	Supported	Open guide

Import2 capabilities

Feature	What it does	Typical use	Support	Guide
Prepared batch insertion	Insert validated rows in bounded prepared-statement batches.	High-volume persistence	Supported	Open guide
Transactions and rollback controls	Control transaction boundaries and failure behavior.	Reliable bulk imports	Supported	Open guide

Mapping2 capabilities

Feature	What it does	Typical use	Support	Guide
Header detection and mapping suggestions	Preview source headers and suggest target fields with confidence values.	User-assisted imports	Supported	Open guide
Explicit transformations and normalizers	Rename fields, normalize values, apply defaults, and transform records.	ETL workflows	Supported	Open guide

Validation2 capabilities

Feature	What it does	Typical use	Support	Guide
Field and cross-field rules	Validate required values, types, formats, ranges, and relationships.	Clean database writes	Supported	Open guide
Source row preservation	Keep original source row numbers in validation and failed-row output.	Actionable upload feedback	Supported	Open guide

Duplicates1 capabilities

Feature	What it does	Typical use	Support	Guide
Insert, update, skip, and error strategies	Resolve existing records using configured unique keys.	Product and customer synchronization	Supported	Open guide

Domains1 capabilities

Feature	What it does	Typical use	Support	Guide
Built-in import presets	Use schemas for users, products, orders, inventory, students, attendance, marks, contacts, locations, posts, media, and categories.	Common application datasets	Supported	Open guide

Operations3 capabilities

Feature	What it does	Typical use	Support	Guide
Preview and dry-run workflows	Inspect mappings, normalized records, and validation failures before persistence.	Safer user confirmation	Supported	Open guide
Failed-row CSV output	Write rejected source records and errors for correction.	Import support workflows	Supported	Open guide
Manifests and resumable state	Persist format-neutral checkpoints and import progress.	Long-running jobs	Supported	Open guide

Export1 capabilities

Feature	What it does	Typical use	Support	Guide
Database cursor integration	Stream PDO query results into an installed output writer.	Large database exports	Supported	Open guide

Feature boundaries

These limits prevent individual-library documentation from being confused with the complete monolithic package.

Capability	Status	What to use instead
Opening XLSX, XLS, CSV, JSON, XML, or ODS files	Partially supported: Install the relevant format package; Database itself is format-neutral.	Install the relevant format package; Database itself is format-neutral.
Direct large XLSX chunk orchestration	Not supported: Install mnb/mnb-phpexcel-database-xlsx for the XLSX-specific bridge.	Install mnb/mnb-phpexcel-database-xlsx for the XLSX-specific bridge.
Spreadsheet presentation and workbook writing	Not supported: Presentation belongs to the selected format writer.	Presentation belongs to the selected format writer.

Was this guide useful?Use GitHub issues for corrections, missing examples, or unclear behavior.

Open an issue