PHP Classes

File: src/demo/index.php

Recommend this page to a friend!
  Classes of shamsh parvez  >  PHP Export Table to Excel  >  src/demo/index.php  >  Download  
File: src/demo/index.php
Role: Example script
Content type: text/plain
Description: Example script
Class: PHP Export Table to Excel
Generate Excel file from database table SQL query
Author: By
Last change:
Date: 1 year ago
Size: 5,688 bytes
 

Contents

Class file image Download
<?php

require_once '../class/Excel.php';

use
agoussec\class\Export;
$export = new Export();



/********************************************************************************************************|
 * WAY 1 FOR CREATING DATABASE CONNECTIONS |
 *_______________________________________________________________________________________________________|
 *
 *
 * $exportObject = new Export('localhost', 'dbuser', 'password', 'database');
 *
 *
 * EXPLAIN - PASS DATABASE CREDENTIALSE AS PARAMETER WHEN CREATING OBJECT OF CLASS
 *
 */


/********************************************************************************************************|
 * WAY 2 FOR CREATING DATABASE CONNECTIONS |
 *_______________________________________________________________________________________________________|
 *
 *
 * try {
 * $Conn = new PDO('mysql:host=localhost;dbname=dbname', 'dbuser', "dbpassword");
 * $Conn->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
 * } catch(PDOException $e) {
 * return $e->getMessage();
 * }
 *
 *
 * $export->setConnection($Conn);
 *
 *
 * EXPLAIN - CREATE PDO CONNECTION AND PASS PDO CONNECTION OBJECT TO setConnection($CONNECTION) LIKE ABOVE
 *
 */


       
try {
           
$Conn = new PDO('mysql:host=localhost;dbname=dbname', 'dbuser', "dbpassword");
           
$Conn->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
        } catch(
PDOException $e) {
            return
$e->getMessage();
        }
       
$export->setConnection($Conn);

if (isset(
$_REQUEST["export"])) {

   
$sql = "SELECT
                table2.column1 as `Column 1 `,
                table3.column2 as `Column 2`,
                table1.column3 as `Column 3`,
                table1.column4 as `Column 4`,
                table1.column5 as `Column 5`,
                table1.column6 as `Column 6`,
                table1.column7 as `Column 7`,
                table1.column8 as `Column 8`,
                table1.column9 as `Column 9`
            FROM `table1`
            left JOIN table2 ON table2.id = table1.table2id
            left JOIN table3 ON table3.id = table1.table3id
            WHERE table1.status = 1"
;
          
                   
   
$export->setQuery($sql);

   
/********************************************************************************************************|
    * EXPLANATION - DATA [OPTIONAL] |
    *________________________________________________________________________________________________________|
    *
    * $export->setData($ARRAY); // OPTIONAL
    *
    * DEF - ROWS OF DATABASE TABLE DATA IN ARRAY
    *
    * EXPLAIN - YOU CAN DIRECTLY PASS DATABASE TABLE ROWS AND THEN NO NEED TO CREATE DATABASE CONNECTION AND PASSING MYSQL QUERIES
    *
    * PARAM - $ROWARRA
    *
    * EXMAPLE -
    * $export->setData('dsdada'); // ERROR - Data should be Array!
    * $export->setData(); // ERROR - Data can not be empty!
    */
   



   

    /********************************************************************************************************|
    * EXPLANATION - FILENAME [OPTIONAL] |
    *________________________________________________________________________________________________________|
    *
    * $export->setFilename('setFilename'); // OPTIONAL
    *
    * DEF - FILENAME OF GENERATED EXCEL FILE (CURRENT TIMESTAMP WILL BE USER WHEN NOT INITIALISING)
    *
    * EXPLAIN - THIS METHOD WILL ACCEPT STRING DATA TYPE AS PARAMETER
    *
    * PARAM - 'FILENAME'
    *
    */
   
$export->setFilename('report-excel');

       
   
/*******************************************************************************************************|
    * EXPLANATION - HEADERROW [OPTIONAL] |
    *_______________________________________________________________________________________________________|
    *
    * $export->setHeaderRow(true); // OPTIONAL
    *
    * DEF - HEADERROW IS COLUMNS NAME OF EXCEL SHEET ORIGINATED FROM DATABASE TABLE COLUMN NAME
    *
    * EXPLAIN - THIS METHOD WILL ACCEPT BOOLEAN DATA TYPE AS PARAMETER
    *
    * PARAM - [TRUE, FALSE]
    *
    * TRUE - FOR ADD DATABASE TABLE COLUMN NAME IN EXCEL SHEET (YOU CAN REDEFINE COULUMN NAME USING ALIASE NAME SELECT SQL QUERY )
    * FALSE - FOR NOT USING COULUMN NAME IN EXCEL SHEET
    *
    */

   
$export->setHeaderRow(true);


   
/*******************************************************************************************************|
    * EXPLANATION - TIMESTAMP [OPTIONAL] |
    *_______________________________________________________________________________________________________|
    *
    * $export->setTimestamp(true); // OPTIONAL
    *
    * DEF - CURRENT TIMESTAMP WILL BE ADDED IN EXCEL FILENAME
    *
    * EXPLAIN - THIS METHOD WILL ACCEPT BOOLEAN DATA TYPE AS PARAMETER
    *
    * PARAM - [TRUE, FALSE]
    *
    * TRUE - FOR USING TIMESTAMP IN FILENAME // report-excel-1616836723.xls
    * FALSE - FOR NOT USING TIMESTAMP IN FILENAME // report-excel.xls
    *
    */
   
$export->setTimestamp(true);
   
$export->getFile();
}

For more information send a message to info at phpclasses dot org.