current community

your communities

more stack exchange communities

Stack Exchange
tour help
careers 2.0
Take the 2-minute tour ×
Stack Overflow is a question and answer site for professional and enthusiast programmers. It's 100% free, no registration required.
up vote 1 down vote favorite

This is a totally experimental question, but if answered it will save me hours of manual HTML mark up.

In theory it should work, but can appreciate advice if I'm talking rubbish.

I need a loop to pull column data from columns in a CSV spreadsheet, and echo them in HTML mark up.

I can't write PHP but this is how I envisage the loop work...

<?php

    // here it needs to load the CSV file and get the column data and output them as variables (I guess)

echo <div id="interactive-map">

    // here a loop needs to begin to output this line off HTML...
    // with the arrayed variables...

<div id="[varible-1]" class="[varible-2]" title="[varible-3]"><span>[varible-3]</span></div>

    // loop finished once no more rows left in CSV

echo </div>

?>

So the result should look like this...

<div id="interactive-map">

    <div id="1" class="free" title="Uber"><span>Uber</span></div>
    <div id="2" class="free" title="Howdy"><span>Howdy</span></div>
    <div id="3" class="free" title="Love"><span>Love</span></div>
    <div id="4" class="free" title="Gimme"><span>Gimme</span></div>
    <div id="5" class="free" title="Totally"><span>Totally</span></div>
    <div id="6" class="free" title="Spank"><span>Spank</span></div>

</div>

The CSV files looks like this...

Any help or advice would be TRULY amazing! Thanks

// UPDATE BELOW FOLLOWING FIRST ANSWER

My CSV below viewed as text...

id,class,name
1,free,Uber
2,free,Howdy
3,free,Love
4,free,Gimme
5,free,Totally
6,free,Spank

The PHP below...

    <?php

        $file = fopen('file.csv', 'r');
        $fields = array();

        if ($file) {
        while (($data = fgetcsv($file)) !== false) {

            if(empty($fields)) {
                $fields = $data;
                    continue;
                }


            $row = array_combine($fields, $data);

            $output = sprintf("% is ID, % is CLASS, % is NAME",
                $row['id'],
                $row['class'],
                $row['name']);

            echo $output;

            }

        fclose($file);
    }

?>

It's not quite working properly, what am I doing wrong?

With regards to adding the HTML, I put the mark up inside where the echoed text is and it gets confused :-/

It is echoing stuff but not the desired info from the csv.

share|improve this question

1 Answer 1

up vote 2 down vote accepted

To read the file, the easiest is to use the built-in fgetcsv in a loop. You can cook up your own parsing code, but it's really thankless work to make it behave correctly in the presence of field delimiters and escaped characters.

After reading the names of the CSV fields (first iteration) and their values for each row (subsequent iterations), you can use sprintf or vsprintf to easily construct an HTML string to output.

For example:

$file = fopen('php://stdin', 'r'); // or open any other file you want
$fields = array(); // this holds the name of the fields, read from the 1st row

if ($file) {
    while (($data = fgetcsv($file)) !== false) {
        // If this is the first row, we assume it holds field names.
        // So just remember what they are and loop to the next.
        if(empty($fields)) {
            $fields = $data;
            continue;
        }

        // Subsequent rows are assumed to contain data.
        // array_combine associates the data in the current row with the field
        // names from the first row, allowing us to refer to them using those
        // names and be independent of the order the fields appear in the input.
        $row = array_combine($fields, $data);

        // Format output conveniently with sprintf
        $output = sprintf("%s is %d years old.\n",
                          $row['name'],
                          $row['age']);
        echo $output;
    }
    fclose($file);
}

See it in action.

share|improve this answer
    
Thank you so much for this - it does seem to work, but I can only get one column to pull in and array - please see my update above if you could help me solve the last hurdle.. –  Joshc Oct 19 '11 at 15:21
    
@user801773: You have the sprintf format string wrong (there's nothing after the %s). You need something like "%d is ID, %s is CLASS, %s is NAME\n". See the sprintf documentation for info on format strings. –  Jon Oct 19 '11 at 21:55
    
I would just like to thank you Jon, you have seriously save me hours of manual coding. Works a beaut!!!! I wonder... can this be connected to google fusion tables? –  Joshc Oct 27 '11 at 17:51
    
This is just come in handy again! –  Joshc Nov 14 '13 at 10:02

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.