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 View files (4)   DownloadInstall with Composer Download .zip   Reputation   Support forum   Blog (1)    
Last Updated Ratings Unique User Downloads Download Rankings
2023-07-03 (7 months ago) RSS 2.0 feedNot yet rated by the usersTotal: 164 All time: 8,898 This week: 75Up
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: 3 packages by
Country: Indonesia Indonesia
Age: ???
All time rank: 382563 in Indonesia Indonesia
Week rank: 42 Up2 in Indonesia Indonesia Up

  Files folder image Files  
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

 Version Control Unique User Downloads Download Rankings  
 100%
Total:164
This week:0
All time:8,898
This week:75Up