PHP Classes

PHP Export MySQL Query to Excel: Download an Excel file from MySQL query results

Recommend this page to a friend!
     
  Info   View files Files   Install with Composer Install with Composer   Download Download   Reputation   Support forum   Blog    
Ratings Unique User Downloads Download Rankings
Not enough user ratingsTotal: 173 All time: 8,807 This week: 39Up
Version License PHP version Categories
php-excel-data-extra 1.0.0The PHP License5PHP 5, Databases, Files and Folders
Description 

Author

This package allows users to download an Excel file from MySQL query results.

It provides a script to connect to a MySQL database server and execute a given SQL query.

The script outputs an HTML table with HTTP response headers that make the browsers interpret the HTTP response as an Excel document and can make the browser open the Excel application available on the user's computer.

Picture of ganesh kavhar
Name: ganesh kavhar <contact>
Classes: 4 packages by
Country: Indonesia Indonesia

 

  Files folder image Files (4)  
File Role Description
Accessible without login Plain text file config.php Conf. Configuration values to access the MySQL database
Accessible without login Plain text file empdata.sql Data Auxiliary data
Accessible without login Plain text file genrate-excel.php Appl. Output an Excel file for download from database query results
Accessible without login Plain text file index.php Aux. Auxiliary script

The PHP Classes site has supported package installation using the Composer tool since 2013, as you may verify by reading this instructions page.
Install with Composer Install with Composer
 Version Control Unique User Downloads Download Rankings  
 100%
Total:173
This week:0
All time:8,807
This week:39Up