Example of a complex csv view file about cakephp-csvview HOT 2 CLOSED

// app/Views/Posts/csv/index.ctp
$header = array('id' => '#', 'title' => 'Title', 'body' => 'Body', 'author' => 'Author(s)');

echo implode(',', $header)."\n"; // print header

foreach ($posts as $post):
	$row = [];
	foreach ($header as $key => $val) {
		if (array_key_exists($key, $post['Post'])) {
			$row[$key] = '"' . preg_replace('/"/','""',$application['Application'][$key]) . '"';
		} 
		elseif ($key == 'author') { //assuming post hasMany authors			
			foreach ($post['Author'] as $author) {
				(isset($row[$key])) ? $row[$key] .= '; '.$author['name'] : $row[$key] = $author['name'];
			}
			(isset($row[$key])) ? $row[$key] = '"' . preg_replace('/"/','""',$row[$key]) . '"' : $row[$key] = '""';
		} 
	}
	echo implode(',', $row) . "\n";
endforeach;