Reply to comment

This is a snippet of code that I had posted on another of my websites and in doing some cleanup it really fits better here.

I spent last evening working on a Comma Separated Values (CSV) list of titles for a project I'm working on. Below is a snippet of code I worked with. The first method from the PHP Cookbook suggests using fgetcsv(). That woks pretty well but the native function in PHP doesn't handle values (fields) that contain separators (commas) very well and doesn't have the concept of multiple values being delimited by a different delimiter within a field. So I whipped up the parser that comes second in the example below.

<?php
$fp = fopen('filename','r') or die("can't open file");
print "<table border=\"1\">\n";
while($csv_line = fgetcsv($fp,1024, ",", "\"")) {
    print '<tr>';
    for ($i = 0, $j = count($csv_line); $i < $j; $i++) {
        print '<td>'. str_replace (";\"", "<br />", $csv_line[$i]).'</td>';
    }
    print "</tr>\n";
}
print '</table>\n';*/
fclose($fp) or die("can't close file");
$bas = file_get_contents ('filename');
print "<table border=\"1\">\n";
$lines = explode("\n", $bas);
foreach ($lines as $line) {
    print'<tr>';
    $line = ltrim($line, "\"");
    $line = rtrim($line, "\"");
    $line = rtrim($line);
    $out = str_replace("\";\"", "<br />", $line);
    $out = str_replace("\",\"", "</td><td>", $out);
    print '<td>' . $out . '</td>';
        print "</tr>\n";
};
print '</table>\n';
?>

AddingUnderstanding

CSV Parser for PHP

Reply

Search

Recent Reads

Recent comments