Posted By

jorisros on 02/18/11

Tagged

Versions (?)

Last Edited at 02/18/11 12:47am

Statistics

Viewed 1294 times

Favorited by 0 user(s)

Related snippets

Save persons as csv example

/ Published in: PHP

Expand | Embed | Plain Text

Copy this code and paste it in your HTML

<?php
 
$arrPerson['name'] = 'Piet';
$arrPerson['lastname'] = 'Janse';
$arrPerson['address'] = 'Thuisstraat 35';
$arrPerson['zipcode'] = '1111AA';
$arrPerson['email'] = '[email protected]';
 
$arrPersons[] = $arrPerson;
 
$arrPerson['name'] = 'Jan';
$arrPerson['lastname'] = 'Slagerszoon';
$arrPerson['address'] = 'Straat 135';
$arrPerson['zipcode'] = '1111AA';
$arrPerson['email'] = '[email protected]';
 
$arrPersons[] = $arrPerson;
 
 
$strCSV = '';
 
//Create titles from first record
if(is_array($arrPersons[0]))
{
	foreach($arrPersons[0] as $strField => $strValue)
	{
		$arrColomns[] = $strField;
	}
}
$strCSV .= "'".implode("','", $arrColomns)."'
";
 
 
//fill rows
if(is_array($arrPersons))
{
	$strRows = '';
 
	foreach($arrPersons as $arrPerson)
	{
 
		if(is_array($arrColomns))
		{
			$i = 0;
			$arrRow = array();
 
			foreach($arrColomns as $strColomn)
			{
				$arrRow[] = $arrPerson[$strColomn];
			}
			$strCSV  .= "'".implode("','",$arrRow)."'
";
 
		}
	}
}
 
header("Content-type: application/octet-stream");
header("Content-Disposition: attachment; filename=\"persons.csv\"");
echo $strCSV;