Proper displaying of csv file data in table if some fields are empty

Question

I want to display a .csv file neatly in a table using php. Some content of the file are empty field.

Here is my first approach, got an error but displaying the datas in one row. Supposedly they should display in their respectively fields.

The code output here:

Should be like this:

<table border = "1">
        <tr>
            <th>NAME</th>
            <th>Email</th>
            <th>Address</th>        
            <th>Payment</th>
            <th>Datepaid</th>
        </tr>
        <?php
          $data = file("data/payment.csv");
          foreach ($data as $line){
          $lineofarray = explode("\t", $line);
          list($name, $email, $address, $payment, $datepaid) = $lineofarray;//error here
        ?>
        <tr>
            <td>
                <?= $name?>
            </td>
            <td>
                <?= $email?>
            </td>
            <td>
                <?= $address?>
            </td>
            <td>
                <?= $payment?>
            </td>

            <td>
                <?= $datepaid?>
            </td>


        </tr>
        <? }?>
</table>

My code now had an error on the part of list. And displaying the datas in one field. Hope you can help me. Thanks

try this stackoverflow.com/questions/518795/…

JYoThI
– JYoThI

2016-06-09 03:55:33 +00:00
Commented Jun 9, 2016 at 3:55 — JYoThI
– JYoThI, Commented Jun 9, 2016 at 3:55

phreakv6 · Accepted Answer · 2016-06-09 03:59:57Z

3

Please try this.

$fp = fopen("data/payment.csv", "r");
while (($line = fgetcsv($fp)) !== false) {
        echo "<tr>";
        foreach ($line as $field) {
                echo "<td>" . htmlspecialchars($field) . "</td>";
        }
        echo "</tr>\n";
}

This is a safe way to read csv lines as it is unicode safe and also supports fields that are wrapped in double quotes.

answered Jun 9, 2016 at 3:59

phreakv6

2,1651 gold badge11 silver badges11 bronze badges

Sign up to request clarification or add additional context in comments.

5 Comments

c.k Over a year ago

even when some fields are empty? does it display neatly?

phreakv6 Over a year ago

Yes it will. Please try it.

c.k Over a year ago

Another thing, In the future I will using this(datas) to compare on other csv file. If the date and payment amount are match to the other csv file it will be mark as MATCHED. So the easy access of each data by row here is obsolete.

phreakv6 Over a year ago

Comparing csv lines like that is dangerous. What if the two csv lines had exact same data but the formatting was different? Say one had fields wrapped in double quotes while the other didn't?

c.k Over a year ago

Thanks for your answer. Is there a way from your code that the displaying of data would be like this? <td><?= $name?></td> <td><?= $email?></td> <td><?= $address?></td> <td><?= $payment?></td> <td><?= $datepaid?></td>

StackSlave · Accepted Answer · 2016-06-09 04:20:14Z

1

You should use fgetcsv:

$fp = @fopen('data/payment.csv', 'r');
$tbl = '<table><thead><tr><th>NAME</th><th>Email</th><th>Address</th><th>Payment</th><th>Datepaid</th></tr></thead><tbody>';
while($r = fgetcsv($fp)){
  $tbl .= '<tr>';
  foreach($r as $v){
    $tbl .= '<td>'.htmlentities($v, ENT_QUOTES, 'UTF-8').'</td>';
  }
  $tbl .= '</tr>';
}
$tbl .= '</tbody></table>';
echo $tbl; // echo $tbl wherever you want

edited Jun 9, 2016 at 4:20

answered Jun 9, 2016 at 4:14

StackSlave

10.6k2 gold badges20 silver badges35 bronze badges

1 Comment

c.k Over a year ago

Thanks for help @PHPglue.

Collectives™ on Stack Overflow

Proper displaying of csv file data in table if some fields are empty

2 Answers 2

5 Comments

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

5 Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related