Problems with using PHP to display CSV file as HTML table

Question

I'm trying to display a two column, four row CSV file in an HTML table. I have the code below, but it only displays the first row and I don't understand why.

<html>
<head>
    <title>test</title>
</head>
<body>
    <table border=1>
        <?PHP
        $file_handle = fopen("oee1.csv", "r");
        while (!feof($file_handle) ) {
            $line_of_text = fgetcsv($file_handle, 1024);
            echo '<tr><td>' . $line_of_text[0] . '</td><td>' . $line_of_text[1] . '</td></tr>';
        }  
        fclose($file_handle);
        ?>
    </table>
</body>
</html>

The csv file looks like:

test1, 1
test2, 2
test3, 3
test4, 4

I don't know the exact answer, but I do know that the example on fgetcsv doesn't use feof at all, but just checks the return value of fgetcsv itself. — GolezTrol
– GolezTrol, Commented Mar 10, 2014 at 15:25
change fgetcsv($file_handle, 1024); to fgetcsv($file_handle, 1024,","); — kraysak
– kraysak, Commented Mar 10, 2014 at 15:27

0x_Anakin · Accepted Answer · 2014-03-10 16:03:45Z

3

You were not iterating through every line. Try something like this:

<!DOCTYPE html>
<html>
    <head>
        <title>+test</title>
    </head>
    <body>
        <?php
            if (($file_handle = fopen("data.csv", "r")) !== false) {
                $str = '';
                $str .= '<table>';
                while (($data = fgetcsv($file_handle, 1024, ",")) !== false) {
                    $str .= '<tr>';
                    foreach ($data as $key => &$value) {
                        $str .= "<td>$value</td>";
                    }
                    $str .= '</tr>';
                }
                fclose($file_handle);
                $str .= '</table>';
                echo $str;
            }
        ?>
    </body>
</html>

output:

<table>
    <tbody>
        <tr>
            <td>test1</td>
            <td>1</td>
        </tr>
        <tr>
            <td>test2</td>
            <td>2</td>
        </tr>
        <tr>
            <td>test3</td>
            <td>3</td>
        </tr>
        <tr>
            <td>test4</td>
            <td>4</td>
        </tr>
    </tbody>
</table>

PS: make sure you have priviledges and your csv is in the smae directory as your php file.

Reference : fgetcsv

edited Mar 10, 2014 at 16:03

answered Mar 10, 2014 at 15:31

0x_Anakin

3,2695 gold badges51 silver badges90 bronze badges

That doesn't seem to do it (although I may be putting the code in the wrong place or not closing brackets properly - I'll keep trying!)

beth
– beth

03/10/2014 15:40:21
Commented Mar 10, 2014 at 15:40
can you provide any sample data?

0x_Anakin
– 0x_Anakin

03/10/2014 15:45:37
Commented Mar 10, 2014 at 15:45
question updated with example of csv file (not using real data for now)

beth
– beth

03/10/2014 15:51:46
Commented Mar 10, 2014 at 15:51
For some reason this gives me all my data in one row. I think it must be to do with the way new lines are marked in my csv file but I don't really understand why!

beth
– beth

03/10/2014 16:17:57
Commented Mar 10, 2014 at 16:17
in this case use ini_set('auto_detect_line_endings',TRUE); read about it on the link i provided

0x_Anakin
– 0x_Anakin

03/10/2014 16:19:41
Commented Mar 10, 2014 at 16:19

| Show 1 more comment

in need of help · Accepted Answer · 2014-03-10 15:29:28Z

0

try adding a call to fgets($file_handle); in each iteration of the loop, you have to advance the file handle pointer somehow.

answered Mar 10, 2014 at 15:29

in need of help

1,62214 silver badges28 bronze badges

sorry, could you elaborate what you mean by this please?

beth
– beth

03/10/2014 15:31:30
Commented Mar 10, 2014 at 15:31

Add a comment |

Collectives™ on Stack Overflow

Problems with using PHP to display CSV file as HTML table

2 Answers 2

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Your Answer

Sign up or log in

Post as a guest

Related