A couple of months ago I downloaded a CSV file from Google containing the stats of my sites. I decided to turn it into an HTML table using PHP. Here's how it's done:
<?php $csv = fopen('top-search-queries.csv', 'r') or die ("Can't open file."); echo '<table border="1" cellspacing="2" cellpadding="3">' . "\n"; while($csv_line = fgetcsv($csv)) { echo "<tr>\n"; for($i = 0, $j = count($csv_line); $i < $j; $i++) { echo '<td>' . htmlentities($csv_line[$i]) . '</td>' . "\n"; } echo "</tr>\n"; } echo "</table>\n"; fclose($csv) or die("Can't close file"); ?>
I used the fgetcsv()
function to parse the CSV file line by line. It's a really straightforward function, but it's very useful in cases like this.