<?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>";
?>