Gecko [ thearyasamaj.org ]

Name	Size	Permission
10-09-2020-AG-arya_adminconnec...	1.59 KB	-rw-r--r--
arya_addadminusercategory.php	588 B	-rw-r--r--
arya_adminconnection.php	2.25 KB	-rw-r--r--
arya_adminconnection_29-07-22-...	1.62 KB	-rw-r--r--
arya_adminfunction.php	89.87 KB	-rw-r--r--
arya_ajaxLanguageChange.php	148 B	-rw-r--r--
arya_ajaxactiveinactive.php	405.2 KB	-rw-r--r--
arya_ajaxtestmark.php	576 B	-rw-r--r--
arya_fetcheventicon.php	513 B	-rw-r--r--
arya_fetchwallpaper.php	479 B	-rw-r--r--
arya_findcity.php	684 B	-rw-r--r--
arya_findcountry.php	673 B	-rw-r--r--
arya_findfromdate_todate.php	1.96 KB	-rw-r--r--
arya_findstate.php	638 B	-rw-r--r--
arya_fnd_adminusercatrights_aj...	1.95 KB	-rw-r--r--
arya_fnd_articlesnm_ajax.php	635 B	-rw-r--r--
arya_fnd_city_ajax.php	738 B	-rw-r--r--
arya_fnd_city_instajax.php	846 B	-rw-r--r--
arya_fnd_date_ajax.php	223 B	-rw-r--r--
arya_fnd_date_year.php	240 B	-rw-r--r--
arya_fnd_event_ajax.php	827 B	-rw-r--r--
arya_fnd_eventdate_ajax.php	1.71 KB	-rw-r--r--
arya_fnd_freqdate_ajax.php	5.96 KB	-rw-r--r--
arya_fnd_imagesize_ajax.php	1.26 KB	-rw-r--r--
arya_fnd_month_ajax.php	240 B	-rw-r--r--
arya_fnd_moondate_ajax.php	337 B	-rw-r--r--
arya_fnd_obituarycity_ajax.php	611 B	-rw-r--r--
arya_fnd_obituarystate_ajax.ph...	625 B	-rw-r--r--
arya_fnd_pendinglist_ajax.php	807 B	-rw-r--r--
arya_fnd_personnm_ajax.php	671 B	-rw-r--r--
arya_fnd_placenm_ajax.php	672 B	-rw-r--r--
arya_fnd_post_ajax.php	626 B	-rw-r--r--
arya_fnd_quecatnm_ajax.php	576 B	-rw-r--r--
arya_fnd_servicesnm_ajax.php	564 B	-rw-r--r--
arya_fnd_sessionstartdate.php	2.97 KB	-rw-r--r--
arya_fnd_sliderhomeenddate_aja...	2.19 KB	-rw-r--r--
arya_fnd_state_ajax.php	742 B	-rw-r--r--
arya_fnd_thirddate_ajax.php	974 B	-rw-r--r--
arya_fndaprvornot.php	3.13 KB	-rw-r--r--
arya_fndquckupldaprv.php	321 B	-rw-r--r--
arya_fndreportapprove.php	299 B	-rw-r--r--
arya_fndreportaprornot.php	1.75 KB	-rw-r--r--
arya_globlang_ajax.php	1010 B	-rw-r--r--
arya_loginstatusajax.php	1.45 KB	-rw-r--r--
arya_paginationlimit.php	1.87 KB	-rw-r--r--
arya_removeimage.php	2.46 KB	-rw-r--r--
arya_sessioncheck.php	214 B	-rw-r--r--
excelwriter.class.php	6.2 KB	-rw-r--r--
variable.php	477 B	-rw-r--r--

Code Editor : excelwriter.class.php

<?php
	
	 /*
	 * Class is used for save the data into microsoft excel format.
	 * It takes data into array or you can write data column vise.
	 */

Class ExcelWriter
	{
			
		var $fp=null;
		var $error;
		var $state="CLOSED";
		var $newRow=false;
		
		/*
		* @Params : $file  : file name of excel file to be created.
		* @Return : On Success Valid File Pointer to file
		* 			On Failure return false	 
		*/
		 
		function ExcelWriter($file="")
		{
			return $this->open($file);
		}
		
		/*
		* @Params : $file  : file name of excel file to be created.
		* 			if you are using file name with directory i.e. test/myFile.xls
		* 			then the directory must be existed on the system and have permissioned properly
		* 			to write the file.
		* @Return : On Success Valid File Pointer to file
		* 			On Failure return false	 
		*/
		function open($file)
		{
			if($this->state!="CLOSED")
			{
				$this->error="Error : Another file is opend .Close it to save the file";
				return false;
			}	
			
			if(!empty($file))
			{
				$this->fp=@fopen($file,"w+");
			}
			else
			{
				$this->error="Usage : New ExcelWriter('fileName')";
				return false;
			}	
			if($this->fp==false)
			{
				$this->error="Error: Unable to open/create File.You may not have permmsion to write the file.";
				return false;
			}
			$this->state="OPENED";
			fwrite($this->fp,$this->GetHeader());
			return $this->fp;
		}
		
		function close()
		{
			if($this->state!="OPENED")
			{
				$this->error="Error : Please open the file.";
				return false;
			}	
			if($this->newRow)
			{
				fwrite($this->fp,"</tr>");
				$this->newRow=false;
			}
			
			fwrite($this->fp,$this->GetFooter());
			fclose($this->fp);
			$this->state="CLOSED";
			return ;
		}
		/* @Params : Void
		*  @return : Void
		* This function write the header of Excel file.
		*/
		 							
		function GetHeader()
		{
			$header = <<<EOH
				<html xmlns:o="urn:schemas-microsoft-com:office:office"
				xmlns:x="urn:schemas-microsoft-com:office:excel"
				xmlns="http://www.w3.org/TR/REC-html40">

<head>
				<meta http-equiv=Content-Type content="text/html; charset=us-ascii">
				<meta name=ProgId content=Excel.Sheet>
				
				<style>
				
				</style>
				
				</head>

<body link=blue vlink=purple>
				<table x:str border=0 cellpadding=0 cellspacing=0 style='border-collapse: collapse;table-layout:fixed;'>
EOH;
			return $header;
		}

/*
		* @Params : Void
		* @Return : Void
		*/
		function writeRow()
		{
			if($this->state!="OPENED")
			{
				$this->error="Error : Please open the file.";
				return false;
			}	
			if($this->newRow==false)
				fwrite($this->fp,"<tr>");
			else
				fwrite($this->fp,"</tr><tr>");
			$this->newRow=true;	
		}

/*
		* @Params : $value : Coloumn Value
		* @Return : Void
		*/
		function writeCol($value)
		{
			if($this->state!="OPENED")
			{
				$this->error="Error : Please open the file.";
				return false;
			}	
			fwrite($this->fp,"<td class=xl24 width=64 >$value</td>");
		}
	}
?>

${this.title}

Code Editor : excelwriter.class.php