X-Git-Url: https://jasonwoof.com/gitweb/?p=wfpl.git;a=blobdiff_plain;f=csv.php;h=a5da6abd53af04ca38d4609eefe6c66994915021;hp=f9e311a517ccab955e0e10fe50dbb174de756cd0;hb=912bdab05d6262ab07e7ea6664192f97239db3e1;hpb=24b62ea46a5cd87139364d7291eaf78dbb284aeb

diff --git a/csv.php b/csv.php
index f9e311a..a5da6ab 100644
--- a/csv.php
+++ b/csv.php
@@ -1,10 +1,15 @@
 <?php
 
-# This file generates what Excell refers to as "CSV" files. This format makes
-# little sense, and does not actually have anything to do with commas.
+# This program is in the public domain within the United States. Additionally,
+# we waive copyright and related rights in the work worldwide through the CC0
+# 1.0 Universal public domain dedication, which can be found at
+# http://creativecommons.org/publicdomain/zero/1.0/
+
+# These functions redutrn a csv download which is hopefully easy to import into
+# Excell and LibreOffice Calc
 
 # pass in a 2d array (array of rows) and it'll send it to the browser
-# I can't figure out how to get multi-line fields to work, so replace newlines with 4 spaces.
+# I can't figure out how to get multi-line fields to work, so this replaces newlines with 4 spaces.
 function array2d_to_csv_download($data, $filename) {
 	header('Content-type: application/csv'); 
 	header('Content-Disposition: attachment; filename=' . $filename); 
@@ -14,7 +19,7 @@ function array2d_to_csv_download($data, $filename) {
 			if($first) {
 				$first = false;
 			} else {
-				echo "\t";
+				echo ",";
 			}
 			echo '"' . str_replace("\n", "    ", str_replace('"', '""', $el)) . '"';
 		}
@@ -22,3 +27,22 @@ function array2d_to_csv_download($data, $filename) {
 	}
 	exit();
 }
+
+# pass an array of associative arrays. keys from the first one will be used
+# see arary2d_to_csv_download above for more details
+function assocs_to_csv_download($data, $filename) {
+	if(count($data) < 1) {
+		$flats = array();
+	} else {
+		$flats = array(array_keys($data[0]));
+		$keys =& $flats[0];
+		foreach($data as $row) {
+			$flat = array();
+			foreach($keys as $k) {
+				$flat[] = $row[$k];
+			}
+			$flats[] = $flat;
+		}
+	}
+	array2d_to_csv_download($flats, $filename);
+}