library export-tools
Export tools
solve-x/export-tools
Export tools
- Friday, September 15, 2017
- by Matej
- Repository
- 2 Watchers
- 3 Stars
- 14 Installations
- PHP
- 0 Dependents
- 0 Suggesters
- 0 Forks
- 0 Open issues
- 6 Versions
- 8 % Grown
Fast MySQL-to-Excel exporter
This library uses MySQL's SELECT INTO OUTFILE feature to export selected rows into a csv file
and then converts that csv into xlsx via a C-language program (Linux only). This is much faster than other pure PHP
solutions., (*1)
Example usage:, (*2)
<?php
use SolveX\ExportTools\ExcelExporter;
$db = app('db'); // Illuminate\Database\ConnectionInterface (Laravel)
$excelExporter = new ExcelExporter($db);
$sql = "SELECT first_name, last_name, phone, email FROM `customers` WHERE id = 1";
$columns = ['First Name', 'Last Name', 'Phone', 'Email'];
$path = $excelExporter->export($sql, $columns);
dev-master
9999999-dev
Export tools
Sources
Download
The Requires
The Development Requires
by
Matej Drame
by
Marko Kuhar
export
exporting
v0.1.4
0.1.4.0
Export tools
Sources
Download
The Requires
The Development Requires
by
Matej Drame
by
Marko Kuhar
export
exporting
v0.1.3
0.1.3.0
Export tools
Sources
Download
The Requires
The Development Requires
by
Matej Drame
by
Marko Kuhar
export
exporting
v0.1.2
0.1.2.0
Export tools
Sources
Download
The Requires
The Development Requires
by
Matej Drame
by
Marko Kuhar
export
exporting
v0.1.1
0.1.1.0
Export tools
Sources
Download
The Requires
The Development Requires
by
Matej Drame
by
Marko Kuhar
export
exporting
v0.1
0.1.0.0
Export tools
Sources
Download
The Requires
The Development Requires
by
Matej Drame
by
Marko Kuhar
export
exporting