PHP Classes

File: sql2excel_example1.php

Recommend this page to a friend!
  Classes of Erh-Wen,Kuo   sql2excel   sql2excel_example1.php   Download  
File: sql2excel_example1.php
Role: Example script
Content type: text/plain
Description: This is anoter demo of 'sql2excel'.
Class: sql2excel
Easy way to stream Mysql sql content to Excel.
Author: By
Last change:
Date: 20 years ago
Size: 1,021 bytes


Class file image Download
     * @version V1.0 2002/July/18 (c) Erh-Wen,Kuo ( 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.
//the query string you want to show
$query="Select * From employees";
//setup parameters for initiating Sql2Excel class instance
    //modify your mysql connection parameters & database name below:
//initiating Sql2Excel class instance
$excel=new Sql2Excel($db_host,$db_user,$db_pwd,$db_dbname);
//Output excel file to user's browser
"<h1>Exel Generate Completed!!</h1>";