Login   Register  
PHP Classes
elePHPant
Icontem

File: sql2excel_example2.php

Recommend this page to a friend!
Stumble It! Stumble It! Bookmark in del.icio.us Bookmark in del.icio.us
  Classes of Erh-Wen,Kuo  >  sql2excel  >  sql2excel_example2.php  >  Download  
File: sql2excel_example2.php
Role: Example script
Content type: text/plain
Description: This is another demo for 'sql2excel' class.
Class: sql2excel
Easy way to stream Mysql sql content to Excel.
Author: By
Last change:
Date: 12 years ago
Size: 1,086 bytes
 

Contents

Class file image Download
<?php
    
/* 
     * @version V1.0 2002/July/18 (c) Erh-Wen,Kuo (erhwenkuo@yahoo.com). All rights reserved.
     * Released under both BSD license and Lesser GPL library license. 
     * Whenever there is any discrepancy between the two licenses, 
     * the BSD license will take precedence. 
     *
     * purpose: This is a example how to use "sql2excel" class to write mysql sql content
     *          to excel file format and stream the output to user's browser directly.
     */
     
    
include_once('sql2excel.class.php');
        
    
//the query string you want to show
    
if(!isset($query)){
        
$query="Select * From employees";
    }else{
        
$query=urldecode($query);
    }
    
    
//setup parameters for initiating Sql2Excel class instance
    //modify your mysql connection parameters & database name below:
    
$db_host="localhost";
    
$db_user="";
    
$db_pwd="";
    
$db_dbname="xcompany";
    
    
//initiating Sql2Excel class instance
    
$excel=new Sql2Excel($db_host,$db_user,$db_pwd,$db_dbname);
    
//Output excel file to user's browser
    
$excel->ExcelOutput($query);
    echo
"<h1>Exel Generate Completed!!</h1>";
?>