PHP MYSQL

EXPORT MYSQL TO EXCEL IN PHP

(a quick example)

DOWNLOAD PHPSPREADSHEET

01

Open terminal, navigate to project folder, run composer require phpoffice/phpspreadsheet.

Composer will download the latest version into vendor folder.

CONNECT TO DATABASE $pdo = new PDO("mysql:host=HOST; dbname=NAME;charset=utf8mb4", USER, PASSWORD);

EXPORT MYSQL TO EXCEL (A)

02

LOAD PHPSPREADSHEET require "vendor/autoload.php"; use PhpOffice\PhpSpreadsheet\         Spreadsheet; use PhpOffice\PhpSpreadsheet\         Writer\Xlsx;

EXPORT MYSQL TO EXCEL (B)

03

CREATE SPREADSHEET $ss = new Spreadsheet(); $as = $ss->getActiveSheet();

FETCH DATA $stmt = $pdo->prepare ( "SELECT * FROM TABLE"); $stmt->execute();

WRITE TO SPREADSHEET $i = 1; while ($r = $stmt->fetch()) {   $as->setCellValue("A$i", $r["COL"]);   $as->setCellValue("B$i", $r["COL"]);   $i++; }

EXPORT MYSQL TO EXCEL (C)

04

SAVE FILE $writer = new Xlsx($ss); $writer->save("EXPORT.xlsx");