Download the PHP package agoussec/phpdbtabletoexcel without Composer
On this page you can find all versions of the php package agoussec/phpdbtabletoexcel. It is possible to download/install these versions without Composer. Possible dependencies are resolved automatically.
Download agoussec/phpdbtabletoexcel
More information about agoussec/phpdbtabletoexcel
Files in agoussec/phpdbtabletoexcel
Package phpdbtabletoexcel
Short Description Create Excel sheet directly from database table rows
License GPL-3.0-only
Informations about the package phpdbtabletoexcel
PHPDBTabletoExcel
Create Excel sheet directly from database table's rows
Getting Started
PHPDBTabletoExcel is a very simple and easy to use PHP package for generating Excel file from database table SQL query.
It can connect to a database using PDO and executes a given SQL database table query.
The class executes the query and then outputs the results to a file in HTML table based format that is served for download and can be read and imported correctly by Microsoft Excel.
Prerequisites
No requirements for now!
Installing
Install using composer
Create Object of Class and start using it directly by adding in your project files if autoload is enabled, if not then include class file in your project.
Usage Example
Way 1 for initializing database connection
You can pass database credentials while creating object of class.
Way 2 for initializing database connection
Create PDO connection and pass PDO object to method
Set SQL Query
Set table rows (optional)
Exported File Name (optional)
Header row in exported excel sheet (optional)
Time Stamp (optional)
And at last get the Excel file -
Authors
- Shamsh Pravez - Initial work - agoussec
License
This project is licensed under the GNU General Public License v3.0 - see the LICENCE file for details