• code snippets
  • all code snippets/
  • popular code snippets/
  • your code snippets
• extras
• blog
• about snipplr

• Big /
• Small

Posted By

rodrigo on 08/09/08

Tagged

mysql class php db array php5 csv reports resulset

Versions (?)

08/14/08 03:54am08/09/08 04:35pm

Who likes this?

1 person have marked this snippet as a favorite

romanos

 / Published in: PHP

 

URL: http://reactor.cl

<?php
 
/* Usage:
/*
/* $report = new Reports_Core; (In Kohana just new Reports;)
/* print $report->csv($result_set_or_array, 'a title', ';');
/*
/*--------------------------------------------------------------*/
 
class Reports_Core
{
	function csv($lines = FALSE, $title = '', $delimiter = ';')
	{
		$output = '';
                if($title) $output .= $title."\n";
 
		if($lines)
		{
			$report_line = array();
 
			foreach($lines as $line)
			{
				$line = implode($delimiter, (array) $line);
				$report_line[] = $line."\n";
			}
 
			$output .= implode('', $report_line);
 
                        return $output;
		}
		else
		{
			trigger_error('There is no data to generate a CSV report.', E_USER_ERROR);
		}
 
	}
}
 
?>

Report this snippet   Tweet

Comments

Subscribe to comments

Posted By: rodrigo on August 9, 2008

Real world usage:

php

...

header('Content-type: text/csv'); header('Content-disposition: attachment; filename="report_'.$this->person->name.'.csv"');

$historic = $this->reports->gethistoric($person->id, Utils::getdate()); // Get historic resultset view from DB where date is provided by helper Utils method get_date();

print Reports::csv($historic);

Posted By: rodrigo on August 14, 2008

Actually you should replace if($title) echo $title."\n"; for something like if($title) $output = $title."\n"; and instead of return implode... $output .= implode... and then return all together.